SKI RESORT SUMMITS IN THE US BY MARSHALL
SKI RESORT SUMMITS IN THE US BY MARSHALL PARKER DSCI 101
PRESENTATION OVERVIEW In this presentation: Overview of the On The Snow data set Problems with this data set Analysis technique Findings Future Work
DATA OVERVIEW From On the Snow datasheet https: //www. kaggle. com/sijialai/onthesnow Info was retrieved from onthesnow. com Format xlsx 37 Fields 331 Records 54 KB
DATA FIELDS Name Quad Days Open Last Year Adult Weekend Price City Triple Days Open Note State Double Years Open Summit Surface Average Snowfall Drop Total Adult Week Day Base Terrain Parks Adult Weekend Trams Longest Run Url Fast Eight Skiable Terrain Projected Days Open Fast Sixes Runs Adult Weekday Price Fast Quads Snow Making Note Night Skiing Fast Eight Note Mi Pistes Mi Snow Making MI Night Skiing Snowfall Note Year Open Note
PROBLEMS WITH THE DATA Lots of Fields Only 14 remained Units weren’t labeled Country and State correction 3218 blanks 9 Fields consisted mostly blanks Missing info that was needed was obtained from Url
ANALYZING TECHNIQUES Drop ft Basic cleaning step prior to analysis Max and Average Comparisons Many Pivot tables Summary of key points New England, Summits, PA, Skiable Terrain Max 4425. 0 Max 26819. 0 Q 3 1800. 0 Q 3 700. 0 Mid 964. 5 Mid 200. 0 Q 1 457. 5 Q 1 85. 0 Min 60. 0 Min 8. 0 Ave 1215. 4 Ave 739. 8 Std Dev 946. 4 Std Dev 1813. 4
FINDINGS: State Highest summit Colorado 13487 New Mexico 12481 Arizona 11500 New York 4650 Vermont 4395 Iowa 1500 Pennsylvania 3146 18 of the 20 Highest Colorado New England lower listed lower than expected 35 states with Skiing California was divided into Southern and Northern Iowa?
FINDINGS: NEW ENGLAND 10 HIGHEST 5000 4500 New Hampshire New York Pennsylvania Vermont 4000 3500 3000 2500 2000 1500 1000 500 0 Whiteface Stowe Killington Sugarbush Cannon Wildcat Waterville Jay Peak Pico Stratton Mountain Resort Mountain Valley Mountain Resort
FINDINGS: SUMMIT Break Down Tallest resort in US: 13, 487 Count of Slopes broken down by heights 4 8 29 61 24 43 72 89 Summit Height >13000 >12000 >10000 >7000 >5000 >3000 >1500 <1500
FINDINGS: PENNSYLVANIA Number of Resorts in PA 18 Min Summit 528 Max Summit 3146 average Drop 708 average Snow Fall 54 average Summit 1822 Seven Springs 2 nd for Summit 2994 Only a 750 foot drop Mount Pleasant 12 th for Summit at 1540 feet Base is at 1200 feet Largest Drop is 1082 Average is just shy of the Nations (969)
SUMMARY OF KEY ITEMS Summit ft Max Q 3 Mid Q 1 Min Ave Std Dev Base ft 13487. 0 7824. 5 3140. 0 1400. 0 315. 0 4600. 3 3732. 4 10800. 0 6345. 0 1563. 0 867. 0 70. 0 3380. 4 3114. 9 Longest Run miles Runs Max Q 3 Mid Q 1 Min Ave Std Dev Drop ft 341. 0 61. 3 33. 5 19. 0 3. 0 48. 4 46. 3 Max Q 3 Mid Q 1 Min Ave Std Dev 6. 00 2. 00 1. 00 0. 50 0. 00 1. 43 1. 16 Max Q 3 Mid Q 1 Min Ave Std Dev Skiable Terrain ac 4425. 0 1800. 0 969. 0 455. 0 60. 0 1217. 4 947. 2 Days open last year Max Q 3 Mid Q 1 Min Ave Std Dev 305. 0 135. 0 114. 0 97. 0 3. 0 115. 1 35. 0 Max Q 3 Mid Q 1 Min Ave Std Dev 26819. 0 700. 0 200. 0 85. 0 8. 0 739. 8 1813. 4 Expected days open Max Q 3 Mid Q 1 Min Ave Std Dev 305. 0 140. 0 114. 0 100. 0 30. 0 120. 3 30. 7
FUTURE WORK Recognitions Regions Runs
- Slides: 12