+ Reply to Thread
Results 1 to 2 of 2

Thread: 95% confidence intervals for linear regression in excel?

  1. #1
    Points: 321, Level: 6
    Level completed: 43%, Points required for next Level: 29

    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    95% confidence intervals for linear regression in excel?




    Hi, I am currently trying to analyse data for my lab experiment and I am having trouble trying to find how to plot individual confidence intervals for my points as I don't have any replicates and we (university class) were told to use the equation B=plus/minus t*s, but as there is no spread of replicate values, I can't see how this is possible... Or is there a way to plot where 95 percent confidence intervals should fall relative to the trend line? Because I tried doing that too, but the intervals were huge and that seemed too big for it to be correct for my two data sets (attached)
    Attached Files

  2. #2
    Points: 293, Level: 5
    Level completed: 86%, Points required for next Level: 7

    Location
    Denmark
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 95% confidence intervals for linear regression in excel?


    Since you were asked to do a linear regression, i would expect your teacher was interested in the confidence interval of the slope and/or the intercept. These interval bounds are printed as "lower 95%" and "upper 95%" by excels Linreg function.
    Uncertainty about your data points would be measurement errors, and should depend on your skill or the instrument you used to measure them.

+ Reply to Thread

           




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts






Advertise on Talk Stats