M

No Sheet Name

1 Sheet 1

2 Sheet 2

3 Sheet 3 Đinh Như Huy Minh

4 Sheet 4 Vương Lê Sơn

5 Sheet 5 Nguyễn Hoàng Sơn

6 Sheet 6 Đỗ Tùng Dương

7 Sheet 7 Tống Khánh Ly

8 Sheet 8 Đào Xuân Trường

 MAS202 GROUP ASSIGNMENT-GROUP 1-IB1813

Student ID

HS180228

HS180831

HS180228

HS186309

HS186548

HS180436
 MAS202 GROUP ASSIGNMENT-GROUP 1-IB1813

Content

Table of Content

DATA

1. Determine the mean, variance, standard deviation,…

2. Display histogram(s) and boxplot(s).

3. Test a hypothesis and construct a confidence interval for the mean of a population.
4. Test a hypothesis and construct a confidence interval for the proportion of a population.

5. Test a hypothesis and construct a confidence interval for the difference in means of two populatio

6. Test a hypothesis and construct a confidence interval for the difference in proportions of two popu

7. F-test for the ratio of two variance.

8. Regression analysis.
 Thời
gian
Tiết Thứ 2 Thứ 3 Thứ 4 Thứ 5
Buổi
Tiết 1 £ 10.00
Tiết 2
Sáng
Tiết 3
Tiết 4
Tiết 1
Tiết 2
Chiều
Tiết 3
Tiết 4
Thứ 6 Ghi chú
 FPT STOCK PRICE

Opening price
Highest price (x1000)
(x1000)
No Date

1 10/31/2024 135.9 136

2 10/30/2024 135.4 135.9
3 10/29/2024 135.4 135.5
4 10/28/2024 134.1 135
5 10/25/2024 134.3 134.6
6 10/24/2024 134.2 134.3
7 10/23/2024 132.9 134.8
8 10/22/2024 135.7 135.7
9 10/21/2024 137 137.7
10 10/18/2024 137.4 137.8
11 10/17/2024 136.5 137.1
12 10/16/2024 136.4 137.1
13 10/15/2024 137.6 138.6
14 10/14/2024 141.1 141.3
15 10/11/2024 142 142.8
16 10/10/2024 135.8 142
17 10/9/2024 134.3 135.8
18 10/8/2024 134.1 135.1
19 10/7/2024 134.2 134.9
20 10/4/2024 134.3 134.8
21 10/3/2024 135.4 136.1
22 10/2/2024 134.6 135.9
23 10/1/2024 134.7 136.2
24 9/30/2024 134.2 134.5
25 9/27/2024 134.3 134.4
26 9/26/2024 135 135
27 9/25/2024 134.3 134.8
28 9/24/2024 134 134.7
29 9/23/2024 135.9 135.9
30 9/20/2024 136.3 137
31 9/19/2024 135 135.8
32 9/18/2024 133.4 135.2
33 9/17/2024 131.2 132.9
34 9/16/2024 131.8 133
35 9/13/2024 132.2 133.4
36 9/12/2024 131 132.5
37 9/11/2024 130 131.3
38 9/10/2024 131 131
39 9/9/2024 130.8 131.9
40 9/6/2024 130.5 132.9
41 9/5/2024 133 133
42 9/4/2024 133 133
43 8/30/2024 133.5 134.9
44 8/29/2024 132.8 133.8
45 8/28/2024 133 134.5
46 8/27/2024 131.5 132.6
47 8/26/2024 133.3 133.5
48 8/23/2024 133.7 133.7
49 8/22/2024 134 134.5
50 8/21/2024 130.6 133.8
51 8/20/2024 130.7 132.5
52 8/19/2024 131.1 131.4
53 8/16/2024 129.1 131
54 8/15/2024 129.1 129.5
55 8/14/2024 130.7 131.5
56 8/13/2024 129.7 130.2
57 8/12/2024 126.9 130.2
58 8/9/2024 122.4 126.9
59 8/8/2024 121.6 122.4
60 8/7/2024 121 122
61 8/6/2024 120 121.9
62 8/5/2024 121.1 122.9
63 8/2/2024 122.1 124.8
64 8/1/2024 129.6 129.7
65 7/31/2024 127.3 128.6
66 7/30/2024 129 129.5
67 7/29/2024 130 130.6
68 7/26/2024 125.9 128
69 7/25/2024 124.2 125.5
70 7/24/2024 125.5 126.6
71 7/23/2024 124.9 127.5
72 7/22/2024 126 126
73 7/19/2024 128.6 129.3
74 7/18/2024 131.4 131.4
75 7/17/2024 134 134.1
76 7/16/2024 133.6 134.5
77 7/15/2024 133.5 134.8
78 7/12/2024 132.2 136
79 7/11/2024 134.1 135.4
80 7/10/2024 136 137
81 7/9/2024 139.1 139.3
82 7/8/2024 138.5 139.6
83 7/5/2024 136.1 139.7
84 7/4/2024 132.1 135.8
85 7/3/2024 130.5 132.8
86 7/2/2024 128.6 132.1
87 7/1/2024 130.4 130.4
88 6/28/2024 132.8 132.8
89 6/27/2024 131.3 134.1
90 6/26/2024 131 131.8
91 6/25/2024 131 131.1
92 6/24/2024 135 135.5
93 6/21/2024 133.9 136.1
94 6/20/2024 133 135.7
95 6/19/2024 128 132.8
96 6/18/2024 128.8 129.7
97 6/17/2024 131 131.4
98 6/14/2024 130.1 132.6
99 6/13/2024 133.7 133.8
100 6/12/2024 127.9 132.7
101 6/11/2024 144.3 146.5
102 6/10/2024 143.5 145
103 6/7/2024 141 142
104 6/6/2024 140.3 141.7
105 6/5/2024 140 144.9
106 6/4/2024 139 139.3
107 6/3/2024 135 137.6
108 5/31/2024 135 136.8
109 5/30/2024 133.8 135
110 5/29/2024 137.1 138.2
111 5/28/2024 134 137
112 5/27/2024 133 133.5
113 5/24/2024 138 138
114 5/23/2024 137.5 137.8
115 5/22/2024 137.9 139.7
116 5/21/2024 134 136
117 5/20/2024 135.2 136.1
118 5/17/2024 135.4 136
119 5/16/2024 135.6 137.3
120 5/15/2024 131.5 134.5
121 5/14/2024 130 131.7
122 5/13/2024 131.3 131.5
123 5/10/2024 131.3 132.2
124 5/9/2024 130.6 132.8
125 5/8/2024 130.1 131
126 5/7/2024 128 131.6
127 5/6/2024 126.5 127.6
128 5/3/2024 128.1 128.4
129 5/2/2024 123.8 129
OCK PRICE

Lowest price (x1000) Closing price (x1000)

135.3 135.9
135.2 135.9
134.8 135.4
133.6 134.9
133.6 134
133.8 134.3
132.6 134.2
133 133.1
135.5 135.5
136.6 137
135.5 137
136 136.3
136.6 137
137.1 137.6
139.6 139.6
135.8 141.7
134.3 135.4
133.6 133.8
133.6 134.1
133.5 134.1
134 134
134.6 135.4
134.7 135.9
133 134.5
133.5 134.2
133.9 134.3
133.6 134.8
133.7 134.5
133.4 134
135 135.3
134.3 135.2
132.9 134.6
131.2 132.9
131.1 131.1
132 133
131 132.3
129.8 130.6
129.6 130
130.1 131.3
130.3 132.1
129.7 130.6
131.5 133
133 134.8
132.2 133.7
132.9 133.3
130.4 132.5
131.5 131.5
132.4 133.1
133.5 133.8
130.6 133.5
130.7 131.5
130 130.5
129.1 130.6
128.2 128.7
129.5 129.5
128 129.7
126.2 130
122 126.9
120.9 121.4
120.2 122
119.8 120.8
117.4 118.6
121 123.2
124.1 124.8
126.6 128.6
127 128
129 129
124.4 128
124.1 125
124 126
124.8 125.5
123.2 124.1
126 126
127.8 127.9
129.9 131.9
132.3 134
132.3 132.7
132.2 133.8
132.5 133
134 134
136 137.5
137.5 139.6
136.1 138.7
132.1 135.8
130.1 131
127.5 128
128.5 128.6
130.4 130.5
130.8 132.8
129.4 131.8
128.6 130
132 132.1
133.3 136.1
131.8 133.3
126.6 131.5
128 128
128.5 128.8
129 131
130 130
127.8 132
143.1 146.5
143 144
140.5 142
138.8 139.6
139.7 140.1
137.8 139.1
134.7 136.9
133.8 134.6
131.9 135
134.8 135.7
133.1 137
130.6 132.8
130.6 131.9
135 137.5
136.1 138
133.5 136
133 133
133.7 134.5
134.2 135.4
131.3 134.1
129.6 130.5
128.8 129.7
129.2 131
130 130.3
129.3 131
127.2 131.3
124.5 127.6
125.6 125.9
123.5 127.3
 Data have collected from CafeF
Data Source: https://s.cafef.vn/lich-su-giao-dich-fpt-1.chn#data

Ngày Giá (nghìn VNĐ) Thay đổi GD khớp lệnh

