SQQS2013 Applied Statistics Individual Assignment 2 Matric no.

: 263228

FIRST SEMESTER 2021/2022 SESSION (A211)

SQQS 2013 APPLIED STATISTICS

(GROUP B)

Individual Assignment 2

SUBMITTED TO:

ROHAIZA BINTI ZAKARIA

PREPARED BY:

NAME MATRIX.NO

KONG LOK YEE 263228

SUBMISSION DATE:

29 JANUARY 2022
SQQS2013 Applied Statistics Individual Assignment 2 Matric no.: 263228

QUESTION 1 (20 MARKS)

A medical doctor is comparing the optical density with respect to lot (treatment) and run (block).
An alpha criterion of 0.05 were used for the test.

Dataset: Enzyme-linked immunosorbent assay/enzyme immunoassay (ELISA) anti-human

immunodeficiency virus (HIV) Optical Density Readings
Source: Hoaglin, D., Mosteller, F., and Tukey, J. (1991).
Fundamentals of Exploratory Analysis of Variance.
Wiley, New York, page 157.
Response Variable: Elisa Optical density
Number of observations: 75
Number of variables per line image: 3
Order of variables per line image:
i. Response variable = optical density from ELISA
ii. Treatment = lot (5 levels)
iii. Block = run (5 levels)

TABLE 1
Optical
Density Lot Run
1.053 1 1
1.708 1 1
0.977 1 1
0.881 1 2
0.788 1 2
0.788 1 2
0.896 1 3
1.038 1 3
0.963 1 3
0.971 1 4
1.234 1 4
1.089 1 4
0.984 1 5
0.986 1 5
1.067 1 5
0.996 2 1
1.129 2 1
1.016 2 1
1.019 2 2
1.088 2 2
1.28 2 2
1.12 2 3
SQQS2013 Applied Statistics Individual Assignment 2 Matric no.: 263228

1.054 2 3
1.235 2 3
1.327 2 4
1.361 2 4
1.233 2 4
1.079 2 5
1.12 2 5
0.959 2 5
1.229 3 1
1.027 3 1
1.109 3 1
1.118 3 2
1.066 3 2
1.146 3 2
1.053 3 3
1.082 3 3
1.113 3 3
1.14 3 4
1.172 3 4
0.966 3 4
0.963 3 5
1.064 3 5
1.086 3 5
0.985 4 1
0.894 4 1
1.109 4 1
0.847 4 2
0.799 4 2
0.918 4 2
1.033 4 3
0.943 4 3
1.089 4 3
0.988 4 4
1.169 4 4
1.106 4 4
1.308 4 5
1.498 4 5
1.271 4 5
1.128 5 1
1.141 5 1
1.144 5 1
SQQS2013 Applied Statistics Individual Assignment 2 Matric no.: 263228

0.99 5 2
0.801 5 2
0.416 5 2
0.929 5 3
0.95 5 3
0.899 5 3
0.873 5 4
0.871 5 4
0.786 5 4
0.93 5 5
0.968 5 5
0.844 5 5

In this study, the medical doctor would like to perform an analysis to determine whether the difference means exist among each of
treatments.

a) Write hypothesis statement in this study. (1 mark)

�� : �� = �� = �� = �� = ��
�� : At least one mean is different from the others.

b) Complete the suitable ANOVA table using the traditional method for data in TABLE 1.
Lot Lot

1 2 3 4 5 1 2 3 4 5

1 1.053 0.996 1.229 0.985 1.128 5.391 1.109 0.992 1.510 0.970 1.272 5.854

Run 1 1.708 1.129 1.027 0.894 1.141 5.899 2.917 1.275 1.055 0.799 1.302 7.348

1 0.977 1.016 1.109 1.109 1.144 5.355 18.470 0.955 1.032 1.230 1.230 1.309 5.755
SQQS2013 Applied Statistics Individual Assignment 2 Matric no.: 263228

2 0.881 1.019 1.118 0.847 0.990 4.855 0.776 1.038 1.250 0.717 0.980 4.762

2 0.788 1.088 1.066 0.799 0.801 4.542 0.621 1.184 1.136 0.638 0.642 4.221

2 0.788 1.280 1.146 0.918 0.416 4.548 12.964 0.621 1.638 1.313 0.843 0.173 4.588

3 0.896 1.120 1.053 1.033 0.929 5.031 0.803 1.254 1.109 1.067 0.863 5.096

3 1.038 1.054 1.082 0.943 0.950 5.067 1.077 1.111 1.171 0.889 0.903 5.151

3 0.963 1.235 1.113 1.089 0.899 5.299 15.805 0.927 1.525 1.239 1.186 0.808 5.685

4 0.971 1.327 1.140 0.988 0.873 5.299 0.943 1.761 1.300 0.976 0.762 5.742

4 1.234 1.361 1.172 1.169 0.871 5.807 1.523 1.852 1.374 1.367 0.759 6.874

4 1.089 1.233 0.966 1.106 0.786 5.180 17.682 1.186 1.520 0.933 1.223 0.618 5.480

5 0.984 1.079 0.963 1.308 0.930 5.264 0.968 1.164 0.927 1.711 0.865 5.636

5 0.986 1.120 1.064 1.498 0.968 5.636 0.972 1.254 1.132 2.244 0.937 6.540

5 1.067 0.959 1.086 1.271 0.844 5.227 17.339 1.138 0.920 1.179 1.615 0.712 5.565

15.423 17.016 16.334 15.957 13.670 78.400 82.26 16.537 19.522 17.858 17.476 12.904 84.297

237.869 289.544 266.800 254.626 186.869 6,147 273.464 381.101 318.914 305.424 166.522 7,106

15.858 19.303 17.787 16.975 12.458 81.954 18.231 25.407 21.261 20.362 11.101 95

*table above show calculation that done in excel

SQQS2013 Applied Statistics Individual Assignment 2 Matric no.: 263228

Source Sum of df mean F

Square square
Treatment 0.426 4 0.107 4.367
Block 0.306 4 0.076
Error 1.611 66 0.024
Total 2.343 74
(13 marks)

c) Using traditional method, test whether is there any difference in the means among the
treatment at 5% significance level. (3 marks)

Critical value = ��.��,�,�� = �. ���

Reject �� .

There is enough evidence to conclude that at least one mean is different among the
treatment at 5% significance level

d) Analyze the data in TABLE 1 using EXCEL (or otherwise), state the p-value? What is
your conclusion about a difference in the means among the treatment at 5% significance
level. (3 marks)

Tests of Between-Subjects Effects

Dependent Variable: Optical Density
Type III Sum of
Source Squares df Mean Square F Sig.
Corrected Model .732 a
8 .092 3.750 .001
Intercept 81.954 1 81.954 3357.494 .000
Lot .426 4 .107 4.367 .003
Run .306 4 .076 3.133 .020
Error 1.611 66 .024
Total 84.297 75
Corrected Total 2.343 74
a. R Squared = .312 (Adjusted R Squared = .229)

p-value = 0.003
Significant level: α = 0.05
Since p-value = 0.003 < α =0.05, the null hypothesis is rejected.
We conclude that at least one of the means is different among the treatment at 5%
significant level.
SQQS2013 Applied Statistics Individual Assignment 2 Matric no.: 263228

QUESTION 2 (11 MARKS)

A survey by TnT company asked its customers preference on the types of telco plan. The
results were 35% of them like plan A, 52% like plan B, and 13% had no opinion.

A random sample of 120 adults was asked the same question at a local county fair. The results
were 40 people prefer plan A, 60 prefer plan B, and 20 had no opinion.

At α = 0.01 level of significance, is there sufficient evidence to conclude that the results differ
from those reported in the survey? (Use traditional method and p-value method).

Answer:
�� : The sample results are same as reported in survey.
�� : The sample results are differ as reported in survey.

Type of Vitamin
Total
Safe Not safe No opinion
Observed 40.00 60.00 20.00 120.00
p 0.35 0.52 0.13 1.00
Expected 42.00 62.40 15.60 120.00
(O-E)^2/E 0.0952 0.0923 1.2410 1.4286

