Question

Part A

A marketing manager wishes to determine whether a relationship exists between the number of cereal boxes (Y) sold at the company's retail store and the number of clerks on duty (X) per day. The sample data below will be used to examine this empirical problem. Calculate the slope of the regression line.

X	Y
3	4
2	4
2	2
1	2

a. 0

b. 1

c. 2

d. None of the above

Part 2

Calculate the Y-intercept

a. 0

b. 1

c. 2

d. None of the above

Part 3

The regression output shows that the sum of squares residual (also called sum of squares error) is 2 and the correlation coefficient is 0.71. What is the coefficient of determination?

a. 0.70

b. 0.60

c. 0.50

d. None of the above

Answer 1

We can use here Excel for regression equation

Step 1) Enter data in Excel .

Step 2) Data >>Data analysis >>Regression >>Select y and x values separately >>Ok

Part A) Slope of the regression line = 1 Option b) is correct.

Part B)  Y-intercept = 1 Option b) is correct.

Part C) Coefficient of determination = 0.50 Option c) is correct.

Mi.ltiple P AdustedR Square square 2 0.292393219 Resclusl oeffents tonuord E Stu Lower 95% Upper 93% Lower 95.0% Upper 35 0% 453970 μ-volue