Week 4 Excel

profileAnyelis Diaz
CH03Level1Figures.xlsx
Home>Business & Finance homework help>Accounting homework help>Week 4 Excel

Consumer Purchases

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

Figure 3.2

Consumer Purchases

Equipment

2009 2010 2011 2012 2013 2014 2015 2016 18971 19033 19170 20319 19439 16196 15224 13320 Footwear

2009 2010 2011 2012 2013 2014 2015 2016 12816 13318 13068 12546 13026 11742 16928 18779 Apparel

2009 2010 2011 2012 2013 2014 2015 2016 11127 12035 12845 10307 11030 9195 12971 15269

Year

Sales (in millions of dollars)

Figure 3.3

Consumer Purchases

Equipment 2009 2010 2011 2012 2013 2014 2015 2016 18971 19033 19170 20319 19439 16196 15224 13320 Footwear 2009 2010 2011 2012 2013 2014 2015 2016 12816 13318 13068 12546 13026 11742 16928 18779 Apparel 2009 2010 2011 2012 2013 2014 2015 2016 11127 12035 12845 10307 11030 9195 12971 15269

i(n millions)

Figure 3.4

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

Figure 3.5

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

Figure 3.6

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 2009 2010 2011 2012 2013 2014 2015 2016 18971 19033 19170 20319 19439 16196 15224 13320 Footwear 2009 2010 2011 2012 2013 2014 2015 2016 12816 13318 13068 12546 13026 11742 16928 18779 Apparel 2009 2010 2011 2012 2013 2014 2015 2016 11127 12035 12845 10307 11030 9195 12971 15269

Equipment 2009 2010 2011 2012 2013 2014 2015 2016 18971 19033 19170 20319 19439 16196 15224 13320 Footwear 2009 2010 2011 2012 2013 2014 2015 2016 12816 13318 13068 12546 13026 11742 16928 18779 Apparel 2009 2010 2011 2012 2013 2014 2015 2016 11127 12035 12845 10307 11030 9195 12971 15269

Figure 3.7

Consumer Purchases by Category
Sales in millions of dollars
2016 2015 2014 2013 2012 2011 2010 2009
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 46,824 45,835 45,625 45,655 43,196 45,083 44,387 42,914
Equipment 2016 2015 2014 2013 2012 2011 2010 2009 18971 19033 19170 20319 19439 16196 15224 13320 Footwear 2016 2015 2014 2013 2012 2011 2010 2009 12816 13318 13068 12546 13026 11742 16928 18779 Apparel 2016 2015 2014 2013 2012 2011 2010 2009 11127 12035 12845 10307 11030 9195 12971 15269

Equipment 2016 2015 2014 2013 2012 2011 2010 2009 18971 19033 19170 20319 19439 16196 15224 13320 Footwear 2016 2015 2014 2013 2012 2011 2010 2009 12816 13318 13068 12546 13026 11742 16928 18779 Apparel 2016 2015 2014 2013 2012 2011 2010 2009 11127 12035 12845 10307 11030 9195 12971 15269

Figure 3.8

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 2012 2013 2014 2015 2016 20319 19439 16196 15224 13320 Footwear 2012 2013 2014 2015 2016 12546 13026 11742 16928 18779 Apparel 2012 2013 2014 2015 2016 10307 11030 9195 12971 15269

Figure 3.9

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

2012 Equipment Footwear Apparel 20319 12546 10307 2013 Equipment Footwear Apparel 19439 13026 11030 2014 Equipment Footwear Apparel 16196 11742 9195 2015 Equipment Footwear Apparel 15224 16928 12971 2016 Equipment Footwear Apparel 13320 18779 15269 2009 Equipment Footwear Apparel 18971 12816 11127 2010 Equipment Footwear Apparel 19033 13318 12035 2011 Equipment Footwear Apparel 19170 13068 12845

Equipment 2012 2013 2014 2015 2016 20319 19439 16196 15224 13320 Footwear 2012 2013 2014 2015 2016 12546 13026 11742 16928 18779 Apparel 2012 2013 2014 2015 2016 10307 11030 9195 12971 15269

Figure 3.10

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

2012 Equipment Footwear Apparel 20319 12546 10307 2013 Equipment Footwear Apparel 19439 13026 11030 2014 Equipment Footwear Apparel 16196 11742 9195 2015 Equipment Footwear Apparel 15224 16928 12971 2016 Equipment Footwear Apparel 13320 18779 15269 2009 Equipment Footwear Apparel 18971 12816 11127 2010 Equipment Footwear Apparel 19033 13318 12035 2011 Equipment Footwear Apparel 19170 13068 12845

