Pleased include excel

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 Office Production Advertising Oscar Revenue Cost Expense Book Sales Major Star Nominated 135.4 15.1 7.? 20.8 Y Y 130.6 10.? 8.4 12.2 Y Y 106.3 12.9 5.8 8.8 Y N 91 .9 7.6 5.9 N N 89.3 10.2 4.5 2.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.1 2.9 10.6 Y N 50.2 5.2 2.1 15.1 N Y 30.3 3.5 1.2 3.5 N N Where box office 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 110 t 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 p0 ints) 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