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 DescriptionCorporations 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 thechild 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 DESCRIPTIONCountry Name of the countries Continent / Region Countries were categories based on regioninto 8 continents. The coding scheme was1= 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 AmericaCMR1998 child mortality rate for 1998CMR2008 child mortality rate for 2008Use the provided random sample of observations to test the hypotheses that1(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. You will need to have the data file for this assignment (Assgt#1.xls) copied onto a disk or flashdrive. You can do this in a variety of ways. Perhaps the easiest way is to simply copy all the relevant files for the Excel assignments. These files reside on the course web site on the Excel files page that you can find by clicking on the Excel files link near the top of the page. 2. Click on the file to download and allow about a half minute for the downloading to be completed.Beginning with the standard screen in the COBA computer labs:3. Click on Spreadsheets & Database, then on Microsoft Excel 2007.4. Click on File Open, click on Look In, then on the down arrow. Choose the address where the data file resides and select Assgt#1.xls5. Highlight the all data and Sort by Continent (region). The data is shown below before and afterthe sort Original dataCountry Region CMR1998 CMR2008Afghanistan 2 257 257Algeria 5 49.4 37Angola 5 213.9 158Argentina 6 23.6 16.2Australia 7 6.6 5.7Bahrain 8 14.1 10.2Belarus 4 19.8 13.4Sorted dataCountry Region CMR1998 CMR2008Brunei 1 8.92 8.8Indonesia 1 58.8 31.2Korea, Dem. Rep. 1 55 556. Copy the net child mortality rates for the sample of countries in Africa (Continent = 5) and paste these values into a new column, beginning at the second row. Put a title (label) at the top ofthis new column to indicate what the values represent (e.g., Africa-CMR2008). Next, copy the net income for child mortality rates for the sample of countries in the South Asia (Continent = 2) 2and paste these values in the column adjacent to the first new column. Put a title (label) at the topof the newest column to indicate what these values represent (e.g., SoAsia-CMR2008).Please note that in these two new columns you should have numbers representing child mortality rates per 1000 and NOT the 5s or 2s! The table below shows what the first lines in your two new columns should resemble.Africa2008 So-Asia200837 257158 847. Select the Data tab then Click on Data Analysis (In Office 2003 - Click on Tools then Data Analysis), then on descriptive statistics and check the ‘summary statistics’ box. Examine that dataand consider its meaning. Africa2008 So-Asia2008 Mean 137.175 Mean 105.0175Standard ErrorMedianModeStandard DeviationSample Variance 2748.53671 Sample Variance 11411.13KurtosisSkewnessRangeMinimumMaximumSumCount 20 Count 48. Once the descriptive statistics are examined, repeat the steps to get to Excel Data Analysis macros and select the t-test: Two-Sample Assuming Unequal Variances. Then set the cursor in the Variable 1 box, and then highlight the column with Africa-CMR2008 data. Repeat with the Variable 2 box and the SoAsia-CMR2008 data.9. Click in the labels box to put a check mark, and take the default .05 significance level.10. Enter 0 (the number zero) in the box for hypothesized mean difference.11. Click on the Output Range radio button then set the cursor in the box beside it and choose any convenient 13 row x 4 column space in your current Excel spreadsheet. Click on O.K.12. Excel will then complete the independent two-samples t-test and place the output in the space3that you named. Expand the column widths if necessary to reveal all of the output without truncation. Your output might resemble the truncated version of the output shown below:t-Test: Two-Sample Assuming Unequal Variances Africa2008 So-Asia2008Mean 137.175 105.0175Variance 2748.53671 11411.12789Observations 20 4Hypothesized Mean Differencedft StatP(T<=t) one-tailt Critical one-tailP(T<=t) two-tailt Critical two-tail13. Repeat steps 6 and 8-12 but with CMR data for countries in the Eastern European Region (4)and the