DataRange

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE
1
2							Issue 1: Numbers are not accurate, seems to only calculate first column
3							Issue 2: It will not calculate first column if at least the second is not filled
4	IQR might need to be spliced within the transpose function						Issue 2a: It works from column 1, forward, if the range is the larger
5	IQR Will not work if spliced*
6	Worked if I spliced the formula for each column					Attempted to Join Ranges together {C18:C, D...}					works when at least 2 rows are filled					Works when the range is specific to column only					does not work with only 1 part of the data set filled
7	Data Set 1										Data Set 1					Data Set 1					Data Set 1					Data Set 1
8	Average		17004.08			Average		17004.08			Average		17004.08			Average		17004.08			Average		17004.08			Average		17004.08
9	Median		18000			Median		14200			Median		14200			Median		18000			Median		#NUM!			Median		#NUM!
10	Mode		18000			Mode		14200			Mode		14200			Mode		18000			Mode		#N/A			Mode		#N/A
11	Max		18,000			Max		18,000			Max		18,000			Max		18,000			Max		18,000			Max		18,000
12	Min		14,200			Min		14,200			Min		14,200			Min		14,200			Min		14,200			Min		14,200
13	IQR		#N/A			IQR		0			IQR		1300			IQR		1701			IQR		#NUM!			IQR		#NUM!
14	Mean Deviation		1305.804			Mean Deviation		371.458			Mean Deviation		886.944			Mean Deviation		1305.804			Mean Deviation		#DIV/0!			Mean Deviation		#DIV/0!
15	Standard Deviation		1549.820			Standard Deviation		530.658			Standard Deviation		1057.679			Standard Deviation		1549.820			Standard Deviation		#DIV/0!			Standard Deviation		#DIV/0!
16	Data Set 1					Data Set 1					Data Set 1					Data Set 1					Data Set 1					Data Set 1
17	1	2	3	4	5	1	2	3	4	5	1	2	3	4	5	1	2	3	4	5	1	2	3	4	5	1	2	3	4	5
18	14200 (20)	17,450	16,399			14200 (20)	17,450	16,399			14200 (20)	17,450				14200 (20)					14200 (20)					14200 (20)				17,450
19	15,000	17,500	16,900			15,000	17,500	16,900			15,000	17,500				15,000					15,000					15,000				17,500
20	15,500	17,500	17,000			15,500	17,500	17,000			15,500	17,500				15,500					15,500					15,500				17,500
21	15,650	17,500	17,000			15,650	17,500	17,000			15,650	17,500				15,650					15,650					15,650				17,500
22	15,999	17,995	17,000			15,999	17,995	17,000			15,999	17,995				15,999					15,999					15,999				17,995
23		17,999	17,000				17,999	17,000			16,399	17,999				16,399					16,399					16,399				17,999
24		18,000	17,000				18,000	17,000			16,900	18,000				16,900					16,900					16,900				18,000
25		18,000					18,000				17,000	18,000				17,000					17,000					17,000				18,000
26		18,000					18,000				17,000	18,000				17,000					17,000					17,000				18,000
27		18,000					18,000				17,000	18,000				17,000					17,000					17,000				18,000
28		18000 (55)					18000 (55)				17,000					17,000					17,000					17,000				18000 (55)
29											17,000					17,000					17,000					17,000
30											18000 (55)					17,450					17,450
31																17,500					17,500
32																17,500					17,500
33																17,500					17,500
34																17,995					17,995
35																17,999					17,999
36																18,000					18,000
37																18,000					18,000
38																18,000					18,000
39																18,000					18,000
40																18000 (55)					18000 (55)
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