Question

In: Statistics and Probability

The following sample of observations was randomly selected. x: 5 3 6 3 4 4 6...

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
  1. Determine the regression equation. Use Excel Regression. (Negative values should be indicated by a minus sign. Round your answers to 3 decimal places.)


Y=

Solutions

Expert Solution

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


Related Solutions

The following sample observations were randomly selected: X) 6     5    4 6   10 Y) 4     ...
The following sample observations were randomly selected: X) 6     5    4 6   10 Y) 4      6     5   2    11 a.) Determine the 0.95 confidence interval for the mean predicted when x=9. [                 ,                ] b.) Determine the 0.95 prediction interval for an individual predicted when x=9 [               ,                 ]
The following sample observations were randomly selected. x: 6, 5, 4, 6, 10 y: 4, 6,...
The following sample observations were randomly selected. x: 6, 5, 4, 6, 10 y: 4, 6, 5, 2, 11. Determine the 0.95 confidence interval for the mean predicted when x=9. Determine the 0.95 prediction interval for an individual predicted when x=9.
The following sample observations were randomly selected. X: 5 6 2 7 11 Y: 3 6...
The following sample observations were randomly selected. X: 5 6 2 7 11 Y: 3 6 4 6 6 (a) Determine the 0.90 confidence interval for the mean predicted when X = 7. (Do not round the intermediate values. Round your answers to 3 decimal places.) What is Confidence interval_____ (b) Determine the 0.90 prediction interval for an individual predicted when X = 7. (Do not round the intermediate values. Round your answers to 3 decimal places.) What is Prediction...
The following sample observations were randomly selected: 1 2 3 4 5 X: 15 8 9...
The following sample observations were randomly selected: 1 2 3 4 5 X: 15 8 9 12 8 Y: 25 22 16 16 14              a. Not available in Connect. b. Determine the regression equation. (Negative answer should be indicated by a minus sign. Do not round intermediate calculations. Round the final answers to 4 decimal places.)                                             b =----  a =---- Y' = -----+-----  X             c. Determine the value of Y' when X is 26. (Do not round intermediate calculations....
The following sample observations were randomly selected:
The following sample observations were randomly selected:12345X:213832Y:18132249            a. Not available in Connect.b. Determine the regression equation.(Negative answer should be indicated by a minus sign. Do not round intermediate calculations. Round the final answers to 4 decimal places.)                                           b =  a =Y' =  +  X           c. Determine the value of Y' whenX is 11. (Do not round intermediate calculations. Round the final answer to 4 decimal places.)
The following sample observations were randomly selected. (Round your answers to 2 decimal places.) X: 4...
The following sample observations were randomly selected. (Round your answers to 2 decimal places.) X: 4 5 3 6 10 Y: 9.8 10.6 8 15.4 19.6 a. The regression equation is   Yˆ Y⁢^⁢  =  +  X b. When X is 8 this gives Yˆ Y⁢^⁢  =   
The following random sample was selected from a distribution: 4, 6, 3, 5, 9, 3. The...
The following random sample was selected from a distribution: 4, 6, 3, 5, 9, 3. The standard deviation for the sample is 2.2804. Construct a 99% confidence interval for population mean .
The following random sample was selected from a normal distribution: 4, 6, 3, 5, 9, 3....
The following random sample was selected from a normal distribution: 4, 6, 3, 5, 9, 3. a. Construct a 90% confidence interval for the population mean. b. Construct a 95% confidence interval for the population mean. c. Construct a 99% confidence interval for the population mean. d. Assume that the sample mean x and sample standard deviation s remain exactly the same as those you just calculated but are based on a sample of n = 25 observations rather than...
You are given the following results from a sample of five observations. 4 6 3 4...
You are given the following results from a sample of five observations. 4 6 3 4 3 ​ a. Construct a 99% confidence interval for the population variance. b. The null and alternative hypotheses are H0: σ2 ≥ 2 and Ha: σ2 < 2. Compute the test statistic. c. Perform the test of the hypothesis at the 1% level. d. What do you conclude about the population variance?
Exercise 13-31 (LO13-6) The following sample observations were randomly selected. (Do not round the intermediate values....
Exercise 13-31 (LO13-6) The following sample observations were randomly selected. (Do not round the intermediate values. Negative amount should be indicated by a minus sign. Round your answers to 3 decimal places.) X: 4 5 2 6 10 Y: 6 3 1 7 7 A) Determine the 0.9 confidence interval for the mean predicted when x = 4. [     ,    ] B) Determine the 0.9 prediction interval for an individual predicted when x = 4. [         ,           ]
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT