Microsoft Office Tutorials and References

In Depth Information

Fig. 3.1
Worksheet Data for Chevy Impala (Practical Example)

Create a spreadsheet with these data and use Excel to ﬁnd 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,

widen column C so that it is three times as wide as the original width of column A

so that your table looks more professional.

Search JabSto ::

Custom Search