i need help on how to do this in excel sheet. i understand the formulas on sheet but if you could help me solve this on an excel sheet that would be amazing !! (if you could provide me with formula screenshots that would be very helpful! from a to d only !! thank you !!)

9. Dixie Showtime Movie Theaters, Inc. owns and operates a chain of cinemas in several markets in the southern United States. The owners would like to estimate weekly gross revenue as a function of advertising expenditures. Data for a sample of eight markets for a recent week follow: Market Weekly Gross Revenue ($100s) 101.3 51.9 Television Advertising ($100s) 5.0 3.0 4.0 Newspaper Advertising ($100s) 1.5 3.0 74.8 1.5 4.3 4.3 Mobile Shreveport Jackson Birmingham Little Rock Biloxi New Orleans Baton Rouge 126.2 137.8 3.6 4.0 3.5 101.4 237.8 219.6 2.3 8.4 5.0 6.9 5.8 a. Develop an estimated regression equation with the amount of television advertising as the independent variable. Test for a significant relationship between television advertising and weekly gross revenue at the 0.05 level of significance. What is the interpretation of this relationship? b. How much of the variation in the sample values of weekly gross revenue does the model in part (a) explain? c. Develop an estimated regression equation with both television advertising and newspaper advertising as the independent variables. Test whether each of the regres- sion parameters Bo, Bi, and B2 is equal to zero at a 0.05 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? d. How much of the variation in the sample values of weekly gross revenue does the model in part (c) explain? e. Given the results in parts (a) and (c), what should your next step be? Explain. f. What are the managerial implications of these results