Microsoft Office Tutorials and References
In Depth Information
Result of using the TINV function to ﬁnd the conﬁdence interval about the mean
Note that you have drawn a picture of the 95 % conﬁdence interval beneath cell
B26, including the lower limit, the upper limit, the mean, and the reference value
of 28 mpg given in the claim that the company wants to make about the car’s miles
per gallon performance.
Now, let’s write the conclusion to your research study on your spreadsheet:
C33: Since the reference value of 28 is inside
C34: the conﬁdence interval, we accept that
C35: the Chevy Impala does get 28 mpg.
You are probably wondering why we wrote the conclusion on
three separate lines of the spreadsheet instead of writing it on
one long line. This is because if you wrote it on one line, two
things would happen that you would not like: (1) If you printed
Search JabSto ::