In: Statistics and Probability
The following sample of observations was randomly selected.
x: | 5 | 3 | 6 | 3 | 4 | 4 | 6 | 8 |
y: | 13 | 15 | 7 | 12 | 13 | 11 | 9 | 5 |
Determine the regression equation. Use Excel Regression. (Negative values should be indicated by a minus sign. Round your answers to 3 decimal places.)
Y=
Using Excel,
Procedure:
Enter data in Excel spreadsheet>go to "Data">Data analysis>Regression>select range of variables>ok.
Output:
From above output, Regression equation is
Y= 19.412 + (-1.765) X Or Y=19.412 - 1.765 X |