1 Event Profit You are the owner of a small business that manages the program, food, and merchandise sales at the Excel Center, where the local professional basketball team plays. In addition to basketball games, the Excel Center hosts dozens of events a year. Your company handles all sales made inside the arena. There are three major products that you sell: programs, food, and merchandise. You have decided to build a spreadsheet model to help you analyze and project the profitability of future events. The 'Event Profit' worksheet contains this model. You have randomly selected sales and attendance data from a number of past events to help build your model. This data can be found on the on the 'Past Events' worksheet. You will complete statistics on this model to obtain appropriate values for the inputs for the model. Complete the tasks to finish the model. Whenever possible, reference cells rather than 'hard-coding' values in the cells of your spreadsheet. 1.1 In the "Input Analysis" section of the spreadsheet model, use the past events listed on the "Past Events" worksheet to calculate the average attendance, and then the average sales for each type of product. 8 1.2 In the "Input Analysis" section of the spreadsheet model, calculate the sample standard deviation for attendance and sales for each type of product from the past events listed on the "Past Events" worksheet. 8 13 In the "Input Analysis" section of the spreadsheet model, calculate the 95% confidence interval for the sales for each type of product. Notice that you will not calculate a confidence interval for attendance. Reference the number of events (in cell (13) as part of your calculations. 7.5 14 In the "Input Analysis" section of the spreadsheet model, calculate the A Give Feedback to Microsoft