| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error of slope taking into account error of the data points
Hi!
I need to find the error of the slope of the line of best fit taking into account the error of the individual data points. I have a fixed value for the error of the points that I have figured out independently. (It's about .8 for every point) I have the error bars on, but excel isn't taking the error of the points into account when determining the error of the slope! So...how do I solve this? I don't necessarily need an excel function to do it for me, a formula would be fine. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SLOPE, (error in b if y= a+ bx) | Excel Worksheet Functions | |||
| How do I specify min/max error bars for individual data points? | Charts and Charting in Excel | |||
| 32,000 data points error message | Charts and Charting in Excel | |||
| Taking in account additional rows | Excel Discussion (Misc queries) | |||
| How to calculate a person's age taking into account their birthda. | Excel Worksheet Functions | |||
Threaded Mode
