Question
he table below contains the 2010 obesity rates in U.S. states. Using MS-Excel, calculate the average rate of states by Group and present your summary
he table below contains the 2010 obesity rates in U.S. states. Using MS-Excel, calculate the average rate of states by Group and present your summary in a chart. Copy and paste the chart into MS-Word. Which group of states has the highest obesity rate?
Group A
Group B
Group C
State
Percent(%)
State
Percent(%)
State
Percent(%)
Alabama
32.2
Kentucky
31.3
NorthDakota
27.2
Alaska
24.5
Louisiana
31.0
Ohio
29.2
Arizona
24.3
Maine
26.8
Oklahoma
30.4
Arkansas
30.1
Maryland
27.1
Oregon
26.8
California
24.0
Massachusetts
23.0
Pennsylvania
28.6
Colorado
21.0
Michigan
30.9
RhodeIsland
25.5
Connecticut
22.5
Minnesota
24.8
SouthCarolina
31.5
Delaware
28.0
Mississippi
34.0
SouthDakota
27.3
Washington,DC
22.2
Missouri
30.5
Tennessee
30.8
Florida
26.6
Montana
23.0
Texas
31.0
Georgia
29.6
Nebraska
26.9
Utah
22.5
Hawaii
22.7
Nevada
22.4
Vermont
23.2
Idaho
26.5
New Hampshire
25.0
Virginia
26.0
Illinois
28.2
New Jersey
23.8
Washington
25.5
Indiana
29.6
New Mexico
25.1
West Virginia
32.5
Iowa
28.4
New York
23.9
Wisconsin
26.3
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Practical Financial Management
Authors: William R. Lasher
8th edition
1305637542, 978-1305887237, 1305887239, 978-1305637542
