You need to prepare an individual analysis report (using Microsoft Word), which requires an amount of computer work and written comment. You may need to seek guidance from your lecturer in the class. Do not leave things until too late!! Each task describes what you are required to do, so please follow these carefully! In this report, you will analyse a randomised subset of a survey. This subset only has three variables, namely read [reading score], female [gender: 0 and 1 denotes male and female respectively], and write [writing score]. Task 1: Identify data type State for each variable in the subset whether it is qualitative or quantitative; if it is qualitative, state whether it is nominal or ordinal, and if it is quantitative, state whether it is discrete or continuous. Task 2: Perform descriptive summary of the variable write a. Find the sample mean and sample standard deviation as well as the 5-number summary of the variable write. b. Create a boxplot showing the distribution of the variable write. Comment upon the shape of the distribution, i.e., either symmetric, skewed to the left or skewed to the right. Use the whisker limits to determine whether any outliers present. c. State which central measure (mean or median) would be best to use to describe the centre of this distribution and provide the reason(s). [Hint: Refer to "Measures of Central Tendency" Lecture, slides 17 to 19 for the calculation of Q1 Q2 and Q3 as well as the whisker limits.] Task 3: Show the difference of write by female a. Construct side-by-side boxplots for the variable write by the variable female (i.e., the two groups are male and female). b. Calculate the Q1, Q2, Q3, interquartile range and whisker limits for the writing score (write variable) of the male group and female group separately. c. Use the respective median and inter-quartile range to compare the data position and variability or spread of the male and female groups separately.

Task 4: Show the relationship between the variable write and read a. Construct a scatter plot of write against read (i.e., values of write and value of read are on the Y-axis and X-axis respectively). b. Comment on the relationship, i.e., whether it has upward trend (i.e., as the value of read increases, the value of write also increases), no trend, or downward trend (i.e, as the value of read increases, the value of write decreases). c. Calculate the correlation coefficient of write and read variable and determine the strength of the relationship. 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. 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.

data is in

read	female	write
57	0	52
68	1	59
44	0	33
63	0	44
47	0	52
44	0	52
50	0	59
34	0	46
63	0	57
57	0	55
60	0	46
57	0	65
73	0	60
54	0	63
45	0	57
42	0	49
47	0	52
57	0	57
68	0	65
55	0	39
63	0	49
63	0	63
50	0	40
60	0	52
37	0	44
34	0	37
65	0	65
47	0	57
44	0	38
52	0	44
42	0	31
76	0	52
65	0	67
42	0	41
52	0	59
60	0	65
68	0	54
65	0	62
47	0	31
39	0	31
47	0	47
55	0	59
52	0	54
42	0	41
65	0	65
55	0	59
50	0	40
65	0	59
47	0	59
53	0	61
39	0	33
44	0	44
63	0	59
73	0	62
39	0	39
37	0	37
42	0	39
63	0	57
48	0	49
50	0	46
47	0	62
44	0	44
34	0	33
50	0	42
44	0	41
60	0	54
47	0	39
63	0	43
50	0	33
44	0	44
60	0	54
73	0	67
68	0	59
55	0	45
47	0	40
55	0	61
68	0	59
31	0	36
63	0	59
36	0	49
68	0	59
55	0	41
55	0	62
52	0	41
34	0	49
50	0	31
55	0	49
52	0	62
63	0	49
68	1	62
39	1	44
44	1	44
50	1	62
71	1	65
63	1	65
34	1	44
63	1	63
68	1	60
47	1	59
47	1	46
63	1	52
55	1	54
60	1	62
35	1	35
47	1	54
71	1	65
57	1	52
44	1	50
65	1	59
68	1	65
73	1	61
36	1	44
43	1	54
73	1	67
52	1	57
41	1	47
60	1	54
50	1	52
50	1	52
47	1	46
47	1	62
55	1	57
50	1	41
39	1	53
50	1	49
34	1	35
57	1	59
57	1	65
68	1	62
42	1	54
61	1	59
76	1	63
47	1	59
46	1	52
39	1	41
52	1	49
28	1	46
42	1	54
47	1	42
47	1	57
52	1	59
47	1	52
50	1	62
44	1	52
47	1	41
45	1	55
47	1	37
65	1	54
43	1	57
47	1	54
57	1	62
68	1	59
52	1	55
42	1	57
42	1	39
66	1	67
47	1	62
57	1	50
47	1	61
57	1	62
52	1	59
44	1	44
50	1	59
39	1	54
57	1	62
57	1	60
42	1	57
47	1	46
42	1	36
60	1	59
44	1	49
63	1	60
65	1	67
39	1	54
52	1	65
60	1	62
44	1	49
52	1	67
55	1	65
50	1	67
65	1	65
52	1	54
47	1	44
63	1	62
50	1	46
42	1	54
36	1	57
50	1	52
41	1	59
47	1	65
55	1	59
42	1	46
57	1	41
55	1	62
63	1	65