Statistics skills with Excel for Data Analysis

Focused View

Yassir El khaloui

1:50:23

344 View

1. Organize the data in the table

1.1 Classeur1.xlsx

1. Introduction.mp4

02:48

2. growing cumulative ECC

1. ECC.mp4

01:44

3. Frequency cumulative

1. FCC.mp4

02:38

4. the center of class

1. CENTER OF CLASS.mp4

02:50

5. mean

1. calculating the mean.mp4

03:00

6. mode

1. calculating the mode.mp4

04:27

7. median

1.1 gh.xlsx

1. calculating the median.mp4

06:15

8. Quartile 25

1.1 gh.xlsx

1. Calculating the quartile 25.mp4

08:18

9. Quartile 75

1.1 gh.xlsx

1. Calculating the quartile 75.mp4

09:43

10. MINMAXEXTENT

1. MINMAXEXTENT.mp4

01:31

11. Variance

1.1 gh.xlsx

1. calculating the variance.mp4

09:01

12. standard deviation

1. calculating the square root.mp4

00:55

13. Organize the whole statistical values

1.1 gh.xlsx

1. statistical values and interpretation of it.mp4

08:54

14. Lorenz curve and gini index

1. in the case of highly concentrated statistical values.mp4

23:00

15. Lorenz curve and Gini Index

1.1 gh.xlsx

1.2 gh.xlsx

1. in the case of highly dispersed statistical value.mp4

25:19

Description

Reach unique and effective Statistical skills with excel as a futur data analyst

What You'll Learn?

Manipulate large amount of data with descriptive statistics
Reach unique data analytics skills
know how to do interpretation for statistical values
know how to do interpretation for Lonrenz Curve and Gini index

Who is this for?

Beginner Data analysts

More details

Description
This course is designed to be an effective easy guide to those who passionate it to persue a career as a data analyst, you will learn not only the quantitative statistical method to but you will learn the why of things and know how to interpret the data linguistically and statistical values and concepts.
learn the most valuable concepts and unique one that a lot of people in the field of data analysis ignore it or don't wanna share it, so you will discovre it with me in this course like lorenz curve and gini index that curve which is crucial in interpretating the situation of the data.
you will learn by following the content of the video and then apply it yourself in parallel to that, and i uploaded the file so you can see if you make some mistake along the way I guarantee you will find this course the most profitable and time saving as well as an opening to the next course where i'm gonna teach sql and r programming language for another statistical concepts confidence intervals, testing hypothesis, and probability theory based on as a said before easy effective way to manipulate the data, as well as google certification in data analytics preparation this is my promise for you to shine quickly and effectively as possible.
Who this course is for:
Beginner Data analysts

User Reviews

Rating

average 0

Total votes0

Focused display

I'm Yassir El khaloui student in HR Management and entrepreneur my obsessive passion about other fields like digital marketing, technology, learning skills, Trading always push me to be creative and optimize my time to achieve great things not only for myself but also provide a great value for other people in low cost possible which give me a sense of fulfillment which the feeling i'am always searching for.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.