Enter Data

1.     Enter  “Temperature (F)” in cell A1. 

2.     Enter “Water Consumption (ounces)” in cell B1.

3.      Enter the data shown below.  Cells A2-A8 should contain the temperature values and cells B2-B8 should contain the water consumption values.      

Temperature (F)

Water Consumption (oz)

99

48

85

27

97

48

75

16

92

32

85

25

83

20

 

5.  Enter Mean in cell A9 and B9. (The mean values will be stored under these cells)

  Next: Excel Mean Calculation

Home      Arithmetic Mean    Standard Deviation      References