Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more. - Basic Excel Business Analytics #46: Slope & Intercept for Estimated Simple Liner Regression Equation

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Learn: 1) (00:14) Should we create an estimated liner regression equation? Scatter and Correlation gives us a hint. 2) (01:17) Remember Algebra Equation and see what we use in Statistics. 3) (02:14) What does slope mean? 4) (02:30) What does y-intercept mean? 5) (02:50) Simple Linear Regression Model with Population Parameters and Error Epsilon. 6) (03:12) What does the Error Epsilon in the Regression Model Mean? 7) (03:50) Assumptions about Error Epsilon in the Simple Linear Regression Model. Assumptions about Least Squared Method. In essence, the assumptions so that the Equation won’t overpredict or underpredict too much. 8) (07:03) Simple Linear Regression Equation with Population Parameters E( y | x) 9) (07:38) Estimated Simple Linear Regression Equation Y hat = b1*x + b0. 10) (09:36) Formulas for Sample Statistics Slope and Intercept. 11) (09:56) Example of formulas for Sample Statistics Slope and Intercept Long Hand using Excel 12) (11:36) SLOPE and INTERCEPT Excel functions. 13) (12:28) Interpret Slope 14) (12:52) Experimental Region 15) (13:37) Predict with Equation 16) (15:29) Interpret Y-Intercept 17) (15:52) Second Example on BMX Racing Bike and Price data set. 18) (17:47) Summary and Conclusion Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.