Answered step by step
Verified Expert Solution
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
- Collect movies and ratings fromRotten Tomatoes for at least 5 actors/actresses (each actor/actress should have appeared in at least 10 movies).
- Remove any entries that you judge the actor/actress did not play a major role (you must indicate which ones were removed).
- 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.
- 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.
- Is the budget for a movie a good predictor for box office gross (domestic and worldwide)?
- What is the correlation between budget and domestic gross?
- What is the correlation between budget and worldwide gross?
- What is the regression equation for budget and domestic gross?
- Is the slope significant? Why or why not?
- Interpret the slope
- What is the regression equation for budget and worldwide gross?
- Is the slope significant? Why or why not?
- Interpret the slope
- 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.
- Repeat parts a-e using only the data for one the actors/actresses you selected.
- Repeat parts a-e using only the data for a different actor/actress you used in part f.
- 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) |
---|---|---|---|---|---|
- 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.
- Is the mean the best measure to use for comparisons? Justify your answer.
- What other information might be skewing the results of your analysis? How might this affect your decision?
- 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.
- Justify your criteria for classifying a movie as good or bad
- 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 |
- If you wanted determine if quality of movie (good/bad) is related to actors or actresses, which hypothesis would you use?
- 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.
- Use the variable you created in part 3 for good/bad movies for this question
- 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) |
- 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?
- 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.
- 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started