Instruction

Nhập data vào ô màu vàng đậm

Note (vd: H0, H1, test direction...) (optional, KHÔNG ảnh hưởng tới kết quả)
Chỉnh range công thức ở ô tím

Xem kết quả ở ô màu trắng chữ đỏ hoặc chữ xanh

Lưu ý: KHÔNG chỉnh sửa

𝜎/s
𝜎^2 / s^2
std.dev standard deviation
var variance
n size
t/z test statistic
E error
CI confidence interval
correl correlation coefficient
Data Data n= 4
1 Mean= 2 1 Growth rate=
2 Median= 2 2
1 Mode= 1 3
2 Midrange= 2.5 4
4 Geom growth= 1.741101
Pop std 1.095445
Sam std 1.224745 Coeffiecient variation
Sam mean=
Sam std=
CV= #DIV/0!

Chebyshev( any population)

k=2 at least 75% within x (+/-) 2 std
k=3 at least 88.9% within x (+/-) 3 std
k=4 at least 93.8% within x (+/-) 4 std

Emperical (normal pop)

k=1 68% within 1 std
k=2 95% within 1 std
k=3 99% within 1 std

z score
x=
mean=
std= #NAME?
z score= #DIV/0!
 0.414214

Box plot
Data Quart 1 3
1 Quart 2 5
2 Quart 3 7
3 Max= 10
4 min= 1
5 midhinge= 5
within x (+/-) 2 std 6
% within x (+/-) 3 std 7
% within x (+/-) 4 std 8
10
0.385439
Expected value

Uniform distribution
a= x=
b=
PDF= 1 (X=x)
CDF= 1 (X<=x)
mean= 0
std= 0

Binomial distribution
n= 100 x= 29
pi= 0.2
mean= 20
std= 4
PDF= 0.008771
CDF= 0.988751 0.011249

Poisson distribution
pi= 4.7 x= 1
std= 2.167948
pdf= 0.042748 0.957252
cdf= 0.051843
Hypergeometric distribution
N= S=
n= s=
mean= #DIV/0!
std= #DIV/0!
PDF= 1
CDF= 1

approximate probability
mean= 20 x= 29.5
std= 4
PDF= 0.005943 If P(X=n) use P(n – 0.5 < X < n + 0.5)
CDF= 0.991226 If P(X ≤ n) use P(X < n + 0.5) 0.008774

n= 100
p= 0.2
q= 0.8
0
Uniform continuous dítribution
a= 30 x= 30
b= 100
PDF= 0.014286
CDF= 0
mean= 65
std= 20.20726

normal/ gaussian distribution

mean= 20 x= 29.5 percentage= 0.95
std= 4 norm.inv= 26.57941 (x=>percentage)
PDF= 0.005943
CDF= 0.991226 0.008774

standard normal distribution

mean= x=
std=
z= #DIV/0!
PDF= #DIV/0!
CDF= #DIV/0!

exponential distribution
lambda= 0.2 x= 30
PDF= 0.000496
CDF= 0.997521
mean=std= 5
Sample mean 𝜇 An estimator is a sample statistic (𝑥̅, 𝑠, 𝑝) that is used to estimate an unknown po
Sample proportion 𝜋
Sample std. deviation 𝜎 FPCF: √(𝑁−𝑛)/(𝑁−1) is the finite population correction factor (FPCF)
CLT

CI mean 𝜇
Unknown var/std.dev 𝜎
Known var/std.dev 𝜎

𝜎= 𝜎=
Normal distribution + Not normal n >= 30
5 if N/n < 20 5
size n = 25 N= 25 size n = 25 N=

𝛼= 𝛼=
mean x = 46 2 mean x = 46
2% 2%

z[𝛼/2] = 2.326347874 t[𝛼/2] = 2.492159473

error E = 2.326347874 E' = 0 error E = 2.492159473 E' =

CI = 43.673652126 CI' = 46 CI = 43.50784053 CI' =

48.326347874 46 48.49215947
CI are same if n LARGE

Sample size mean 𝜇

range = min = 51

est. std.dev 𝜎 2) uniform 𝜎 = 1.732051 3) norm 𝜎 = 6 ) poisson 𝜎 =

max = 87 λ=
0

𝛼=
z[𝛼/2] = 1.644854
sample size n = 10%

error E = 2

2) uniform 𝜎 = 3 3) norm 𝜎 = 25 ) poisson 𝜎 = 0

CI proportion Sample size proportion

condition: CLT: np >= 10 & n(1-p) >= 10
np = 0 n(1-p) = 25

𝛼=
p= if N/n < 20 p= 62.50%

