Please answer the following questions.

Q2.

Conduct a simple regression analysis and express this relationship in terms of a linear equation of age predicting sIgA.

Report the slope and intercept of the unstandardised regression equation and explain what these statistics mean.

What would be the estimated sIgA concentration of an 80-year old person?

Q3. Test the hypothesis that higher ERIratio predicts lower sIgA concentrations.

Report the results of this test in terms of effect size and F test.

This is an EXCEL LINK of the SAME DATA AS BELOW. Thank you

https://docs.google.com/spreadsheets/d/1a6FiZmx2WWqDSqRV3E5SLORHRMi3fr3vHQTJwg2yrds/edit?usp=sharing

Gender Age OC EF RW ERIratio SigA

1 Male 44.00 17.00 14.00 21.00 .49 11.00

2 Male 59.00 12.00 19.00 15.00 .73 8.00

3 Male 35.00 11.00 16.00 18.00 .54 9.00

4 Male 28.00 14.00 15.00 19.00 2.71 15.00

5 Male 31.00 12.00 14.00 25.00 2.00 28.00

6 Male 39.00 22.00 16.00 16.00 .48 17.00

7 Male 26.00 16.00 14.00 13.00 1.56 21.00

8 Male 35.00 16.00 12.00 23.00 2.00 21.00

9 Male 58.00 8.00 8.00 12.00 .20 14.00

10 Male 26.00 13.00 4.00 13.00 .11 18.00

11 Male 42.00 14.00 12.00 18.00 2.02 10.00

12 Male 35.00 19.00 18.00 37.00 .71 8.00

13 Male 20.00 18.00 22.00 30.00 2.59 12.00

14 Male 35.00 18.00 8.00 14.00 .60 14.00

15 Male 42.00 17.00 18.00 18.00 1.98 13.00

16 Male 52.00 23.00 14.00 23.00 .00 9.00

17 Male 48.00 19.00 11.00 13.00 1.64 13.00

18 Male 33.00 22.00 14.00 25.00 1.11 14.00

19 Male 52.00 8.00 12.00 14.00 3.08 14.00

20 Male 56.00 11.00 17.00 24.00 2.67 11.00

21 Male 24.00 11.00 22.00 25.00 1.81 16.00

22 Male 35.00 17.00 15.00 15.00 .68 8.00

23 Male 56.00 19.00 19.00 21.00 1.58 13.00

24 Male 26.00 20.00 12.00 18.00 1.69 11.00

25 Male 41.00 23.00 12.00 44.00 .48 13.00

26 Male 35.00 13.00 18.00 25.00 .20 22.00

27 Male 26.00 21.00 16.00 31.00 1.45 11.00

28 Male 35.00 17.00 9.00 15.00 1.13 14.00

29 Male 35.00 14.00 12.00 23.00 2.70 21.00

30 Male 58.00 9.00 8.00 11.00 1.22 15.00

31 Male 26.00 15.00 7.00 12.00 1.79 19.00

32 Male 42.00 16.00 14.00 15.00 2.74 9.00

33 Female 35.00 18.00 17.00 37.00 1.59 6.00

101 Female 41.00 18.00 10.00 28.00 .98 19.00

102 Female 38.00 17.00 12.00 31.00 .90 11.00

104 Female 48.00 17.00 8.00 27.00 .10 17.00

106 Female 49.00 15.00 9.00 30.00 .61 21.00

108 Female 57.00 9.00 8.00 33.00 1.09 21.00

109 Female 64.00 11.00 10.00 38.00 1.46 18.00

110 Female 50.00 19.00 11.00 32.00 .00 22.00

111 Female 41.00 16.00 10.00 30.00 .84 20.00

112 Female 22.00 11.00 6.00 33.00 .21 19.00

113 Female 55.00 21.00 15.00 28.00 .93 30.00

114 Female 44.00 17.00 5.00 29.00 .32 21.00

115 Female 26.00 14.00 12.00 32.00 .10 18.00

117 Female 37.00 17.00 6.00 31.00 1.21 16.00

118 Female 49.00 18.00 6.00 31.00 .56 34.00

119 Female 46.00 22.00 14.00 34.00 .00 14.00

121 Female 53.00 14.00 7.00 33.00 .00 19.00

122 Female 57.00 15.00 6.00 33.00 .00 16.00

123 Female 24.00 9.00 9.00 34.00 .96 34.00

124 Female 38.00 15.00 8.00 31.00 .00 35.00

126 Female 48.00 17.00 10.00 30.00 .55 16.00

127 Female 43.00 15.00 11.00 30.00 .00 21.00

128 Female 38.00 21.00 9.00 31.00 .19 15.00

129 Female 59.00 15.00 9.00 30.00 .00 27.00

130 Female 52.00 18.00 11.00 31.00 1.27 10.00

131 Female 22.00 12.00 7.00 32.00 .00 28.00

132 Female 48.00 12.00 6.00 33.00 .67 13.00

133 Female 45.00 13.00 11.00 29.00 1.16 17.00

134 Female 52.00 14.00 14.00 31.00 .00 22.00

135 Female 41.00 18.00 13.00 30.00 2.20 18.00

136 Female 41.00 14.00 17.00 31.00 2.14 31.00

138 Female 31.00 11.00 5.00 31.00 .00 20.00

139 Female 41.00 17.00 18.00 25.00 3.01 14.00

140 Female 56.00 15.00 9.00 30.00 1.17 22.00

(age 3rd column - scale) (ERIratio 7th column - scale) (sigA last column - nominal)