Question

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

In the above question 95% confidence level is taken on behave of that picture of the data is;

Here scatterplot has been used since it best differentiate the data and the trend of the graph here is not linear .

Equation for the graph is:

                                              X VALUES = 34.63 - 135.6 Y VALUES