2. Assume the following data is obtained from the top 10 movies so that have been based on books to come out so far this year: Box Ofce Production Advertising Oscar Revenue Cost Expense Book Sales Major Star Nominated 135.4 15.1 7.7 20.8 Y Y 130.6 10.7 8.4 12.2 Y Y 106.3 12.9 5.8 8.8 Y N 9] 9 7.6 5.9 N N 89.3 10.2 4-5 7.9 N N 85.1 8.5 5.1 4.7 Y N 79.4 9.2 3.7 9.7 Y Y 54.8 3.] 2.9 10.6 Y N 50.2 5.2 2.] 15.] N Y 30.3 3.5 1.2 3.5 N N Where box ofce revenue, production cost, advertising expense, and book sales are all in millions of dollars. Major star is a dummy variable which refers to whether or not the movie stared one of the top 20 highest paid actors, and Oscar nominated is a dummy variable which refers to whether or not the movie received an Oscar nomination in for either Best Picture, Best Actor, or Best Actress. ('4 points) a. Based on the above data generate an estimated equation to explain box ofce revenue. b. Based on your results how would you evaluate your estimate (overall and variables)? c. Include your Excel generated summary output