Create own website

Analysis Report

Date Due: Week 13 (2nd of June 2023; 5pm)

Total Marks: 30 marks Worth: 30% of final assessment

You need to prepare an analysis report (using Microsoft Word), which requires an amount of

computer work and written comment. Each task describes what you are required to do, so please

follow these instructions carefully!

In this report, you will analyse a student survey. It has four selected variables, namely ses (Socio

economic status of student's family, with categories low, middle, and high), schtyp (Type of school,

with categories public and private), read (Standardized read score) and write (Standardized write

score).

Task 1: Use the Chi-square test at the 10% level of significance to determine whether schtyp and ses

are independent. The following table can be used: (15 Marks)

a. Create the contingency table to show student’s frequencies of the schtyp and ses variables.

Calculate the row totals, column totals and total frequency. (5 Marks)

Type of school

(schtyp)

Socio economic status of student's family (ses)

low middle high Total

private

public

Total

b. State the null and alternative hypotheses. (2 Mark)

α degree of freedom (df) Χ2 α

0.1 2 4.605

0.05 2 5.991

0.01 2 9.21

c. Calculate expected values. (3 Marks)

Type of school

(schtyp)

Socio economic status of student's family (ses)

low middle high Total

private

public

Total

d. Calculate the test statistics. 3 Marks)

e. State the rule of decision. (1 Mark)

f. State the conclusion. (1 Mark)

Task 2: Perform the regression analysis of the read variable on the write variable. The following table

can be used for part (e): (15 marks)

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 write and

read variables respectively. (3 Marks)

b. Create a scatter plot using read and write variables as the x-axis and the y-axis respectively.

(2 Marks)

c. Determine and interpret the Coefficient of Determination, i.e., R square. (2 Marks)

d. Determine the regression equation. Interpret the slope. (3 Marks)

e. Perform the hypothesis test to determine if the slope is significantly differently from zero at

5% significance level. (5 Marks)

α degree of freedom (df) tα/2; df -tα; df tα; df

0.1 188 1.653 -1.286 1.286

0.05 188 1.973 -1.653 1.653

0.01 188 2.602 -2.346 2.346