The least-squares estimates of the slope and intercept for the given data set should be calculated.
The least-squares estimates of a set of data behaving linearly are defined as follows:
can be calculated using:
Standard deviations of the slope and intercept and the standard error of the estimates for the given data set should be calculated using the LINEST function in EXCEL.
In order to use the LINEST function in EXCEL to obtain statistical values for a given data set, the following command should be typed on an EXCEL spread sheet, in which the given data is already been typed in two columns.
The confidence intervals for the slope and the intercept should be determined.
The general formula to calculate the confidence intervals for a statistic relevant to a regression analysis is as follows:
The glucose concentration and its standard deviation of a serum sample, which gave an absorbance of 0.350 should be calculated.
To determine an unknown glucose concentration from the least-squares line, the valueof the absorbancey, the slope ( ) and intercept ( ) can be used as follows,
The standard deviation of ( ) is calculated by,
Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*
*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.