1. The IMR for 20 states randomly selected from the 50 states given on the U.S. IMR worksheet of the file Chpt 4-1.xls (consider using the finite population correction)

PLEASE SHOW WITH EXCEL FORMULAS IN EXCEL FORMAT

State	IMR 1998
Alabama	10.2
Alaska	5.9
Arizona	7.5
Arkansas	8.9
California	5.8
Colorado	6.7
Connecticut	7
Delaware	9.6
Florida	7.2
Georgia	8.5
Hawaii	6.9
Idaho	7.2
Illinois	8.4
Indiana	7.6
Iowa	6.6
Kansas	7
Kentucky	7.5
Louisiana	9.1
Maine	6.3
Maryland	8.6
Massachusetts	5.1
Michigan	8.2
Minnesota	5.9
Mississippi	10.1
Missouri	7.7
Montana	7.4
Nebraska	7.3
Nevada	7
New Hampshire	4.4
New Jersey	6.4
New Mexico	7.2
New York	6.3
North Carolina	9.3
North Dakota	8.6
Ohio	8
Oklahoma	8.5
Oregon	5.4
Pennsylvania	7.1
Rhode Island	7
South Carolina	9.6
South Dakota	9.1
Tennessee	8.2
Texas	6.4
Utah	5.6
Vermont	7
Virginia	7.7
Washington	5.7
West Virginia	8
Wisconsin	7.2
Wyoming	7.2