Home » Questions » Computers [ Ask a new question ]

Use regression equation in excel formula

Use regression equation in excel formula

I have a spreadsheet with a number of graphs on, and I have displayed the trend-lines / regression lines on these graphs. These are not simple linear regression lines, but are high order polynomial ones.

Asked by: Guest | Views: 321
Total answers/comments: 1
Guest [Entry]

"Polynomial n-grade regression in one variable ~ Linear regression in n variables

where ~ denotes ""equivalent to"".

So, in your source data table, add columns to calculate powers of ""independent"" variable values, and then apply formula to calculate coefficients for linear regression with many variables."