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

     

4.     Enter "Mean" in cells A9 and B9. (It may already be there from the previous lesson.) 

5.     Enter “Standard Deviation” in cells A11 and B11.  (The standard deviation values will be stored under these cells)

Next: Excel Deviation Calculation 

Home      Arithmetic Mean      Standard Deviation      References

 Back      Next