| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to get slope with a forced intercept of zero
how to get slope with a forced intercept of zero in excel
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to get slope with a forced intercept of zero
Try using regression from data analysis.
"Dennis" wrote: how to get slope with a forced intercept of zero in excel |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to get slope with a forced intercept of zero
See Help for the LINEST worksheet function.
Jerry "Dennis" wrote: how to get slope with a forced intercept of zero in excel |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to get slope with a forced intercept of zero
And yet a third way is
=SUMPRODUCT(y-range, x-range)/SUMSQ(x-range) or the equivalent =SUMPRODUCT(y-range, x-range)/SUMPRODUCT(x-range, x-range) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dennis" wrote in message ... how to get slope with a forced intercept of zero in excel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting intercept to zero with SLOPE/STEYX/etc | Excel Worksheet Functions | |||
| Linear Regression by set Slope (not intercept) | Excel Discussion (Misc queries) | |||
| Excel Linear Regression by set slope (not intercept) | Excel Worksheet Functions | |||
| Calculating slope, intercept, LOGEST with empty cells in data | Excel Worksheet Functions | |||
| plot 10 data pts in least square fit to find slope and intercept | Excel Worksheet Functions | |||
Hybrid Mode
