| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SLOPE, (error in b if y= a+ bx)
So I did my regression analysis using the SLOPE function, the number I'm
interested in however is the error in the result of SLOPE (b if y = a + bx). What Excel function to use here ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SLOPE, (error in b if y= a+ bx)
On Mon, 10 Mar 2008 04:11:01 -0700, Miesjz
wrote: So I did my regression analysis using the SLOPE function, the number I'm interested in however is the error in the result of SLOPE (b if y = a + bx). What Excel function to use here ? Look at HELP for the LINEST function. The standard error for the slope, assuming a single range of x-values, would be returned by =INDEX(LINEST(known_y's,known_x's,,TRUE),2) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Interpreting graph of a slope | Charts and Charting in Excel | |||
| How to add slope formula to graph | Charts and Charting in Excel | |||
| slope of data with the same y values | Excel Discussion (Misc queries) | |||
| Slope of graph? | Charts and Charting in Excel | |||
| Simple Slope Formulation | Excel Discussion (Misc queries) | |||
Linear Mode
