| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
error analysis
I have a graph of Force(mN) vs Distance(m). The error in the force is 0.0001g and the error in the distance is 0.0254mm. I have 10 points on the graph. Excel gives R^2 = 0.90. My gradient is 1.045. What is it's error? Can someone help? -- labview1958 ------------------------------------------------------------------------ labview1958's Profile: http://www.excelforum.com/member.php...o&userid=32123 View this thread: http://www.excelforum.com/showthread...hreadid=526335 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
error analysis
labview1958 said the following on 3/26/2006 7:12 AM:
I have a graph of Force(mN) vs Distance(m). The error in the force is 0.0001g and the error in the distance is 0.0254mm. I have 10 points on the graph. Excel gives R^2 = 0.90. My gradient is 1.045. What is it's error? Can someone help? It helps to insert the formula you are using. Distance(m) meters? as opposed to (mm) milimeters? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
error analysis
I have another problem about excel staight line graphs. The error bar in the y-axis is 0.0002 and the x-axis is 0.2. Does the slope of my graph have an error of 0.0002/0.2 = 0.001 ? Is that a fair assumption? -- labview1958 ------------------------------------------------------------------------ labview1958's Profile: http://www.excelforum.com/member.php...o&userid=32123 View this thread: http://www.excelforum.com/showthread...hreadid=526335 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
error analysis
labview1958 said the following on 3/26/2006 10:01 AM:
I have another problem about excel staight line graphs. The error bar in the y-axis is 0.0002 and the x-axis is 0.2. Does the slope of my graph have an error of 0.0002/0.2 = 0.001 ? Is that a fair assumption? I would look into one of the MVP sites on excel charting Going through David McRitchie's site http://www.mvps.org/dmcritchie/excel/xlindex.htm I found these subsequent links for manipulating excel charts. http://peltiertech.com/Excel/Charts/index.html#hdrAxes http://www.edferrero.com/charting.aspx |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
error analysis
I have looked at the sites but I still have not found a reasonable answer. Is my reasoning flawed? -- labview1958 ------------------------------------------------------------------------ labview1958's Profile: http://www.excelforum.com/member.php...o&userid=32123 View this thread: http://www.excelforum.com/showthread...hreadid=526335 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
error analysis
I have come across a formula that calculates the error in a slope. Here it is: error in slope = (N (sigma(y) ^ 2))/(delta) Can excel help? -- labview1958 ------------------------------------------------------------------------ labview1958's Profile: http://www.excelforum.com/member.php...o&userid=32123 View this thread: http://www.excelforum.com/showthread...hreadid=526335 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
error analysis
labview1958 said the following on 3/27/2006 11:02 PM:
I have come across a formula that calculates the error in a slope. Here it is: error in slope = (N (sigma(y) ^ 2))/(delta) Can excel help? In Excel, I use statistical functions to determin error in slope {=LINEST(y-range,x-range,intercept,statistics)}. Which is typed in like this =LINEST(B6:B12,A6:A12,,1) then hit ctrl+shift+enter. Ctrl+shift+enter will place the {} around the formula. See MS KB at for the description and sample use. I assume you have Excel 2003 or 2004. http://support.microsoft.com/kb/828533 I assume you need to view a sample worksheet If you need one I can send it to you but use an anti-virus checker. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
