Create a histogram of the weekly operating profits

Assignment Help Applied Statistics

Reference no: EM131917001

Using MS Excel and the data given in the case:

a. Create a histogram of the weekly operating profits from the prior year of operation, using 6 equal sized bins. What is the mode on the histogram? How would you define it? Which probability distribution does the histogram resemble? (You may wish to use the Excel file Harvey's Case.xls at the Gateway web site.)

b. What was the average weekly profit for the prior 12-month period? Determine and define the variance and standard deviation of weekly profit.

c. How confident are you of this estimate? Calculate a 99% confidence interval for weekly profits, assuming that sigma is unknown. What does this tell you about weekly profits?

d. Based on the above, what is the expected exposure on the lost profits claim?

Assume that, based on Q. 2. d. above, Harvey's made an initial settlement offer to Burger. However, on behalf of Burger, Mr. Cooper declined the offer because he felt the offer underestimated the lost profits. He stated that profits from the last six months (26 weeks) before the fire are more indicative of future expected profits. He feels that only data from the last six months should be used to calculate future expected profits.

a. To formally test Mr. Cooper's claim, test to see if there was a significant difference in mean weekly profits between the first 6 months of the year and the last 6 months. Use a 0.05 significance level and assume equal variances. Does this support Mr. Cooper's claim?

b. Having thought about Mr. Cooper's suggestion, you consider several options as an estimate of lost profits. These include 1) the full year, 2) the last six months only, 3) a weighted average that gives twice the weight to the last six months as to the first six months, or 4) some other weighted average. Which method do you think gives the most accurate estimate of lost profits?

Attachment:- harveys-tree-farm-case.rar

Reference no: EM131917001

Questions Cloud

Evaluation of the conceptual-theoretical-empirical linkages : Evaluation of the conceptual-theoretical-empirical linkages. Evaluation of the selected theory. Evaluation of the empirical indicators.

How does the charge move : A charge of -2 C is moving at a speed of 5 m/s in the +X direction in a magnetic field of 0.2 T in the +Z direction. If its mass of 0.1 kg.

Explain the plaintiff argument : John D. Archbold Memorial Hospital excluded all job applicants whose weight exceeded the maximum desirable weight (based on Metropolitan Life's actuarial.

Current income is important component of your fico score : Your current income is an important component of your FICO score.

Create a histogram of the weekly operating profits : Create a histogram of the weekly operating profits from the prior year of operation, using 6 equal sized bins. What is the mode on the histogram?

Identify the elements responsible : Identify the elements responsible for each of these x-rays.

Explain healthcare-related component of rio policy statement : For this critical thinking assignment compare main healthcare-related components of Rio Policy Statement to the health components of Saudi Arabia's Vision 2030.

Discuss equal employment opportunity commission of us : Michael Cooke, an African-American male, worked at Novellus Systems in Silicon Valley where he had to listen on a regular basis to a Vietnamese-American.

What is the payback period for project : The tax rate is 32 percent, and the cost of capital is 8 percent. What is the payback period for this project?

User Account

All Pages