4/8/2023 0 Comments Trend lines in excel 2016![]() ![]() Now consider a weighted least squares regression. ![]() If const = FALSE the regressor matrix is simply X so running the regression with a column of ones included gives the same estimates as running without a column of ones and setting const=TRUE. If const = TRUE the regressor matrix is the augmented matrix consisting of a column of ones followed by the regressor columns i.e. With data in A2:C7, based on the standard weighted least squares formula, you can try: =LINEST(B2:B7*C2:C7^0.5,IF(,1,A2:A7)*C2:C7^0.5,0,1),3,1)Ĭonsider first a normal regression of y on X using LINEST.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |