Statistical Analysis Excel 2013 Essentials

Learn the ins and outs of statistical analysis with Excel 2013

Created by: John Wiley & Sons
Video Training

What Will I 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.

Requirements

• Students should have an intermediate knowledge of how to use Excel
• Having access to Excel 2013 is helpful for practicing the skills you have learned

Target audience

• Intermediate through Advanced Excel Users
• For students who want to take advantage of formulas, Pivot Tables, dashboards, and reporting tools
• If you need to effectively and efficiently analyze data within Excel this course is for you.