First, enter manually into Excel the data set accompanying this exercise. Second, calculate the % population black for each state. You can use an Excel formula (e.g., =e2/c2*100). If you do not know how use formulas in Excel, there's a video on the topic on this week's Resources page. (You should notice that I gave you the number of people Black in each state but not the % Black.)
First, enter manually into Excel the data set accompanying this exercise. Second, calculate the % population black for each state. You can use an Excel formula (e.g., =e2/c2*100). If you do not know how use formulas in Excel, there's a video on the topic on this week's Resources page. (You should notice that I gave you the number of people Black in each state but not the % Black.)
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
First, enter manually into Excel the data set accompanying this exercise.
Second, calculate the % population black for each state. You can use an Excel formula (e.g., =e2/c2*100). If you do not know how use formulas in Excel, there's a video on the topic on this week's Resources page. (You should notice that I gave you the number of people Black in each state but not the % Black.)
Transcribed Image Text:State
Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
District of Columbia
Florida
Georgia
Hawall
Idaho
Tilinols
Indiana
lowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Virginia
Washington
West Virginia
RegloaName RegionNumber NorthEast Midwest Seuth West ViolentCrimeRate2019 Population 2018 Poverty Rate 2019 Black2018 Biden
0
0
1
0
4903185
0
0
0
1
0
0
0
1
0
0
1
0
0
0
0
1
0
0
1
0
0
0
0
1
0
0
1
0
0
1
0
0
1
0
731545
7278717
3017004
39512223
5758736
3565207
973764
705749
21477737
10617423
1415872
1707065
12671821
6732219
3155070
2913314
4467673
4648794
1344212
6045690
0
0
1
0
0
1
0
0
0
0
0
D
0
1
1
0
1
0
6892503
0
0
1
14.7 1296162 0
118
21093 0
12.1 339150 1
150 453783 0
114 2237044 1
9.1 234828 1
9.7 388675 1
7.6 218899 1
13.7 285010 1
12.9 3246381 0
13.3 3320513 1
94
23417 1
10.0
15726 0
104 1800271
1
11.1 648513 0
8.6 131972 0
10.4 168809 0
142 362417 0
19.1 1464023 0
115
25752 1
7.5 1820472 1
92 494029 1
107 1376579 1
7.4 398434 0
19.1 1034481 0
11.0 699940 0
10.1
5484 10
10.3
96535 O
122 304739 1
5.6
20127 1
1219770 1
172
45904 1
121 2986172 1
13.6 2140217 0
10.1
26783 0
124 1478781 0
124 289961 0
9.8
82655 1
10.5 1423169 I
98
62168 1
14.4 1280531 0
106
17842 0
121 1092948 0
127 3552997 0
7.6 40058 0
9034 1
1607581 1
307565 1
65813
0
0
0
0
0
0
9986857
5639632
2976149
6137428
1068778
1934408
3080156
1359711
8882190
2096829
19453561
10488084
762062
11689100
3956971
4217737
12001989
1059361
5148714
0
0
1
0
0
1
0
0
0
1
0
884659
6329174
1
1
0
0
28995681
3205958
623989
8535519
7614893
1
9.0
9.7
Q.B
156
0
1792147
South
West
West
South
West
West
Northeast
South
South
South
South
West
West
Midwest
Midwest
Midwest
Midwest
South
South
Northeast
South
Northeast
Midwest
Midwest
South
Midwest
West
Midwest
West
Northeast
Northeast
West
Northeast
South
Midwest
Midwest
South
West
Northeast
Northeast
South
Midwest
South
South
West
Northeast
South
West
South
3
4
4
3
4
4
1
3
3
3
3
4
4
2
2
2
2
3
3
I
3
1
2
2
3
4
2
4
1
1
1
3
2
2
3
1
1
3
2
3
3
4
1
3
3
0
I
0
0
0
0
0
0
0
0
0
0
0
0
I
0
1
0
0
0
0
0
0
0
1
1
0
1
0
0
0
0
0
1
1
0
0
0
0
0
1
0
0
1
1
1
1
0
0
0
0
0
1
1
0
1
0
1
0
0
0
0
0
0
1
1
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
D
D
0
0
0
0
1
0
1
0
0
1
0
0
0
0
0
1
0
0
0
0
0
0
1
0
0
1
5108
867.1
455.3
5046
4412
3910
1036
422.6
10490
3784
3407
285.5
223.8
4069
370.8
2666
4108
217.1
5493
1152
454.1
3276
4374
2364
277.9
495.0
404.9
300.9
493.8
1525
2069
8322
358.6
371B
2846
2932
4318
2044
306-4
221.1
5113
399.0
595.2
4189
2356
2022
208.0
2939
3166
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
From the states data set, get the
Solution
by Bartleby ExpertRecommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman