In immediate need of help with error analysis

[Void123]

Homework Statement

I have used excel to make a linearized fit of data - x and y variables - with no problem. But I must solve for a value that can only be extracted from my slope, also not a problem. My problem is I don't know how to calculate the uncertainty for my slope, based on the fit. I can do individual standard deviations for each column, but I don't know what to do with the slope.

I would appreciate any help, as this is the only thing keeping me from finishing this lab report.

Thanks!

Homework Equations

The Attempt at a Solution

 

[lippyka]

The uncertainty for a slope can be calculated using the following formula: σm = √[∑(x - x̄)2 / (n-2) ∑(x - x̄)2] * σy / √[∑(x-x̄)2]Where: σm is the uncertainty of the slope x is the independent variable x̄ is the mean of the x values n is the number of data points σy is the standard deviation of the y values To calculate the uncertainty of the slope, you will need to calculate the mean of the x values, the standard deviation of the y values, and the sum of the squares of the differences between each x value and the mean of the x values. Once you have these values, plug them into the above formula and you will have the uncertainty of the slope.