Question

Decide by taking at least 12 data with simple correlation and regression analysis so that there is a relationship between the two variables. When X = 8

Y =? Guess

Answer 1

suppose we have the data

number of days(x)	expenditures claim (y)
10	116
3	39
8	85
17	159
5	61
9	94
14	143
16	178
21	225
13	134

Ans a ) the scatterplot of the data is

b ) since scatterplot shows that there is a linear relationship between number of days and expenditures claim so we can fit the regression line here.

c )using minitab>stat>Regression

we have

Regression Analysis: expenditures claim versus number of days

The regression equation is
expenditures claim = 8.640 + 9.893 number of days

S = 8.96626 R-Sq = 97.7% R-Sq(adj) = 97.5%

Analysis of Variance

Source DF SS MS F P
Regression 1 27835.2 27835.2 346.24 0.000
Error 8 643.2 80.4
Total 9 28478.4

the regression equation is

y = 8.64+9.893 *x

When X = 8

Y =8.64+9.893 *8 = 87.784