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
Watch video Statistics: Linear Regression XLMiner Toolpack online without registration, duration hours minute second in high quality. This video was added by user Joshua Johnson 09 October 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,445 once and liked it 13 people.