Download - Frequency Table Example
![Page 1: Frequency Table Example](https://reader035.vdocuments.us/reader035/viewer/2022062222/56816196550346895dd14065/html5/thumbnails/1.jpg)
Frequency Table Example
Problem 24 page 46
![Page 2: Frequency Table Example](https://reader035.vdocuments.us/reader035/viewer/2022062222/56816196550346895dd14065/html5/thumbnails/2.jpg)
Put the disk from the book in and find the Excel files and scroll down to Trough.You get this
![Page 3: Frequency Table Example](https://reader035.vdocuments.us/reader035/viewer/2022062222/56816196550346895dd14065/html5/thumbnails/3.jpg)
Click on Data on the main menu and scroll to PivotTable and PivotChart Report to have this pop up
Have these two checked and hit next
![Page 4: Frequency Table Example](https://reader035.vdocuments.us/reader035/viewer/2022062222/56816196550346895dd14065/html5/thumbnails/4.jpg)
This will pop up and make sure you put A1 to A50 because this is all the data including the label.
If you want you can click on this button and then go and highlight all the data. Click it again to come back to here and then click next.
![Page 5: Frequency Table Example](https://reader035.vdocuments.us/reader035/viewer/2022062222/56816196550346895dd14065/html5/thumbnails/5.jpg)
Click Layout
![Page 6: Frequency Table Example](https://reader035.vdocuments.us/reader035/viewer/2022062222/56816196550346895dd14065/html5/thumbnails/6.jpg)
Touch and drag the box with the label Width (this was the name of the variable you included in the data) into the “Row” area. Do this again but go into the data area.
![Page 7: Frequency Table Example](https://reader035.vdocuments.us/reader035/viewer/2022062222/56816196550346895dd14065/html5/thumbnails/7.jpg)
Note it says Sum of Width – this is the default – we will change later.Now click on OK.
![Page 8: Frequency Table Example](https://reader035.vdocuments.us/reader035/viewer/2022062222/56816196550346895dd14065/html5/thumbnails/8.jpg)
You can go to a new worksheet – I like to stay at the existing one (so I click it and put in a cell number where I know the table will fit). Then click finish.
![Page 9: Frequency Table Example](https://reader035.vdocuments.us/reader035/viewer/2022062222/56816196550346895dd14065/html5/thumbnails/9.jpg)
This is our initial result. Not very useful yet. But we will modify.Go to the “Sum of Width” cell and double click on it.
![Page 10: Frequency Table Example](https://reader035.vdocuments.us/reader035/viewer/2022062222/56816196550346895dd14065/html5/thumbnails/10.jpg)
Change from Sum to Count – Count will give the Frequency of each value or group. Click on OK.
![Page 11: Frequency Table Example](https://reader035.vdocuments.us/reader035/viewer/2022062222/56816196550346895dd14065/html5/thumbnails/11.jpg)
RIGHT click on Width and scroll all the way to group.
![Page 12: Frequency Table Example](https://reader035.vdocuments.us/reader035/viewer/2022062222/56816196550346895dd14065/html5/thumbnails/12.jpg)
This pop up tells you the highest or maximum value is 8.498 and the lowest is 8.312 for a range of 0.186. Six classes means divide the 0.186 by 6 to get .031. So this would mean we could make each class width .03.
Change the By to .03 and click OK.
![Page 13: Frequency Table Example](https://reader035.vdocuments.us/reader035/viewer/2022062222/56816196550346895dd14065/html5/thumbnails/13.jpg)
Here is our basic frequency table. Note we get 7 classes.