Hey guys,
I have a graph of distance on the x and time on the y axis. I will be finding speed by using 1/gradient. I have custom error bars on excel for the time(obtained by combining random and digital uncertainty). I want to know how to find the uncertainty in the trendline in Excel. I know about the LINEST function, but that doesn't take into account the error bars and only takes into account the x and y values only.
Or should I just use LINEST without the error bars and combine the random and scale/digital reading uncertainties after using LINEST? The thing is, for each value plotted on the graph, the combined uncertainty is not the same so I don't know how I would go about combining these uncertainties with the uncertainty from LINEST. Any help would be appreciated!