You will calculate several descriptive statistics and make some graphs for the "age" column. Be sure your graphs have a descriptive title and labels on the x and y- axis as "ogive" or "polygon" is not descriptive of what the graph is representing. In addition, when calculating the standard deviation, notice that we have a sample from our class, not a population of all online students. Be sure to use the correct standard deviation!
You will submit the Excel sheet with the following information:
- Make a Frequency Distribution with 5 classes, also list the midpoints, relative frequency, and cumulative relative frequency
- 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 standard deviation (our data is sample from our class, not a population!)
- Calculate the Q1 and Q3 values
Week 3 tab only ---