What was the average weekly profit

Assignment Help Applied Statistics

Reference no: EM131917010

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: EM131917010

Questions Cloud

Calculate taxable equivalent yield for this investment : Calculate the taxable equivalent yield for this investment.

Identify the wave process : Describe a sound wave experience phenomenon that you have personally and identify the wave process

How you plan to address the weaknesses : Identify any areas of weakness that you still feel exist in your marketing and communication skills all-round. Explain how you plan to address these weaknesses.

What are the phases or states in which matter can exist : What are the phases or states in which matter can exist. Provide characteristics of each state and how transformations are made from one state to another.

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

What is a projectile : What is a projectile? Describe the two forces involved in projectile motion and whether or not one has any influence on the other.

What is repeated rehearsal : What does the child's behavior lead you to conclude about children's ability to think logically in early childhood? Explain your answer.

Total amount of risk in mortgage-backed pool : A CMO is a pass-through security. Creating a CMO reduces the total amount of risk in a mortgage-backed pool.

What is the radius of the circle now in meters : If the field is then increased by a factor of 4 (Nothing else is changed), what is the radius of the circle now in meters?

User Account

All Pages