1. Find the data entry error. This is the January 11, 2021 Snow Report for Colorado ski areas from https://www.coloradoski.com/snow-report-2020. Write a couple of sentences about the error (there might be more than one) Snow Report OPEN RESORTS Mid- Lifts Resort Mtn Surface Weather 24 hrs 48 hrs Depth Cond. Oper Conditions Arapahoe Basin updated: 5:42 AM MDT 0" 31" PP 6/9 18/35 12/57 10/49 -O- 1/1 1/21 29/9 Aspen Highlands updated; 4:07 AM MDT pp 32/34 20/21 36/67 -O- 30/6 Aspen Mountain 230' pp 8/8 32/32 18/20 21/24 -Q- Updated: 4:07 AM MDT 27/9 Buttermilk pp 11/11 -O- updated: 4:07 AM MDT 8/8 21/21 9/9 30/6 Cooper 28 PP 5/5 10/10 -O- 1/19: 8:51 AM MDT 16/16 18/18 15/15 24/3 Copper Mountain updated: 4:35 AM MDT 24" PP/HP 23/2 32/36 36/36 29/5 6/25 -O- 28/13 Echo Mountain updated: 6:00 AM MDT 18" PP/MM -O- 313 1/3 1/5 1 2/09/20 33/1 Eldora 2. In the spreadsheet (DataWithFiveErrors.xIsx) identify five errors in the data set by listing their original location in the spreadsheet (there might be more). Continuing the document produced to answer question one, identify the errors (there are at least five) by completing Table 1 and embedding it into your . docx. Discuss why you ranked the errors the way you did. Why is your error ranked number one the worst error? As usual, your submission should have an introduction, analysis or techniques used to identify the errors, and a conclusion. Table 1 Errors and their severity Error Location Type of Error Proposed Severity Rank (Cell Reference) spelling, data type, typo...) Correction (1 = most severe) YAWNleight of to Number Clin Distance to top (km) 4 Stage of to V Category Length Gradient of climb climbs (on nun from start) Overall length of stage (K 1 11.3 7 1477 2 43 10 158.5 8.8 8.9 1297 130 10 158.5 7.5 8.5 1618 5 144 10 158.5 17.6 5.8 1855 4 108.5 11 108.5 12.3 6.3 1205 140 15 181.5 6.9 8.1 1349 171 16 218 8.3 7.1 1292 208 16 218 14.9 6.7 1645 1 15 17 65 7.4 8.3 1580 37 17 65 12 6.5 1490 78.5 19 200.5 IN W W N 5 .7 6.5 1968 70 11 108.5 2.4 8.2 782 33 12 175.5 9.1 5.3 1088 129 14 18 8 3 10.1 1030 18 8 14 1880 10.2 4.9 919 54.5 15 181.5 5 . 4 7.1 1069 .55.5 16 218 8.6 5.8 1156 159. 19 200.5 1 .5 UT A W UT W M 6.6 221 138 5 204.5 6.2 210 159.5 204.5 2.2 5.9 233 181 5 204.5 1.5 7 12 44 6 181 2 6.9 293 165 6 181 2 6.9 293 181 6 181 2.4 6.9 45 32.5 13 169.5 3.3 6.3 1084 142 14 188 3.1 5.9 538 14 15 181.5 4.2 30 173 1 201 3.9 202 28 2 182.5 80Om 7.8 79 135.5 4 195 1.7 7.1 209 106 204.5 Q Q W A D A A A U GI G N N U U A N U N N H A U U H H H W A N A A A U U LT O UT W A A A BOWL 5.6 223 113 ON UT UT 1.6 204.5 NN K 3.5 340 58.5 181 1.5 3.9 235 120 7 231 2 4.3 135 35 8 181.5 2.3 4.3 134 71.5 181.5 5.1 5 .6 622 19 10 158.5 1.5 4.9 298 109.5 13 169.5 1 7.4 321 1 81 14 188 2.4 4.9 348 25 16 218 N H 2.3 5.8 72 72 16 218 1.2 7 260 53.5 18 171 2.1 4.6 301 152.5 18 171 1.8 532 19 200.5 3.4 5.1 604 40 19 200.5 HC 6 11.2 1390 68.5 10 158.5 HC 12.4 8.2 1723 1 26 11 108.5 48 HC 12.6 7.7 1748 57.5 1 1 108.5 HC 25.3 6.2 2000 53.3 12 175.5 HC 29 5.2 22067 121 12 175.5 HC 13.8 8.1 1850 175.5 12 175.5 HC 16 8.7 2215 65 17 65 HC 16.6 4.9 1709 180. 19 200.5 54 HD 17.1 7 .3 2115 108 19 200.5D G H Height of top Number of Climb Distance to top (km) Stage Overall length of Category (y) Length (km) Gradient (%) of climb (m) climbs (on day) number (from start) (of tour) stage (km) 0.7 4.2 30 173 201 3.9 202 28 182.5 800m 7.8 79 135.5 n A 195 1. 7.1 209 106 104.5 113 204.5 2018 Tour de France 1.6 5.6 223 1.9 6.6 221 138 204. 3 6.2 210 159.5 204.5 2.2 5.9 233 181 204.5 1.5 7 128 181 2.5 3.5 340 8.5 18 2 6.9 293 165 181 2 6.9 293 18 6 181 1.5 3.9 235 120 231 2 4.3 135 181.5 2.3 4.3 134 181.5 5 .1 5.6 622 10 158.5 11.3 7 1477 10 158.5 HC 11.2 139 10 158.5 8.9 1297 130 10 158. 8.5 1618 144 10 158.5 HC 12.4 1723 26 11 108.5 12.6 7.7 1748 7.5 11 108.5 6.5 1968 11 108. 17.6 5.8 1855 08. 11 108. 25.3 6.2 2000 3.3 12 175.5 N N H 2 2.4 8.2 782 12 175.5 HC 29 5.2 22067 121 12 175.5 HC 13.8 8.1 1850 175.5 12 175.5 2.4 6.9 450 32.5 13 169. NN 1.5 4.9 298 13 69. 7.4 321 14 188 9.1 5.3 1088 14 188 3.3 6.3 1084 14 188 10.1 1030 14 1880 3.1 5.9 538 15 181.5 10.2 4.9 919 15 181.5 12.3 6.3 205 15 81.5 4.9 348 16 218 MAW NH W N H 5.8 72 16 218 7.1 1069 16 218 8.1 134 16 218 7.1 1292 16 218 6.7 1645 17 65 8.3 1580 17 65 16 8.7 2215 17 65 1.2 7 260 18 171 2.1 4.6 301 152.5 18 171 1 .8 532 19 200.5 OUT A W N H N H W M 3.4 5.1 604 200.5 12 6.5 1490 8. 19 200.5 17.1 7.3 211 108 19 200.5 8.6 5.8 1156 59.5 DO. 16.6 1709 180. 200.5