Figure 3.11

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

2012 Equipment Footwear Apparel 20319 12546 10307 2013 Equipment Footwear Apparel 19439 13026 11030 2014 Equipment Footwear Apparel 16196 11742 9195 2015 Equipment Footwear Apparel 15224 16928 12971 2016 Equipment Footwear Apparel 13320 18779 15269 2009 Equipment Footwear Apparel 18971 12816 11127 2010 Equipment Footwear Apparel 19033 13318 12035 2011 Equipment Footwear Apparel 19170 13068 12845

Sporting Goods

(in millions)

Consumer Purchases

2012 Equipment Footwear Apparel 20319 12546 10307 2013 Equipment Footwear Apparel 19439 13026 11030 2014 Equipment Footwear Apparel 16196 11742 9195 2015 Equipment Footwear Apparel 15224 16928 12971 2016 Equipment Footwear Apparel 13320 18779 15269 2009 Equipment Footwear Apparel 18971 12816 11127 2010 Equipment Footwear Apparel 19033 13318 12035 2011 Equipment Footwear Apparel 19170 13068 12845

Sales of Sproting Goods (in millions)

Figure 3.12

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

2012 Equipment Footwear Apparel 20319 12546 10307 2013 Equipment Footwear Apparel 19439 13026 11030 2014 Equipment Footwear Apparel 16196 11742 9195 2015 Equipment Footwear Apparel 15224 16928 12971 2016 Equipment Footwear Apparel 13320 18779 15269 2009 Equipment Footwear Apparel 18971 12816 11127 2010 Equipment Footwear Apparel 19033 13318 12035 2011 Equipment Footwear Apparel 19170 13068 12845

Sporting Goods

(in millions)

Consumer Purchases

Equipment 2012 2013 2014 2015 2016 20319 19439 16196 15224 13320 Footwear 2012 2013 2014 2015 2016 12546 13026 11742 16928 18779 Apparel 2012 2013 2014 2015 2016 10307 11030 9195 12971 15269

Sporting Goods

(in millions)

Figure 3.13

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

13320 18779 15269

Figure 3.14

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

2016 Consumer Purchases

Equipment Footwear Apparel 13320 18779 15269

Figure 3.15

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

2016 Consumer Purchases

Equipment Footwear Apparel 13320 18779 15269

Figure 3.16

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 Footwear Apparel 13320 18779 15269

2016 Consumer Purchases

Equipment Footwear Apparel 13320 18779 15269

Figure 3.17

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

Equipment 2009 2010 2011 2012 2013 2014 2015 2016 18971 19033 19170 20319 19439 16196 15224 13320 Footwear 2009 2010 2011 2012 2013 2014 2015 2016 12816 13318 13068 12546 13026 11742 16928 18779 Apparel 2009 2010 2011 2012 2013 2014 2015 2016 11127 12035 12845 10307 11030 9195 12971 15269

(in millions)

Consumer Purchases

Equipment 2009 2010 2011 2012 2013 2014 2015 2016 18971 19033 19170 20319 19439 16196 15224 13320 Footwear 2009 2010 2011 2012 2013 2014 2015 2016 12816 13318 13068 12546 13026 11742 16928 18779 Apparel 2009 2010 2011 2012 2013 2014 2015 2016 11127 12035 12845 10307 11030 9195 12971 15269

(in millions)

Consumer Purchases

Equipment 2009 2010 2011 2012 2013 2014 2015 2016 18971 19033 19170 20319 19439 16196 15224 13320 Footwear 2009 2010 2011 2012 2013 2014 2015 2016 12816 13318 13068 12546 13026 11742 16928 18779 Apparel 2009 2010 2011 2012 2013 2014 2015 2016 11127 12035 12845 10307 11030 9195 12971 15269

(in millions)

Consumer Purchases

Apparel 2009 2010 2011 2012 2013 2014 2015 2016 11127 12035 12845 10307 11030 9195 12971 15269 Footwear 12816 13318 13068 12546 13026 11742 16928 18779 Equipment 18971 19033 19170 20319 19439 16196 15224 13320

(in millions)

1

2

3

4

5

6

A

B

C

Consumer Purchases by Category

Sales in millions of dollars

2009

2010

Equipment

18,971

19,033

Footwear

12,816

13,318