Magic.xlsx

	A	B	C	D	E	F	G	H	I	J	K	M	N	O	P	Q	R
1	Magic #													4	-	4	$12,952
2	Prod	Week	Date	Slot	Prizes							Magic #		W		L	Winnings
3	0833	2	Sep. 30	4	Alan White Sofa						$799	$1,130		1			$2,534
4					Howard Miller Grandfather Clock						$1,735
5	0893	8	Nov. 11	3	Chromcraft Dinette						$1,716	$1,160	X			1	$0
6					Water Ventures Water Trike						$2,950
7	0902	9	Nov. 17	3	Tuff Stuff Home Gym						$1,699	$2,470		1			$4,306
8					Pulaski Clothing Armoire						$2,607
9	0985	17	Jan. 22	3	James Industries Foosball Table						$1,395	$1,302	X			1	$0
10					Bed & Loving Care Mattress						$2,620
11	1021	21	Feb. 15	2	Largo Daybed & Loving Care Mattress						$638	$700		1			$2,613
12					Olhausen Pool Table						$1,975
13	1052	24	Mar. 16	5	Ashley Dinette						$999	$1,492		1			$3,499
14					Howard Miller Grandfather Clock						$2,500
15	1093	28	Apr. 21	3	Little Miss Liberty of Beverly Hills Crib						$1,576	$1,148	X			1	$0
16					Royal Products Wine Closet						$2,800
17	1142	33	May 25	3	Hooker Executive Desk						$1,770	$1,401	X			1	$0
18					Water Ventures Water Trike						$2,950
19
20
21	Statistics:
22
23	Set magic # too low:					4
24	Set magic # too high:					0
25
26	Furthest from the range in a loss:					$556	too low (Nov. 11)
27	Closest to the range in a loss:					$93	too low (Jan. 22)
28
29	Largest spread between prizes:					$1,501	(Mar. 16)
30	Smallest spread between prizes:					$908	(Nov. 17)
31
32	$0-$1,000 spread between prizes:					2	(	2	-	0	)
33	$1,001-$1,250 spread between prizes:					4	(	0	-	4	)
34	$1,251-$1,500 spread between prizes:					1	(	1	-	0	)
35	$1,500+ spread between prizes:					1	(	1	-	0	)
36
37	Highest magic # set by the contestant:					$2,470	(Nov. 17)
38	Lowest magic # set by the contestant:					$700	(Feb. 15)
39
40	Least expensive first prize:					$638	(Largo Daybed - Feb. 15)
41	Most expensive first prize:					$1,770	(Hooker Desk - May 25)
42
43	Least expensive second prize:					$1,735	(Howard Miller Grandfather Clock - Sep. 30)
44	Most expensive second prize:					$2,950	(Water Ventures Water Trike - Nov. 11 / May 25)
45
46	Least expensive prize package:					$2,534	(Sep. 30)
47	Most expensive prize package:					$4,720	(May 25)
48
49	Longest winning streak:					Won 2
50	Longest losing streak:					Lost 2
51
52	Frequency:
53
54	1	0
55	2	1
56	3	5
57	4	1
58	5	1
59	6	0
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