Giá trị (tỷ

Đóng cửa Điều chỉnh Khối lượng VNĐ)
10/31/2024 135.9 -- 0(0.00 %) 1,241,700 168.45
10/30/2024 135.9 -- 0.5(0.37 %) 1,709,800 231.78
10/29/2024 135.4 -- 0.5(0.37 %) 2,459,200 332.04
10/28/2024 134.9 -- 0.9(0.67 %) 1,506,000 202.64

10/25/2024 134 -- -0.3(-0.22 %) 1,839,000 246.29

10/24/2024 134.3 -- 0.1(0.07 %) 2,277,200 305.37
10/23/2024 134.2 -- 1.1(0.83 %) 3,015,100 403.48

10/22/2024 133.1 -- -2.4(-1.77 %) 6,009,200 806.44

10/21/2024 135.5 -- -1.5(-1.09 %) 2,681,300 366.27

10/18/2024 137 -- 0(0.00 %) 2,169,400 297.52
10/17/2024 137 -- 0.7(0.51 %) 2,579,200 351.61

10/16/2024 136.3 -- -0.7(-0.51 %) 2,756,000 376.15

10/15/2024 137 -- -0.6(-0.44 %) 2,860,800 393

10/14/2024 137.6 -- -2(-1.43 %) 5,605,300 777.27

10/11/2024 139.6 -- -2.1(-1.48 %) 3,813,600 536.15

10/10/2024 141.7 -- 6.3(4.65 %) 9,952,200 1.392
10/9/2024 135.4 -- 1.6(1.20 %) 2,619,900 354.28

10/8/2024 133.8 -- -0.3(-0.22 %) 2,108,600 282.82

10/7/2024 134.1 -- 0(0.00 %) 1,330,500 178.34
10/4/2024 134.1 -- 0.1(0.07 %) 1,468,400 196.79

10/3/2024 134 -- -1.4(-1.03 %) 2,300,800 311.08

10/2/2024 135.4 -- -0.5(-0.37 %) 1,719,800 232.88

10/1/2024 135.9 -- 1.4(1.04 %) 4,725,900 642.31
9/30/2024 134.5 -- 0.3(0.22 %) 3,030,500 404.86

9/27/2024 134.2 -- -0.1(-0.07 %) 3,352,800 448.85

9/26/2024 134.3 -- -0.5(-0.37 %) 2,815,600 378.1

9/25/2024 134.8 -- 0.3(0.22 %) 4,479,900 601.39
9/24/2024 134.5 -- 0.5(0.37 %) 2,011,400 269.63

9/23/2024 134 -- -1.3(-0.96 %) 2,441,200 327.88

9/20/2024 135.3 -- 0.1(0.07 %) 3,719,700 506.35
9/19/2024 135.2 -- 0.6(0.45 %) 5,154,300 695.88
9/18/2024 134.6 -- 1.7(1.28 %) 5,379,600 722.78
9/17/2024 132.9 -- 1.8(1.37 %) 2,651,400 350.67

9/16/2024 131.1 -- -1.9(-1.43 %) 1,915,700 252.15

9/13/2024 133 -- 0.7(0.53 %) 3,186,800 423.78
9/12/2024 132.3 -- 1.7(1.30 %) 4,118,000 543.3
9/11/2024 130.6 -- 0.6(0.46 %) 3,190,400 416.16

9/10/2024 130 -- -1.3(-0.99 %) 4,195,100 546.65

9/9/2024 131.3 -- -0.8(-0.61 %) 2,885,200 377.09

9/6/2024 132.1 -- 1.5(1.15 %) 3,821,400 503.72

9/5/2024 130.6 -- -2.4(-1.80 %) 8,055,600 1,051.19

9/4/2024 133 -- -1.8(-1.34 %) 4,535,200 600.25

8/30/2024 134.8 -- 1.1(0.82 %) 3,315,800 446.15
8/29/2024 133.7 -- 0.4(0.30 %) 2,092,700 278.68
8/28/2024 133.3 -- 0.8(0.60 %) 2,711,500 362.34
8/27/2024 132.5 -- 1(0.76 %) 2,338,500 308.17

8/26/2024 131.5 -- -1.6(-1.20 %) 2,590,300 342.21

8/23/2024 133.1 -- -0.7(-0.52 %) 3,055,000 406.25

8/22/2024 133.8 -- 0.3(0.22 %) 3,020,500 404.7
8/21/2024 133.5 -- 2(1.52 %) 6,119,700 808.78
8/20/2024 131.5 -- 1(0.77 %) 3,741,400 492.12

8/19/2024 130.5 -- -0.1(-0.08 %) 2,498,400 326.05

8/16/2024 130.6 -- 1.9(1.48 %) 5,093,600 663.59

8/15/2024 128.7 -- -0.8(-0.62 %) 2,257,600 290.61

8/14/2024 129.5 -- -0.2(-0.15 %) 2,862,200 372.25

8/13/2024 129.7 -- -0.3(-0.23 %) 4,097,900 529.46

8/12/2024 130 -- 3.1(2.44 %) 6,183,500 797.5
8/9/2024 126.9 -- 5.5(4.53 %) 5,496,400 684.74

8/8/2024 121.4 -- -0.6(-0.49 %) 2,654,900 323

8/7/2024 122 -- 1.2(0.99 %) 2,822,800 341.32
8/6/2024 120.8 -- 2.2(1.85 %) 6,728,100 812.06
8/5/2024 118.6 -- -4.6(-3.73 %) 10,415,200 1,254.10

8/2/2024 123.2 -- -1.6(-1.28 %) 9,944,700 1,221.18

8/1/2024 124.8 -- -3.8(-2.95 %) 6,870,300 866.88

7/31/2024 128.6 -- 0.6(0.47 %) 2,869,200 366.62
7/30/2024 128 -- -1(-0.78 %) 2,373,800 303.85
7/29/2024 129 -- 1(0.78 %) 4,859,800 631.08
7/26/2024 128 -- 3(2.40 %) 3,951,100 497.18
7/25/2024 125 -- -1(-0.79 %) 2,563,400 319.82
7/24/2024 126 -- 0.5(0.40 %) 4,151,700 520.86
7/23/2024 125.5 -- 1.4(1.13 %) 5,311,600 672.73

7/22/2024 124.1 -- -1.9(-1.51 %) 6,216,900 772.29

7/19/2024 126 -- -1.9(-1.49 %) 6,551,700 832.65

7/18/2024 127.9 -- -4(-3.03 %) 10,800,200 1,391.94

7/17/2024 131.9 -- -2.1(-1.57 %) 6,970,100 921.8

7/16/2024 134 -- 1.3(0.98 %) 4,002,300 533.55

7/15/2024 132.7 -- -1.1(-0.82 %) 3,067,200 408.78

7/12/2024 133.8 -- 0.8(0.60 %) 3,553,400 476.05
7/11/2024 133 -- -1(-0.75 %) 6,842,100 913.79

7/10/2024 134 -- -3.5(-2.55 %) 6,294,700 853.17

7/9/2024 137.5 -- -2.1(-1.50 %) 9,676,100 1,327.02

7/8/2024 139.6 -- 0.9(0.65 %) 5,865,700 814.73
7/5/2024 138.7 -- 2.9(2.14 %) 7,789,400 1,078.09
7/4/2024 135.8 -- 4.8(3.66 %) 8,117,900 1,088.49
7/3/2024 131 -- 3(2.34 %) 7,634,100 1,005.10

7/2/2024 128 -- -0.6(-0.47 %) 6,720,600 873.66

7/1/2024 128.6 -- -1.9(-1.46 %) 6,376,000 822.64

6/28/2024 130.5 -- -2.3(-1.73 %) 6,633,000 873.57

6/27/2024 132.8 -- 1(0.76 %) 6,403,700 847.77
6/26/2024 131.8 -- 1.8(1.38 %) 7,147,400 932.1

6/25/2024 130 -- -2.1(-1.59 %) 13,706,800 1,776.77

6/24/2024 132.1 -- -4(-2.94 %) 13,186,900 1.762
6/21/2024 136.1 -- 2.8(2.10 %) 7,653,300 1,034.71
6/20/2024 133.3 -- 1.8(1.37 %) 10,465,700 1,404.64
6/19/2024 131.5 -- 3.5(2.73 %) 9,669,200 1,249.78
6/18/2024 128 -- -0.8(-0.62 %) 6,680,000 860.58

6/17/2024 128.8 -- -2.2(-1.68 %) 4,867,600 631.22

6/14/2024 131 -- 1(0.77 %) 6,406,200 834.85
6/13/2024 130 -- -2(-1.52 %) 8,136,200 1,066.86
6/12/2024 132 -- 5.48(4.33 %) 11,215,500 1,464.08
6/11/2024 146.5 126.52 2.5(1.74 %) 6,327,300 915.26
6/10/2024 144 124.36 2(1.41 %) 3,775,400 542.41
6/7/2024 142 122.63 2.4(1.72 %) 3,756,900 530.59

6/6/2024 139.6 120.56 -0.5(-0.36 %) 5,211,800 731.83

6/5/2024 140.1 120.99 1(0.72 %) 6,321,600 895.48
6/4/2024 139.1 120.13 2.2(1.61 %) 7,009,800 973.9
6/3/2024 136.9 118.23 2.3(1.71 %) 7,773,600 1,062.26

