independent variable x

MGSC 331-O2 Exam 4 2014 Name:
Use Assignment 4 tutorial for gudance in using statistical functions.
Use EXCEL worksheet to solve problems.

1. The following data applies to an independent variable x and seemingly dependent variable y.
x 10 6 8 12 5 15 4 9
y 11 8 10 15 6 20 5 12

a) Develop regression equation relating x and y.

b) Find y when x=16

2. Use data and results from problem 1 above.
a) Find 0.95 confidence interval for predicted y when x =20.

3. Again using problem 1 data repeated below.

x 7 3 9 14 8 5 12 4
y 9 5 10 13 12 8 16 6

a) Correlation coefficient is derived using CORREL(y values, x values)
r =

b) Coefficient od determination is r^2 =

c) Is there a significant relarionship between x and y.
Use test of hypothesis.
Significance level is .05.

PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