Excel File Edit View Insert Format Tools Data Window Help Mon Nov 22 5:53 PM AutoSave OFF AO Exam 3 Fall FR1 Q Home Insert Draw Page Layout Formulas Data Review View Developer Acrobat Tell me Share Comments Calibri (Body) 11 . i General LO #Insert Conditional Formatting Format as Table WO 28u O I Delete FO IN Analyze Data Paste == == A $ % ) E OO Sensitivity Cell Styles # Format Sort & Filter Find & Select Create and Share Adobe PDF C21 x fx A B C D E F G H I J L M N O P Q R 1 3. 15 pts 2 3 4 5 6 7 8 You are thinking about buying a double-decker pontoon boat in order to take customers on daily cruises of Lake Keowee. The boat has space for 30 people and from your research, you believe you can make a profit of $15 for every space that is filled and you will lose $7 for every space that is not filled. You plan on taking the boat out every weekend from the beginning of April to the end of October. The number of customers depends heavily on the weather forecast. The probability of rain on average is 35%. The number of customers on a rainy day is normally distributed with a mean of 25 and a st dev of 7. The number of customers on a non-rainy day is normally distributed with a mean of 32 and a st dev of 5. 9 A. Simulate the total profit for the season (assume 8 days in each month). B. Replicate this 200 times using a data table and calculate the average profit for a "pontoon" season. 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Ready T 3 150% + New Folder DUI Cabanduline. MGT 4560 Business Data Management TT, 5:00-6:15 Powers 203 Desktop.pkg oad ctv 22 4 Ps JU GG