MAKE AN EXCEL SHEET

• Make a Frequency Distribution with 5 classes, also list themidpoints, relative frequency, and cumulative relativefrequency
• Make a relative frequency ogive
  • Don?t forget descriptive title and labels on x and y axis(ogive is not descriptive, what does the graph represent?)
• Make a frequency polygon
  • Don?t forget a descriptive title and labels on x and y axis(polygon is not descriptive, what does the graph represent?)
• Calculate the mean
• Calculate the median
• Calculate the sample standarddeviation (our data is sample from our class, not apopulation!)
• Calculate the Q1 and Q3 values

2 3 6 5 7 3 3 0 1 2 3 4 5 6 7 9 0 1 2 3 4 5 6 7 8 9 0 1 Age A B Gender 19 F 19 F 19 M 19 F 21 F 22 F 47 M 23 F 30 M 17 F 29 F 21 M 21 M 25 F 26 F 22 M 24 M 44 F 33 M 22 F 17 M 36 F 20 F D Limits Freq. Mid. RF CF Ogive: Polygon Total: E Points 2 2 2 2 1 ~ ~ ~ ~ ~ 2 2 2 2 2 3 3 25 F G I J For the following questions, use only the "age" column: Age Frequency Distribution: Low Q1 Q3 Class Limits H High Midpoint Freq. Mean Median Sample Standard deviation: *Round to two decimals *Round to one decimal *Round to one decimal *Round to one decimal Class Width Ogive: Relative Frequency K Cumulative Relative Freq *Round to two decimals L M N Polygon: