Data Analytics and Modeling

QUESTION 4 Jim runs a T-shirt printing business. His sales per week follow the distribution below. # of Tshirts sold Probability 200 10% 250 25% 300 30% 350 25% 400 10% He also orders t-shirts weekly to maintain his inventory. He orders t-shirts according to a normal distribution with a mean of 300 t-shirts and a standard deviation of 50 shirts. He starts with 500 t-shirts in inventory. Consider that for each week, he sells t-shirts and orders t-shirts. Find the inventory at the end of each week. mulate this process for 52 weeks and see what the inventory is at the end of the year. Do this simulation 1000 times. (Hint: using the normal distribution means you will get answers in decimals, like 252.52 shirts. To get rid of that, use the function ROUND(#, decimal places). So if I want a whole #, I use ROUND(#,0).) What is the probability that Jim has negative inventory at the end of the year? (For a nu YouTube 5%, input 25, not 0.25) QUESTION 5 For the problem you just did with Jim and his inventory, what was the mean final inventory? QUESTION 6 For the problem you just did with Jim and his inventory, what was the median final inventory? QUESTION 7 For the problem you just did with Jim and his inventory, what was the 25th percentile on final inventory? (Run this multiple times to get a sense of the central #) Click Save and Submit to save and submit. Click Save All Answers to save all answers. Save All Answ O 67'F Haze F3 1') F4 DII F5 F6 F7 PrtScnF8 Home F9 End F10 PgUP F11 P % 4 5 6 7 O E R T Y U O P