Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts In Practical Differential Equations

Authors: Sabita Mahanta

1st Edition

9353146488, 9789353146481

More Books

Students also viewed these Mathematics questions

Question

How does mindfulness practice assist in rational decision-making?

Answered: 1 week ago