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^{2} ,

( 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)

Find the equation of the 95% confidence line from given data in
EXCEL (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...

Find the equation of the regression line for the given data.
Then construct a scatter plot of the data and draw the regression
line. (Each pair of variables has a significant correlation.)
Then use the regression equation to predict the value of y for each
of the given x-values, if meaningful. The caloric content and the
sodium content (in milligrams) for 6 beef hot dogs are shown in
the table below.
Calories, x Sodium, y
150 420
170 470...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 10 minutes ago

asked 27 minutes ago

asked 29 minutes ago

asked 29 minutes ago

asked 34 minutes ago

asked 42 minutes ago

asked 52 minutes ago

asked 55 minutes ago

asked 56 minutes ago

asked 59 minutes ago

asked 59 minutes ago

asked 1 hour ago