## How do you calculate the uncertainty of a slope?

Draw the “max” line — the one with as large a slope as you think reasonable (taking into account error bars), while still doing a fair job of representing all the data. Measure the slope of this line. Calculate the uncertainty in the slope as one-half of the difference between max and min slopes.

### How do you find theoretical value of slope?

The theoretical value of the slope is equal to 2p, or p = slope/2. The formula in cell E3 (=E1/2) gives the experimental value of p to be 3.09.

#### How does excel calculate best fit line?

The equation of a straight line is y = mx + b. Once you know the values of m and b, you can calculate any point on the line by plugging the y- or x-value into that equation. You can also use the TREND function. where x and y are sample means; that is, x = AVERAGE(known x’s) and y = AVERAGE(known_y’s).

How do you calculate linear error?

The linearity error of a system is the maximum deviation of the actual transfer characteristic from a prescribed straight line. Manufacturers specify linearity in various ways, for instance as the deviation in input or output units: Δxmax or Δymax, or as a fraction of FS (full scale): Δxmax/xmax.

What is the formula for calculating uncertainty?

Relative uncertainty is relative uncertainty as a percentage = δx x × 100. To find the absolute uncertainty if we know the relative uncertainty, absolute uncertainty = relative uncertainty 100 × measured value.