Working with the Data Analysis ToolPak
Description de la session
| In this video you will learn how to use the Data Analysis ToolPak. |
Pour en savoir plus, suivez le cours complet
Statistical Analysis Excel 2013 Essentials
Learn the ins and outs of statistical analysis with Excel 2013
Vidéo à la demande de 04:06:40 • Mise à jour : novembre 2014
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.