. Pie Charts: Using the data in Part 4 of your excel work- book, display the requested information as a 2D and 3D pie chart. a. Create a 2D pie chart that displays the percentages by ethnic background of women students that re- ceived a PhD in 2016. Add data labels to each sec- tion that include only category names, percentages and leader lines, where appropriate. Percentages will be shown to 1 decimal place. Adjust to make the chart the most readable and ensuring all label- ing is correct. The chart will have no legend. b. Create a 3D pie chart that displays the number of men students that received a PhD in 2018. Add data labels to each section that include only cate- gory names, percentages and leader lines, where appropriate. Percentages will be shown to 1 deci- mal place. Set the data series Pie Explosion to Xx%, where xx is your birth month. c. Adjust the individual category labels to make the chart the most readable. The chart will have no leg- end.

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
4. Pie Charts: Using the data in Part 4 of your excel work-
PHDS Awarded to Women in 2016
oner Women ankas nen wones
book, display the requested information as a 2D and 3D
Aaim-Amerikan Wemen
pie chart.
a. Create a 2D pie chart that displays the percentages
apank rin Wm
NAmerkan Wm
by ethnic background of women students that re-
ceived a PhD in 2016. Add data labels to each sec-
tion that include only category names, percentages
Casien Women
Foreigs tesa Women
and leader lines, where appropriate. Percentages
will be shown to 1 decimal place. Adjust to make
the chart the most readable and ensuring all label-
ing is correct. The chart will have no legend.
b. Create a 3D pie chart that displays the number of
PHDS Awarded to Men in 2018
men students that received a PhD in 2018. Add
data labels to each section that include only cate-
Oer Men Ae im Mm Aanelican Mes
SAN
gory names, percentages and leader lines, where
appropriate. Percentages will be shown to 1 deci-
Hp Aerke M
orlve nede
Ndve American
M
Caasian Me
mal place. Set the data series Pie Explosion to
Xx%, where xx is your birth month.
c. Adjust the individual category labels to make the
27
Foreign Natonal Mem
chart the most readable. The chart will have no leg-
end.
Part 4 2D Pie Chart
Part 4 3D Pie Chart
Transcribed Image Text:4. Pie Charts: Using the data in Part 4 of your excel work- PHDS Awarded to Women in 2016 oner Women ankas nen wones book, display the requested information as a 2D and 3D Aaim-Amerikan Wemen pie chart. a. Create a 2D pie chart that displays the percentages apank rin Wm NAmerkan Wm by ethnic background of women students that re- ceived a PhD in 2016. Add data labels to each sec- tion that include only category names, percentages Casien Women Foreigs tesa Women and leader lines, where appropriate. Percentages will be shown to 1 decimal place. Adjust to make the chart the most readable and ensuring all label- ing is correct. The chart will have no legend. b. Create a 3D pie chart that displays the number of PHDS Awarded to Men in 2018 men students that received a PhD in 2018. Add data labels to each section that include only cate- Oer Men Ae im Mm Aanelican Mes SAN gory names, percentages and leader lines, where appropriate. Percentages will be shown to 1 deci- Hp Aerke M orlve nede Ndve American M Caasian Me mal place. Set the data series Pie Explosion to Xx%, where xx is your birth month. c. Adjust the individual category labels to make the 27 Foreign Natonal Mem chart the most readable. The chart will have no leg- end. Part 4 2D Pie Chart Part 4 3D Pie Chart
Excel Charts Project Part 4
1. Create pie charts with the data below as described in the Excel Chart Project handout
2. Set the data series Pie Explosion to xx%, where xx is your birth month.
Data from supplement
Number of Engineering PhDs Awarded
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
African-American Men
103
113
94
114
129
118
112
134
128
140
Asian-American Men
393
373
463
467
445
493
515
556
538
485
Hispanic-American Men
129
149
135
134
152
189
247
230
233
239
Native American Men
14
15
20
18
18
20
11
33
18
20
Caucasian Men
1946
1997
2090
2224
2356
2630
2581
2550
2457
2501
Foreign National Men
4070
3736
4128
4241
4673
4894
4993
4945
5005
5354
Other Men
500
556
564
606
577
449
534
486
490
520
Total Men
7155
6939
7494
7804
8350
8793
8993
8934
8869
9259
African-American Women
50
57
59
76
69
64
60
100
68
81
Asian-American Women
145
173
197
196
206
226
234
227
224
252
Hispanic-American Women
40
66
48
58
75
71
74
72
92
79
Native American Women
8
7
9
3
6
7
8.
7
5
Caucasion Women
564
567
556
639
626
696
758
716
733
795
Foreign National Women
927
985
1069
1081
1263
1306
1405
1441
1452
1489
Other Women
194
201
154
172
172
147
171
156
144
196
Total Women
1928
2056
2088
2231
2414
2516
2709
2720
2720
2897
Transcribed Image Text:Excel Charts Project Part 4 1. Create pie charts with the data below as described in the Excel Chart Project handout 2. Set the data series Pie Explosion to xx%, where xx is your birth month. Data from supplement Number of Engineering PhDs Awarded 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 African-American Men 103 113 94 114 129 118 112 134 128 140 Asian-American Men 393 373 463 467 445 493 515 556 538 485 Hispanic-American Men 129 149 135 134 152 189 247 230 233 239 Native American Men 14 15 20 18 18 20 11 33 18 20 Caucasian Men 1946 1997 2090 2224 2356 2630 2581 2550 2457 2501 Foreign National Men 4070 3736 4128 4241 4673 4894 4993 4945 5005 5354 Other Men 500 556 564 606 577 449 534 486 490 520 Total Men 7155 6939 7494 7804 8350 8793 8993 8934 8869 9259 African-American Women 50 57 59 76 69 64 60 100 68 81 Asian-American Women 145 173 197 196 206 226 234 227 224 252 Hispanic-American Women 40 66 48 58 75 71 74 72 92 79 Native American Women 8 7 9 3 6 7 8. 7 5 Caucasion Women 564 567 556 639 626 696 758 716 733 795 Foreign National Women 927 985 1069 1081 1263 1306 1405 1441 1452 1489 Other Women 194 201 154 172 172 147 171 156 144 196 Total Women 1928 2056 2088 2231 2414 2516 2709 2720 2720 2897
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Research Ethics
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
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