Statistics: Linear Regression XLMiner Toolpack
This video covers evaluating the fit of a line and demonstrates finding the important values using a spreadsheet, as well as an addon called XLMiner Data Analysis Tooolpack.
Findings include:
Slope (m), Intercept, Correlation (r), Coefficient of Determination (r^2), Sum Squared Error (SSE), Mean Squared Error (MSE), and Standard Error (SE)
Table of Contents:
01:09 - Using the Insert Chart
02:23 - The Important Terms for Evaluating Best Fit
04:44 - SSE, MSE, SE by Hand
07:26 - XLMiner Toolpack Install and Linear Regression