I have data from a chemistry experiment. I have ploted it on a scatter graph, an

Question

I have data from a chemistry experiment. I have ploted it on a scatter graph, and have gotten the trendline. i have to calculate uncertainty, which means I need to use the linest function, but when i use this, i get a compltely different slope, which leads me to believe the uncertainty is off as well (as the uncertainty I have calucalated seems to be incorect.

1/T (Kelvin) In(Pressure 0.003403676 5.416544748 0.00337952 5.48147191 0.003343922 5.589119566 0.003322811 5.662613198 0.003298697 5.74875584 0.003273858 5.828651457 0.003250447 5.90835464 0.003222169 6.009550015 0.003201537 6.081305251 0.003179145 6.160151913 0.003156068 6.242806753 0.003136271 6.307916276 0.003118665 6.368187186 0.003099334 6.434385992 Pressure Vs Temperature of Acetone 6.6 6.4 6.2 y -3400.2x 16.969 In(Pressure) 5.8 5.6 5.4 5.2 Linear (In[Pressure)) Slope(m) t(m RA2 0.004989517 intercept (b) -0.00029394 2.03536E-06 1.21195E-05 (b) 0.999424942 2.46095E-06 sy 20855.47556 0.003 0.0031 0.0032 0.0033 0.0034 0.0035 12 DF Regression S 1.26307E-07 7.26756E-11 residual ss

Explanation / Answer

The reason why you get two completely different slopes is because while plotting the graph all your values are rounded off and then the graph is plotted while when you did regression the calculation was done on actual data values and not rounded off values.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.