Task 5: Perform the regression analysis of the variable write and read.

a. Use the Excel Regression function in the Data Analysis Tools Add-ins to create a simple regression model. The straight line equation is y = a + bx where y and x are the variable write and read respectively.

b. Determine and interpret the Coefficient of Determination, i.e., R square.

c. Determine the regression equation. Interpret the slope.

d. Perform the hypothesis test to determine if the slope is significantly differently from zero at 5% significance level.

Conclusion:

From the tasks above, you should have some idea of the relationship between write and read. Also, you can see the difference of the writing score (write variable) for male and female. In this section, write a short report summarising your main findings.