𝛼= z[𝛼/2] = 2.575829304
size n = 25 N= 108 1%
5%

z[𝛼/2] = 1.9599639845
error E = 3%

error E = 0 E' = 0 sample size n = 1728

50
 CI = - CI' = -
- -

SAMPLE SIZE GIVEN 𝜎

est. std.dev 𝜎 2) uniform 𝜎 = 25 3) norm 𝜎 = 12

𝛼=
z[𝛼/2] = 1.080319
sample size n = 28%

error E = 3

2) uniform 𝜎 = 3) norm 𝜎 =
5
82 19

The standard error is σ/(n ) 1/2

σ=
n=
E= #DIV/0!
t is used to estimate an unknown population parameter ( 𝜇, 𝜎, 𝜋). /A desirable estimator is unbiased (correctly centered), efficient (minim

correction factor (FPCF) Instruction

Nhập data vào ô màu vàng đậm
Xem kết quả ở ô màu trắng chữ đỏ hoặc chữ xanh
Lưu ý: KHÔNG chỉnh sửa

nown var/std.dev 𝜎

Not normal n >= 30 Not normal n < 30

if N/n < 20 bootstrap estimation
25

46
46

roportion
tly centered), efficient (minimum variance), and consistent (variance goes to zero as n increases)./ Sampling error (the difference between

chữ đỏ hoặc chữ xanh

(the difference between an estimator and its parameter) is inevitable, but a larger sample size yields estimates that are closer to the unkn
tes that are closer to the unknown parameter.
 1 sample hypothesis test for mean known population var 𝜎 unknown population var (sample s)

Test mean 𝜇
for proportion

Known population variance Unknown population var

population 𝜎 =
any n n >= 30
10 sample s = 0.77
Rejection method Rejection method

population mean 𝜇0 = population mean 𝜇0 =

Step 1: State Step 1: State
100 56
H0: H0:
H1: H1:
direction: direction:

𝛼= 𝛼=
Step 2: Decision rule Step 2: Decision rule
0.05 5%
crit z0 = left-tailed -1.644853627 accept H0 reject z < z0 crit z0 = left-tailed -1.64485363 reject H0
right-tailed 1.644854 reject H0 reject z > z0 right-tailed 1.644854 accept H0
2-tailed 1.9599639845 reject H0 reject z < -crit, z > crit 2-tailed 1.95996398 reject H0

Step 3: Test statistic Step 3: Test statistic

Sample size n = 100 Sample size n = 444
mean x = 103 mean x = 55.82

z= 3 z = -4.92576

p-value approach p-value approach

p-value = left-tailed 0.998650102 accept H0 p-value = left-tailed 4.20165E-07 reject H0
right-tailed 0.001349898 reject H0 right-tailed 0.99999958 accept H0
2-tailed 0.00270 reject H0 2-tailed 2.00000 accept H0

z[𝛼/2] = 1.9599639845 z[𝛼/2] = 1.959964

CI approach (2-tailed only) CI approach (2-tailed only)

error E = 1.9599639845 error E = 0.071622

 CI = 101.04003602 2-tailed reject H0 CI = 55.74838 2-tailed reject H0
104.95996398 55.89162

Test proportion 𝜋 Instruction

condition: CLT: n Nhập data vào ô màu vàng đậm
n pi= 28.8 Xem kết quả ở ô màu trắng chữ đỏ hoặc chữ xanh

population mean 𝜋0 =
Step 1: State Lưu ý: KHÔNG chỉnh sửa
20.00%
H0:
H1:

𝛼=
Step 2: Decision rule

crit z0 = left-tailed #VALUE! #VALUE!

right-tailed #VALUE! #VALUE!
2-tailed #VALUE! #VALUE!

Step 3: Test statistic

Sample size n = 144
success x = 36
20
proportion p = 0.25
z= 1.5

p-value approach
p-value = left-tailed 0.9331927987 accept H0
right-tailed 0.0668072013 accept H0
2-tailed 1.86639 reject H0

0.0427162208
wn population variance
n < 30
sample s = 12
Rejection method

population mean 𝜇0 =
Step 1: State
60
H0:
H1:
direction:

𝛼=
Step 2: Decision rule
1.0%
crit t0 = left-tailed -2.821438 accept H0
right-tailed 2.821438 accept H0
2-tailed 3.249836 accept H0

Step 3: Test statistic

Sample size n = 10
mean x = 67

t = 1.844662

p-value approach
p-value = left-tailed 0.950909 accept H0
right-tailed 0.049091 accept H0
2-tailed 0.09818 accept H0

t[𝛼/2] = 3.249836
CI approach (2-tailed only)

error E = 12.33226
 CI = 54.66774 2-tailed accept H0
79.33226

chữ đỏ hoặc chữ xanh

 Compare 2 means independent known var 𝜎^2 paired
unknown var
equal
unequal
2 proportions independent paired
2 variances independent paired

Compare 2 m
Known variances
Equal
Rejection method Rejection method
Step 1: State Step 1: State
population mean diff D0 = 9 population mean diff D0 = 9
H0: H0:
H1: H1:
direction: direction:

𝛼= 𝛼=
Step 2: Decision rule Step 2: Decision rule
10.0% 5%
crit z0 = left-tailed -1.281552 reject H0 crit t0 = left-tailed
right-tailed 1.281552 accept H0 right-tailed
2-tailed 1.644854 reject H0 2-tailed

Step 3: Test statistic Step 3: Test statistic

𝜎1^2 = 𝜎2^2 =
Sample s1^2 = 14.9769
Population 5.4 n1 = 7
Sample n1 = 18 n2 = 18 x1 = 6.84
x1 = 13.4 x2 = 15.2 mean diff = 0.83
mean diff = -1.8 d.f = 12

𝜎p^2 =
z = -3.286335 pooled variance sp^2 = 12.10925
2.7 t = 0.446225

p-value approach p-value approach

p-value = left-tailed 0.000508 reject H0 p-value = left-tailed
right-tailed 0.999492 accept H0 right-tailed
2-tailed 1.99898 accept H0 2-tailed

CI (2-tailed) t[𝛼/2] = 2.178813

CI = -3.222701
4.882701

Compare 2 proportions Compare 2 var

Rejection method test for normality n.pi => 10 n(1-pi) =>10 data set
Step 1: State Step 1: State
 H0: p1 = p2 H0:
H1: p1 # p2 H1:
direction: two tailed direction:

𝛼= 𝛼=
Step 2: Decision rule Step 2: Decision rule
5%
crit z0 = left-tailed -1.644854 accept H0 crit F0 = 1-tailed left tailed
right-tailed 1.644854 reject H0
2-tailed 1.959964 accept H0
2-tailed FL =
Step 3: Test statistic
Fly Blue
x1 = 66 x2 = 54 Step 3: Test statistic
n1 = 100 n2 = 100 s1^2 =
p1 = 0.66 p2 = 0.54 n1 =
df1 =
pooled proportio pc = 0.6
test statistic z = 1.732051 F=

p-value approach p-value approach

p-value = left-tailed 0.958368 accept H0 p value = 1-tailed left-tailed
right-tailed 0.041632 reject H0
2-tailed 0.08326 accept H0

z[𝛼/2] = 1.959964
CI (2-tailed)

difference of pro CI = -0.014768 accept H0

0.254768

PAIRED DATA
d= 0.8285714285714
D=
s= 1.7547215217942
n= 7 d.f= 6
tcalc= 1.2493115951596
crit.val= 0.005 t(a/2)= -3.707428
left.tail= -3.707428021325 CI -1.6302779
right.tail= 3.7074280213248
2.tail= 4.3168271036334

1.9 0.8285714285714
0.8 1.7547215217942
3.4
-1.5
2.1
0
-0.9
 Instruction
Nhập data vào ô màu vàng đậm
Xem kết quả ở ô màu trắng chữ đỏ hoặc chữ xanh
Lưu ý: KHÔNG chỉnh sửa

Compare 2 means
Unknown variances
Equal Unequal
Rejection method
Step 1: State
population mean diff D0 =
H0:
H1:
direction:

𝛼=
Step 2: Decision rule
1%
-1.7822876 accept H0 n1, n2 >= 30 n1, n2 < 30
1.78228756 accept H0 crit z0 = left-tailed -2.32634787 accept H0 crit t0 = left-tailed
2.17881283 accept H0 right-tailed 2.326348 accept H0 right-tailed
2-tailed 2.575829304 accept H0 2-tailed

s2^2 = 9.2416 Step 3: Test statistic

n2 = 7 Sample s1^2 = 29.16 s2^2 = 68.89
x2 = 6.01 n1 = 5 n2 = 5
x1 = 4.9 x2 = 7.9
mean diff = -3
d.f = 4
z = t = -0.677458

p-value approach
0.6683 accept H0
0.3317 accept H0
0.66338 accept H0

CI (2-tailed) t[𝛼/2] = 5.840909

2-tailed accept H0 CI = -28.8654 2-tailed accept H0
22.8654

Compare 2 variances
data set
 F1 = F2
F1 # F2
2-tailed

0.9
t F0 = 1-tailed left tailed 1.83624 reject H0
right-tailed 0.56859 reject H0

2-tailed FL = 0.95569 reject H0

FR = 1.07126

0.7921 s2^2 = 0.4489

25 n2 = 18
24 df2 = 17

1.76454 F>1

lue = 1-tailed left-tailed Err:502 Err:502

right-tailed Err:502 Err:502
2-tailed = 0.23082 reject H0

difference cho t, tìm pvalue

3.2 t -1.81
2.2 n1 8
8.7 n2 12
7.7 p-value 0.043512124
9.4
3.287421 7.8
3.1
Sd = 3.04599659194
d= 6.01428571429
n1, n2 < 30
-3.746947 accept H0
3.746947 accept H0
4.604095 accept H0
Chap11
SS d MS F Fcrit P-value
Treatment SSB 126.00 1 126 34.615384615385 3.986269 1.4716E-07
Error SSE 240.00 66 3.64
Total SST 366.00 67
a= 0.05
Z
Chap12
Sample (Pearson) correlation coefficient
Raw data Orders ShipCost

H0:𝜌 = 0
X Y

H1: 𝜌 # 0 2-tailed
1 3 9
2 5 13
3 9 10
4 13 23 n= 36

𝛼=
5 15 35 df = 34
6 5%
7
8 correl r = 0.873608 range: edit range của công thức
9 crit r0 = left-tailed -0.2785166
10 right-tailed 0.27851658
11 2-tailed 0.32911104
12
13 t = 10.46785
14 crit t0 = left-tailed -1.6909243
15 right-tailed 1.69092426
2-tailed 2.03224451

fitted regession y = 530 +

intercept b0 = 1.038462 range: edit range của công thức
slope b1 = 1.884615

if x increase: 50 , y increase:

𝛼 t[𝛼/2] t[a/2] R.T

CI
Coefficient r Standard error s
Intercept b0 -0.1667 2.8912 2.5% 2.968687 2.44691185
Slope b1 1.8333 0.2307 5.0% 2.446912 1.94318028

n= 8 slope tcalc= 7.946684

intercept tcalc= -0.057658
Residual
y=
y hat=
ei= 0

FOR REGRESSION
 SS d MS F Fcrit P-value
Treatment SSR 744.00 4 186 3.7125748502994 3.055568 0.06909441
Error SSE 751.50 15 50.1
Total SST 1,495.50 19
a= 0.05
n= 8

high leverage= hi >1/n

quick interval= y predicted +- 2se

 Err:501 Công thức
→ SS d MS
→ Treatment SSB SSB (c dB (c-1) MSB = SSB / dB
→ Error SSE SSE dE (n-c) MSE = SSE / dE
→ Total SST SSB + SSE dB + dE
Instruction
Nhập data vào ô màu vàng đậm
Xem kết quả ở ô màu trắng
Lưu ý: KHÔNG chỉnh sửa
Chỉnh range công thức ô tím
Ví dụ: có 12 giá trị X và Y
nhìn vào table: X12 ở ô C23, Y12 ở ô
range công thức sẽ là:

có 7 giá trị X và Y
nhìn vào table: X7 ở ô C18, Y7 ở ô D1
range công thức sẽ là:

ange: edit range của công thức theo table x,y correl(x1:xn,y1:yn)
accept H0
reject H0
reject H0

accept H0
reject H0
reject H0

0.045 * Orders
ange: edit range của công thức theo table x,y intercept(x1:xn,y1:yn)

94.230769

t[a/2] L.T CI
-2.4469119 -8.749767 8.41636694122
-2.4469119 1.268797 2.39780256406
 R^2 Err:501 Công thức
0.4974925 → SS d
→ Treatment SSR SSR 1
→ Error SSE SSE n-2
0.05 → Total SST SSB + SSE n-1
 F Hartley's H = s2max/s2min Hartley df Tukey df
MSB / MSE df = (c, (n/c) - 1) df = (c, n - c)

page 161
chữ đỏ hoặc chữ xanh

theo table x,y

giá trị X và Y
vào table: X12 ở ô C23, Y12 ở ô D23
công thức sẽ là: (C12:C23,D12:D23)

vào table: X7 ở ô C18, Y7 ở ô D18

công thức sẽ là: (C12:C18,D12:D18)
 MS F R^2
MSR = SSR / 1 MSR / MSE SSR/SST
MSE = SSE / (n-2)
X Y
3 9
5 13 1.884615 1.038462
9 10
13 23
15 35

Chart Title
40

35
f(x) = 0.306122448979591 x² − 3.62558869701726
30 R² = 0.945346860931277

25

20

15

10

0
2 4 6 8 10
 Chart Title

48979591 x² − 3.62558869701726 x + 19.4670329670329

0931277

6 8 10 12 14 16