Please use the model in the range F3:G7 and Goal Seek to fin…

Please use the model in the range F3:G7 and Goal Seek to find the answer to this question.  IU would like to increase the total Home game attendance by approximately 1.5% from 362,393 in 2025 to 367,822 in 2026. However, there are 6 home games scheduled in 2025 compared to 7 home games in 2026. To reach 367,822 total attendance to Memorial Stadium in 2026, IU needs to fill the stadium at the minimum of [Capacity] % capacity for each game (enter the number with two decimal points; xx.xx).

Using Scenario Manager and the calculations in the range A1:…

Using Scenario Manager and the calculations in the range A1:B7, create two scenarios comparing the two college football stadiums using the information below. Memorial Stadium Cardinal Stadium Capacity (Seats) 53,524 60,800 2025 Capacity (%) 96.7% 82.6% 2026 Home Games 8 7 Create a scenario summary report showing Total Attendance for each stadium in 2025.  In 2026, IU’s Memorial Stadium expects a total attendance of [Memorial] from 8 home games if the university can fill the stadium similarly to the 2025 season at 96.7% capacity. In 2026, the larger 60,800-seat University of Louisville’s Cardinal Stadium expects a total attendance of [Cardinal] from 7 home games if the university can fill the stadium similarly to the 2025 season at 82.6% capacity. Enter the number with a thousand separator and no decimal points, e.g. 123,456

Prescriptive Analytics using Microsoft Excel You are an inte…

Prescriptive Analytics using Microsoft Excel You are an intern for Indiana University Athletics. You were assigned to analyze the football stadium attendance data. Open the IUMS5345.xlsx data file in Microsoft Excel and save it as an Excel Workbook (.xlsx) using a meaningful file name. Continue to use this file for Questions 3-6.   Please upload your completed Excel file to this question. 

Short Answer Question (Worth 10 points) These questions can…

Short Answer Question (Worth 10 points) These questions can be answered with a few sentences. Make sure to answer each part for full credit. 2. Explain the core concepts of both Realism and Liberalism. What assumptions do they each make? How do they analyze international relations? What are the important differences/similarities between these two theories?