Microsoft Excel Homework
lion321trends.xlsx
2016 Participation
2016 Participation - Ranked by Total Participation | |
Participated more than once (in millions) | |
Seven (7) years of age and older | |
Sport | Total |
Exercise Walking | 86.776 |
Camping (vacation/overnight) | 65.832 |
Swimming | 56.076 |
Exercising with Equipment | 55.216 |
Fishing | 54.412 |
Bowling | 40.712 |
Bicycle Riding | 40.124 |
Billiards/Pool | 38.736 |
Hiking | 34.728 |
Aerobic Exercising | 33.320 |
Basketball | 32.564 |
Golf | 30.940 |
Weight Lifting | 29.304 |
Boating, Motor/Power | 25.348 |
Running/Jogging | 24.848 |
Roller Skating (in-line) | 22.212 |
Dart Throwing | 21.676 |
Baseball | 18.688 |
Backpack/Wilderness Camp | 17.524 |
Mountain Biking (on road) | 16.452 |
Soccer | 15.740 |
Softball | 14.992 |
Scooter Riding | 14.980 |
Volleyball | 14.660 |
Tennis | 13.668 |
Football (touch) | 13.420 |
Skateboarding | 13.124 |
Mountain Biking (off-road) | 10.472 |
Canoeing | 10.376 |
Skiing (alpine) | 9.550 |
Football (tackle) | 9.536 |
T'ai Chi/Yoga | 9.424 |
Paintball Games | 8.670 |
Water Skiing | 8.330 |
Snowboarding | 6.880 |
Martial Arts | 4.208 |
Archery (target) | 3.536 |
Skiing (cross-country) | 3.476 |
Hockey (ice) | 3.420 |
10-Year Participation
Ten-Year History of Selected Sports Participation | ||||||
Participated more than once (in millions) | ||||||
Seven (7) years of age and older | ||||||
Sport | 2006 | 2008 | 2010 | 2012 | 2014 | 2016 |
Aerobic Exercising | 31.32 | 28.836 | 27.864 | 26.028 | 25.056 | 30.024 |
Archery (target) | 4.536 | 4.86 | 5.184 | 5.724 | 5.832 | 5.94 |
Backpack/Wilderness Camp | 16.74 | 16.632 | 15.768 | 12.42 | 10.584 | 10.476 |
Baseball | 16.848 | 16.848 | 17.172 | 15.984 | 16.308 | 16.308 |
Basketball | 31.212 | 29.268 | 31.752 | 34.344 | 30.456 | 30.456 |
Bicycle Riding | 44.712 | 46.548 | 46.98 | 57.564 | 53.784 | 58.968 |
Billiards/Pool | 38.124 | 35.1 | 34.884 | 37.26 | 36.72 | 31.644 |
Boating, Motor/Power | 28.728 | 26.136 | 27.756 | 31.104 | 28.512 | 24.084 |
Bowling | 47.412 | 46.548 | 43.308 | 46.332 | 40.392 | 45.9 |
Camping (vacation/overnight) | 59.832 | 53.892 | 50.22 | 48.276 | 46.332 | 51.084 |
Canoeing | 8.208 | 6.696 | 7.668 | 9.072 | 9.18 | 7.776 |
Dart Throwing | 19.98 | 18.792 | 22.464 | 23.004 | 22.896 | 20.304 |
Exercise Walking | 88.776 | 87.804 | 83.808 | 79.164 | 76.464 | 73.224 |
Exercising with Equipment | 54.216 | 48.384 | 49.788 | 51.624 | 47.304 | 42.552 |
Fishing | 47.736 | 50.976 | 47.088 | 49.248 | 49.356 | 51.408 |
Football (tackle) | 7.992 | 8.64 | 8.748 | 9.72 | 9.72 | 10.8 |
Football (touch) | 11.124 | 10.584 | 11.664 | 12.528 | 12.96 | 13.284 |
Golf | 30.564 | 28.512 | 29.7 | 24.948 | 26.568 | 25.92 |
Hiking | 32.94 | 26.244 | 29.376 | 28.62 | 27.324 | 23.328 |
Hockey (ice) | 2.268 | 2.052 | 2.268 | 2.268 | 2.052 | 1.728 |
Martial Arts | 4.536 | 5.832 | 4.968 | 5.076 | 5.184 | 5.076 |
Mountain Biking (off-road) | 8.424 | 7.668 | 9.288 | 7.884 | 6.156 | 5.94 |
Mountain Biking (on road) | 16.524 | 15.444 | 16.524 | 14.364 | 9.72 | 8.64 |
Paintball Games | 7.452 | 5.724 | 5.4 | 4.32 | 3.996 | 3.24 |
Roller Skating (in-line) | 20.304 | 23.544 | 29.16 | 27.54 | 21.06 | 10.476 |
Running/Jogging | 26.676 | 24.624 | 24.3 | 23.976 | 22.248 | 23.652 |
Scooter Riding | 14.472 | 12.528 | 11.88 | 10.8 | 10.26 | 9.72 |
Skateboarding | 10.476 | 9.828 | 6.264 | 5.076 | 5.292 | 5.94 |
Skiing (alpine) | 7.992 | 7.992 | 8.316 | 11.34 | 11.448 | 11.664 |
Skiing (cross-country) | 2.376 | 2.484 | 2.808 | 3.672 | 3.888 | 3.78 |
Snowboarding | 6.048 | 4.644 | 3.888 | 3.348 | 2.268 | 1.296 |
Soccer | 15.66 | 13.932 | 14.256 | 15.012 | 13.5 | 11.448 |
Softball | 14.688 | 15.12 | 16.848 | 21.492 | 19.548 | 20.736 |
Swimming | 59.076 | 63.504 | 62.856 | 65.016 | 65.124 | 68.148 |
T'ai Chi/Yoga | 7.668 | 7.668 | 7.128 | 7.02 | 6.804 | 6.48 |
Tennis | 11.88 | 10.8 | 12.096 | 12.42 | 12.528 | 18.684 |
Volleyball | 12.42 | 13.284 | 15.984 | 19.98 | 18.792 | 23.868 |
Water Skiing | 7.452 | 6.372 | 7.776 | 7.992 | 7.992 | 8.532 |
Weight Lifting | 30.348 | 24.624 | 22.68 | 22.464 | 21.708 | 20.52 |
This bar chart has the advantage of easily showing each category on the category axis and the bars for each year make it easy to see the changes in participation over the 10 year period. The obvious disadvantage is the vertical length of the chart which is necessary to accommodate the number of categories. Sparklines do a much better job of illustrating participation changes within each of these categories, but sparklines do not allow for easy comparison between categories. There isn't a common axis, so scale issues are a problem.
Female Sports Participation
Female Sports Participation: 2016 vs 2011 | |||||
Participated more than once (in millions) | |||||
Seven (7) years of age and older | |||||
Ranked by difference in percent | |||||
Sport | 2016 Total Female | 2016 Percent Female | 2011 Total Female | 2011 Percent Female | Percent Difference |
Hockey (ice) | 0.54 | 26.04% | 0.324 | 17.89% | 8.15% |
Martial Arts | 1.944 | 48.82% | 1.944 | 42.51% | 6.31% |
Mountain Biking (off-road) | 3.132 | 43.10% | 2.808 | 37.22% | 5.88% |
Canoeing | 3.564 | 48.82% | 2.916 | 44.56% | 4.26% |
Running/Jogging | 12.312 | 52.28% | 9.72 | 48.13% | 4.15% |
Softball | 7.236 | 55.95% | 7.992 | 51.91% | 4.04% |
Hiking | 16.416 | 56.17% | 14.04 | 52.56% | 3.61% |
Baseball | 4.428 | 30.90% | 3.456 | 27.50% | 3.40% |
Volleyball | 6.696 | 61.46% | 9.828 | 58.39% | 3.07% |
Water Skiing | 3.024 | 47.10% | 2.7 | 44.35% | 2.75% |
Basketball | 10.368 | 38.24% | 10.152 | 36.36% | 1.88% |
Camping (vacation/overnight) | 28.836 | 54.55% | 23.22 | 52.99% | 1.56% |
Billiards/Pool | 14.796 | 44.72% | 14.904 | 43.59% | 1.13% |
Bowling | 23.22 | 55.41% | 22.896 | 54.28% | 1.13% |
Roller Skating (in-line) | 10.584 | 58.76% | 14.472 | 57.85% | 0.91% |
Boating, Motor/Power | 12.528 | 49.69% | 12.42 | 48.88% | 0.80% |
Mountain Biking (on road) | 7.128 | 49.04% | 7.236 | 48.45% | 0.59% |
Bicycle Riding | 20.412 | 51.96% | 21.816 | 51.58% | 0.37% |
Swimming | 31.536 | 60.27% | 34.02 | 60.22% | 0.05% |
Exercising with Equipment | 29.268 | 60.92% | 27.756 | 61.20% | -0.28% |
Football (tackle) | 0.756 | 13.08% | 0.864 | 13.46% | -0.38% |
Football (touch) | 2.376 | 25.28% | 2.7 | 25.66% | -0.38% |
Tennis | 5.184 | 49.58% | 5.184 | 50.29% | -0.71% |
Exercise Walking | 55.728 | 70.42% | 51.948 | 71.35% | -0.92% |
Fishing | 16.2 | 39.10% | 16.524 | 40.24% | -1.14% |
Backpack/Wilderness Camp | 6.48 | 44.50% | 5.076 | 45.64% | -1.14% |
Snowboarding | 1.404 | 27.44% | 0.648 | 28.69% | -1.25% |
Golf | 6.264 | 24.96% | 6.048 | 26.42% | -1.46% |
Soccer | 5.94 | 43.42% | 5.724 | 45.54% | -2.11% |
Skateboarding | 2.052 | 23.66% | 1.404 | 25.99% | -2.33% |
Dart Throwing | 7.452 | 42.67% | 9.072 | 45.54% | -2.87% |
Skiing (alpine) | 3.132 | 45.04% | 3.996 | 48.13% | -3.08% |
Aerobic Exercising | 23.004 | 81.66% | 21.6 | 85.60% | -3.95% |
Archery (target) | 1.08 | 27.55% | 1.404 | 31.93% | -4.38% |
Skiing (cross-country) | 1.08 | 52.82% | 1.404 | 57.20% | -4.38% |
Purchases by Sport
Consumer Equipment Purchases by Sport (in millions) | |||
2016 | 2015 | 2014 | |
Exercise | $4,992.21 | $4,885.58 | $4,400.11 |
Golf | $3,716.73 | $3,779.42 | $4,380.25 |
Team Goods | $2,835.45 | $2,882.88 | $2,856.28 |
Fishing Tackle | $2,265.21 | $2,320.54 | $2,357.26 |
Camping | $1,649.61 | $1,645.61 | $1,590.48 |
Optics | $992.97 | $991.99 | $934.37 |
Billiards & Indoor Games | $678.69 | $678.54 | $649.88 |
Skiing, Downhill | $657.09 | $662.12 | $635.04 |
Wheel Sports & Pogo Sticks | $581.49 | $623.52 | $871.45 |
Tennis | $508.05 | $515.93 | $474.95 |
Skin Diving & Scuba Gear | $438.93 | $443.06 | $449.62 |
Basketball | $427.05 | $434.08 | $396.30 |
Baseball & Softball | $415.17 | $415.33 | $413.92 |
Archery | $382.77 | $382.72 | $368.52 |
Skiing, Snowboards | $347.13 | $347.68 | $333.49 |
Bowling | $267.21 | $267.48 | $248.03 |
Hockey & Ice Skates | $258.57 | $259.50 | $229.40 |
Football | $167.85 | $175.87 | $160.56 |
Soccer Balls | $146.25 | $145.36 | $137.25 |
Water Skis | $139.77 | $140.93 | $126.98 |
Skiing, Cross-Country | $116.01 | $117.41 | $102.55 |
Volleyball & Badminton Sets | $110.61 | $111.87 | $96.97 |
Racquetball | $105.21 | $107.76 | $92.95 |
Total | $22,200.00 | $22,335.20 | $22,306.60 |