e Standard Deviation 95% Confidence Interval Product Type Correlation with Attendance Attendance Product Type Sales Forecast Upper Limit for Sales Lower Limit for Sales 2145.53 Programs 18000 Programs Food $50,000.00 $75,000.00 $100,000.00 Food What-if Analysis 15000 Merchandise Merchandise Attendance 18000 $393,360.47 21000 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