Submit Excel model for the Movie Theater Releases Case from chapter 3 (page 140). The case is in your e-book (at the end of chapter 3). Use appropriate data-visualization methods to explore the data and address all questions. For \#1 you will need to create 4 pivot table reports with column charts - remember to rename each sheet, customize chart titles to include your name. Use the Group by option to prepare the summaries. For \#2-4 you are creating XY scatter charts with trendlines, equations, R square. If the relationship between the quantitative variables is not linear, try to find a non-linear equation with a better fit. Provide explanations, interpretation of results for \#1-4. Be thorough! Good luck! Managerial Report Use the tabular and graphical methods of descriptive statisties to learn how these variables contribute to the success of a motjon picture. Include the following in your report. 1. Tabular and graphical summaries for each of the four variables along with a discussion of what each summary tells us about the movies that are released to theaters. 2. A scatter diagram to explore the relationship between Total Gross Sales and Opening Weekend Gross Sales. Discuss. 3. A seatter diagram to explore the relationship between Total Gross Sales and Numbet of Theaters. Discuss. 4. A scatter diagram to explore the relationship between Total Gross Sales and Number of Weeks in Release. Discuss