Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Help with Statistics: Linear Regression, Correlation, Confidence Interval

Hello everyone,   I have two columns of data that are somewhat correlated. My task here is to show that correlation, and to use it to predict future outcomes (e.g given X, what is y) as well as the...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi Anonymous

Does the margin of error which calculated as you said satisfy your requirement?

What you are seeking for is to show the value of “margin of error” around a trendline?

 

Best Regards

Maggie

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Yes, that's exactly what i am trying to calculate - the margin of error/confidence interval around the trendline.

    Determining the margin of error for set of values (one variable) is simple...  what I don't understand is how to do for a trendline becauses there are two correlated values.

     

    Any stats gurus who know how this can be done, please help :)