Magic.xlsx

	A	B	C	D	E	F	G	H	I	J	K	M	N	O	P	Q	R
1	Magic #													8	-	1	$28,208
2	Prod	Week	Date	Slot	Prizes							Magic #		W		L	Winnings
3	1195	2	Oct. 1	3	Sanford Art Supplies						$712	$748		1			$2,708
4					Chromcraft Dinette						$1,996
5	1223	5	Oct. 20	6	La-Z-Boy Reclining Sofa						$949	$1,790		1			$3,144
6					Aqua Finn Daysailer						$2,195
7	1251	8	Nov. 8	3	Corsican Cradle						$1,555	$1,600		1			$4,154
8					RCA 56" Television						$2,599
9	1281	11	Nov. 29	3	Daybed						N/A	N/A		1			$3,684
10					Day Sailer						N/A
11	1332	16	Jan. 18	6	Rustic Crafts Fireplace						$1,175	$2,257		1			$3,670
12					Golden West Pool Table						$2,495
13	1392	22	Mar. 7	3	La-Z-Boy Reclining Sofa						$949	$929	X			1	$0
14					Ridgeway Grandfather Clock						$1,991
15	1431	26	May 1	3	Broyhill Sofa						$1,209	$1,340		1			$3,859
16					Trip to Victoria, Canada						$2,650
17	1464	29	May 25	2	2 ZapWorld Scooters						$1,248	$1,572		1			$3,588
18					Broyhill Bed & Select Comfort Mattress						$2,340
19	1504	33	Sep. 21*	2	Broyhill Sofa						$1,102	$1,359		1			$3,401
20					Life Fitness Treadmill						$2,299
21
22
23	Statistics:
24
25	Set magic # too low:					1
26	Set magic # too high:					0
27
28	Furthest from the range in a loss:					$20	too low (Mar. 7)
29	Closest to the range in a loss:					$20	too low (Mar. 7)
30
31	Largest spread between prizes:					$1,441	(May 1)
32	Smallest spread between prizes:					$1,042	(Mar. 7)
33
34	$0-$1,000 spread between prizes:					0	(	0	-	0	)
35	$1,001-$1,250 spread between prizes:					5	(	4	-	1	)
36	$1,251-$1,500 spread between prizes:					3	(	3	-	0	)
37	Unknown:					1	(	1	-	0	)
38
39	Highest magic # set by the contestant:					$2,257	(Jan. 18)
40	Lowest magic # set by the contestant:					$748	(Oct. 1)
41
42	Most expensive first prize:					$1,555	(Corsican Cradle - Nov. 8)
43	Most expensive second prize:					$2,650	(Trip to Victoria - May 1)
44
45	Least expensive first prize:					$712	(Sanford Art Supplies - Oct. 1)
46	Least expensive second prize:					$1,991	(Ridgway Grandfather Clock - Mar. 7)
47
48	Most expensive prize package:					$4,154	(Nov. 8)
49	Least expensive prize package:					$2,708	(Oct. 1)
50
51	Longest winning streak:					Won 5
52	Longest losing streak:					Lost 1
53
54	Frequency:
55
56	1	0
57	2	2
58	3	5
59	4	0
60	5	0
61	6	2
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