G # of Events Assignment Tasks Event Profitability In the Input Analysis section of the spreadsheet...

Transcribed Image Text:

G # of Events Assignment Tasks Event Profitability 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 2 the "Past Events" worksheet (note for Excel 2007 users: Excel 2007 does not support a specific function to calculate sample standard deviations. Use the STDEV function instead). [8 points] Input Analysis 100 Statistic Attendance 14966 Programs Food $72,471.76 $154,242.26 Merchandise $393,360.47 Average Standard Deviation 95% Confidence Interval Product Type Programs Food Merchandise Correlation with Attendance Attendance 18000 Product Type Programs Food Merchandise Sales Forecast Upper Limit for Sales Lower Limit for Sales You are the owner of a small bus and merchandise sales at the Exc basketball team plays. In addition hosts dozens of event a year. You inside the arena. There are three food, and merchandise. You hav to help you analyze and project t Event Profit' worksheet contains selected sales and attendance da build your model. This data can t worksheet. You will complete sta appropriate values for the inputs finish the model. Whenever poss coding' values in the cells of your G # of Events Assignment Tasks Event Profitability 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 2 the "Past Events" worksheet (note for Excel 2007 users: Excel 2007 does not support a specific function to calculate sample standard deviations. Use the STDEV function instead). [8 points] Input Analysis 100 Statistic Attendance 14966 Programs Food $72,471.76 $154,242.26 Merchandise $393,360.47 Average Standard Deviation 95% Confidence Interval Product Type Programs Food Merchandise Correlation with Attendance Attendance 18000 Product Type Programs Food Merchandise Sales Forecast Upper Limit for Sales Lower Limit for Sales You are the owner of a small bus and merchandise sales at the Exc basketball team plays. In addition hosts dozens of event a year. You inside the arena. There are three food, and merchandise. You hav to help you analyze and project t Event Profit' worksheet contains selected sales and attendance da build your model. This data can t worksheet. You will complete sta appropriate values for the inputs finish the model. Whenever poss coding' values in the cells of your