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
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 ::