1 1 2 3 3 4 5 5 5 6 6 6 6 9 10 10 10 11 11 11 12 12 12 12 12 14 14 14 14 15 15 15 15 16 16 17 17 17 18 18 18 19 19 19 19 23 24 26 29 29
The worksheet "Transportation Costs" contains the amount (rounded to the nearest dollar) that fifty, randomly selected, Kwantlen students spent on transportation on September 22, 2021. Please do the following with this data. Construct a stretched stem and leaf diagram. (You may do this by hand or in Excel.) What does it tell you about the distribution of costs in this sample?
Using Excel, use the data to generate the following: an ordered array (ascending order) a histogram an ogive a frequency table a percent frequency table a cumulative frequency table.
Why isn’t it appropriate to use this data to do a pie chart or bar chart?
Use Excel to calculate the three measures of central location, the standard deviation, range and interquartile range. Comment generally on what you found in this dataset. For instance, is the distribution symmetrical? Are there any outliers? How did you measure this? There are two correct ways to gauge if a value is an outlier. You can use either.
