how do i calculate least-square regression analysis?

  • Thread starter Thread starter Guest
  • Start date Start date
We need more details: are you fitting to a linear function? what info do you
want?
Please tell us more so we can hep.
best wishes
 
Guys,

please help me. thx.

Cheers,
Mie Mie
Click to expand...


Look at the LINEST function.

LINEST calculates the statistics for a line by using the "least squares" method
to calculate a straight line that best fits your data, and then returns an
array that describes the line.

It will return the values for the line, as well as, optionally, additional
regression statistices.
--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2002 Analysis ToolPak Regression Analysis Help Requested 1
Regression with zero intercept 2
Least Squares Regression ST. Dev. 5
How does Excel calculate Multiple R when doing multiple regression 1
Linear Regression in Excel 1
How to perform logistic regression in Excel 2003 4
Recalculating a Regression Output in Data Analysis 1
Does Excel use least squares regression to calculate trendlines? 3

Back
Top