The Manga Guide to Statistics

194 Aendix

Step 4

Select the area shown in the figure below, and click OK.

Step 5

Start with cell J3, and select the area from cell J3 to J7 as shown below.

Step 6

Click this part in the formula bar.

Step 7

Press enter while holding down the shift key and ctrl key at the same time.

Let's Calculate Using Excel 195

Step 8

Now you have the frequency of each class!

2. Calculating Arithmetic Mean, Median, and Standard Deviation

This data comes from Rui’s classmates’ bowling scores on page 41.

Step 1

Select cell B10.

Step 2

Select InsertFunction.