Statistics for Health Care Professionals-Workin?g with Excel

*****Clear instruction is in the attachment.

******To complete data analysis for certain homework problems, you will need to use the Data Analysis Toolpak that can be added into Excel. Please follow the directions that to download the Analysis Toolpak.
https://support.office.com/en-US/article/Video-Install-and-activate-the-Analysis-ToolPak-and-Solver-933F0106-8586-4838-A726-542282B75AAA
*****It a challenge to complete this work on a MAC computer

******Create 1 Excel file to include all work problems per assignment.

? Formulas should be contained in the Excel cells when relevant (i.e. do not “write out” the work in Excel or place pictures of hand written work in Excel, use the Excel functions and capabilities).

? Create a new worksheet for each problem (a new tab in the 1 Excel file), or group of problems, and label the worksheet accordingly (e.g. “p23-Q1” for page 23, question 1).

******To complete data analysis for certain homework problems, you will need to use the Data Analysis Toolpak that can be added into Excel. Please follow the directions that to download the Analysis Toolpak.
https://support.office.com/en-US/article/Video-Install-and-activate-the-Analysis-ToolPak-and-Solver-933F0106-8586-4838-A726-542282B75AAA
*****It a challenge to complete this work on a MAC computer

******Create 1 Excel file to include all work problems per assignment.

?    Formulas should be contained in the Excel cells when relevant (i.e. do not “write out” the work in Excel or place pictures of hand written work in Excel, use the Excel functions and capabilities).

?    Create a new worksheet for each problem (a new tab in the 1 Excel file), or group of problems, and label the worksheet accordingly (e.g. “p23-Q1” for page 23, question 1).

?    I am not picky about how you label the individual problems; just make sure problems are clearly labeled.

?    For written answers, insert a text box into the Excel worksheet, and write in the text box.

Please follow the instruction in the pictures  to complete the work. Pictures can be enlarge.

Work
1)    Page 198; Exercise 6.1 Problem 1

1)    Page 209; Exercise 6.2  Problem 1

2)    Page 209; Exercise 6.2 Problem 8, parts a and c

3)    Page 227; Exercise 6.5 Problem 2

4)    Page 232; Exercise 6.6 Problem 1, parts a, b, and c
5)    Page 232; Exercise 6.6 Problem 2, parts a, b, and c
6)    Page 232; Exercise 6.6 Problem 3, parts a, b, and c
7)    Page 232; Exercise 6.6 Problem 4, parts a, b, and c
Supportive documents

Work

8)    Page 232; Exercise 6.6 Problem 5, parts a and b

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