1. 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: Ofce Production Advertisin Oscar Revenue Cost ; Ex-ense Ma'or Star Nominated I Y Y Y Y -- N - N N Y N Y - N - Y - N Where box office revenue, production cost, advertising expense, and book sales are all in millions of dollars. Maj or 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 office revenue. b. Based on your results how would you evaluate your estimate overall? (Include discussion on multicollinearity, overall model significance, and the significance of included variables) c. Include your Excel generated summary output