Question

Cursider she fallrwing set af ardered pairs a) Calculate the slope and y intercept for these dala. b) Caiculatc the total sum of squares ISST c) Pa ton the sum of squaresmo the SSH, and SSE sum ct saunto tme SSH

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.

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

a) Slope = 1.75 and y intercept =-2

b) SST=22

c) SSR=12.25 and SSE=9.75

SUMMARY OUTPUT Multiple R Squan Adjusted R Square 0409090909 tandard Errer -802775638 12.25 3.703231 0 147302 coefficentsEndard Err .volue Lower 95%Upper 95%ower 93.09pper 95.G% tStat 3.65-0.511331962 03-13.2578 9.757836 -13.7578 9.257835 0.90138 1.941450687 0.147302 1.11362 4.513618 111862 4.618613