Discuss the below:
Q: Consider the following data on distances traveled by people to visit the local amusement park:
Distance Frequency
1-8 miles 15
8-15 miles 14
15-22 miles 10
22-29 miles 8
29-36 miles 3
Expand and construct the table adding columns for relative frequency and cumulative relative frequency and construct the histogram of frequencies, plot the frequency polygon and the Ogive curve using Excel.
Distance Frequency Rel frequency Cumulative Rel. freq.
1 - 8 15 0.30 0.30
8 - 15 14 0.28 0.58
15 - 22 10 0.20 0.78
22 - 29 8 0.16 0.84
29 - 36 3 0.06 1.00
Total 50 1.000 N/A