Microsoft Office Tutorials and References
In Depth Information
they achieve on these two tanks of gas. Your research study produces the results
given in Fig. 3.1 :
Fig. 3.1
Worksheet data for Chevy Impala (practical example)
Create a spreadsheet with these data and use Excel to find the sample size (n),
the mean, the standard deviation (STDEV), and the standard error of the mean
(s.e.) for these data using the following cell references.
A3:
Chevy Impala
A5:
Miles per gallon
A6
30.9
Enter the other mpg data in cells A7: A30.
Now, highlight cells A6:A30 and format these numbers in number format (one
decimal place). Center these numbers in Column A. Then, widen columns A and B
by making both of them twice as wide as the original width of column A. Then,
Search JabSto ::




Custom Search