(*table above is calculation done in Excel)

df = (3-1)(2-1) = 2
Statistical value = 1.4286
Critical Value:
���.��,� = �. ����

Failed to reject null hypothesis.

There is enough evidence to conclude that the sample results are same as reported in
survey at 1% significant level.
SQQS2013 Applied Statistics Individual Assignment 2 Matric no.: 263228

QUESTIONS 3 (19 MARKS)

A survey has conducted among IP College students about monthly junk food expenses. There are
50 random samples for variables: course group, junk food types and monthly bills. Raw data
shown in TABLE 2. Let α = 0.05.

Analyze the data in TABLE 2 using p-value method based on the following questions:

a) Is there any difference means of monthly bills among the junk food types?

Yes, there is difference means of monthly bills among the junk food types. Because
suppose take 7 food type foe example fast food.

From the data there are 11 fast food = 11 x 2 = 22

Mean of the fast food types= 22/11 =2

Mean of 11 fast food monthly bills

= 100+100+30+40+98+30+50+50+30+50+42/11
=56.36

Yes, there is difference means of monthly among the junk food types.

(5 marks)

b) Is there enough evidence to reject the claim that there is no preference in the selection of
junk food types?

Yes, there is enough evidence to reject the claim that there is no p reference in
selection of junked type because p reference based on monthly bills or their price of
the item.
(5 marks)
c) Can we conclude that junk food types related to course group?

No, we cant conclude the junked types related to course group.

(5 marks)
d) Is there any violation of assumption in 3(b) and 3(c)? Explain.

Yes, the course group are different for some junk food types.
(4 marks)

TABLE 2
Junk food CAKES AND FAST CHOCOLATE SUGARY
types BISCUITS FOODS AND SWEETS SNACKS DRINKS
coding 1 2 3 4 5
SQQS2013 Applied Statistics Individual Assignment 2 Matric no.: 263228

Course group Junk food type Junk food type Monthly bill
B CAKES AND BISCUITS 1 30
B CAKES AND BISCUITS 1 50
B FAST FOODS 2 100
B FAST FOODS 2 100
B FAST FOODS 2 45
B CHOCOLATE AND SWEETS 3 30
A CHOCOLATE AND SWEETS 3 30
B SUGARY DRINKS 5 30
A SNACKS 4 50
A FAST FOODS 2 30
B CHOCOLATE AND SWEETS 3 30
A CAKES AND BISCUITS 1 50
B CAKES AND BISCUITS 1 40
B CHOCOLATE AND SWEETS 3 30
B CHOCOLATE AND SWEETS 3 60
B CAKES AND BISCUITS 1 40
B CAKES AND BISCUITS 1 90
A FAST FOODS 2 40
A FAST FOODS 2 98
B SNACKS 4 35
A SUGARY DRINKS 5 50
A CAKES AND BISCUITS 1 80
B SUGARY DRINKS 5 28
B FAST FOODS 2 30
B SUGARY DRINKS 5 30
A FAST FOODS 2 50
B CAKES AND BISCUITS 1 10
B CAKES AND BISCUITS 1 10
A CAKES AND BISCUITS 1 40
A SUGARY DRINKS 5 35
B SNACKS 4 72
B CAKES AND BISCUITS 1 42
A SUGARY DRINKS 5 50
A CHOCOLATE AND SWEETS 3 35
A SUGARY DRINKS 5 50
A CAKES AND BISCUITS 1 60
B FAST FOODS 2 50
A CHOCOLATE AND SWEETS 3 30
A SUGARY DRINKS 5 80
A CHOCOLATE AND SWEETS 3 35
SQQS2013 Applied Statistics Individual Assignment 2 Matric no.: 263228

A FAST FOODS 2 30
A CAKES AND BISCUITS 1 130
A SUGARY DRINKS 5 40
A SUGARY DRINKS 5 59
A FAST FOODS 2 50
A FAST FOODS 2 42
A SNACKS 4 55
A CAKES AND BISCUITS 1 30
A CAKES AND BISCUITS 1 200
A CHOCOLATE AND SWEETS 3 40

~ END OF QUESTIONS ~