9.2 10.2 10.3 11.2 Paper aircraft flight distances analysis edu

	A	B	C	D	E	F	G	H	I
1	Flight distance	https://www.desmos.com/calculator/zrfouaktz2	Flight distance	Formula Text	Numeric calculation		Distances	Data normalized	Sampling distribution of means
2	0	Pre-existing expected/predicted population mean μ	556	centimeters			166	0.00054	0.00000
3	40	sample size n	18	=count(A:A)			332	0.00067	0.00025
4	65	sample mean ̅x	607	=average(A:A)			498	0.00076	0.00220
5	100	sample standard deviation sx	514	=stdev(A:A)			664	0.00077	0.00295
6	200	point estimate for the population mean µ	607	=C4			830	0.00071	0.00060
7	427	standard error of the mean SE	121	=C5/sqrt(C3)	=514/sqrt(18)		996	0.00058	0.00002
8	470	t-critical for alpha 5％ (the tail area!)	2.110	=tinv(0.05,C3-1)	=tinv(0.05,18-1)	NEVER EVER USE 1-0.95!	1162	0.00043	0.00000
9	450	lower bound for the population mean ̅x-tc × sx/√n	351	=C4-C8*C7	=607-2.11*121		1328	0.00029	0.00000
10	480	upper bound for the population mean ̅x+tc × sx/√n	862	=C4+C8*C7	=607+2.11*121		1494	0.00017	0.00000
11	260						1660	0.00009	0.00000
12	565	There is a 95% probability that the population mean is between:	p(351 ≤ μ ≤ 862) = 0.95
13	594	Predicted population mean preflight:	556		351
14	790	Does the confidence interval include the population mean µ?	yes		862
15	950
16	1010	\|t-statistic\|	0.418
17	1218	Is \|t-statistic\| > t-critical?	no
18	1640	Reject or fail to reject?	fail to reject
19	1660	Sample mean significantly different from μ?	no
20		Could the μ for this sample be 556?	yes
21
22		p-value	0.681
23
24
25			Flight distance
26		Sample lower bound for the pop mean	351
27		Expected/predicted pop mean	556
28		Expected/predicted pop mean	556
29		Sample upper bound for the pop mean	862
30
31		New population mean μ post-flight	556.61
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100