senior advanced writer

profilemkraarikamghorzt
brewers_ticket_sim_410.xlsx-2.xls
Home>Business & Finance homework help>Financial markets homework help>senior advanced writer

Sheet1

Milwaukee Brewers Estimated Single-Game Average Ticket Prices (USD), 2005 - 2014 Ln(Returns) Volatility
YEAR YEAR Realized Volatility Realized Percent Vol.
GAME 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 1 YR
1 63.34 65.83 71.02 88.83 56.58 81.91 69.41 77.76 62.93 61.89 5 YR
2 55.69 56.14 58.73 51.86 48.21 50.67 46.49 58.56 59.07 54.65 10 YR
3 58.91 52.35 57.65 50.42 39.07 54.46 45.27 62.10 60.78 52.69
4 63.14 53.11 64.70 51.17 43.92 57.53 42.88 61.89 63.30 45.23
5 63.21 62.17 59.58 62.37 43.71 62.79 39.12 62.94 51.94 47.66
6 61.96 66.46 56.57 74.71 48.16 59.40 40.84 59.56 51.19 50.12
7 65.47 72.42 63.51 66.27 52.27 64.64 41.00 55.20 51.30 47.48
8 76.57 87.17 71.24 63.60 46.81 65.62 40.12 53.38 47.53 49.66
9 82.44 96.03 64.96 69.03 45.10 65.39 38.25 58.13 47.46 43.94
10 83.08 99.37 66.15 56.75 41.88 74.93 43.79 56.96 45.02 39.29
11 79.01 116.11 73.82 62.85 42.55 84.23 48.23 54.78 48.41 35.41
12 82.45 107.12 82.32 61.18 46.84 67.95 47.47 50.19 46.06 35.10
13 79.05 100.89 73.26 68.58 47.09 70.07 47.84 45.32 51.25 33.53
14 80.71 118.46 83.50 63.42 38.60 64.98 54.10 45.42 51.09 39.06
15 86.16 123.15 88.30 58.41 42.72 63.34 62.47 49.51 55.05 38.84
16 93.06 122.77 90.07 70.08 42.75 59.91 68.43 54.79 65.91 40.74
17 97.81 127.67 88.36 73.66 41.08 68.32 66.55 57.45 66.32 42.77
18 109.46 124.83 81.06 71.73 33.67 75.65 63.24 55.96 74.88 44.16
19 126.95 121.75 81.76 65.39 34.77 79.30 67.36 54.21 68.01 44.91
20 106.28 117.76 80.00 71.63 35.52 84.14 62.39 55.95 78.71 49.74
21 90.06 112.20 95.94 73.78 36.57 87.50 56.67 60.49 70.56 44.78
22 82.96 103.15 97.56 59.44 33.19 92.69 54.96 65.59 70.20 51.11
23 68.73 102.66 96.15 54.85 31.13 94.74 59.51 53.66 68.26 54.15
24 66.66 97.64 96.08 68.89 28.69 93.33 60.36 53.47 61.54 48.82
25 64.76 109.80 91.06 68.86 33.11 97.46 61.66 49.05 54.65 53.51
26 66.19 112.08 107.35 57.04 30.79 94.91 67.66 47.08 57.71 58.98
27 67.85 121.99 113.28 52.71 30.29 91.73 69.06 54.14 50.84 67.68
28 63.88 120.58 114.07 50.83 27.98 89.65 62.33 50.54 45.00 65.27
29 59.44 119.80 125.15 53.90 30.19 89.01 66.88 43.24 49.39 74.51
30 63.52 132.83 124.86 53.17 30.17 89.12 69.65 43.92 49.43 76.23
31 61.47 149.68 123.87 53.66 30.37 108.58 69.15 43.47 51.06 66.67
32 54.24 150.18 118.00 53.60 32.84 97.20 66.73 41.94 47.13 62.25
33 54.32 172.13 111.81 49.20 34.77 88.28 63.64 45.14 46.35 67.26
34 55.30 179.26 127.30 54.19 37.14 90.20 63.54 47.36 47.60 77.67
35 53.37 185.04 135.78 52.51 30.34 89.85 59.19 48.91 48.31 69.80
36 56.44 220.04 136.87 50.44 30.93 84.25 56.61 47.77 55.77 69.17
37 57.57 249.23 157.01 51.31 33.52 86.66 49.39 49.23 52.80 65.29
38 56.54 268.81 157.41 51.04 34.54 92.32 47.21 48.02 52.15 75.89
39 56.36 278.25 161.41 48.78 37.24 83.20 44.42 48.82 55.91 70.07
40 58.61 265.50 141.77 49.34 44.06 80.32 46.65 51.26 60.50 78.13
41 56.41 262.99 147.64 58.33 48.82 71.46 52.52 52.79 50.25 73.97
42 51.32 304.36 129.32 61.08 44.12 72.00 57.22 49.76 48.58 78.95
43 50.65 251.56 118.38 57.67 40.99 73.06 62.40 47.48 45.77 69.99
44 51.24 237.89 128.12 53.38 40.58 77.38 66.07 43.25 45.73 79.07
45 53.51 234.15 132.05 52.31 38.36 70.19 69.21 46.99 47.78 64.12
46 53.40 237.25 122.20 45.24 38.11 72.02 73.71 46.91 49.64 65.93
47 51.33 200.94 118.08 52.37 42.16 71.17 69.12 44.28 54.54 68.35
48 53.99 210.19 120.74 53.32 40.25 79.73 74.11 46.88 56.66 63.55
49 53.48 223.49 123.09 48.00 39.28 81.87 66.50 44.84 58.23 58.30
50 57.23 205.52 105.02 48.53 38.53 78.13 70.07 46.59 63.00 61.39
51 56.81 201.04 94.17 42.52 40.79 76.62 65.09 52.69 65.35 55.94
52 56.81 180.14 79.85 44.67 44.45 73.13 59.68 56.97 57.93 55.83
53 56.39 205.41 79.39 44.00 43.90 82.22 57.38 56.21 58.51 42.31
54 51.94 212.12 67.67 44.18 42.72 78.64 50.98 55.69 50.21 34.75
55 47.83 207.64 71.79 45.58 46.18 67.81 51.07 65.00 55.03 34.64
56 43.89 191.21 65.61 48.95 49.07 66.66 55.98 64.08 45.07 37.99
57 50.66 192.92 59.40 45.56 51.16 73.26 54.81 65.77 42.96 32.61
58 49.81 220.99 68.58 39.83 65.57 77.48 57.17 67.65 43.33 34.53
59 53.87 226.33 81.38 39.49 65.78 78.61 58.00 73.07 43.21 36.02
60 55.51 233.32 75.68 36.72 67.74 90.73 64.07 74.46 50.24 34.21
61 64.42 209.33 75.48 38.08 67.29 86.18 63.23 76.84 50.50 34.16
62 69.59 212.43 88.26 32.02 70.89 88.15 64.86 79.01 47.86 40.62
63 62.28 226.73 84.20 34.40 67.72 81.58 78.67 97.33 50.30 35.74
64 60.56 199.88 96.69 35.32 73.63 76.08 86.47 104.72 45.10 37.24
65 65.23 219.39 103.56 31.96 85.26 73.87 79.56 96.87 47.24 37.92
66 66.88 266.05 104.11 31.10 85.93 78.02 87.27 86.77 48.28 38.99
67 79.96 230.51 101.00 33.36 85.47 91.85 80.37 74.75 46.68 38.99
68 79.67 189.62 115.76 40.35 81.36 98.21 80.48 86.63 44.20 39.95
69 69.06 188.53 122.90 39.15 78.09 89.21 82.52 80.57 39.69 39.11
70 71.74 200.94 116.27 43.82 66.68 87.68 88.74 87.49 33.29 33.43
71 66.14 199.63 120.26 40.60 66.40 83.54 85.75 91.55 32.10 31.76
72 66.46 197.01 111.23 41.34 61.40 81.47 89.76 79.56 34.26 32.42
73 72.66 197.21 112.71 40.62 68.06 89.79 103.48 93.45 32.17 33.16
74 74.62 179.24 127.63 41.83 69.01 92.75 86.56 97.94 36.57 34.90
75 76.58 153.97 133.53 40.06 69.37 100.71 78.58 113.33 33.80 41.59
76 75.32 175.00 124.87 35.18 77.75 105.99 86.70 116.73 40.04 35.69
77 74.41 179.50 128.67 34.38 65.91 98.81 84.55 118.59 37.67 37.79
78 73.78 161.24 121.01 35.70 67.81 106.78 84.31 108.25 38.02 38.25
79 56.05 176.25 142.10 34.16 61.67 94.42 91.06 108.65 42.73 38.15
80 57.97 156.66 120.23 33.63 58.29 100.96 108.53 109.99 47.29 35.89
81 62.94 155.09 113.46 34.81 59.61 106.22 96.42 95.64 44.23 35.52
82 55.94 165.06 121.05 36.45 64.22 116.34 88.92 95.54 47.06 37.61
83 48.64 153.19 112.57 34.16 59.63 102.18 88.37 96.93 42.57 39.01
84 51.27 148.66 112.80 33.39 62.49 100.44 88.42 90.96 36.34 33.64
85 44.64 149.11 119.21 35.91 70.37 100.64 89.28 94.22 38.43 36.28
86 38.21 174.24 132.17 36.95 65.22 101.56 86.92 84.43 32.72 37.08
87 40.82 181.21 121.69 32.68 59.69 109.27 96.09 80.30 26.72 43.14
88 38.54 175.08 119.97 37.05 59.66 115.92 88.61 81.07 26.59 39.03
89 42.69 171.77 115.16 35.10 62.90 122.48 90.21 76.89 29.78 36.62
90 37.97 167.71 114.08 33.01 62.94 124.42 97.94 79.72 32.91 31.12
91 35.98 186.65 117.77 28.98 58.55 142.43 101.15 77.27 28.70 31.14
92 36.74 182.18 111.55 28.72 59.16 138.52 95.79 71.49 28.80 33.83
93 38.50 169.85 119.29 28.48 60.25 139.79 96.83 77.26 30.81 32.45
94 40.07 173.45 123.73 27.71 57.97 132.92 94.23 81.29 33.40 31.02
95 40.75 172.13 118.76 25.72 52.41 132.28 89.42 85.33 37.91 30.24
96 39.96 183.96 121.64 22.05 54.40 140.61 99.87 90.40 43.10 29.84
97 37.99 199.24 132.01 27.78 54.50 125.83 98.22 98.30 46.30 32.48
98 39.58 217.98 143.35 31.39 52.83 127.95 93.39 106.73 40.65 32.55
99 38.28 230.23 151.67 30.43 49.98 119.93 87.36 107.09 40.80 31.21
100 39.69 242.88 150.90 30.15 47.86 128.12 88.31 102.99 35.98 32.93
101 43.42 282.79 142.92 31.09 44.31 106.51 76.98 102.06 39.81 29.08
102 35.04 254.69 145.74 31.07 40.36 88.64 66.12 112.99 45.80 30.59
103 40.50 247.21 139.97 29.56 44.78 101.07 67.25 101.40 37.94 30.06
104 38.31 211.26 136.04 31.96 43.87 99.82 59.81 96.52 40.68 35.61
105 42.67 228.09 146.93 28.84 37.36 82.96 57.79 105.23 39.50 33.64
106 48.39 228.62 165.30 33.71 35.81 70.96 61.67 112.95 37.90 34.88
107 42.30 222.84 173.86 28.61 39.10 70.47 66.59 108.19 35.02 35.26
108 42.96 189.95 204.67 27.83 37.31 72.37 75.48 106.32 38.84 31.99
109 55.80 193.04 177.84 29.94 43.03 74.51 68.96 104.94 40.14 34.42
110 54.80 188.82 178.27 30.25 40.17 81.38 74.08 102.51 39.75 27.84
111 57.12 166.90 179.82 26.36 37.58 83.76 76.19 81.00 41.20 23.19
112 58.78 150.35 204.90 28.46 34.26 83.27 84.44 78.06 44.81 20.59
113 65.22 140.57 213.84 28.87 37.71 90.82 86.08 80.18 41.48 22.91
114 71.37 137.61 207.98 26.86 35.85 106.96 92.16 97.14 38.66 24.87
115 65.59 118.15 218.01 27.81 37.15 107.26 101.25 84.96 40.97 22.20
116 63.15 116.36 230.17 29.63 31.90 105.09 97.71 80.35 46.58 21.87
117 65.05 122.58 233.90 35.22 30.34 114.53 93.88 77.72 51.62 20.48
118 64.75 118.67 193.20 34.95 32.08 109.59 83.19 71.46 51.13 20.90
119 78.91 111.60 210.31 34.08 28.56 95.65 82.60 67.35 45.30 24.69
120 81.93 114.57 147.21 32.62 28.70 94.83 85.17 56.23 36.18 22.84
121 85.05 125.49 148.67 27.23 30.07 96.87 79.76 55.71 33.32 26.68
122 78.96 120.72 128.90 28.46 34.68 98.14 80.30 53.25 36.57 25.63
123 70.12 115.93 125.02 23.44 36.61 88.74 77.87 55.73 34.86 24.20
124 74.94 101.67 140.13 22.91 39.61 84.23 75.02 56.04 35.73 25.48
125 73.71 93.16 134.01 22.38 38.43 79.34 80.09 61.20 36.40 27.05
126 77.86 98.06 156.19 24.02 36.53 85.90 85.75 69.77 29.52 27.72
127 72.33 97.15 166.73 18.30 36.73 84.98 94.27 70.54 32.71 24.23
128 77.94 103.59 163.27 19.76 33.92 89.77 85.52 63.06 38.43 22.80
129 65.82 109.62 150.66 18.88 37.21 94.44 84.56 64.41 38.32 21.11
130 74.72 113.22 144.30 16.79 39.72 92.92 89.37 72.20 41.63 20.19
131 80.20 120.74 149.02 16.79 43.03 77.13 79.46 71.64 38.94 18.84
132 81.00 136.64 118.69 17.13 47.72 79.57 92.68 74.06 40.96 19.54
133 72.95 143.49 125.03 16.52 47.30 84.43 94.58 67.94 48.46 21.25
134 70.49 148.82 128.10 14.44 44.97 79.01 90.19 76.80 53.96 20.80
135 72.07 148.34 137.19 15.94 47.03 78.93 98.26 79.51 50.73 21.80
136 79.59 132.55 161.44 16.22 51.71 75.97 101.49 76.66 46.30 23.24
137 72.55 126.86 157.02 15.24 55.56 87.13 102.50 65.65 46.54 23.52
138 80.68 130.48 143.85 16.84 60.11 86.94 96.55 61.80 45.61 22.98
139 99.94 118.06 158.52 17.38 67.93 88.51 81.93 56.36 45.39 21.91
140 95.73 122.88 170.81 15.50 69.69 80.57 75.17 54.00 50.38 19.73
141 99.64 126.35 168.79 16.33 76.95 75.51 71.03 55.64 51.36 19.28
142 94.05 127.50 160.25 13.82 76.91 66.74 73.83 59.64 58.74 19.55
143 80.20 130.87 163.76 12.57 82.17 70.95 77.78 60.47 58.55 19.25
144 90.39 131.21 147.92 12.74 72.28 74.70 72.56 60.93 57.91 19.62
145 95.83 131.02 148.83 13.19 81.91 69.41 77.76 62.93 61.89 19.71
146 91.67 130.99 140.74 13.28 69.44 86.69 82.27 77.33 64.19 20.85
147 92.61 141.53 130.88 11.08 70.70 93.59 81.42 79.58 63.07 19.73
148 90.82 140.50 141.85 11.86 68.63 96.91 74.80 80.59 54.48 19.54
149 79.44 108.63 142.29 13.16 61.82 112.94 80.58 91.57 49.27 19.96
150 59.77 104.14 158.91 14.49 63.64 89.12 79.72 92.32 51.91 19.32
151 59.56 105.95 144.13 13.78 65.49 88.47 72.80 87.02 54.36 19.80
152 57.22 114.75 147.18 13.32 73.48 88.32 74.42 94.04 47.52 16.78
153 54.40 128.44 134.00 12.16 74.38 89.89 77.81 91.19 48.04 17.45
154 50.47 118.10 141.20 12.43 78.11 81.90 68.06 92.82 50.25 18.16
155 42.60 125.89 157.13 12.70 79.78 85.67 79.03 99.87 45.19 18.16
156 40.71 128.53 171.05 11.87 89.90 69.37 64.45 106.86 41.33 17.62
157 41.30 126.29 139.99 12.81 98.69 70.04 55.41 92.17 45.60 16.97
158 37.54 126.62 148.28 13.76 98.83 72.72 61.27 73.48 38.74 14.49
159 39.02 126.37 148.46 14.54 99.94 72.50 63.02 69.08 40.25 15.86
160 38.12 127.96 152.80 13.61 115.29 74.81 60.72 78.93 43.65 16.74
161 37.81 130.64 145.68 12.05 112.98 69.93 60.81 80.57 36.95 15.18
162 33.17 123.16 125.05 12.73 121.37 73.27 64.67 79.55 36.55 13.26

Sheet2

Sheet3