There are some conventional (and logical) rules for frequency distributions: I h
ID: 3061897 • Letter: T
Question
There are some conventional (and logical) rules for frequency distributions: I have to do a graph that follows these five steps. 1.Between 5 and 20 classes is best. 2. Classes may not overlap. 3. Classes with no data are shown. 4. All values in the data set must be included. 5. Classes must be of equal widths (exceptions to Rule 5 may be made in some cases for the first and/or last class). I need to put in these amounts
COST
$0.00 $3.75 $0.00 $0.00 $0.00 $18.00 $0.00 $2.50 $0.00 $23.00 $0.00 $20.00 $0.00 $7.00 $0.00 $1.00 $0.00 $0.00 $0.00 $6.50 $0.00 $0.00 $7.00 $3.50 $0.00 $10.00 $8.00 $5.00 $0.00 $3.25 $0.00 $3.50 $0.00 $0.00 $0.00 $0.00 $0.00 $3.25 $3.25 $2.50 $10.00 $0.00 $10.00 $0.00 $3.50 $3.00 $0.50 Create a table just as the one above for the data COST shown here (the approximate daily cost for Math 175 students to commute to school, fall 2012). Be sure to follow rules 1 – 5 I need to add it to an excel sheet. IF you know how to do that please let me know. I need column for class, limits, boundaries, midpoint, frequency, cumulative frequency, and relative frequency.
Explanation / Answer
Minimum value of ordered data set: 0
Maximum value of ordered data set: 23
Let us assume number of classes: 5
Class width =(maximum -minimum) / 5 = 23 /5 = 4.6
That is class width is 5.
Following is the completed table:
Class Class boudaries Midpoint Frequency, f Relative frequency , f/47 Cumulative frequency 0-4 (-0.5)-4.5 (0+4)/2=2 36 0.76596 36 5-9 4.5-9.5 (5+9)/2=7 5 0.10638 41 10-14 9.5-14.5 12 3 0.06383 44 14-19 13.5-19.5 17 1 0.02128 45 20-24 19.5-24.5 22 2 0.04255 47 Total 47