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

Question:

The file S03_22.xlsx lists financial data on movies released since 1980 with budgets at least $20 million.
a. Reduce the size of this data set by deleting all movies with a budget of more than $100 million. Also, delete all movies where US Gross and/or Worldwide Gross is listed as Unknown.
b. For the remaining movies, create a table of correlations between the variables Budget, US Gross, and Worldwide Gross. Comment on the results. Are there any surprises?
c. For the movies remaining after part a, create a scatter plot of Worldwide Gross (Y axis) versus US Gross and another scatter plot of US Gross (Y axis) versus Budget. Briefly explain any patterns you see in these scatter plots. Do they seem to be consistent with the corresponding correlations?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Answer rating: 60% (10 reviews)

Answered By

Denis González

I have high ethical and moral principles. I do not do the tasks of copying and pasting information, I like to be creative and original. I teach step by step all necessary procedures so that the student understands the whole lesson and explanations. Since I finished high school in 1979, I taught math and physics. In 2002, I began to give courses at university level in information systems, computer science, mathematics and others. I worked as an assistant professor in Operations Research, Linear Programming and Mathematics. Since 2005 I have been advising degree theses and distance lessons, using social networks and other Internet platforms, where I opened courses and designed four websites that worked for a year. Currently I continue to advise students at a distance for the development of tasks, exercises, programs and thesis. I work as an online tutor at TutorMe.com starting in 2017, attending about 20 lessons per week and teaching 40 subjects, especially mathematics, statistics, accounting, finance, linear programming, computer science, Spanish and Italian.

0.00 0 Reviews 10+ Question Solved

Related Book For book-img-for-question