Excel homework
Consumer Purchases by Category
Sales in millions of dollars
2009 2010 2011 2012 2013 2014 2015 2016
Equipment 18,971 19,033 19,170 20,319 19,439 16,196 15,224 13,320
Footwear 12,816 13,318 13,068 12,546 13,026 11,742 16,928 18,779
Apparel 11,127 12,035 12,845 10,307 11,030 9,195 12,971 15,269
Total 42,914 44,387 45,083 43,196 45,655 45,625 45,835 46,824
Consumer Purchases by Category
Sales in millions of dollars
2009 2010 2011 2012 2013 2014 2015 2016
Equipment 18,971 19,033 19,170 20,319 19,439 16,196 15,224 13,320
Footwear 12,816 13,318 13,068 12,546 13,026 11,742 16,928 18,779
Apparel 11,127 12,035 12,845 10,307 11,030 9,195 12,971 15,269
Total 42,914 44,387 45,083 43,196 45,655 45,625 45,835 46,824
$0
$5,000
$10,000
$15,000
$20,000
$25,000
Equipment Footwear Apparel
(i n
m il
li o
n s)
Sporti ng Goods
Consumer Purchases
2012 2013 2014 2015 2016
Consumer Purchases by Category
Sales in millions of dollars
2009 2010 2011 2012 2013 2014 2015 2016
Equipment 18,971 19,033 19,170 20,319 19,439 16,196 15,224 13,320
Footwear 12,816 13,318 13,068 12,546 13,026 11,742 16,928 18,779
Apparel 11,127 12,035 12,845 10,307 11,030 9,195 12,971 15,269
Total 42,914 44,387 45,083 43,196 45,655 45,625 45,835 46,824
Apparel Footwear
Equipment
$0
$10,000
$20,000
$30,000
2009 2010 2011 2012 2013 2014 2015 2016
(i n
m il
li o
n s)
Consumer Purchases
Apparel Footwear Equipment
Consumer Purchases by Category
Sales in millions of dollars
2009 2010 2011 2012 2013 2014 2015 2016
Equipment 18,971 19,033 19,170 20,319 19,439 16,196 15,224 13,320
Footwear 12,816 13,318 13,068 12,546 13,026 11,742 16,928 18,779
Apparel 11,127 12,035 12,845 10,307 11,030 9,195 12,971 15,269
Total 42,914 44,387 45,083 43,196 45,655 45,625 45,835 46,824
Equipment 28%
Footwear 40%
Apparel
32%
2016 Consumer Purchases
Consumer Equipment Purchases by Sport (in millions) 2016 2015 2014
Exercise $4,992.21 $4,757.14 $4,259.54
Golf $3,716.73 $3,680.05 $4,240.32
Team Goods $2,835.45 $2,807.09 $2,765.04
Fishing Tackle $2,265.21 $2,259.53 $2,281.95
Camping $1,649.61 $1,602.35 $1,539.67
Optics $992.97 $965.91 $904.52
Billiards & Indoor Games $678.69 $660.70 $629.12
Skiing, Downhill $657.09 $644.71 $614.76
Wheel Sports & Pogo Sticks $581.49 $607.13 $843.61
Tennis $508.05 $502.37 $459.78
Skin Diving & Scuba Gear $438.93 $431.41 $435.26
Basketball $427.05 $422.67 $383.64
Baseball & Softball $415.17 $404.41 $400.70
Archery $382.77 $372.66 $356.74
Skiing, Snowboards $347.13 $338.53 $322.83
Bowling $267.21 $260.45 $240.10
Hockey & Ice Skates $258.57 $252.67 $222.07
Football $167.85 $171.24 $155.43
Soccer Balls $146.25 $141.54 $132.86
Water Skis $139.77 $137.22 $122.92
Skiing, Cross-Country $116.01 $114.33 $99.27
Volleyball & Badminton Sets $110.61 $108.93 $93.87
Racquetball $105.21 $104.93 $89.98
Total $22,200.00 $21,748.00 $21,594.00
Exercise
Golf
Team Goods
Fishing Tackle
Camping
Optics
Billiards & Indoor Games
Skiing, Downhill
Wheel Sports & Pogo Sticks
Tennis
Skin Diving & Scuba Gear
Basketball
Baseball & Softball
Archery
Skiing, Snowboards
Bowling
Hockey & Ice Skates
Football
Soccer Balls
Water Skis
Skiing, Cross-Country