5/31/2024 134.6 116.24 -0.4(-0.30 %) 2,633,500 354.49

5/30/2024 135 116.59 -0.7(-0.52 %) 7,261,300 965.21

5/29/2024 135.7 117.19 -1.3(-0.95 %) 5,837,600 793.59

5/28/2024 137 118.31 4.2(3.16 %) 4,625,300 623.83
5/27/2024 132.8 114.69 0.9(0.68 %) 5,157,800 682.27

5/24/2024 131.9 113.91 -5.6(-4.07 %) 13,375,600 1,782.68

5/23/2024 137.5 118.74 -0.5(-0.36 %) 3,621,500 493.72

5/22/2024 138 119.18 2(1.47 %) 4,511,800 621.72
5/21/2024 136 117.45 3(2.26 %) 3,471,900 467.06

5/20/2024 133 114.86 -1.5(-1.12 %) 2,013,500 270.5

5/17/2024 134.5 116.15 -0.9(-0.66 %) 2,306,400 310.27

5/16/2024 135.4 116.93 1.3(0.97 %) 3,119,000 423.78
5/15/2024 134.1 115.81 3.6(2.76 %) 3,653,100 485.07
5/14/2024 130.5 112.7 0.8(0.62 %) 2,304,600 300.96

5/13/2024 129.7 112.01 -1.3(-0.99 %) 1,852,200 240.66

5/10/2024 131 113.13 0.7(0.54 %) 3,789,700 494.17

5/9/2024 130.3 112.53 -0.7(-0.53 %) 2,203,300 288.3

5/8/2024 131 113.13 -0.3(-0.23 %) 3,017,800 392.62

5/7/2024 131.3 113.39 3.7(2.90 %) 3,122,800 406.19
5/6/2024 127.6 110.2 1.7(1.35 %) 2,704,600 341.47

5/3/2024 125.9 108.73 -1.4(-1.10 %) 3,191,200 403.1

5/2/2024 127.3 109.94 4.1(3.33 %) 3,469,300 439.89
ed from CafeF

GD thỏa thuận Giá (nghìn VNĐ)

Giá trị (tỷ

Khối lượng VNĐ) Mở cửa Cao nhất Thấp nhất
100 13.56 135.9 136 135.3
160.4 21.75 135.4 135.9 135.2
190 25.65 135.4 135.5 134.8
1 0 134.1 135 133.6

0 0 134.3 134.6 133.6

1 0 134.2 134.3 133.8
1 0 132.9 134.8 132.6

165.3 22.34 135.7 135.7 133

180 24.52 137 137.7 135.5

1 0 137.4 137.8 136.6
1,190,000 166.6 136.5 137.1 135.5

20.001 2.83 136.4 137.1 136

50 7.19 137.6 138.6 136.6

30 4.5 141.1 141.3 137.1

50 7.07 142 142.8 139.6

50 6.9 135.8 142 135.8
200 27.07 134.3 135.8 134.3

1 0 134.1 135.1 133.6

571.001 76.4 134.2 134.9 133.6
0 0 134.3 134.8 133.5

1,331,001 180.14 135.4 136.1 134

649.4 87.67 134.6 135.9 134.6

2,161,100 293.9 134.7 136.2 134.7
248 33.15 134.2 134.5 133

200 26.77 134.3 134.4 133.5

265 35.58 135 135 133.9

0 0 134.3 134.8 133.6
 184.116 23.36 134 134.7 133.7

1,041,000 134.79 135.9 135.9 133.4

0 0 136.3 137 135
0 0 135 135.8 134.3
70 9.22 133.4 135.2 132.9
950 129.5 131.2 132.9 131.2

380 50.12 131.8 133 131.1

748.9 99.32 132.2 133.4 132
250 33.02 131 132.5 131
400 52.18 130 131.3 129.8

1 0 131 131 129.6

1 0 130.8 131.9 130.1

400 52.79 130.5 132.9 130.3

0 0 133 133 129.7

400 52.91 133 133 131.5

64 8.74 133.5 134.9 133
545.001 72.57 132.8 133.8 132.2
198.201 26.41 133 134.5 132.9
651.4 85.33 131.5 132.6 130.4

167.9 22.18 133.3 133.5 131.5

270.001 35.91 133.7 133.7 132.4

540 72.33 134 134.5 133.5
352.2 46.24 130.6 133.8 130.6
243 31.83 130.7 132.5 130.7

56.462 7.37 131.1 131.4 130

393 51.09 129.1 131 129.1

48 6.24 129.1 129.5 128.2

940 114.84 130.7 131.5 129.5

48.001 6.24 129.7 130.2 128

591.501 75.42 126.9 130.2 126.2
165 20.55 122.4 126.9 122

576.531 70.13 121.6 122.4 120.9

0 0 121 122 120.2
263.75 31.26 120 121.9 119.8
 0 0 121.1 122.9 117.4

212.5 25.35 122.1 124.8 121

1 0 129.6 129.7 124.1

225 28.85 127.3 128.6 126.6
50 6.05 129 129.5 127
150 20.54 130 130.6 129
1,182,600 148.81 125.9 128 124.4
685.001 86.06 124.2 125.5 124.1
20 2.68 125.5 126.6 124
100 11.55 124.9 127.5 124.8

0 0 126 126 123.2

0 0 128.6 129.3 126

25.001 3.3 131.4 131.4 127.8

0 0 134 134.1 129.9

349.9 46.6 133.6 134.5 132.3

0 0 133.5 134.8 132.3

36.6 4.9 132.2 136 132.2
40 5.37 134.1 135.4 132.5

43 5.86 136 137 134

20 2.74 139.1 139.3 136

240 33.33 138.5 139.6 137.5
20 2.76 136.1 139.7 136.1
0 0 132.1 135.8 132.1
250.001 32.92 130.5 132.8 130.1

839.401 109.69 128.6 132.1 127.5

78 10.89 130.4 130.4 128.5

0 0 132.8 132.8 130.4

124 15.36 131.3 134.1 130.8
38 5.05 131 131.8 129.4

343.343 44.63 131 131.1 128.6

1,204,000 174.12 135 135.5 132
0 0 133.9 136.1 133.3
595 73.04 133 135.7 131.8
600 71.64 128 132.8 126.6
 256.8 33.3 128.8 129.7 128

0 0 131 131.4 128.5

201 26.18 130.1 132.6 129
540 70.86 133.7 133.8 130
0 0 127.9 132.7 127.8
2,091,200 320.86 144.3 146.5 143.1
0 0 143.5 145 143
169.7 23.97 141 142 140.5

20 2.61 140.3 141.7 138.8

20.201 2.83 140 144.9 139.7
40 5.52 139 139.3 137.8
0 0 135 137.6 134.7

63.1 8.48 135 136.8 133.8

40 5.37 133.8 135 131.9

270 37.23 137.1 138.2 134.8

794.2 104.25 134 137 133.1
963.3 126.56 133 133.5 130.6

759.001 102.56 138 138 130.6

100 13.8 137.5 137.8 135

2,620,600 348.75 137.9 139.7 136.1
734.4 99.45 134 136 133.5

1,130,000 152.86 135.2 136.1 133

642.601 86.43 135.4 136 133.7

924.9 119.98 135.6 137.3 134.2
1,044,600 139.8 131.5 134.5 131.3
847.3 113.19 130 131.7 129.6

2,508,000 336.62 131.3 131.5 128.8

0 0 131.3 132.2 129.2

838.3 111.35 130.6 132.8 130

759.7 104.94 130.1 131 129.3

0 0 128 131.6 127.2
0 0 126.5 127.6 124.5

0 0 128.1 128.4 125.6

3,418,700 450.58 123.8 129 123.5
 FPT STOCK PRICE

Opening price (x1000) Highest price (x1000)

