You can easily change the column headings in the frequency distribution output. for instance, to change the current heading in cell A3 (Row Labels) to “Soft drink,” click in cell A3 and type “Soft drink”; to change the current heading in cell b3 (Count of brand Purchased) to “frequency,” click in cell b3 and type “frequency”; and to change the current heading in A9 (Grand Total) to “Total,” click in cell A9 and type …show more content…
The formula work- sheet is in the background and the value worksheet in the foreground. To compute the relative frequency for Coca-Cola using equation (2.1), we entered the formula 5b4/$b$9 into cell C4; the result, 0.38, is the relative frequency for Coca-Cola. Copying cell C4 to cells C5:C8 computes the relative frequencies for each of the other soft drinks. To compute the percent frequency for Coca-Cola, we entered the formula 5C4*100 into cell d4. The result, 38, indicates that 38% of the soft drink purchases were Coca-Cola. Copying cell d4 to cells d5:d8 computes the percent frequencies for each of the other soft drinks. To compute the total of the relative and percent frequencies we used Excel’s SUM function in cells C9 and …show more content…
To construct a pie chart, we first draw a circle to represent all the data. Then we use the relative frequencies to subdivide the circle into sectors, or parts, that correspond to the relative frequency for each class. for example, because a circle contains 360 degrees and Coca-Cola shows a relative frequency of .38, the sector of the pie chart labeled Coca-Cola consists of .38(360) 5 136.8 degrees. The sector of the pie chart labeled diet Coke consists of .16(360) 5 57.6 degrees. Similar calculations for the other classes yield the pie chart in figure 2.4. The numerical values shown for each sector can be frequencies, relative frequencies, or percent