Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on historical data, the probability distribution shown in cells B26:C62 below was created to represent the daily number of customers who purchase a dozen

image text in transcribed
Based on historical data, the probability distribution shown in cells B26:C62 below was created to represent the daily number of customers who purchase a dozen donuts from Cuspin Bakery, where a dozen donuts sells for $18. (A customer may only purchase one dozen.) Each day, Cuspin's production costs are uniformly distributed between $250 and $425.
Use Excel formulas and data tables to develop a simulation model with 1,000 trials to calculate Cuspin Bakery's daily profit, and create a histogram showing the distribution of daily profit.
Also answer the following questions in cells C19:C23 below. (Type the value into the cell - not a formula.)
What is the median daily profit for Cuspin Bakery, rounded to two decimal places?
If Cuspin has a goal of earning at least $400 in profit on a given day, what is the probability that they will reach their goal?
What daily profit does the bakery exceed 20% of the time?
What is the coefficient of skewness for Cuspin Bakery's daily profit?
How would you characterize the distribution of daily profit? (Select the best answer.)
DON'T FORGET TO SAVE!
Aho answer the followine questions in cells C1s:cas toliow. (Trpe the value into the cell - not a formula.) 2) What is the median daik profit for Cuspin alakery, rounded to two decimal places? c) What dally prefit does the balery excetd 20N of the time? d) What is the coefficient of skewness for Curpin asiervis dally profic? * e) How would you characteriat the ditribution of dally protit? (Solect the best answer.) DONT FOHGET TO SAvE

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Multifractal Detrended Analysis Method And Its Application In Financial Markets

Authors: Guangxi Cao, Ling-Yun He, Jie Cao

1st Edition

9811079153, 978-9811079153

More Books

Students also viewed these Finance questions