Format Tools Data Window Help L2 1111 Mon Nov 22 5:53 PM Excel File Edit View Insert AutoSave OFF AA @ Insert Draw Page Layout Exam 3 Fall FR1 Q Home Formulas Data Review View Developer Acrobat Tell me Share Comments Insert v Calibri (Body) 11 . General LO V Conditional Formatting Format as Table v Cell Styles WO Ayu O Paste == == FO IN Analyze Data BIU A HO $ %) EM Delete # Format .00 V Sort & Filter Find & Select Sensitivity Create and Share Adobe PDF K16 xv fx B C D D E E F G H J L M N O Q R S The following probability distribution shows the daily sales of laundry detergent in a large grocery store (to the nearest 10). A A 1 1. 15 pts 2 3 4 4 5 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Units Sold Probability 30 0.12 40 0.24 50 0.32 60 0.26 70 0.06 A) Assuming there are 30 days in a month, simulate a months worth of sales and find the average number of units sold per day. Round to the nearest integer. B) Use a data table to replicate 10 years of average units sold per day. Find this average and round to the nearest integer. C) Find the true expected number of units sold. 19 D) Which average (A or B ) shows less variation around the true expected value in part C? Why is this true? 20 21 22 23 24 25 26 2 3 + Ready iT 3 141% + New Folder Nuncakaaluline MGT 4560 Business Data Management TT, 5:00-6:15 Powers 203 Desktop.pkg oad NOV O di ISSA etv 22 4 A & Ps G