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 ...
Get Excel Data Analysis For Dummies, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
