CSU Holiday Trees Case Profits and Distribution Questions
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →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?
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds