Please answer in excel format with the formulas showing. A screenshot works perfectly.

Problem 31 worth 12 points. Answer this question to the best of your ability. Please do not write in column A. Orion Electronics, a fictitious chain of electronics stores, operations a website to encourage potential customers to buy its products online. Because the website is expensive to maintain, the BP of Marketing is unsure if the online sales of the company's products is directly related to the number of hits on the website. To evaluate this relationship, the marketing manager of the company is directed to gather monthly data on the number of hits and the corresponding sales for the past 24 months. The data are presented in the following table: Number of hits (in 000) a (3 points) What should you do with the data highlighted in red for forecasting purposes? Include it in the model or omit it? b (3 Points) Develop a linear regression model using excel by including all 24 pieces of data. 42.3 29.6 38.4 45.7 24.3 55.4 3.9 30.7 29.2 33.9 28.5 21.6 C (3 points) Develop a linear regression model using Excel after excluding the highlighted data in red. Customer orders (in 000s) 9.4 6.1 9.7 8.3 5.1 11.7 0.5 7.3 6.7 7.4 5.5 4.9 11.3 9.9 12.5 11.9 14.8 6.9 5.4 4.9 10.8 10.9 11.1 7.7 48.8 d (3 points) Compare the Excel outputs from Parts b and c, and determine which linear regression model is a better fit. 44.3 57.1 54.3 65.9 36.8 27.4 24.1 40.1 47.8 45.5 32.3