Determining Min & Max Slopes w/Varying STDEV

  • Context: Graduate 
  • Thread starter Thread starter Salish99
  • Start date Start date
  • Tags Tags
    Data Max
Click For Summary
SUMMARY

This discussion focuses on determining the maximum and minimum slopes in a simple linear regression analysis when each data point has individual, non-equal standard deviations. The proposed method involves adjusting the data points by their standard deviations to calculate the slopes. The concept of "Weighted Least Squares" is suggested as a potential solution for this analysis, allowing for the incorporation of varying standard deviations in the slope calculations.

PREREQUISITES
  • Understanding of simple linear regression analysis
  • Familiarity with standard deviation and its application in data analysis
  • Knowledge of "Weighted Least Squares" methodology
  • Basic proficiency in data manipulation and statistical software
NEXT STEPS
  • Research "Weighted Least Squares" for regression analysis
  • Explore the application of standard deviations in slope calculations
  • Learn about the "LINEST" function in Excel for regression analysis
  • Investigate alternative methods for handling varying standard deviations in datasets
USEFUL FOR

Data analysts, statisticians, and researchers involved in regression analysis and those looking to refine their understanding of handling varying standard deviations in datasets.

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?
 

Similar threads

Replies
2
Views
1K
  • · Replies 2 ·
Replies
2
Views
8K
  • · Replies 41 ·
2
Replies
41
Views
6K
  • Poll Poll
  • · Replies 5 ·
Replies
5
Views
13K
  • Poll Poll
  • · Replies 3 ·
Replies
3
Views
3K
  • Poll Poll
  • · Replies 1 ·
Replies
1
Views
5K
  • · Replies 6 ·
Replies
6
Views
6K
  • Poll Poll
  • · Replies 3 ·
Replies
3
Views
8K
Replies
3
Views
3K
  • · Replies 11 ·
Replies
11
Views
33K