| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i calculate least-square regression analysis?
Guys,
please help me. thx. Cheers, Mie Mie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i calculate least-square regression analysis?
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 -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Mie Mie" <Mie wrote in message ... Guys, please help me. thx. Cheers, Mie Mie |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i calculate least-square regression analysis?
On Mon, 8 Oct 2007 03:13:00 -0700, Mie Mie <Mie
wrote: Guys, please help me. thx. Cheers, Mie Mie 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i graph a regression analysis? | Excel Discussion (Misc queries) | |||
| Using Regression Analysis? | New Users to Excel | |||
| regression lines and r-square in work sheets instead of charts | Charts and Charting in Excel | |||
| Regression Output -- R Square versus Adjusted R Square | Excel Discussion (Misc queries) | |||
| Regression Analysis Format | Excel Discussion (Misc queries) | |||
Linear Mode
