Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

From Calculus To Analysis

Authors: Steen Pedersen

1st Edition

3319136410, 9783319136417

More Books

Students also viewed these Mathematics questions