Chapter 11

Inferential Statistics

In This Chapter

arrow Discovering the Data Analysis t-test tools

arrow Performing a z-test

arrow Creating a scatter plot

arrow Using the Regression tool that comes with Data Analysis

arrow Using the Correlation tool that comes with Data Analysis

arrow Implementing the ANOVA data analysis tools

arrow Comparing variances from populations with the f-test Data Analysis tool

arrow Using the Fourier Data Analysis tool

In this chapter, I talk about the more sophisticated tools provided by the Excel Data Analysis add-in, such as t-test, z-test, scatter plot, regression, correlation, ANOVA, f-test, and Fourier. With these other tools, you can perform inferential statistics, which you use to first look at ...

Get Excel Data Analysis For Dummies now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.