Assgt_1 - DSCI 3710 EXCEL ASSIGNMENT#1 We assume that all...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
DSCI 3710 EXCEL ASSIGNMENT #1 We assume that all students have had an introduction to Excel. The instructions given below are an outline of the steps you need to take in order to complete your assignment. They should be regarded as a guide and not a detailed map of the procedure. Further help on using Excel is available on for download with the Excel assignment from our course web site and by clicking on the Excel Help menu. Please be sure to read the instructions listed below before you begin the computer exercise . By doing so, you will have a clearer understanding of the purpose of the exercise and how you will conduct the analysis. This could help reduce the amount of time you spend in the computer lab. on this assignment. Case Description Corporations with international operations need to assess the risks associated with setting up and maintaining operations in different regions of the world. Consideration of the risks include considering such issues as political and economic stability. One indicator of the healthcare and quality of life in a country or region that is considered correlated with the risk and stability in the region is the child mortality rate. As a result, the healthcare and quality of care as measured by the child mortality rate in a region can impact the type and amount of investment in a region and countries within a region. The child mortality rate is the number of children 5 and under that die per thousand people in the population. The Inter-agency Group for Child Mortality Estimation (IGME) was obtained from www.childmortality.org. In 2008 the US rate was 7.6 deaths per thousand and in North America (US and Canada) the rate was 6.65 with a standard deviation of 0.68. The Excel file for this assignment has labels for the year, country name, and continent group. NAME OF FIELD DESCRIPTION Country Name of the countries Continent / Region Countries were categories based on region into 8 continents. The coding scheme was 1= South-East Asia, 2 = South Asia, 3 = Western Europe, 4 = Eastern Europe, 5 = Africa, 6 = South America and Islands, 7 = Oceania with Australia and New Zealand, 8 = Middle East, 9 = North America CMR1998 child mortality rate for 1998 CMR2008 child mortality rate for 2008 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Use the provided random sample of observations to test the hypotheses that (i) the mean child mortality rate for countries in Africa is more than the mean Child mortality rate for countries in South Asia. ( α = .05), (ii) the mean child mortality rate for countries in Eastern Europe is more than the mean Child mortality rate for countries in the Middle East. ( α = .01), (iii) the mean child mortality rate for countries in South East Asia is more than the mean Child mortality rate for countries in Western Europe. ( α = .05) by 10 per thousand. 1.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 7

Assgt_1 - DSCI 3710 EXCEL ASSIGNMENT#1 We assume that all...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online