Stock prices reflect the value of a company and corporate executives are often concerned about their company's share price. The data set here share prices for the stocks of two companies for trading dates in 2014. The companies are Starbucks and Dunkin Donuts. Use the Data Analysis feature in Excel to help you find the correct answers. What is the coefficient of variation for the price of Dunkin Donut's shares? Don't include the percent sign and your answer should be greater than 1. Coffee and donut stock prices data set is here. 41.19 47.84 A B 1 date Starbuck's closing stock price (SBUX) Dunkin Donut's closing stock price (DNKN) 2 12/31/2014 41.025 42.65 3 12/30/2014 40.895 43.38 4 12/29/2014 42.9 5 12/26/2014 40.915 42.37 6 12/24/2014 40.635 41.85 7 12/23/2014 40.715 41.98 8 12/22/2014 40.27 41.99 9 12/19/2014 39.72 41.67 10 12/18/2014 40.015 43.05 11 12/17/2014 40.2175 46.22 12 12/16/2014 39.565 45.14 13 12/15/2014 40.445 46.42 14 12/12/2014 41.625 46.755 15 12/11/2014 41.56 46.29 16 12/10/2014 41.33 46.09 17 12/9/2014 41.515 46.99 18 12/8/2014 41.9 47.04 19 12/5/2014 41.785 47.94 20 12/4/2014 40.655 47.62 21 12/3/2014 40.235 47.94 22 12/2/2014 40.185 23 12/1/2014 40.425 48.45 24 11/28/2014 40.605 48.35 25 11/26/2014 39.85 47.41 26 11/25/2014 40.105 47.54 27 11/24/2014 40.26 48 28 11/21/2014 39.88 47.39 29 11/20/2014 39.1 47.29 30 11/19/2014 38.91 47.03 31 11/18/2014 38.785 32 11/17/2014 38.915 47.58 33 11/14/2014 39.06 47.9 34 11/13/2014 38.945 48.52 35 11/12/2014 38.925 48.09 36 11/11/2014 38.865 47.34 37 11/10/2014 38.825 47.29 38 11/7/2014 38.895 47.04 39 11/6/2014 38.725 47.05 40 11/5/2014 38.33 46.14 41 11/4/2014 38.355 46.33 42 11/3/2014 38.05 45.54 43 10/31/2014 37.78 45.48 44 10/30/2014 38.66 45.93 45 10/29/2014 38.27 45.75 46 10/28/2014 38.525 46.38 47 10/27/2014 37.985 45.5 48 10/24/2014 37.905 45.11 49 10/23/2014 37.42 44 50 10/22/2014 37.3 46.79 51 10/21/2014 37.18 46.55 52 10/20/2014 37.35 46.76 53 10/17/2014 36.77 45.24 54 10/16/2014 36.32 44.73 55 10/15/2014 36.19 45.02 56 10/14/2014 36.37 45.11 57 10/13/2014 36.095 44.51 58 10/10/2014 37.23 45.02 59 10/9/2014 37.24 45.08 10 lo/2011 11 72 Sheet1 47.03 CA : H Type here to search o e B 45.02 58 59 60 61 45.08 44.73 43.78 62 44.96 63 64 44.485 43.7 37.23 37.24 37.63 37.025 37.5725 37.945 37.225 37.305 37.73 37.635 37.585 37.06 37.66 36.9775 65 44.46 66 67 68 69 70 71 44.82 45.14 44.57 44.12 44.48 43.71 44.24 45.23 45.64 46.78 47.36 47.5 72 37.3 73 38.035 74 75 37.865 37.67 37.545 76 77 37.46 78 37.735 47.21 79 46.91 80 81 38.06 38.605 38.56 38.835 38.975 46.52 46.82 46.36 82 83 84 46.01 38.58 45.25 85 44.46 86 43.96 38.395 38.74 38.905 38.905 87 A 10/10/2014 10/9/2014 10/8/2014 10/7/2014 10/6/2014 10/3/2014 10/2/2014 10/1/2014 9/30/2014 9/29/2014 9/26/2014 9/25/2014 9/24/2014 9/23/2014 9/22/2014 9/19/2014 9/18/2014 9/17/2014 9/16/2014 9/15/2014 9/12/2014 9/11/2014 9/10/2014 9/9/2014 9/8/2014 9/5/2014 9/4/2014 9/3/2014 9/2/2014 8/29/2014 8/28/2014 8/27/2014 8/26/2014 8/25/2014 8/22/2014 8/21/2014 8/20/2014 8/19/2014 8/18/2014 8/15/2014 8/14/2014 8/13/2014 8/12/2014 8/11/2014 8/8/2014 8/7/2014 8/6/2014 8/5/2014 8/4/2014 8/1/2014 7/31/2014 7/30/2014 7/29/2014 7/28/2014 7/25/2014 7/24/2014 7/23/2014 7/22/2014 7/21/2014 7/10/2014 Sheet1 43.54 88 89 38.96 43.57 43.59 43.8 90 38.895 91 38.985 44.01 92 43.75 38.64 38.735 93 44.24 94 39.015 44.64 95 39.06 44.05 96 38.795 43.65 97 43.43 38.455 38.31 98 99 38.62 38.91 43.54 43.94 43.73 100 101 38.935 43.87 43.61 38.81 102 103 104 38.355 38.565 38.395 38.765 43.47 43.5 43.46 105 106 38.49 107 108 43.41 43.11 42.86 38.84 109 39.45 43.29 43.95 110 39.325 39.18 42.77 111 112 113 114 115 116 117 39.37 40.225 39.57 42.13 42.015 43.96 39.37 43.74 38.805 43.56 2007 115 116 43.74 43.56 117 44.14 39.37 38.805 38.97 38.62 39.365 39.445 39.28 118 119 120 43.89 43.52 44.09 121 44.97 44.81 122 123 39.3 39.425 39.725 44.99 124 45.51 125 39.28 126 45.33 46.24 46.07 45.57 46.02 45.81 46.31 45.93 39.345 39.53 39.095 39.04 38.69 38.97 39.03 39.06 38.715 38.365 38.3 38.615 127 128 129 130 131 132 133 134 135 136 137 138 139 140 45.8 45.1 43.45 43.73 44.38 37.78 44.84 37.655 44.52 37.545 44.23 141 37.345 36.98 44.04 44.335 45.23 37.4 7/22/2014 7/21/2014 7/18/2014 7/17/2014 7/16/2014 7/15/2014 7/14/2014 7/11/2014 7/10/2014 7/9/2014 7/8/2014 7/7/2014 7/3/2014 7/2/2014 7/1/2014 6/30/2014 6/27/2014 6/26/2014 6/25/2014 6/24/2014 6/23/2014 6/20/2014 6/19/2014 6/18/2014 6/17/2014 6/16/2014 6/13/2014 6/12/2014 6/11/2014 6/10/2014 6/9/2014 6/6/2014 6/5/2014 6/4/2014 6/3/2014 6/2/2014 5/30/2014 5/29/2014 5/28/2014 5/27/2014 5/23/2014 5/22/2014 5/21/2014 5/20/2014 5/19/2014 5/16/2014 5/15/2014 5/14/2014 5/13/2014 5/12/2014 5/9/2014 5/8/2014 5/7/2014 5/6/2014 5/5/2014 5/2/2014 5/1/2014 4/30/2014 4/29/2014 Ano 2014 Sheet1 37.3 37.59 45.52 45.88 142 143 144 145 146 147 148 149 150 151 152 153 154 46.06 45.8 37.665 37.36 37.335 37.09 36.925 36.62 36.555 36.635 36.83 35.99 35.7 46 45.65 45.97 44.76 44.365 44.94 45.09 44.63 155 156 44.67 157 35.2 44.34 158 43.91 35.115 35.51 159 44.34 44.93 160 161 35.47 34.925 35.085 44.1 162 44.36 35.58 163 164 44.32 45.05 35.575 165 45.05 35.145 34.79 34.87 166 167 168 169 44.77 44.28 44.51 45.61 45.75 170 171 34.79 35.46 35.3 35.56 35.31 35.32 20 ACC 172 173 45.57 45.51 45.79 AC 76 + A B 172 173 174 175 176 177 35.31 35.32 35.465 35.725 35.545 35.195 35.5745 35.24 45.51 45.79 45.75 46.51 46.692 47.59 49.07 48.38 178 179 180 35.075 181 182 183 184 185 186 187 35.395 34.445 34.655 34.365 35.11 36.24 35.74 35.215 35.775 36.545 36.835 37.005 36.69 48.14 48.4 48.06 48.08 47.12 47.57 48.35 47.73 46.92 48.48 49.57 50.29 50.88 188 189 190 191 192 193 194 50.18 36.85 195 36.7 49.4 48.91 50.03 196 36.77 197 37.305 50.55 51.31 37.885 198 199 200 201 202 203 204 205 4/30/2014 4/29/2014 4/28/2014 4/25/2014 4/24/2014 4/23/2014 4/22/2014 4/21/2014 4/17/2014 4/16/2014 4/15/2014 4/14/2014 4/11/2014 4/10/2014 4/9/2014 4/8/2014 4/7/2014 4/4/2014 4/3/2014 4/2/2014 4/1/2014 3/31/2014 3/28/2014 3/27/2014 3/26/2014 3/25/2014 3/24/2014 3/21/2014 3/20/2014 3/19/2014 3/18/2014 3/17/2014 3/14/2014 3/13/2014 3/12/2014 3/11/2014 3/10/2014 3/7/2014 3/6/2014 3/5/2014 3/4/2014 3/3/2014 2/28/2014 2/27/2014 2/26/2014 2/25/2014 2/24/2014 2/21/2014 2/20/2014 2/19/2014 2/18/2014 2/14/2014 2/13/2014 2/12/2014 2/11/2014 2/10/2014 2/7/2014 2/6/2014 2/5/2014 Inno1 Sheet1 38.355 38.4775 37.955 37.3 37.09 37.135 37.215 37.815 37.515 36.78 36.535 36.345 35.65 35.83 52.26 52.34 52.24 52.67 52.47 52.25 51.686 52.44 52.17 51.91 52.16 51.43 206 207 208 209 51.4 210 211 212 213 214 215 216 52.2 51.43 35.235 35.48 36.095 51.67 51.58 35.89 51.31 217 35.275 51.48 218 36.28 50.59 219 36.28 50.02 220 50.51 221 36.775 36.66 36.985 50.17 222 50.38 223 224 37.515 37.345 36.955 225 226 227 228 229 230 37.25 37.4 37.0175 36.18 35.245 2015 49.76 49.2161 48.77 49.15 49.83 48.99 48.89 47.3 17.20 B 229 230 231) 232 233 234 235) 236 237 238 239 36.18 35.245 35.325 34.485 35.56 35.955 35.78 36.945 37.105 37.49 36.695 36.8 48.89 47.3 47.28 46.05 46.53 46.21 45.94 46.79 46.56 46.51 46.13 A 2/6/2014 2/5/2014 2/4/2014 2/3/2014 1/31/2014 1/30/2014 1/29/2014 1/28/2014 1/27/2014 1/24/2014 1/23/2014 1/22/2014 1/21/2014 1/17/2014 1/16/2014 1/15/2014 1/14/2014 1/13/2014 1/10/2014 1/9/2014 1/8/2014 1/7/2014 1/6/2014 1/3/2014 240 47.13 46.82 36.825 37.45 46.9 46.9 37.645 38.095 47.26 241 242 243 244 245 246 247 248 249 37.73 47.12 46.4 37.56 38.835 46.95 38.8 46.99 250 39.015 38.605 38.085 38.475 47.52 46.71 47.17 47.43 251 252