Error In The Slope Of A Line
Contents |
The standard error of slope of regression line Linest() function in Excel gives the error (or uncertainty) error in slope linear regression for data in the lab. It calculates the statistics for a line
Error In Slope Of Linear Fit
by using the "least squares" method to calculate a straight line that best fits your data, and returns an array that
Percent Error Slope
describes the line. Because this function returns an array of values, it must be entered as an array formula. An array should be entered in the four boxes. The array represents the following: error in slope calculator Error in the Slope To determine the +/- error in the slope and the y-intercept, an array must be created. Go back to the original spreadsheet and highlight 4 empty boxes as shown below. Click the mouse in the formula box and enter the LINEST function. =LINEST(B2:B12,A2:A12,true,true) The B2:B12 interval represent the known y values and the A:2:A12 interval represent the x values. The LINEST function will evaluate the errors in the slope and y-intercept for a data set. The const and stats should be labeled true and true as shown below. IMPORTANT: To enter an array, hold down the Ctrl and Shift keys at the same time and then press Enter.
circles; each datum has error bars to indicate the
Error In Slope Excel
uncertainty in each measurement. It appears that current is measured to how to find standard error of slope +/- 2.5 milliamps, and voltage to about +/- 0.1 volts. The hollow triangles represent points used standard error of slope formula to calculate slopes. Notice how I picked points near the ends of the lines to calculate the slopes! Draw the "best" line through all the points, taking http://web.alfredstate.edu/quagliato/linest/linest.htm into account the error bars. Measure the slope of this line. Draw the "min" line -- the one with as small 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. Draw the "max" line -- http://spiff.rit.edu/classes/phys369/workshops/w1b/graph_example.html 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. In the example above, I find 147 mA - 107 mA mA "best" slope = ------------------ = 7.27 ---- 10 V - 4.5 V V 145 mA - 115 mA mA "min" slope = ------------------ = 5.45 ---- 10.5 V - 5.0 V V 152 mA - 106 mA mA "max" slope = ------------------ = 9.20 ---- 10 V - 5.0 V V mA Uncertainty in slope is 0.5 * (9.20 - 5.45) = 1.875 ---- V There are at most two significant digits in the slope, based on the uncertainty. So, I would say the graph shows mA slope = 7.3 +/- 1.9 ---- V Last modified 7/17/2003 by MWR.
treated statistically in terms of the mean and standard deviation. The same phenomenon applies to each measurement taken in the course of constructing a calibration curve, causing a variation in the slope and intercept of http://www.chem.utoronto.ca/coursenotes/analsci/stats/ErrRegr.html the calculated regression line. This can be reduced - though never completely eliminated - http://phys114115lab.capuphysics.ca/App%20B%20-%20graphing/appB%20Slope.htm by making replicate measurements for each standard. Multiple calibrations with single values compared to the mean of all three trials. Note how all the regression lines pass close to the centroid of the data. Even with this precaution, we still need some way of estimating the likely error (or uncertainty) in the slope and intercept, error in and the corresponding uncertainty associated with any concentrations determined using the regression line as a calibration function. Tips & links: Skip to uncertainty of the regression Skip to uncertainty of the slope Skip to uncertainty of the intercept Skip to the suggested exercise Skip to Using Excel’s functions Download a specimen Excel file for this section Navigation: Introduction Bibliography Contact Info Copyright How to Use Concept Map Site Map error in slope Excel™ Basics Entering Data Formulas Plotting Functions Trendlines Basic Statistics Stats in Anal Chem Mean and Variance Error and Residuals Probability Confidence Levels Degrees of Freedom Linear Regression Calibration Correlation Linear Portions Regression Equation Regression Errors Using the Calibration Limits of Detection Outliers in Regression Evaluation & Comparison Hypotheses t-test 1- and 2-tailed Tests F-test Summary Quick Links: Site Map Concept Map Next Page Previous Page Next Topic Previous Topic The Uncertainty of the Regression: We saw earlier that the spread of the actual calibration points either side of the line of regression of y on x (which we are using as our calibration function) can be expressed in terms of the regression residuals, (yi − ): The greater these resdiuals, the greater the uncertainty in where the true regression line actually lies. The uncertainty in the regression is therefore calculated in terms of these residuals. Technically, this is the standard error of the regression, sy/x: Note that there are (n − 2) degrees of freedom in calculating sy/x. This is because we are making two assumptions in this equation: a) that the sample population is representative of the entire population, and b) that the values are representative of the true y-values. For each assumpti
For instance, \(5 \pm 1\) would be a bar drawn from 4to6. When the uncertainty is too small to be indicated on the graph then a single point is used. Figure 5 Worst FitsWhen determining parameters, such as slope, from a graph there is always an uncertainty associated with it - similar to making any sort of measurement. In determining the slope of a straight line graph one draws a best fit line. To estimate the uncertainty of the best fit one draws two worst fit lines. These indicate the largest and smallest slopes which might still reasonably fit the plot. The uncertainty of the best fit is then taken as half the difference between the worst fits. Note that the best fit may not lie exactly half way between the two worst fits. Graph slope =\(m_{best} \pm \Delta m\) where slope uncertainty is \(\Delta m = \frac{1}{2}(m_{high} - m_{low})\) Special Case, points dead-onA special case may occur when the best fit line hits all the points dead-on, so that drawing worst fit lines is unfeasible. The uncertainty in the slope is now determined from the reading error of the graph by treating the graph paper as a measuring instrument. This is done by considering the x-values as fixed and measuring the uncertainty in reading of the y-values from the graph (as read from the graph, not from the data). This uncertainty is then propagated through the slope calculation. Note that the uncertainties in the data points themselves are not used here and the error bars are too small to be visible on the graph. \[m \pm \Delta m = \frac{(y_{2} \pm \Delta y) - (y_{1} \pm \Delta y)}{x_{2} - x_{1}} \]