Statistical Analysis Excel 2013 Essentials

Rating 4.7 out of 5 (191 ratings in Udemy)

What you'll learn

Learn how to locate the built-in functions, how to set-up a shortcut to the functions and how to load the Data Analysis ToolPak.
Learn how to group data into intervals with a built in function and the data analysis tool, sort tables and summarize your data by counting your data points.
Explore the three common types of charts featured in excel: column, line, and pie and scatter.
Discover how to use Sparklines and PowerView in …

Rating 4.7 out of 5 (191 ratings in Udemy)

What you'll learn

Learn how to locate the built-in functions, how to set-up a shortcut to the functions and how to load the Data Analysis ToolPak.
Learn how to group data into intervals with a built in function and the data analysis tool, sort tables and summarize your data by counting your data points.
Explore the three common types of charts featured in excel: column, line, and pie and scatter.
Discover how to use Sparklines and PowerView in Excel.
Learn how to calculate the statistics of central tendency, also known as, the average, median, mode in Excel. Find the mean and standard deviation together.
Apply normal distributions and understand the concept of sampling distributions.
Discover the connection between hypotheses and sampling distribution in excel and learn how to test hypothesis about variances.
Create and interpret statistics in a business or classroom setting.

Description

Big Data is Big Business - learn the ins and outs of statistical analysis with Excel.

Learn statistical analysis with Excel 2013 on your own terms with this one-of-a-kind video training course. Big data is big business, and many professionals are turning to Excels data analysis tools to help them make sense of their organizational data.

Now, you can learn the ins and outs of statistical analysis with Excel - from importing data toutilizing Pivot Tables - with Statistical Analysis with Excel 2013 Essentials. Our instructors provide expert, straight-forward, user-friendly training to help you tackle new topics the way you want to learn. Master basic skills, boost your creativity, and challenge yourself in bold new directions.

Understand Excels data analysis capabilities, even if you’ve never taken a statistics course. Work with data, normal distributions, hypothesis testing, variances, rank, and percentiles. Take advantage of formulas, Pivot Tables, dashboards, and reporting tools to display your data Includes 4 hours of statistical analysis with Excel 2013 video training.

This coursem also includes lessons that allow you to practice and master the skills you have learned.

If you're looking for real-world statistical analysis with Excel 2013 instruction, you'll find it here.

Duration 4 Hours 58 Minutes

Paid

Self paced

Intermediate Level

English (US)

1296

Rating 4.7 out of 5 (191 ratings in Udemy)

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.