| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
