t F Beta distribution (plus) kkk.xlsx

	A	B	C	D	E	F	G	H	I	J
1								compute area by ...
2	alpha	df	t	t^2	F	Beta		By t dist	By F dist	By Beta dist
3	0.05	7.1234	1.89457861	3.589428091	3.589428091	3.570786473	left area	0.95	0.95	0.9503630437
4							rigth area	0.05	0.05	0.04963695632
5	alpha	df1	df2	F		Beta
6	0.05	2	3	9.552094496	0.8642791192	0.8642791192	T-Distribution Probability Calculator - MathCracker.com
7							Student's t-Distribution Applet/Calculator (uiowa.edu)
8	alpha	df1	df2	Beta		F	Probability - GeoGebra
9	0.05	2	3	0.7513953743	4.53367695	4.53367695	F-distribution - Wikipedia
10							Run R code online (rdrr.io)
11
12
13	alpha	df	cumulative prob.	probability	degrees_freedom	t by t.inv	***cal. by cumulative prob
14	0.05	7	0.95	0.95	7	1.894578605	Calculates the negative inverse of the one-tailed TDIST function. (Lower tailed)
15
16						t by tinv	***cal. by alpha (2-tailed. ex. prob.=0.05 -> cal. t for 0.025 , prob.=0.10 -> cal. t for 0.05
17				0.1	7	1.894578605	Calculates the inverse of the two-tailed TDIST function.
18						TRUE
19
20	alpha	df1	df2	cumulative prob.	probability	degrees_freedom 1	degrees_freedom 2	F by F.inv	sqrt(F)
21	0.05	1	7	0.95	0.9	1	7	3.589428091	1.894578605
22								Calculates the inverse of the left-tailed F probability distribution.
23								F by Finv	sqrt(F)
24					0.1	1	7	3.589428091	1.894578605
25								Calculates the inverse of the right-tailed F probability distribution.
26								TRUE
27
28		F	df1	df2	F dist	F dist by Beta dist
29		0.7	1	6	0.4348335898	0.4348335898	-1.11E-16
30						1-BETADIST(Fdf1/df2/(1+Fdf1/df2),df1/2,df2/2)
31
32		t	df	t dist	t dist by beta
33		2.6	0.5	#NUM!	0.1967594805
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