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/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.