Golf Equipment Purchases by Age & Gender Age US Population 2013 2012 2011 2010 Under 14 19.80% 3.00% 1.00% 3.00% 2.00% 14-17 5.70% 7.00% 4.00% 7.00% 3.00% 18-24 9.70% 6.00% 6.00% 5.00% 2.00% 25-34 13.50% 22.00% 14.00% 18.00% 15.00% 35-44 16.20% 19.00% 18.00% 21.00% 23.00% 45-64 22.40% 32.00% 45.00% 33.00% 40.00% 55 & Older 12.70% 11.00% 12.00% 13.00% 15.00% Total 100.00% 100.00% 100.00% 100.00% 100.00% Gender Male 48.90% 88.00% 88.00% 79.00% 89.00% Female 51.10% 12.00% 12.00% 21.00% 11.00% Total 100.00% 100.00% 100.00% 100.00% 100.00%

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

The data in the picture contains purchase data for golf purchases. Create a doughnut chart  in Excel to compare the purchases by gender each year with the US population. Below the chart, explain what it illustrates.

Golf Equipment Purchases by Age & Gender
Age
US Population
2013
2012
2011
2010
Under 14
19.80%
3.00%
1.00%
3.00%
2.00%
14-17
5.70%
7.00%
4.00%
7.00%
3.00%
18-24
9.70%
6.00%
6.00%
5.00%
2.00%
25-34
13.50%
22.00%
14.00%
18.00%
15.00%
35-44
16.20%
19.00%
18.00%
21.00%
23.00%
45-64
22.40%
32.00%
45.00%
33.00%
40.00%
55 & Older
12.70%
11.00%
12.00%
13.00%
15.00%
Total
100.00%
100.00%
100.00%
100.00%
100.00%
Gender
Male
48.90%
88.00%
88.00%
79.00%
89.00%
Female
51.10%
12.00%
12.00%
21.00%
11.00%
Total
100.00%
100.00%
100.00%
100.00%
100.00%
Transcribed Image Text:Golf Equipment Purchases by Age & Gender Age US Population 2013 2012 2011 2010 Under 14 19.80% 3.00% 1.00% 3.00% 2.00% 14-17 5.70% 7.00% 4.00% 7.00% 3.00% 18-24 9.70% 6.00% 6.00% 5.00% 2.00% 25-34 13.50% 22.00% 14.00% 18.00% 15.00% 35-44 16.20% 19.00% 18.00% 21.00% 23.00% 45-64 22.40% 32.00% 45.00% 33.00% 40.00% 55 & Older 12.70% 11.00% 12.00% 13.00% 15.00% Total 100.00% 100.00% 100.00% 100.00% 100.00% Gender Male 48.90% 88.00% 88.00% 79.00% 89.00% Female 51.10% 12.00% 12.00% 21.00% 11.00% Total 100.00% 100.00% 100.00% 100.00% 100.00%
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Charts and Graphs for Data Visualization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman