Calculate the average variation in driving time

Assignment Help Financial Management

Reference no: EM131909905

Question

Wayne Merritt drives from Cleveland to Chicago frequently and has noticed that traffic and weather make a big difference in the time it takes to make the trip.

As a result, he has a hard time planning activities around his arrival time. To better plan his business, Wayne wants to calculate his average driving time as well as measure of how much an actual trip is likely to vary from that average.

To do that, he clocked 10 trips with the following results:

Driving time Number of trips

6hrs, 0 min 1

6 hrs, 15 min 1

6 hrs, 30 min 2

6 hrs, 45 min 3

7 hrs 0 min 1

7 hrs, 30 min 1

9 hrs, 20 min 1

A. Calculate the mean, standard deviation, and coefficient of variation of Wayne's driving time to Chicago.

B. Calculate the average variation in driving time. Compare the standard and average variations. Is the difference significant? Which is more meaningful to Wayne?

PLease do in excel with calculation and please dont copy other answers.

Reference no: EM131909905

Questions Cloud

Describe nature of relationship among types of planning : It has been said that aggregate planning is related to personnel planning, budgeting, and market planning. Describe the nature of the relationship.

Research the information : Why is it important to thoroughly research the information that will go in a communication document prior to beginning the layout the document

Journal entries using percentage-of-completion method : ACC204 – Advanced Financial Accounting How would you account for the revaluation of the above assets and What would the relevant journal entries be?

Discuss the issue of speech anxiety : Discuss the issue of speech anxiety as it relates to public speaking (found in Part 1 of your text).

Calculate the average variation in driving time : Wayne Merritt drives from Cleveland to Chicago frequently and has noticed that traffic and weather make a big difference in the time it takes to make the trip.

Calculate the tax owed amount for tax returns : The company that needed the flowchart and pseudocode for calculating the Tax Owed amount for tax returns is now giving you the responsibility.

How should the options be compared : What factors are important in choosing the length of the planning horizon for aggregate planning? 11. A barbershop has been using a level workforce of barbers.

Discuss about the inflation effects : Inflation Effects Assume that inflation is expected to decline soon. How could this affect future bond prices?

State general rule regarding the amount of capacity to build : Suppose we are considering the question of how much capacity to build in the face of uncertain demand. Assume that the cost is $20 per unit of lost sales.

User Account

All Pages