LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default slope of data that already contains STDEVs

I am looking for methods to calculate the error in a slope.
the caveat is that my values themselves are averages with a STDEV.
E.g.
x
1+-1%
2+-1%
3+-1%
y
0.14+-0.01
0.27+-0.02
0.42+-0.02
(using http://www.cartage.org.lb/en/themes/...onDivision.htm as the
calculation method for these errors)

This could be simplified by assuming the x-values have no deviation.

Now I can just plot the average slope of those three values, I can make a
simple linear regression analysis, obtain the least square values as shown
here
http://www.physicsforums.com/showthread.php?t=194616 and somewhat related here
http://www.physicsforums.com/showthread.php?t=173827

or use the Excel Linestatistics
(http://www.trentu.ca/academic/physics/linestdemo.html)
I obtain a value for the slope of my averaged slope, and a STDEV, based on
the Least Square algorithm. But this does not take into account at all my
initial STDEV, only the deviation of my data from the mean.
Is there a more general algorithm that can take STDEVs in the initial (at
least) y values, or both x and y values, and how would I calculate that?

Thank you.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to recognize changes in slope of data? [email protected] Excel Discussion (Misc queries) 2 November 23rd 08 01:09 AM
slope of data with the same y values Rosa Excel Discussion (Misc queries) 2 January 2nd 06 01:32 PM
Linest/slope functions with with different data ranges Pat Excel Worksheet Functions 1 August 8th 05 01:42 PM
plot 10 data pts in least square fit to find slope and intercept engineeringdoll Excel Worksheet Functions 1 April 14th 05 01:56 PM
how can i get the slope function to ignore missing data? Delmar Excel Discussion (Misc queries) 0 December 2nd 04 05:55 PM


All times are GMT +1. The time now is 12:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"