Hi(adsbygoogle = window.adsbygoogle || []).push({});

I have some data which concists of some points (x,y) and I'm looking for a program that can calculate for me the slope of the linear fit line (trendline) including uncertanity on the slope. Also the y-interception has to bo at 0.

My data set includes incertanities on both x and y variables.

I have tried this in excel. I can get the slope for the line that has y-intercept = 0, and I can add in the graph my uncertanities, but I cant find out how to calculate the uncertanity of the slope.

I tried another program called graphical analysis. That program can easily give me the slope and the uncertanity of the slope. But I can't seem to find out how to force y-intercept to 0 (force the line through the point (0,0) )

So my questions in general are:

Is there another program that is better suited for this?

How can I calculate uncertanity for the trendline in Excel?

How can I force the trendline (linear fit line) to go through the point (0,0) in Graphical Analysis.

An answer to just one of these questions would be sufficent :)

best regards

frímann kjerúlf

student of University of Iceland

**Physics Forums - The Fusion of Science and Community**

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# What program does linear fit including uncertanities? (excel, graphical analysis ?)

Loading...

Similar Threads - program does linear | Date |
---|---|

Monte carlo algorithms in C++ | Jan 24, 2018 |

How to understand which program is blocking websites? | Dec 28, 2017 |

3 programs installed without my consent, one incompatible... | Oct 17, 2017 |

Running compatibility to install old program in Win10 | Aug 7, 2017 |

Does anyone know what program do professors use for creating PDFs? | Mar 31, 2011 |

**Physics Forums - The Fusion of Science and Community**