Write My Paper Button

WhatsApp Widget

CSU Holiday Trees Case Profits and Distribution Questions

https://www.csun.edu/sites/default/files/Holiday%20Tree%20Services%20-%20Case%20Text%20Rev1_1.pdfCase material 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 Holiday Tree’s Case.xls at the Gateway website.)

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?

CSU Holiday Trees Case Profits and Distribution Questions
Scroll to top