# Question

The file S03_22.xlsx lists financial data on movies released since 1980 with budgets at least $20 million.

a. Create three new variables, Ratio1, Ratio2, and Decade. Ratio1 should be US Gross divided by Budget, Ratio2 should be Worldwide Gross divided by Budget, and Decade should list 1980s, 1990s, or 2000s, depending on the year of the release date. If either US Gross or Worldwide Gross is listed as “Unknown,” the corresponding ratio should be blank.

b. Use a pivot table to find counts of movies by various distributors. Then go back to the data and create one more column, Distributor New, which lists the distributor for distributors with at least 30 movies and lists Other for the rest.

c. Create a pivot table and corresponding pivot chart that shows average and standard deviation of Ratio1, broken down by Distributor New, with a report filter for Decade. Comment on any striking results.

d. Repeat part c for Ratio2.

a. Create three new variables, Ratio1, Ratio2, and Decade. Ratio1 should be US Gross divided by Budget, Ratio2 should be Worldwide Gross divided by Budget, and Decade should list 1980s, 1990s, or 2000s, depending on the year of the release date. If either US Gross or Worldwide Gross is listed as “Unknown,” the corresponding ratio should be blank.

b. Use a pivot table to find counts of movies by various distributors. Then go back to the data and create one more column, Distributor New, which lists the distributor for distributors with at least 30 movies and lists Other for the rest.

c. Create a pivot table and corresponding pivot chart that shows average and standard deviation of Ratio1, broken down by Distributor New, with a report filter for Decade. Comment on any striking results.

d. Repeat part c for Ratio2.

## Answer to relevant Questions

The file S03_50.xlsx lists NBA salaries for five seasons. a. Merge all of the data into a single new sheet called All Data. In this new sheet, add a new column Season that lists the season, such as 2006–2007. b. Note that ...The file S03_55.xlsx lists the average salary for each MLB team from 2004 to 2009, along with the number of team wins in each of these years. a. Create a table of correlations between the Wins columns. What do these ...The file S03_15.xlsx contains monthly data on the various components of the Consumer Price Index.a. Create differences for each of the variables. You can do this quickly with StatTools, using theDifference item in the Data ...In a particular suburb, 30% of the households have installed electronic security systems.a. If a household is chosen at random from this suburb, what is the probability that this household has not installed an electronic ...A fair coin (i.e., heads and tails are equally likely) is tossed three times. Let X be the number of heads observed in three tosses of this fair coin. a. Find the probability distribution of X.b. Find the probability that ...Post your question

0