Results 1 to 15 of 15

20020320, 20:06 #1
 Join Date
 Mar 2002
 Posts
 5
 Thanks
 0
 Thanked 0 Times in 0 Posts
Statistical Analysis and error calculation (Excel 2002)
I have recently begun a pysics investigation and have decided to use Excel.I have created my graph of all the data, however for use in a calculation I must know the error percentage in the gradient of the trendline that excell has placed on the graph, does any one know how I can either display this or calculate it.????

20020321, 07:11 #2
 Join Date
 Feb 2001
 Location
 Weert, Limburg, Netherlands
 Posts
 4,812
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Statistical Analysis and error calculation (Excel 2002)
Check out the Tools, Data analysis option, which gives more control over what you get.
Be aware, that Excels' statistical features are far from precise and sometimes even yield faulty results. It is better to use dedicated statistical software for real life statistical tasks.Jan Karel Pieterse
Microsoft Excel MVP, WMVP
www.jkpads.com
Professional Office Developers Association

20020321, 09:22 #3
 Join Date
 Mar 2002
 Posts
 5
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Statistical Analysis and error calculation (Excel 2002)
Yeh I know they are but I really need this thing and I dont have time to get the new software so does n e 1 know a way to get excel to do it or even a formula for working this thing out.

20020321, 10:20 #4
 Join Date
 Feb 2001
 Location
 Weert, Limburg, Netherlands
 Posts
 4,812
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Statistical Analysis and error calculation (Excel 2002)
As I said:
Tools, Data analysis, regression.Jan Karel Pieterse
Microsoft Excel MVP, WMVP
www.jkpads.com
Professional Office Developers Association

20020321, 10:57 #5
 Join Date
 Mar 2002
 Posts
 5
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Statistical Analysis and error calculation (Excel 2002)
Yeh but dosent regression just give you how well the points lie on the line????? Thats not what the percentage error in the gradient is, is it???

20020321, 11:02 #6
 Join Date
 Feb 2001
 Location
 Weert, Limburg, Netherlands
 Posts
 4,812
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Statistical Analysis and error calculation (Excel 2002)
Hey, why not just try? Look at the attached sheet what it can do!
I am pretty sure what you need is there.Jan Karel Pieterse
Microsoft Excel MVP, WMVP
www.jkpads.com
Professional Office Developers Association

20020321, 12:19 #7
 Join Date
 Mar 2002
 Posts
 5
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Statistical Analysis and error calculation (Excel 2002)
k thanks m8t I know ive bin a pain but uve saved my @#$!% big time.

20020321, 18:06 #8
 Join Date
 Jan 2001
 Location
 Kortrijk, Belgium
 Posts
 571
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Statistical Analysis and error calculation (Excel 2002)
If you apply the regression tool from the Analysis Toolpak, then the standard error of the regression line is given. This standard error of the regression line is simply the root of (the sum of squares of residuals divided by the number of degrees of freedom df). df = n2 in case of linear regression and n is the number of observations.
By the way, regression in Excel can be trusted, except for the adjusted Rsquare when fitting through the origin (zero intercept); then the calculation of the adjusted Rsquare is wrong. For the rest, you can trust the results.
I don't know what you exactly mean with the error percentage in the gradient of the trendline, but there exists a way to calculate confidence intervals and even prediction intervals for a regression line. Is that what you need or did Jan Karel solve your problem?

20020321, 19:38 #9
 Join Date
 Mar 2002
 Posts
 5
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Statistical Analysis and error calculation (Excel 2002)
yeh dude i think thats it if u can tell me PLEASE ill check when i get back to collage [img]/forums/images/smilies/smile.gif[/img]

20020322, 07:14 #10
 Join Date
 Feb 2001
 Location
 Weert, Limburg, Netherlands
 Posts
 4,812
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Statistical Analysis and error calculation (Excel 2002)
Now for the LAST TIME!
Check out the sheet I included some 100 posts ago.
Look at the range a26:G28. It shows all statistics needed, including the confidence interval of the intercept.
Sorry for loosing my patience.Jan Karel Pieterse
Microsoft Excel MVP, WMVP
www.jkpads.com
Professional Office Developers Association

20020322, 12:26 #11
 Join Date
 Mar 2001
 Location
 Springfield, Ohio, USA
 Posts
 2,136
 Thanks
 0
 Thanked 1 Time in 1 Post
Re: Statistical Analysis and error calculation (Excel 2002)
Tokra, you will receive well thought out and well written replies on this board. In turn we would ask that you spend some time phrasing your questions in proper English, looking at the replies, and doing some work yourself. You have just irritated two geniuses at both statistics and Excel, provoked those of us whose first language is English, and confused those who are struggling with English. I would like to learn more about statistical analysis, not just be annoyed by your lack of courtesy. What are you learning at
<font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
<small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

20020322, 13:16 #12
 Join Date
 Feb 2001
 Location
 Weert, Limburg, Netherlands
 Posts
 4,812
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Statistical Analysis and error calculation (Excel 2002)
<<geniuses>>
You didn't mean me, did you <vbg>?Jan Karel Pieterse
Microsoft Excel MVP, WMVP
www.jkpads.com
Professional Office Developers Association

20020322, 14:04 #13
 Join Date
 Mar 2001
 Location
 Springfield, Ohio, USA
 Posts
 2,136
 Thanks
 0
 Thanked 1 Time in 1 Post
Re: Statistical Analysis and error calculation (Excel 2002)
Yes I did and I'll stick by it. Microsoft doesn't give out MVP stickers as Halloween treats. I
<font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
<small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

20020322, 14:25 #14
 Join Date
 Feb 2001
 Location
 Weert, Limburg, Netherlands
 Posts
 4,812
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Statistical Analysis and error calculation (Excel 2002)
I never took a MOUS exam. Wouldn't know for the world if I'd pass <g>.
Jan Karel Pieterse
Microsoft Excel MVP, WMVP
www.jkpads.com
Professional Office Developers Association

20020322, 14:43 #15
 Join Date
 Mar 2001
 Location
 Springfield, Ohio, USA
 Posts
 2,136
 Thanks
 0
 Thanked 1 Time in 1 Post
Re: Statistical Analysis and error calculation (Excel 2002)
The core is a snap, but the expert is a bear: everything from scenarios to database queries.
<font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
<small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>