Excel Data Analysis For Dummies, 2nd Edition

Chapter 11

Inferential Statistics

In This Chapter

Discovering the Data Analysis t-test tools

Performing a z-test

Creating a scatter plot

Using the Regression tool that comes with Data Analysis

Using the Correlation tool that comes with Data Analysis

Implementing the ANOVA data analysis tools

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

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 ...