No Date
1 10/31/2024 135.9 136
2 10/30/2024 135.4 135.9
3 10/29/2024 135.4 135.5
4 10/28/2024 134.1 135
5 10/25/2024 134.3 134.6
6 10/24/2024 134.2 134.3
7 10/23/2024 132.9 134.8
8 10/22/2024 135.7 135.7
9 10/21/2024 137 137.7
10 10/18/2024 137.4 137.8
11 10/17/2024 136.5 137.1
12 10/16/2024 136.4 137.1
13 10/15/2024 137.6 138.6
14 10/14/2024 141.1 141.3
15 10/11/2024 142 142.8
16 10/10/2024 135.8 142
17 10/9/2024 134.3 135.8
18 10/8/2024 134.1 135.1
19 10/7/2024 134.2 134.9
20 10/4/2024 134.3 134.8
21 10/3/2024 135.4 136.1
22 10/2/2024 134.6 135.9
23 10/1/2024 134.7 136.2
24 9/30/2024 134.2 134.5
25 9/27/2024 134.3 134.4
26 9/26/2024 135 135
27 9/25/2024 134.3 134.8
28 9/24/2024 134 134.7
29 9/23/2024 135.9 135.9
30 9/20/2024 136.3 137
31 9/19/2024 135 135.8
32 9/18/2024 133.4 135.2
33 9/17/2024 131.2 132.9
34 9/16/2024 131.8 133
35 9/13/2024 132.2 133.4
36 9/12/2024 131 132.5
37 9/11/2024 130 131.3
38 9/10/2024 131 131
39 9/9/2024 130.8 131.9
40 9/6/2024 130.5 132.9
41 9/5/2024 133 133
42 9/4/2024 133 133
43 8/30/2024 133.5 134.9
44 8/29/2024 132.8 133.8
45 8/28/2024 133 134.5
46 8/27/2024 131.5 132.6
47 8/26/2024 133.3 133.5
48 8/23/2024 133.7 133.7
49 8/22/2024 134 134.5
50 8/21/2024 130.6 133.8
51 8/20/2024 130.7 132.5
52 8/19/2024 131.1 131.4
53 8/16/2024 129.1 131
54 8/15/2024 129.1 129.5
55 8/14/2024 130.7 131.5
56 8/13/2024 129.7 130.2
57 8/12/2024 126.9 130.2
58 8/9/2024 122.4 126.9
59 8/8/2024 121.6 122.4
60 8/7/2024 121 122
61 8/6/2024 120 121.9
62 8/5/2024 121.1 122.9
63 8/2/2024 122.1 124.8
64 8/1/2024 129.6 129.7
65 7/31/2024 127.3 128.6
66 7/30/2024 129 129.5
67 7/29/2024 130 130.6
68 7/26/2024 125.9 128
69 7/25/2024 124.2 125.5
70 7/24/2024 125.5 126.6
71 7/23/2024 124.9 127.5
72 7/22/2024 126 126
73 7/19/2024 128.6 129.3
74 7/18/2024 131.4 131.4
75 7/17/2024 134 134.1
76 7/16/2024 133.6 134.5
77 7/15/2024 133.5 134.8
78 7/12/2024 132.2 136
79 7/11/2024 134.1 135.4
80 7/10/2024 136 137
81 7/9/2024 139.1 139.3
82 7/8/2024 138.5 139.6
83 7/5/2024 136.1 139.7
84 7/4/2024 132.1 135.8
85 7/3/2024 130.5 132.8
86 7/2/2024 128.6 132.1
87 7/1/2024 130.4 130.4
88 6/28/2024 132.8 132.8
89 6/27/2024 131.3 134.1
90 6/26/2024 131 131.8
91 6/25/2024 131 131.1
92 6/24/2024 135 135.5
93 6/21/2024 133.9 136.1
94 6/20/2024 133 135.7
95 6/19/2024 128 132.8
96 6/18/2024 128.8 129.7
97 6/17/2024 131 131.4
98 6/14/2024 130.1 132.6
99 6/13/2024 133.7 133.8
100 6/12/2024 127.9 132.7
101 6/11/2024 144.3 146.5
102 6/10/2024 143.5 145
103 6/7/2024 141 142
104 6/6/2024 140.3 141.7
105 6/5/2024 140 144.9
106 6/4/2024 139 139.3
107 6/3/2024 135 137.6
108 5/31/2024 135 136.8
109 5/30/2024 133.8 135
110 5/29/2024 137.1 138.2
111 5/28/2024 134 137
112 5/27/2024 133 133.5
113 5/24/2024 138 138
114 5/23/2024 137.5 137.8
115 5/22/2024 137.9 139.7
116 5/21/2024 134 136
117 5/20/2024 135.2 136.1
118 5/17/2024 135.4 136
119 5/16/2024 135.6 137.3
120 5/15/2024 131.5 134.5
121 5/14/2024 130 131.7
122 5/13/2024 131.3 131.5
123 5/10/2024 131.3 132.2
124 5/9/2024 130.6 132.8
125 5/8/2024 130.1 131
126 5/7/2024 128 131.6
127 5/6/2024 126.5 127.6
128 5/3/2024 128.1 128.4
129 5/2/2024 123.8 129
 1. Determine the mean, variance, standar
2. Display histogram(s) and boxplot(s).

Lowest price Closing price

(x1000) (x1000)

135.3 135.9 Mean

135.2 135.9 Standard Deviation
134.8 135.4 Median
133.6 134.9 Mode
133.6 134 Standard Error
133.8 134.3 Sample Variance
132.6 134.2 Range
133 133.1 Minimum
135.5 135.5 Maximum
136.6 137 Count
135.5 137
136 136.3 This chart isn't available in your version of Excel.
136.6 137
Editing this shape or saving this workbook into a different file for
137.1 137.6
139.6 139.6
135.8 141.7
134.3 135.4
133.6 133.8
133.6 134.1
133.5 134.1
134 134
134.6 135.4
134.7 135.9 This chart isn't available in your version of Excel.
133 134.5
Editing this shape or saving this workbook into a different file for
133.5 134.2
133.9 134.3
133.6 134.8
133.7 134.5
133.4 134
135 135.3
134.3 135.2
132.9 134.6
131.2 132.9 This chart isn't available in your version of Excel.

Editing this shape or saving this workbook into a different file for
 This chart isn't available in your version of Excel.
131.1 131.1
Editing this shape or saving this workbook into a different file for
132 133
131 132.3
129.8 130.6
129.6 130
130.1 131.3
130.3 132.1
129.7 130.6
131.5 133
133 134.8 This chart isn't available in your version of Excel.
132.2 133.7
Editing this shape or saving this workbook into a different file for
132.9 133.3
130.4 132.5
131.5 131.5
132.4 133.1
133.5 133.8
130.6 133.5
130.7 131.5
130 130.5
129.1 130.6
128.2 128.7
129.5 129.5
128 129.7
126.2 130
122 126.9
120.9 121.4
120.2 122
119.8 120.8
117.4 118.6
121 123.2
124.1 124.8
126.6 128.6
127 128
129 129
124.4 128
124.1 125
124 126
124.8 125.5
123.2 124.1
 126 126
127.8 127.9
129.9 131.9
132.3 134
132.3 132.7
132.2 133.8
132.5 133
134 134
136 137.5
137.5 139.6
136.1 138.7
132.1 135.8
130.1 131
127.5 128
128.5 128.6
130.4 130.5
130.8 132.8
129.4 131.8
128.6 130
132 132.1
133.3 136.1
131.8 133.3
126.6 131.5
128 128
128.5 128.8
129 131
130 130
127.8 132
143.1 146.5
143 144
140.5 142
138.8 139.6
139.7 140.1
137.8 139.1
134.7 136.9
133.8 134.6
131.9 135
134.8 135.7
133.1 137
130.6 132.8
130.6 131.9
135 137.5
136.1 138
133.5 136
133 133
133.7 134.5
134.2 135.4
131.3 134.1
129.6 130.5
128.8 129.7
129.2 131
130 130.3
129.3 131
127.2 131.3
124.5 127.6
125.6 125.9
123.5 127.3
ne the mean, variance, standard deviation,…
histogram(s) and boxplot(s).

Opening price (x1000) Highest price (x1000) Lowest price (x1000)

132.539 133.866 131.295

4.518 4.398 4.539
133 134.4 132
134.3 134.5 133.6
0.398 0.387 0.400
20.408 19.340 20.599
24.3 24.6 25.7
120 121.9 117.4
144.3 146.5 143.1
129 129 129

available in your version of Excel.

pe or saving this workbook into a different file format will permanently break the chart.

available in your version of Excel.

pe or saving this workbook into a different file format will permanently break the chart.

available in your version of Excel.

pe or saving this workbook into a different file format will permanently break the chart.
available in your version of Excel.

pe or saving this workbook into a different file format will permanently break the chart.

available in your version of Excel.

pe or saving this workbook into a different file format will permanently break the chart.
Closing price (x1000)

132.618
4.509
133
134
0.397
20.330
27.9
118.6
146.5
129

This chart isn't available in your version of Excel.

Editing this shape or saving this workbook into a different file forma
will permanently break the chart.

This chart isn't available in your version of Excel.

Editing this shape or saving this workbook into a different file forma
permanently break the chart.

This chart isn't available in your version of Excel.

Editing this shape or saving this workbook into a different file forma
will permanently break the chart.
This chart isn't available in your version of Excel.

Editing this shape or saving this workbook into a different file forma
will permanently break the chart.

This chart isn't available in your version of Excel.

Editing this shape or saving this workbook into a different file

format will permanently break the chart.
of Excel.

ok into a different file format

of Excel.

ok into a different file format will

of Excel.

ok into a different file format

of Excel.

ok into a different file format

of Excel.

ok into a different file

 FPT Stock Opening Price
Opening price
No Date (x1000) Dummy
1 10/31/2024 135.9 0
2 10/30/2024 135.4 0
3 10/29/2024 135.4
4 10/28/2024 134.1
5 10/25/2024 134.3
6 10/24/2024 134.2
7 10/23/2024 132.9
8 10/22/2024 135.7
9 10/21/2024 137
10 10/18/2024 137.4
11 10/17/2024 136.5
12 10/16/2024 136.4
13 10/15/2024 137.6
14 10/14/2024 141.1
15 10/11/2024 142
16 10/10/2024 135.8
17 10/9/2024 134.3
18 10/8/2024 134.1
19 10/7/2024 134.2
20 10/4/2024 134.3
21 10/3/2024 135.4
22 10/2/2024 134.6
23 10/1/2024 134.7
24 9/30/2024 134.2
25 9/27/2024 134.3
26 9/26/2024 135
27 9/25/2024 134.3
28 9/24/2024 134
29 9/23/2024 135.9
30 9/20/2024 136.3
31 9/19/2024 135
32 9/18/2024 133.4
33 9/17/2024 131.2

