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:
- 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.
- 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.
- Determine the goodness of fit. Is the fit statistically significant?
