Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inverse prediction in regression
After performing a linear or quadratic regression of y = f(x), I need to
find the find the Lower and Upper bounds for the 100gamma percent confidence interval for the predicted value of x given one or more observed values of y. Regards, Ernie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inverse prediction in regression
Excel has no built-in functions to calculate the standard error of a
predicted value, much less do the inversion. LINEST will give you the standard erorr of coefficients, but not their covariance. For simple linear regression, the covariance between slope and intercept estimates is -AVERAGE(xdata)/SQRT(VAR(xdata)+AVERAGE(xdata)) Standard error of a predicted value at xx (possibly not a value in the original xdata) is then SQRT(1/n+(xx-AVERAGE(xdata)/DEVSQ(xdata)) You form a 95% confidence interval for the predicted value by multiplying by TINV(.05,n-2) To invert these confidence limits, you solve quadratics where the upper and lower and lower confidence bounds equal your observed y. Jerry "Ernie Lippert" wrote: After performing a linear or quadratic regression of y = f(x), I need to find the find the Lower and Upper bounds for the 100gamma percent confidence interval for the predicted value of x given one or more observed values of y. Regards, Ernie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prediction | Excel Worksheet Functions | |||
Value Prediction | Excel Worksheet Functions | |||
Rolling Average for Prediction | Excel Discussion (Misc queries) | |||
Vulnerability Prediction Tool | Charts and Charting in Excel | |||
the best prediction formula?URgent! | Excel Worksheet Functions |