Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Make a dataset as follows: https://1drv.ms/x/s!ApAjhIcc8n1EghSCxOHFDX5IIVJC?e=lwcbam Collect movies and ratings fromRotten Tomatoes for at least 5 actors/actresses (each actor/actress should have appeared in at least

Make a dataset as follows: https://1drv.ms/x/s!ApAjhIcc8n1EghSCxOHFDX5IIVJC?e=lwcbam

  1. Collect movies and ratings fromRotten Tomatoes for at least 5 actors/actresses (each actor/actress should have appeared in at least 10 movies).
  2. Remove any entries that you judge the actor/actress did not play a major role (you must indicate which ones were removed).
  3. For each movie, find the budget and box office gross fromThe Numbers website or use the provided spreadsheet.Movies without any budget/gross information should be removed.
  4. Make two variables for return on investment (ROI): one based on domestic gross and one based on worldwide gross. (ROI = 100*(gross - budget)/budget).

Use your data to answer the following questions.

  1. Is the budget for a movie a good predictor for box office gross (domestic and worldwide)?
    1. What is the correlation between budget and domestic gross?
    2. What is the correlation between budget and worldwide gross?
    3. What is the regression equation for budget and domestic gross?
      1. Is the slope significant? Why or why not?
      2. Interpret the slope
    4. What is the regression equation for budget and worldwide gross?
      1. Is the slope significant? Why or why not?
      2. Interpret the slope
    5. Based on parts a-d, do you believe that budget is good predictor for a movie's domestic and/or worldwide gross?Justify your answer.
    6. Repeat parts a-e using only the data for one the actors/actresses you selected.
    7. Repeat parts a-e using only the data for a different actor/actress you used in part f.

  1. Fill in the following table

Actor/Actress

Number of movies (n)

Rating

mean (sd)

Budget

mean (sd)

Domestic ROI

mean (sd)

Worldwide ROI

mean (sd)

  1. Based on the numbers in the table, whom would you consider the best actor to hire if you were a movie studio executive? Justify your answer.
  2. Is the mean the best measure to use for comparisons? Justify your answer.
  3. What other information might be skewing the results of your analysis? How might this affect your decision?

  1. Use the Rating variable to create a variable that indicates whether a movie is good or bad, i.e., classify each movie as good or bad depending on its rating.
    1. Justify your criteria for classifying a movie as good or bad
    2. Fill in the following table for the number of good and bad movies for each actor/actresses

Movie

Actor/Actress

Good (n, %)

Bad (n, %)

Total

Total

  1. If you wanted determine if quality of movie (good/bad) is related to actors or actresses, which hypothesis would you use?
  2. Conduct the hypothesis test from part c (if possible). Based on the test (or the data if you cannot conduct the test), would you conclude that there is a relationship between actors/actresses and movie quality?Justify your answer.

  1. Use the variable you created in part 3 for good/bad movies for this question
    1. Find the mean and standard deviation for each :

Domestic ROI

Worldwide ROI

Actor/Actresses

Good

mean (sd)

Bad

mean (sd)

Good

mean (sd)

Bad

mean (sd)

Overall

mean (sd)

  1. If you wanted to determine if Domestic (Worldwide) ROI differed between good movies and bad movies for each actor/actress, which hypothesis test would you use?
  2. Based on the means and standard deviations in the table, does it appear that there is a difference between good movies and bad movies for each actor/actress? Justify your answer.

  1. Based on information from parts 1-4, who do you believe is the best actor/actress? Justify your answer.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistical Inference

Authors: George Casella, Roger L. Berger

2nd edition

0534243126, 978-0534243128

More Books

Students also viewed these Mathematics questions