34 9/16/2024 131.8
35 9/13/2024 132.2
36 9/12/2024 131
37 9/11/2024 130
38 9/10/2024 131
39 9/9/2024 130.8
40 9/6/2024 130.5
41 9/5/2024 133
42 9/4/2024 133
43 8/30/2024 133.5
44 8/29/2024 132.8
45 8/28/2024 133
46 8/27/2024 131.5
47 8/26/2024 133.3
48 8/23/2024 133.7
49 8/22/2024 134
50 8/21/2024 130.6
51 8/20/2024 130.7
52 8/19/2024 131.1
53 8/16/2024 129.1
54 8/15/2024 129.1
55 8/14/2024 130.7
56 8/13/2024 129.7
57 8/12/2024 126.9
58 8/9/2024 122.4
59 8/8/2024 121.6
60 8/7/2024 121
61 8/6/2024 120
62 8/5/2024 121.1
63 8/2/2024 122.1
64 8/1/2024 129.6
65 7/31/2024 127.3
66 7/30/2024 129
 67 7/29/2024 130
68 7/26/2024 125.9
69 7/25/2024 124.2
70 7/24/2024 125.5
71 7/23/2024 124.9
72 7/22/2024 126
73 7/19/2024 128.6
74 7/18/2024 131.4
75 7/17/2024 134
76 7/16/2024 133.6
77 7/15/2024 133.5
78 7/12/2024 132.2
79 7/11/2024 134.1
80 7/10/2024 136
81 7/9/2024 139.1
82 7/8/2024 138.5
83 7/5/2024 136.1
84 7/4/2024 132.1
85 7/3/2024 130.5
86 7/2/2024 128.6
87 7/1/2024 130.4
88 6/28/2024 132.8
89 6/27/2024 131.3
90 6/26/2024 131
91 6/25/2024 131
92 6/24/2024 135
93 6/21/2024 133.9
94 6/20/2024 133
95 6/19/2024 128
96 6/18/2024 128.8
97 6/17/2024 131
98 6/14/2024 130.1
99 6/13/2024 133.7
100 6/12/2024 127.9
101 6/11/2024 144.3
102 6/10/2024 143.5
103 6/7/2024 141
104 6/6/2024 140.3
105 6/5/2024 140
106 6/4/2024 139
107 6/3/2024 135
108 5/31/2024 135
109 5/30/2024 133.8
110 5/29/2024 137.1
111 5/28/2024 134
112 5/27/2024 133
113 5/24/2024 138
114 5/23/2024 137.5
115 5/22/2024 137.9
116 5/21/2024 134
117 5/20/2024 135.2
118 5/17/2024 135.4
119 5/16/2024 135.6
120 5/15/2024 131.5
121 5/14/2024 130
122 5/13/2024 131.3
123 5/10/2024 131.3
124 5/9/2024 130.6
125 5/8/2024 130.1
126 5/7/2024 128
127 5/6/2024 126.5
128 5/3/2024 128.1
129 5/2/2024 123.8
3. Test a hypothesis and construct a confidenc

Test claim: Based on descriptice statistic, we w

t-Test: One-Sample Assuming Unequal Variances
Opening price (x1000)
Mean
Variance
Observations
Hypothesized Mean Difference
df
t Stat
P(T<=t) one-tail
t Critical one-tail
P(T<=t) two-tail
t Critical two-tail

Descriptive Statictis FPT Stock Opening Pri

Mean
Standard Error
Median
Mode
Standard Deviation
Sample Variance
Kurtosis
Skewness
Range
Minimum
Maximum
Sum
Count
Confidence Level(95.0%)
4. Test a hypothesis and construct a confidence inte

Test claim: Data were collected from a random

H₀: π ≤ 0.3
H₁: π > 0.3
This is Right One Tail Test

95% confidence interval for the proportion of a

95% Lower CI
95% Upper CI
Conclusion with 95% confidence interval, the propor
and construct a confidence interval for the mean of a population an

descriptice statistic, we want to test If population mean of FPT Sto

ssuming Unequal Variances
g price (x1000)
132.539
20.408
129
132
128
1.355
0.089
1.657
0.178
1.979

tis FPT Stock Opening Price (x1000)

132.539
0.398
133
134.3
4.518
20.408
0.727
-0.369
24.3
120
144.3
17097.5
129
0.787
 construct a confidence interval for the proportion of a population.

collected from a random sample of 129 days at the opening price

X: Population
x 99
n 129
p 0.767
π 0.3
α 0.05
Z Critical 1.645
Z Statistic 11.585

Because 1.645< 11.5854 => Z critical < Z Statistic

So Reject H₀

