Excel 2007 Regression line calculations

HaxorNubcake

Golden Member
Jun 23, 2004
1,983
0
0
I have data with uncertainties (+/- 0.05) and I plotted the error bars accordingly. However, I also need to show the uncertainties in the slope and Y intercept of the regression line.

I'm not sure how to do this in excel 07. Any help would be greatly appreciated.

Thanks.
 

WildHorse

Diamond Member
Jun 29, 2003
5,006
0
0
well, in the context of quality assurance / process improvement programs I've seen diagrams that display regression lines, and then show the uncertainty by drawing a small normal distribution curve centered over the line, and indicating the standard deviation with a label.

Can you picture that?

Here's an example I pulled out quickly, but you can probably find better examples:

for HaxorNubcake

If you can't read this scan then PM your e-mail address to me & I'll send it to you.

So for your regression line you could show the uncertainty / variability with a bell curve straddling over the line. Label it with its standard deviation.

For your slope, you could show uncertainty / variability by maybe drawing 2 regression lines, one being the min slope & the other being the max slope. You could designate the uncsrtainty by drawing a little normal distribution curve sideways along the y-axis between their y intercepts, and label it with its standard deviation.

Or for your slope, here's another way to show the uncertainty:
since slope is simply the 1st derivative, you could take the 1st derivative of your regression line, and draw the result as a line, then straddle a normal distribution curve over it to show the uncertainty of the slope.

(In actuality the uncertainty may not follow a normal distribution, but I'd think it's fair to assume it is for purposes of your exercise. You could maybe put this fact in a footnote.)

"How" to display data is a large subject, and if you look in your school library you'll find entire books dedicated just to How to display data. Just ask any business or engineering grad student, or your research librarian, about how to do it.
 
sale-70-410-exam    | Exam-200-125-pdf    | we-sale-70-410-exam    | hot-sale-70-410-exam    | Latest-exam-700-603-Dumps    | Dumps-98-363-exams-date    | Certs-200-125-date    | Dumps-300-075-exams-date    | hot-sale-book-C8010-726-book    | Hot-Sale-200-310-Exam    | Exam-Description-200-310-dumps?    | hot-sale-book-200-125-book    | Latest-Updated-300-209-Exam    | Dumps-210-260-exams-date    | Download-200-125-Exam-PDF    | Exam-Description-300-101-dumps    | Certs-300-101-date    | Hot-Sale-300-075-Exam    | Latest-exam-200-125-Dumps    | Exam-Description-200-125-dumps    | Latest-Updated-300-075-Exam    | hot-sale-book-210-260-book    | Dumps-200-901-exams-date    | Certs-200-901-date    | Latest-exam-1Z0-062-Dumps    | Hot-Sale-1Z0-062-Exam    | Certs-CSSLP-date    | 100%-Pass-70-383-Exams    | Latest-JN0-360-real-exam-questions    | 100%-Pass-4A0-100-Real-Exam-Questions    | Dumps-300-135-exams-date    | Passed-200-105-Tech-Exams    | Latest-Updated-200-310-Exam    | Download-300-070-Exam-PDF    | Hot-Sale-JN0-360-Exam    | 100%-Pass-JN0-360-Exams    | 100%-Pass-JN0-360-Real-Exam-Questions    | Dumps-JN0-360-exams-date    | Exam-Description-1Z0-876-dumps    | Latest-exam-1Z0-876-Dumps    | Dumps-HPE0-Y53-exams-date    | 2017-Latest-HPE0-Y53-Exam    | 100%-Pass-HPE0-Y53-Real-Exam-Questions    | Pass-4A0-100-Exam    | Latest-4A0-100-Questions    | Dumps-98-365-exams-date    | 2017-Latest-98-365-Exam    | 100%-Pass-VCS-254-Exams    | 2017-Latest-VCS-273-Exam    | Dumps-200-355-exams-date    | 2017-Latest-300-320-Exam    | Pass-300-101-Exam    | 100%-Pass-300-115-Exams    |
http://www.portvapes.co.uk/    | http://www.portvapes.co.uk/    |