Create the Linear Model tab as described in Foreman Chapter 6, The Granddaddy of Supervised Artificial Intelligence- Regression, p. 215 of the Foundations of Data Analytics custom ebook.

Data Analytics Question

MICROSOFT EXCEL REGRESSION EXERCISE: LINEAR REGRESSION

Use the Microsoft Excel Practice Exercise Linear Regression Training Data workbook provided and the instructions in the text reading to complete the following tasks:

1. Create the Linear Model tab as described in Foreman Chapter 6, The Granddaddy of Supervised Artificial Intelligence- Regression, p. 215 of the Foundations of Data Analytics custom ebook.
2. Follow the instructions to use Solver to find the minimum sum of squared error. Note that using Evolutionary Solver will give you a different value than in the text or solution.
3. Determine the goodness of fit. Is the fit statistically significant?