I don’t know how to handle this Excel question and need guidance.
Complete the Chapter 3 Case Problem: All-Time Movie Box-Office Data in the Essentials of Business Analytics (2nd ed.) textbook. A Managerial Report should be created summarizing your responses to all five questions at the end of the case problem. The following Minitab instructions can be used to create the statistical summaries in support of your responses. Please provide an interpretation for each table and graph.
Question 1
Scatterplot:
Minitab: Graph – Scatterplot with Regression – Ok
Y variable: U.S. Box Office Receipts (Inflation Adjusted)
X variable: Year Released
Select the “Ok” icon to generate the chart
Question 2
Scatterplot:
Minitab: Graph – Scatterplot – Simple – Ok
Y variable: World Box Office Receipts (Non-Inflation Adjusted)
X variable: Budget (Non-Inflation Adjusted)
Select the “Ok” icon to generate the chart
Question 3
Frequency Distribution:
Minitab: Data – Recode – To Text
Recode values in the following columns: U.S. Box Office Receipts (Inflation)
Method: Recode ranges of values