Dixie Showtime Movie Theatres, 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. The data are stored in HI6007 Group Assignment T1 2024 data file (sheet 3). Using this data set and EXCEL, and no more than 1500 words in total, answer the following questions. a) Using an appropriate numerical descriptive measure, comment on the strength and the direction of the linear relationship between weekly gross revenue and television advertising; and weekly gross revenue and newspaper advertising. (2 marks) b) Develop a simple linear regression model to estimate the relationship between weekly gross revenue and television advertising expenditure and Comment on the goodness of fit of the estimated model. (2 marks) c) Develop and estimate a multiple linear regression model to estimate the relationship between weekly gross revenue and television and newspaper advertising expenditure. (2 marks) d) What do the estimated regression coefficients in part (c) reveal about the relationship between weekly gross revenue and television and newspaper advertising expenditure? (2 marks) e) Test the overall validity of the estimated multiple regression model in part (d) at the 5% level of significance. (2 marks) f) Test whether linear relationship exists between weekly gross revenue and individual independent variables in part (d) at the 5% level of significance. (2 marks) g) Will your conclusion in part (f) change if the level of significance changes to 1% level of significance? (1 mark) h) Compare the fitness of the multiple linear regression model with that of the simple linear regression model. (2 mark) i) Based on your answers to (a) to (h) above, write a research report (of maximum 300 words) for the head of research division of your company, summarizing your findings and highlighting the managerial implications of these results?