SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Frequency Table Example

hateya avatar
hateya
13 diapositives · 298 Views · Jul 29, 2014

This guide walks you through the steps of creating a frequency table in Excel using PivotTables. Start by inputting your data from the provided disk into Excel, then navigate to the "Data" menu, select "PivotTable and PivotChart Report," and set your data range. Follow the prompts to layout your table by dragging the "Width" variable into the "Row" area. Adjust the aggregation from "Sum" to "Count" to analyze data frequency. Finally, define class widths to generate a comprehensive frequency table.

Frequency Table Example - slide 1
01 / 13Frequency Table Example
1 / 17

Télécharger la présentation

Frequency Table Example
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. Frequency Table Example Problem 24 page 46

  2. Put the disk from the book in and find the Excel files and scroll down to Trough. You get this

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

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

  5. Click Layout

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

  7. Note it says Sum of Width – this is the default – we will change later. Now click on OK.

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

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

  10. Change from Sum to Count – Count will give the Frequency of each value or group. Click on OK.

  11. RIGHT click on Width and scroll all the way to group.

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

  13. Here is our basic frequency table. Note we get 7 classes.