Chapter 10
Using Significance Tests
In This Chapter
Understanding estimation statistics
Using the Student t-distribution test functions
Analyzing probabilities and results with the Chi Square functions
When you have data from a population, you can draw a sample and run your statistical analysis on the sample. You can also run the analysis on the population itself. Is the mean of the sample data the same as the mean of the whole population? You can calculate the mean of both the sample and the population and then know precisely how well the sample represents the population. Are the two means exact? Off a little bit? How much different?
The problem with this though is that getting the data of the entire population in the first place isnât always feasible. On average, how many miles per gallon does a Toyota Camry get after five years on the road? You cannot answer this question to an exact degree because itâs impossible to test every Camry out there.
So instead we infer the answer. Testing a handful, or sample, of Camrys is certainly possible. Then the mean gas mileage of the sample is used to represent the mean gas mileage of all five-year-old Camrys. The mean of the sample group ...
Get Excel Formulas and Functions For Dummies, 3rd 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.
