Statistics skills with Excel for Data Analysis



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

What you will 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

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.

English
language

Content

Organize the data in the table

Introduction

growing cumulative ECC

ECC

Frequency cumulative

FCC

the center of class

CENTER OF CLASS

mean

calculating the mean

mode

calculating the mode

median

calculating the median

Quartile 25

Calculating the quartile 25

Quartile 75

Calculating the quartile 75

MIN/MAX/EXTENT

MIN/MAX/EXTENT

Variance

calculating the variance

standard deviation

calculating the square root

Organize the whole statistical values

statistical values and interpretation of it

Lorenz curve and gini index

in the case of highly concentrated statistical values

Lorenz curve and Gini Index

in the case of highly dispersed statistical value

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
100% Free SEO Tools - Tool Kits PRO

Check Today's 30+ Free Courses on Telegram!

X