Question

Find the equation of the 95% prediction line from given data in EXCEL to predict PPV. (above regression line): X VALUES: The equation is supposed to not be linear and be to a power of a constant in the equation.If you can figure out that part its ok. Just need the equation/picture of the data, and equation for graph. Will rate highest for good answer. Y VALUES 0.232 0.122 0.241 0.148 0.022 0.165 0.182 0.164 0.077 0.104 0.191 0.032 0.13 0.08 0.132 0.021 0.118 X VALUES ARE LISTED BELOW 9.138547 12.94254 9.956063 12.63151 40.78222 12.17864 13.73187 11.01636 17.66244 11.91036 8.969413 40.12883 12.74238 16.63304 14.04124 38.2091 13.13019

Answer 1

We first plot the data :

We see that the plot has some extreme values at the lower right corner and hence we use a second degree equation to predict y on the basis of x.

Our predicted equation is:

y= 0.4326 - 0.0284 x + 0.0004 x² ,

( all the coefficients are significant at 95% level)

The graph along with the regression equation is :

R codes used for the data :

y=c(0.232 ,0.122 ,0.241, 0.148, 0.022 ,0.165, 0.182 ,0.164 ,0.077, 0.104, 0.191, 0.032 ,0.13, 0.08 ,0.132, 0.021, 0.118)
x=c(9.138547, 12.94254 ,9.956063 ,12.63151 ,40.78222, 12.17864 ,13.73187 , 11.01636, 17.66244 ,11.91036, 8.969413 ,40.12883 ,12.74238, 16.63304 ,14.04124, 38.2091, 13.13019)
z=x*x
plot(x,y)
plot(x,y)
f=lm(y~x+z)
summary(f)
abline(f)