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 ﬁ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,

Search JabSto ::

Custom Search