Question
The 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
The 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