Question
7) The first sheet on QMB3200-Homework#1Data.xlsx is named CommuteTime.It lists the average commute time (in minutes) it takes citizens of 379 metropolitan areas to travel
7) The first sheet on QMB3200-Homework#1Data.xlsx is named CommuteTime.It lists the average commute time (in minutes) it takes citizens of 379 metropolitan areas to travel to work and back home each day.
a. Using Excels statistical functions such as =AVERAGE(), =SUM() etc., give the mean, median, mode, max, min, variance (sample) and standard deviation (sample) of the average commute times, 10th percentile, 20th percentile, 40th percentile, 50th percentile, 60th percentile, 80th percentile, 1st quartile, 2nd quartile, 3rd quartile.Look at the values of the median and the 2nd quartile and the 50th percentile and comment.
b. Find the frequency of commute times between 30-39.99, 40-49.99, 50-59.99, 60-69.99 and 70-79.99.
c. Find the relative frequency of the commute times for the above intervals.
d. Find the cumulative relative frequency of the commute times for the above intervals.
e. Plot a line chart of the relative frequencies obtained in part c above.
f. Plot a pie-chart of the relative frequencies.
g. Make three statements about the data from the cumulative relative frequency table or the plots.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started