In: Statistics and Probability
Consider the following set of ordered pairs. Complete parts a through c.
x |
1 |
1 |
3 |
3 |
1 |
|
---|---|---|---|---|---|---|
y |
−1 |
1 |
4 |
3 |
−1 |
a. Calculate the slope and y-intercept for these data.
^y=______ + (______) x
(Round to four decimal places as needed.)
b. Calculate the total sum of squares (SST).
SST=
(Round to one decimal place as needed.)
c. Partition the sum of squares into the SSR and SSE.
SSE=
(Round to three decimal places as needed.)
SSR=
(Round to three decimal places as needed.)
a. Calculate the slope and y-intercept for these data.
y = -2.2500 + 1.9167
Run a regression analysis in excel followed by below procedures:
1. Go to data tab --> data analysis --> choose
Regression
Summary output:
SST= 20.8
SSE = 3.167
SSR = 17.633