TABLE 14.5 Data for Example 14.4 Group A Findings Group B Findings p (kg/m?) p (kg/m?) 1020 950 1015 940 990 890 1060 1080 1030 1120 950 900 975 1040 1020 1150 980 910 960 1020 The final results for Example 14.4 are shown in Figure 14.12. A B D Group A Findings Group B Findings 1 Density (kg/m) Density (kg/m) 4 1020 950 1015 940 7 990 890 1080 1120 1060 1030 10 950 900 11 975 1040 12 1020 1150 13 980 910 14 960 1020 15 AVERAGE: 16 1000 1000 17 18 STAND. DEV. STAND. DEV. 19 34.56 95.22 20 21 22 Sheetl FIGURE 14.12 The Excel worksheet for Example 14.4.
Using Excel, compute the average (arithmetic mean) and the standard deviation of the density of water data given as shown to learn about what the value of standard deviation for a set of data points represents.
Refer to as shown when following the steps.
1. In cell B1, type Group A findings , and in cell C1 type Group B findings .
2. I n each of cells B3 and C3, type Density (kg ⁄m3). Highlight the 3 in the
kg m ⁄m3, and use the following command to make 3 a superscript. Right
click on the mouse right button and choose Format Cells ..." Next click
on the Font tab, and turn on the superscript toggle switch. In cells B5
to C14, type density values for Group A and Group B.
3. Next, we want to compute the arithmetic means for the Group A and
Group B data, but first we need to create a title for this computation.
Because we are calculating the average, we might as well just use the
word AVERAGE for the title of our calculations, thus in cell B15 type
AVERAGE: .
4. In order to have Excel compute the average, we use the AVERAGE function in the following manner. In cell B16, we type =AVERAGE(B5:B14),
and similarly in cell C16, we type =AVERAGE(C5:C14) .
5. Next, we will make a title for the standard deviation calculation by simply
typing in cell B18 STAND. DEV.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