val for the proportion of a population (with population standard de

0.706
0.829
nfidence interval, the proportion of a population (FPT Stock Opening Price)
al for the mean of a population and proportion of a population

est If population mean of FPT Stock Opening Price is higher than 1

H₀: μ ≤ 132
H₁: μ > 132
This is Right One Tail Test
t statistic 1.355
Critical value (one-tail) (-1.657;1.657)
Because -1.657<1.355<1.657 or p-value= 0.089 > 0.05
So do not reject H₀

95% Confidence interval of the population mean of opening p

95% Lower CI 131.752
95% Upper CI 133.326

Conclusion: With 95% Confidence, the population mean of opening

he proportion of a population.

of 129 days at the opening price of FPT stock, the results showed

4 => Z critical < Z Statistic

tion (with population standard deviation unknown)

population (FPT Stock Opening Price) will be between 0.706 and 0.829
 a population

ce is higher than 132 in significant le

9 > 0.05

mean of opening price (with population standard deviation unknow

n mean of opening price will be between 131.752 to 133.326.

he results showed that 99 days had stock prices higher than 130. A

.706 and 0.829

d deviation unknown)

133.326.
higher than 130. At the 0.05 significance level, is there evidence t
there evidence that more than 30% of the days had stock prices h
ock prices higher than 130.
 Lowest price
No Date (x1000) Highest price (x1000)
1 10/31/2024 135.3 136
2 10/30/2024 135.2 135.9
3 10/29/2024 134.8 135.5
4 10/28/2024 133.6 135
5 10/25/2024 133.6 134.6
6 10/24/2024 133.8 134.3
7 10/23/2024 132.6 134.8
8 10/22/2024 133 135.7
9 10/21/2024 135.5 137.7
10 10/18/2024 136.6 137.8
11 10/17/2024 135.5 137.1
12 10/16/2024 136 137.1
13 10/15/2024 136.6 138.6
14 10/14/2024 137.1 141.3
15 10/11/2024 139.6 142.8
16 10/10/2024 135.8 142
17 10/9/2024 134.3 135.8
18 10/8/2024 133.6 135.1
19 10/7/2024 133.6 134.9
20 10/4/2024 133.5 134.8
21 10/3/2024 134 136.1
22 10/2/2024 134.6 135.9
23 10/1/2024 134.7 136.2
24 9/30/2024 133 134.5
25 9/27/2024 133.5 134.4
26 9/26/2024 133.9 135
27 9/25/2024 133.6 134.8
28 9/24/2024 133.7 134.7
29 9/23/2024 133.4 135.9
30 9/20/2024 135 137
31 9/19/2024 134.3 135.8
32 9/18/2024 132.9 135.2
33 9/17/2024 131.2 132.9
34 9/16/2024 131.1 133
35 9/13/2024 132 133.4
36 9/12/2024 131 132.5
37 9/11/2024 129.8 131.3
38 9/10/2024 129.6 131
39 9/9/2024 130.1 131.9
40 9/6/2024 130.3 132.9
41 9/5/2024 129.7 133
42 9/4/2024 131.5 133
43 8/30/2024 133 134.9
44 8/29/2024 132.2 133.8
45 8/28/2024 132.9 134.5
46 8/27/2024 130.4 132.6
47 8/26/2024 131.5 133.5
48 8/23/2024 132.4 133.7
49 8/22/2024 133.5 134.5
50 8/21/2024 130.6 133.8
51 8/20/2024 130.7 132.5
52 8/19/2024 130 131.4
53 8/16/2024 129.1 131
54 8/15/2024 128.2 129.5
55 8/14/2024 129.5 131.5
56 8/13/2024 128 130.2
57 8/12/2024 126.2 130.2
58 8/9/2024 122 126.9
59 8/8/2024 120.9 122.4
60 8/7/2024 120.2 122
61 8/6/2024 119.8 121.9
62 8/5/2024 117.4 122.9
63 8/2/2024 121 124.8
64 8/1/2024 124.1 129.7
65 7/31/2024 126.6 128.6
66 7/30/2024 127 129.5
67 7/29/2024 129 130.6
68 7/26/2024 124.4 128
69 7/25/2024 124.1 125.5
70 7/24/2024 124 126.6
71 7/23/2024 124.8 127.5
72 7/22/2024 123.2 126
73 7/19/2024 126 129.3
74 7/18/2024 127.8 131.4
75 7/17/2024 129.9 134.1
76 7/16/2024 132.3 134.5
77 7/15/2024 132.3 134.8
78 7/12/2024 132.2 136
79 7/11/2024 132.5 135.4
80 7/10/2024 134 137
81 7/9/2024 136 139.3
82 7/8/2024 137.5 139.6
83 7/5/2024 136.1 139.7
84 7/4/2024 132.1 135.8
85 7/3/2024 130.1 132.8
86 7/2/2024 127.5 132.1
87 7/1/2024 128.5 130.4
88 6/28/2024 130.4 132.8
89 6/27/2024 130.8 134.1
90 6/26/2024 129.4 131.8
91 6/25/2024 128.6 131.1
92 6/24/2024 132 135.5
93 6/21/2024 133.3 136.1
94 6/20/2024 131.8 135.7
95 6/19/2024 126.6 132.8
96 6/18/2024 128 129.7
97 6/17/2024 128.5 131.4
98 6/14/2024 129 132.6
99 6/13/2024 130 133.8
100 6/12/2024 127.8 132.7
101 6/11/2024 143.1 146.5
102 6/10/2024 143 145
103 6/7/2024 140.5 142
104 6/6/2024 138.8 141.7
105 6/5/2024 139.7 144.9
106 6/4/2024 137.8 139.3
107 6/3/2024 134.7 137.6
108 5/31/2024 133.8 136.8
109 5/30/2024 131.9 135
110 5/29/2024 134.8 138.2
111 5/28/2024 133.1 137
112 5/27/2024 130.6 133.5
113 5/24/2024 130.6 138
114 5/23/2024 135 137.8
115 5/22/2024 136.1 139.7
116 5/21/2024 133.5 136
117 5/20/2024 133 136.1
118 5/17/2024 133.7 136
119 5/16/2024 134.2 137.3
120 5/15/2024 131.3 134.5
121 5/14/2024 129.6 131.7
122 5/13/2024 128.8 131.5
123 5/10/2024 129.2 132.2
124 5/9/2024 130 132.8
125 5/8/2024 129.3 131
126 5/7/2024 127.2 131.6
127 5/6/2024 124.5 127.6
128 5/3/2024 125.6 128.4
129 5/2/2024 123.5 129
5. Test a hypothesis and construct a confidence interval for the difference in means of two population

t-Test: Two-Sample Assuming Equal Variances

X2 X1
Lowest price (x1000) Highest price (x1000)
Mean 131.295 133.866
Variance 20.599 19.340
Observations 129 129
Pooled Variance 19.969
Hypothesized Mean Difference 0
df 256
t Stat -4.620
P(T<=t) one-tail 3.045139135057E-06
t Critical one-tail 1.651
P(T<=t) two-tail 6.090278270113E-06
t Critical two-tail 1.969
n means of two populations.

H0: μ1- μ2=0

H1: μ1- μ2≠0
This is two-tailed test
t Stat -4.620
Critical value -1.969 1.969
Because -4.620<-1,969 => t Stat < t Critical value
So reject H0

A 95% confidence interval for μ1- μ2

95% lower CI 1.475
95% upper CI 3.666

Conclusion with 95% confidence interval, the proportion of two population (FPT S
wo population (FPT Stock Opening Price) will be between 1.475 and 3.666
 Opening Closing price
No Date price (x1000) (x1000)
1 10/31/2024 135,9 135,9 6. Test a hypothesis and construct a confidence in
2 10/30/2024 135,4 135,9
3 10/29/2024 135,4 135,4
4 10/28/2024 134,1 134,9 H0: π1-π2 = 0
5 10/25/2024 134,3 134 H1: π1-π2 ≠ 0

6 10/24/2024 134,2 134,3 This is two-tailed test

7 10/23/2024 132,9 134,2
8 10/22/2024 135,7 133,1
9 10/21/2024 137 135,5
10 10/18/2024 137,4 137
11 10/17/2024 136,5 137
12 10/16/2024 136,4 136,3
13 10/15/2024 137,6 137
14 10/14/2024 141,1 137,6 A 95% confident interval for π1-π2
15 10/11/2024 142 139,6 95% lower CI
16 10/10/2024 135,8 141,7 95% upper CI
17 10/9/2024 134,3 135,4
18 10/8/2024 134,1 133,8 Conclusion with 95% confidence interval, the
19 10/7/2024 134,2 134,1
20 10/4/2024 134,3 134,1
21 10/3/2024 135,4 134
22 10/2/2024 134,6 135,4
23 10/1/2024 134,7 135,9
24 9/30/2024 134,2 134,5
25 9/27/2024 134,3 134,2
26 9/26/2024 135 134,3
27 9/25/2024 134,3 134,8
28 9/24/2024 134 134,5
29 9/23/2024 135,9 134
30 9/20/2024 136,3 135,3
31 9/19/2024 135 135,2
32 9/18/2024 133,4 134,6
33 9/17/2024 131,2 132,9
34 9/16/2024 131,8 131,1
35 9/13/2024 132,2 133
36 9/12/2024 131 132,3
37 9/11/2024 130 130,6
38 9/10/2024 131 130
39 9/9/2024 130,8 131,3
40 9/6/2024 130,5 132,1
41 9/5/2024 133 130,6
42 9/4/2024 133 133
43 8/30/2024 133,5 134,8
44 8/29/2024 132,8 133,7
45 8/28/2024 133 133,3
46 8/27/2024 131,5 132,5
47 8/26/2024 133,3 131,5
48 8/23/2024 133,7 133,1
49 8/22/2024 134 133,8
50 8/21/2024 130,6 133,5
51 8/20/2024 130,7 131,5
52 8/19/2024 131,1 130,5
53 8/16/2024 129,1 130,6
54 8/15/2024 129,1 128,7
55 8/14/2024 130,7 129,5
56 8/13/2024 129,7 129,7
57 8/12/2024 126,9 130
58 8/9/2024 122,4 126,9
59 8/8/2024 121,6 121,4
60 8/7/2024 121 122
61 8/6/2024 120 120,8
62 8/5/2024 121,1 118,6
63 8/2/2024 122,1 123,2
64 8/1/2024 129,6 124,8
65 7/31/2024 127,3 128,6
66 7/30/2024 129 128
67 7/29/2024 130 129
68 7/26/2024 125,9 128
69 7/25/2024 124,2 125
70 7/24/2024 125,5 126
71 7/23/2024 124,9 125,5
72 7/22/2024 126 124,1
73 7/19/2024 128,6 126
74 7/18/2024 131,4 127,9
75 7/17/2024 134 131,9
76 7/16/2024 133,6 134
77 7/15/2024 133,5 132,7
78 7/12/2024 132,2 133,8
79 7/11/2024 134,1 133
80 7/10/2024 136 134
81 7/9/2024 139,1 137,5
82 7/8/2024 138,5 139,6
83 7/5/2024 136,1 138,7
84 7/4/2024 132,1 135,8
85 7/3/2024 130,5 131
86 7/2/2024 128,6 128
87 7/1/2024 130,4 128,6
88 6/28/2024 132,8 130,5
89 6/27/2024 131,3 132,8
90 6/26/2024 131 131,8
91 6/25/2024 131 130
92 6/24/2024 135 132,1
93 6/21/2024 133,9 136,1
94 6/20/2024 133 133,3
95 6/19/2024 128 131,5
96 6/18/2024 128,8 128
97 6/17/2024 131 128,8
98 6/14/2024 130,1 131
99 6/13/2024 133,7 130
100 6/12/2024 127,9 132
101 6/11/2024 144,3 146,5
102 6/10/2024 143,5 144
103 6/7/2024 141 142
104 6/6/2024 140,3 139,6
105 6/5/2024 140 140,1
106 6/4/2024 139 139,1
107 6/3/2024 135 136,9
108 5/31/2024 135 134,6
109 5/30/2024 133,8 135
110 5/29/2024 137,1 135,7
111 5/28/2024 134 137
112 5/27/2024 133 132,8
113 5/24/2024 138 131,9
114 5/23/2024 137,5 137,5
115 5/22/2024 137,9 138
116 5/21/2024 134 136
117 5/20/2024 135,2 133
118 5/17/2024 135,4 134,5
119 5/16/2024 135,6 135,4
120 5/15/2024 131,5 134,1
121 5/14/2024 130 130,5
122 5/13/2024 131,3 129,7
123 5/10/2024 131,3 131
124 5/9/2024 130,6 130,3
125 5/8/2024 130,1 131
126 5/7/2024 128 131,3
127 5/6/2024 126,5 127,6
128 5/3/2024 128,1 125,9
129 5/2/2024 123,8 127,3
hesis and construct a confidence interval for the difference in proportions of two populations

n1 129 X1 35
n2 129 X2 34

Z stat 0,145
Z critical 1,645
Critical value (-1,645;1,645)
Because -1,645<0,145<1,645 => -Z critical< Z stat< Z critical
So fail to reject H0

fident interval for π1-π2

-0.0826
0.098

th 95% confidence interval, the proportion of two population (FPT Stock Opening Price) will be between -0.0826 and 0.098
 P1 0.2713178295 Ṗ 0.26744186
P2 0.2635658915

26 and 0.098
 Highest price (x1000) Lowest price (x1000)
No Date
1 10/31/2024 136 135.3
2 10/30/2024 135.9 135.2
3 10/29/2024 135.5 134.8
4 10/28/2024 135 133.6
5 10/25/2024 134.6 133.6
6 10/24/2024 134.3 133.8
7 10/23/2024 134.8 132.6
8 10/22/2024 135.7 133
9 10/21/2024 137.7 135.5
10 10/18/2024 137.8 136.6
11 10/17/2024 137.1 135.5
12 10/16/2024 137.1 136
13 10/15/2024 138.6 136.6
14 10/14/2024 141.3 137.1
15 10/11/2024 142.8 139.6
16 10/10/2024 142 135.8
17 10/9/2024 135.8 134.3
18 10/8/2024 135.1 133.6
19 10/7/2024 134.9 133.6
20 10/4/2024 134.8 133.5
21 10/3/2024 136.1 134
22 10/2/2024 135.9 134.6
23 10/1/2024 136.2 134.7
24 9/30/2024 134.5 133
25 9/27/2024 134.4 133.5
26 9/26/2024 135 133.9
27 9/25/2024 134.8 133.6
28 9/24/2024 134.7 133.7
29 9/23/2024 135.9 133.4
30 9/20/2024 137 135
31 9/19/2024 135.8 134.3
32 9/18/2024 135.2 132.9
33 9/17/2024 132.9 131.2
34 9/16/2024 133 131.1
35 9/13/2024 133.4 132
36 9/12/2024 132.5 131
37 9/11/2024 131.3 129.8
38 9/10/2024 131 129.6
39 9/9/2024 131.9 130.1
40 9/6/2024 132.9 130.3
41 9/5/2024 133 129.7
42 9/4/2024 133 131.5
43 8/30/2024 134.9 133
44 8/29/2024 133.8 132.2
45 8/28/2024 134.5 132.9
46 8/27/2024 132.6 130.4
47 8/26/2024 133.5 131.5
48 8/23/2024 133.7 132.4
49 8/22/2024 134.5 133.5
50 8/21/2024 133.8 130.6
51 8/20/2024 132.5 130.7
52 8/19/2024 131.4 130
53 8/16/2024 131 129.1
54 8/15/2024 129.5 128.2
55 8/14/2024 131.5 129.5
56 8/13/2024 130.2 128
57 8/12/2024 130.2 126.2
58 8/9/2024 126.9 122
59 8/8/2024 122.4 120.9
60 8/7/2024 122 120.2
61 8/6/2024 121.9 119.8
62 8/5/2024 122.9 117.4
63 8/2/2024 124.8 121
64 8/1/2024 129.7 124.1
65 7/31/2024 128.6 126.6
66 7/30/2024 129.5 127
67 7/29/2024 130.6 129
68 7/26/2024 128 124.4
69 7/25/2024 125.5 124.1
70 7/24/2024 126.6 124
71 7/23/2024 127.5 124.8
72 7/22/2024 126 123.2
73 7/19/2024 129.3 126
74 7/18/2024 131.4 127.8
75 7/17/2024 134.1 129.9
76 7/16/2024 134.5 132.3
77 7/15/2024 134.8 132.3
78 7/12/2024 136 132.2
79 7/11/2024 135.4 132.5
80 7/10/2024 137 134
81 7/9/2024 139.3 136
82 7/8/2024 139.6 137.5
83 7/5/2024 139.7 136.1
84 7/4/2024 135.8 132.1
85 7/3/2024 132.8 130.1
86 7/2/2024 132.1 127.5
87 7/1/2024 130.4 128.5
88 6/28/2024 132.8 130.4
89 6/27/2024 134.1 130.8
90 6/26/2024 131.8 129.4
91 6/25/2024 131.1 128.6
92 6/24/2024 135.5 132
93 6/21/2024 136.1 133.3
94 6/20/2024 135.7 131.8
95 6/19/2024 132.8 126.6
96 6/18/2024 129.7 128
97 6/17/2024 131.4 128.5
98 6/14/2024 132.6 129
99 6/13/2024 133.8 130
100 6/12/2024 132.7 127.8
101 6/11/2024 146.5 143.1
102 6/10/2024 145 143
103 6/7/2024 142 140.5
104 6/6/2024 141.7 138.8
105 6/5/2024 144.9 139.7
106 6/4/2024 139.3 137.8
107 6/3/2024 137.6 134.7
108 5/31/2024 136.8 133.8
109 5/30/2024 135 131.9
110 5/29/2024 138.2 134.8
111 5/28/2024 137 133.1
112 5/27/2024 133.5 130.6
113 5/24/2024 138 130.6
114 5/23/2024 137.8 135
115 5/22/2024 139.7 136.1
116 5/21/2024 136 133.5
117 5/20/2024 136.1 133
118 5/17/2024 136 133.7
119 5/16/2024 137.3 134.2
120 5/15/2024 134.5 131.3
121 5/14/2024 131.7 129.6
122 5/13/2024 131.5 128.8
123 5/10/2024 132.2 129.2
124 5/9/2024 132.8 130
125 5/8/2024 131 129.3
126 5/7/2024 131.6 127.2
127 5/6/2024 127.6 124.5
128 5/3/2024 128.4 125.6
129 5/2/2024 129 123.5
7. F-test for the ratio of two variance

S₂ (Highest price) 19.34023 F-Test Two-Sample for Variances

S₁ (Lowest price) 20.59857
H₀: Ϭ²₁ ≤ Ϭ²₂ Lowest price (x1000)
H₁: Ϭ²₁ > Ϭ²₂ Mean 131.295
Variance 20.599
Observations 129
df 128
F 1.065
P(F<=f) one-tail 0.361
F Critical one-tail 1.339

F stat= 1.065
F critical = 1.339
Because F stat < F critical
So fail to reject H₀
Highest price (x1000)
133.866
19.340
129
128
 Opening price (x1000)
No Date Closing price (x1000)
1 10/31/2024 135.9 135.9
2 10/30/2024 135.4 135.9
3 10/29/2024 135.4 135.4
4 10/28/2024 134.1 134.9
5 10/25/2024 134.3 134
6 10/24/2024 134.2 134.3
7 10/23/2024 132.9 134.2
8 10/22/2024 135.7 133.1
9 10/21/2024 137 135.5
10 10/18/2024 137.4 137
11 10/17/2024 136.5 137
12 10/16/2024 136.4 136.3
13 10/15/2024 137.6 137
14 10/14/2024 141.1 137.6
15 10/11/2024 142 139.6
16 10/10/2024 135.8 141.7
17 10/9/2024 134.3 135.4
18 10/8/2024 134.1 133.8
19 10/7/2024 134.2 134.1
20 10/4/2024 134.3 134.1
21 10/3/2024 135.4 134
22 10/2/2024 134.6 135.4
23 10/1/2024 134.7 135.9
24 9/30/2024 134.2 134.5
25 9/27/2024 134.3 134.2
26 9/26/2024 135 134.3
27 9/25/2024 134.3 134.8
28 9/24/2024 134 134.5
29 9/23/2024 135.9 134
30 9/20/2024 136.3 135.3
31 9/19/2024 135 135.2
32 9/18/2024 133.4 134.6
33 9/17/2024 131.2 132.9
34 9/16/2024 131.8 131.1
35 9/13/2024 132.2 133
36 9/12/2024 131 132.3
37 9/11/2024 130 130.6
38 9/10/2024 131 130
39 9/9/2024 130.8 131.3
40 9/6/2024 130.5 132.1
41 9/5/2024 133 130.6
42 9/4/2024 133 133
43 8/30/2024 133.5 134.8
44 8/29/2024 132.8 133.7
45 8/28/2024 133 133.3
46 8/27/2024 131.5 132.5
47 8/26/2024 133.3 131.5
48 8/23/2024 133.7 133.1
49 8/22/2024 134 133.8
50 8/21/2024 130.6 133.5
51 8/20/2024 130.7 131.5
52 8/19/2024 131.1 130.5
53 8/16/2024 129.1 130.6
54 8/15/2024 129.1 128.7
55 8/14/2024 130.7 129.5
56 8/13/2024 129.7 129.7
57 8/12/2024 126.9 130
58 8/9/2024 122.4 126.9
59 8/8/2024 121.6 121.4
60 8/7/2024 121 122
61 8/6/2024 120 120.8
62 8/5/2024 121.1 118.6
63 8/2/2024 122.1 123.2
64 8/1/2024 129.6 124.8
65 7/31/2024 127.3 128.6
66 7/30/2024 129 128
67 7/29/2024 130 129
68 7/26/2024 125.9 128
69 7/25/2024 124.2 125
70 7/24/2024 125.5 126
71 7/23/2024 124.9 125.5
72 7/22/2024 126 124.1
73 7/19/2024 128.6 126
74 7/18/2024 131.4 127.9
75 7/17/2024 134 131.9
76 7/16/2024 133.6 134
77 7/15/2024 133.5 132.7
78 7/12/2024 132.2 133.8
79 7/11/2024 134.1 133
80 7/10/2024 136 134
81 7/9/2024 139.1 137.5
82 7/8/2024 138.5 139.6
83 7/5/2024 136.1 138.7
84 7/4/2024 132.1 135.8
85 7/3/2024 130.5 131
86 7/2/2024 128.6 128
87 7/1/2024 130.4 128.6
88 6/28/2024 132.8 130.5
89 6/27/2024 131.3 132.8
90 6/26/2024 131 131.8
91 6/25/2024 131 130
92 6/24/2024 135 132.1
93 6/21/2024 133.9 136.1
94 6/20/2024 133 133.3
95 6/19/2024 128 131.5
96 6/18/2024 128.8 128
97 6/17/2024 131 128.8
98 6/14/2024 130.1 131
99 6/13/2024 133.7 130
100 6/12/2024 127.9 132
101 6/11/2024 144.3 146.5
102 6/10/2024 143.5 144
103 6/7/2024 141 142
104 6/6/2024 140.3 139.6
105 6/5/2024 140 140.1
106 6/4/2024 139 139.1
107 6/3/2024 135 136.9
108 5/31/2024 135 134.6
109 5/30/2024 133.8 135
110 5/29/2024 137.1 135.7
111 5/28/2024 134 137
112 5/27/2024 133 132.8
113 5/24/2024 138 131.9
114 5/23/2024 137.5 137.5
115 5/22/2024 137.9 138
116 5/21/2024 134 136
117 5/20/2024 135.2 133
118 5/17/2024 135.4 134.5
119 5/16/2024 135.6 135.4
120 5/15/2024 131.5 134.1
121 5/14/2024 130 130.5
122 5/13/2024 131.3 129.7
123 5/10/2024 131.3 131
124 5/9/2024 130.6 130.3
125 5/8/2024 130.1 131
126 5/7/2024 128 131.3
127 5/6/2024 126.5 127.6
128 5/3/2024 128.1 125.9
129 5/2/2024 123.8 127.3
8. Regression analysis.
(a) Identify two random variables X and Y in your data (For example, X = height, Y = weigh

Price Stock

(b) Construct a scatter plot for the data. Do you observe a linear relationship?

Closing price (x1000)

150

145

140 f(x) = 0.915924713104431 x + 11.222304013155

R² = 0.842134527451687
135

130

125

120

115
115 120 125 130 135

I do see a linear relationship in the chart above. Because the higher the opening price, the higher the

(c) Find the equation of the estimated regression line, and use it to predict a future value
Ŷ= b₀ + b₁.X
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.917678880356133
R Square 0.842134527451686
Adjusted R Square 0.84089149223477
Standard Error 1.79853051162678
Observations 129

ANOVA
 df SS
Regression 1 2191.4605681
Residual 127 410.80842416
Total 128 2602.2689922

Coefficients Standard Error

Intercept 11.222304013155 4.6666349915
Opening price (x1000) 0.915924713104431 0.0351893105

Equation of the estimated regression line Ŷ= 11.222+ 0.915.X

If X=120=> y-predict= 10.605+0.919*120=120.885

(d) Test the significance of regression.

Test the significance of regression (α=0.05)
H0: βj=0 (no correlation)
H1: βj ≠ 0
P-value=0.017
α= 0.05
Because P-value < α => Reject H0
X = height, Y = weight).
X (independent): Opening price
Y (dependent): Closing price

ionship?

ng price (x1000)

304013155

0 135 140 145 150

g price, the higher the closing price.

edict a future value for Y.

 MS F Significance F
2191.4605681 677.4824 9.486324E-53
3.2347120013

t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
2.404795754 0.017624 1.9878755307 20.4567325 1.987875531 20.4567325
26.028492783 9.486E-53 0.8462914182 0.98555801 0.846291418 0.985558008
150
No Date Opening price (x1000) Closing price (x1000)
1 10/31/2024 135,9 135,9
2 10/30/2024 135,4 135,9
3 10/29/2024 135,4 135,4
4 10/28/2024 134,1 134,9
5 10/25/2024 134,3 134

6 10/24/2024 134,2 134,3

7 10/23/2024 132,9 134,2
8 10/22/2024 135,7 133,1
9 10/21/2024 137 135,5

10 10/18/2024 137,4 137

11 10/17/2024 136,5 137
12 10/16/2024 136,4 136,3
13 10/15/2024 137,6 137
14 10/14/2024 141,1 137,6
15 10/11/2024 142 139,6
16 10/10/2024 135,8 141,7
17 10/9/2024 134,3 135,4
18 10/8/2024 134,1 133,8
19 10/7/2024 134,2 134,1
20 10/4/2024 134,3 134,1
21 10/3/2024 135,4 134
22 10/2/2024 134,6 135,4
23 10/1/2024 134,7 135,9
24 9/30/2024 134,2 134,5
25 9/27/2024 134,3 134,2
26 9/26/2024 135 134,3
27 9/25/2024 134,3 134,8
28 9/24/2024 134 134,5
29 9/23/2024 135,9 134
30 9/20/2024 136,3 135,3
31 9/19/2024 135 135,2
32 9/18/2024 133,4 134,6
33 9/17/2024 131,2 132,9
34 9/16/2024 131,8 131,1
35 9/13/2024 132,2 133
36 9/12/2024 131 132,3
37 9/11/2024 130 130,6
38 9/10/2024 131 130
39 9/9/2024 130,8 131,3
40 9/6/2024 130,5 132,1
41 9/5/2024 133 130,6
42 9/4/2024 133 133
43 8/30/2024 133,5 134,8
44 8/29/2024 132,8 133,7
45 8/28/2024 133 133,3
46 8/27/2024 131,5 132,5
47 8/26/2024 133,3 131,5
48 8/23/2024 133,7 133,1
49 8/22/2024 134 133,8
50 8/21/2024 130,6 133,5
51 8/20/2024 130,7 131,5
52 8/19/2024 131,1 130,5
53 8/16/2024 129,1 130,6
54 8/15/2024 129,1 128,7
55 8/14/2024 130,7 129,5
56 8/13/2024 129,7 129,7
57 8/12/2024 126,9 130
58 8/9/2024 122,4 126,9
59 8/8/2024 121,6 121,4
60 8/7/2024 121 122
61 8/6/2024 120 120,8
62 8/5/2024 121,1 118,6
63 8/2/2024 122,1 123,2
64 8/1/2024 129,6 124,8
65 7/31/2024 127,3 128,6
66 7/30/2024 129 128
67 7/29/2024 130 129
68 7/26/2024 125,9 128
69 7/25/2024 124,2 125
70 7/24/2024 125,5 126
71 7/23/2024 124,9 125,5
72 7/22/2024 126 124,1
73 7/19/2024 128,6 126
74 7/18/2024 131,4 127,9
75 7/17/2024 134 131,9
76 7/16/2024 133,6 134
77 7/15/2024 133,5 132,7
78 7/12/2024 132,2 133,8
79 7/11/2024 134,1 133
80 7/10/2024 136 134
81 7/9/2024 139,1 137,5
82 7/8/2024 138,5 139,6
83 7/5/2024 136,1 138,7
84 7/4/2024 132,1 135,8
85 7/3/2024 130,5 131
86 7/2/2024 128,6 128
87 7/1/2024 130,4 128,6
88 6/28/2024 132,8 130,5
89 6/27/2024 131,3 132,8
90 6/26/2024 131 131,8
91 6/25/2024 131 130
92 6/24/2024 135 132,1
93 6/21/2024 133,9 136,1
94 6/20/2024 133 133,3
95 6/19/2024 128 131,5
96 6/18/2024 128,8 128
97 6/17/2024 131 128,8
98 6/14/2024 130,1 131
99 6/13/2024 133,7 130
100 6/12/2024 127,9 132
101 6/11/2024 144,3 146,5
102 6/10/2024 143,5 144
103 6/7/2024 141 142
104 6/6/2024 140,3 139,6
105 6/5/2024 140 140,1
106 6/4/2024 139 139,1
107 6/3/2024 135 136,9
108 5/31/2024 135 134,6
109 5/30/2024 133,8 135
110 5/29/2024 137,1 135,7
111 5/28/2024 134 137
112 5/27/2024 133 132,8
113 5/24/2024 138 131,9
114 5/23/2024 137,5 137,5
115 5/22/2024 137,9 138
116 5/21/2024 134 136
117 5/20/2024 135,2 133
118 5/17/2024 135,4 134,5
119 5/16/2024 135,6 135,4
120 5/15/2024 131,5 134,1
121 5/14/2024 130 130,5
122 5/13/2024 131,3 129,7
123 5/10/2024 131,3 131
124 5/9/2024 130,6 130,3
125 5/8/2024 130,1 131
126 5/7/2024 128 131,3
127 5/6/2024 126,5 127,6
128 5/3/2024 128,1 125,9
129 5/2/2024 123,8 127,3
6. Test a hypothesis and construct a confidence interval for the difference in proportions of two populations

H0: π1-π2 = 0 n1 129 X1

H1: π1-π2 ≠ 0 n2 129 X2

This is two-tailed test

Z stat -1,423
Z critical 1,645
Critical value (-1,645;1,645)
Because -1,645<-1,423<1,645 => -Z critical< Z
stat< Z critical

So fail to reject H0

A 95% confident interval for π1-π2

95% lower CI -0.0834
95% upper CI 0.0059

Conclusion with 95% confidence interval, the proportion of two population (FPT Stock Opening Price) will be between -0.0834
o populations

120 P1 0.93 Ṗ 0.95

125 P2 0.969

k Opening Price) will be between -0.0834 and 0.0059