Determining Min & Max Slopes w/Varying STDEV

  • Thread starter Thread starter Salish99
  • Start date Start date
  • Tags Tags
    Data Max
Salish99
Messages
28
Reaction score
0
If I have a slope for which I do simple linear regression analysis, but each of the 6 datapoints of the slope have their individual (non-equal) standard deviations, how can I calculate the maximum and minimum slope of the graph?
One idea we too up was to increase the first half of the data points by the standard deviation, and decrease the other have by their standard deviations (and vice versa) in order to determine the maximum and minimum slopes from the resulting data points.
Is such an analysis valid? What else could I do to determine the maximum and minimum slopes based on the individual standard deviations?
If my explanation was unclear I have attached a document with simple made-up values for representation of the issue:
http://drop.io/stats20100/asset/minmax-gif"
This example data was created for simple commenting, the actual data is more complex.
Below the values used for this example:

x y σ, % σ y-σ y+σ MINsl MAXslope
1 1 10 0.1 0.9 1.1 1.1 0.9
2 2 20 0.4 1.6 2.4 2.4 1.6
3 3 10 0.3 2.7 3.3 3.3 2.7
4 4 10 0.4 3.6 4.4 3.6 4.4
5 5 20 1.0 4.0 6.0 4.0 6.0
6 6 10 0.6 5.4 6.6 5.4 6.6

LINEST
1 0 AVG
0.76 0.64 MIN
1.24 -0.64 MAX
 
Last edited by a moderator:
Physics news on Phys.org


Salish99 said:
each of the 6 datapoints of the slope have their individual (non-equal) standard deviations

Is "Weighted Least Squares" what you were looking for?
 
Namaste & G'day Postulate: A strongly-knit team wins on average over a less knit one Fundamentals: - Two teams face off with 4 players each - A polo team consists of players that each have assigned to them a measure of their ability (called a "Handicap" - 10 is highest, -2 lowest) I attempted to measure close-knitness of a team in terms of standard deviation (SD) of handicaps of the players. Failure: It turns out that, more often than, a team with a higher SD wins. In my language, that...
Hi all, I've been a roulette player for more than 10 years (although I took time off here and there) and it's only now that I'm trying to understand the physics of the game. Basically my strategy in roulette is to divide the wheel roughly into two halves (let's call them A and B). My theory is that in roulette there will invariably be variance. In other words, if A comes up 5 times in a row, B will be due to come up soon. However I have been proven wrong many times, and I have seen some...

Similar threads

Back
Top