It also gives the option of producing a best fit trendline and formula for the trendline.It also produces bubble diagrams which take into consideration a weight provided with each value.However, the weight has no influence on the trendline or formula.
Here is an example set of values, with their mappings and weights. Is there any way to produce a formula that reflects the respective weights. All three answers from you and brettdj are excellent but each has its disadvantage and advantage. Expanding the data as Brett suggests would help solve polynomial equations. But its slightly impractical for my real world data which has weights in tens of thousands as well as several in single figures. Id also have to find some means of creating that artificial data in large volumes without excel complaining about its 32000 row limit for charts. If const TRUE the regressor matrix is the augmented matrix consisting of a column of ones followed by the regressor columns i.e. X(1,X). 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 constTRUE. The regression is now Wy on WX(W1,WX) where W is the diagonal matrix consisting of the square root of the weights. Since there is not a column of ones present, we must set const FALSE and use two columns in the regressor matrix. Perhaps it could be fixed and adapted for weights tushar-mehta.compublishtraindataanalysis16.htm. Now just add extra digits to the array for a weighted polynomial fit eg use 0,1,2 for a quadratic. The reputation requirement helps protect this question from spam and non-answer activity. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |