STAT 2010 Lab - Robert Bubb
Types of frequency tablesStandard frequency table (units)Group frequency table (intervals of values)Steps to Create Frequency table [Standard]Step 1: Open Excel, identify the column of your targeted variableStep 2:: Step 3: Right screen of your Excel: PivotTable Field ListChoose fields to add to report: Click the box in front of the variableDrag the variable into ∑ Values (do this twice to create three columns)Step 4: Now you should have three columnsRight click the title of the 2nd column: summarize value by countRight click the title of the 3rd column: show values as % of grand total Step 5: Rename each column (Score/Interval, Frequency, Percentage), and add a title for the table, and remove the interval with “blank”If you are making a standard frequency table then you will need to remove the interval with “blank.” If you are creating a group frequency table then continue directly to step 6Highlight and right click on the interval that says “blank” with a frequency counts of “0”Click on “Filter”Click on “Hide selected”Steps to create a frequency table [Interval]Use Steps 1-5 above Step 6: Group the variableRight click the first value under the 1st column title: Group: Starting at: Min number, ending at: Max number; By: Interval widthInterval width = full range/intervals = (Max-Min + “something”)/ intervals Usually choose 7-10 intervalsIntervals with frequency counts of “0” will not be automatically shown. To include these intervals (if necessary):Right click the first value under the 1st column titleClick on “Field settings”Click on “Layout and print” tabCheck box “Show items with no data”Right click on a cell in the Pivot Table to fill empty cells with the value of “0”Click on “Pivot table options”Click on “Layout and format” tabEnter “0” in the “For empty cells” fieldFor a frequency table, you will need to hide the interval cells with frequency counts of “0” if they are the first and/or last intervals. Highlight and right click on the first and last interval if the frequency counts is “0”Click on “Filter”Click on “Hide selected”Adjust the interval widths to remove overlapLeft click on each interval and adjust that last number to be slightly smaller than the first number in the next interval. Example: interval “0-10” becomes “0-9.99”Finally, give your table a title ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.