Consider the following set of ordered pairs.
x 4 1 2 5
y 5 1 3 6
a) Calculate the slope and y-intercept for these data.
b) Calculate the total sum of squares (SST).
c) Partition the sum of squares into the SSR and SSE.
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
We have regression equation is
y=0.15+1.2x
a) Slope =1.2 and y intercept =0.15
b) SST=14.75
c) SSR=14.4 and SSE=0.35
Get Answers For Free
Most questions answered within 1 hours.