![]() With R-squared of 0.8 and estimated standard deviation of u of 0.36515Īnd we forecast that for x = 6 we have y = 0.8 + 0.4*6 = 3.2. FORECAST(6,A1:A6,B1:B6) yields the OLS forecast value ofįor X=6 (forecast 3.2 cars for household of size 6).STEYX(A1:A6,B1:B6) yields the standard error of the regression. ![]() RSQ(A1:A6,B1:B6) yields the R-squared of 0.8.SLOPE(A1:A6,B1:B6) yields the OLS slope estimate of 0.4.INTERCEPT(A1:A6,B1:B6) yields the OLS intercept estimate.The individual functions INTERCEPT, SLOPE, RSQ, STEYX andįORECAST can be used to get key results for two-variable We wish to estimate the regression line: y = ![]() The population regression model is: y = β 1 REGRESSION USING EXCEL FUNCTIONS INTERCEPT, SLOPE, RSQ, STEYX and It is easier to instead use the Data Analysis Add-in for Regression.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |