can someone complete this math assignment

Unit 5 Assignment

Complete the following exercise per the instructions below.
Submit a single Excel file with a labeled tab (Question 1). Submit a single Word file with any written answers for your questions (prepare your written answers in “words your grandmother would understand”). Please keep your data sheets in Excel legible and orderly and highlight or bold the answers. Prior to uploading your files to the Assignment Drop Box, name your files with your name and the assignment number (Todd Smith – Unit 5 Assignment). Make sure you run a spell check on your spreadsheet and Word file and complete your written analyses in Word using complete sentences and proper grammar. Use the same techniques we’ve gone over in class and show your work in Excel (I should be able to find your formulas in the appropriate cells).

1. Open and save the Unit 5 Assignment Excel file. Complete the analysis per the instructions below. Interpret your results in a separate Word file.

a) Calculate the correlation coefficient for each pair of variables (Poverty vs. IMR, IMR vs. LEB, and LEB vs. poverty) via the CORREL function (you will have three separate correlation values) b) Create a correlation matrix for the three variables via the Data Analysis Toolpak. Save Time On Research and Writing Hire a Pro to Write You a 100% Plagiarism-Free Paper. Get My Paper c) Create a scatterplot with trend line for each pair of variables (3 separate charts). d) Tell me about each the relationship between each pair of variables (strength, direction, etc.).

2. Describe a research hypothesis and a null hypothesis, the difference between the two, and what makes a good hypothesis. What is meant by a one-tailed and two-tailed hypothesis? Give an example of a related null and research hypothesis, both written and in mathematical notation.

3. Describe a correlation coefficient and tell me about strong and negative relationships (values) with correlation coefficients.

2

>Question

1

Assigment

1

5

6

2

3

3

25

4

2

5

6

25

7

5

8

5 4

9

35 70

27

4 6 77

64 62

25 15

17

45

19

14 14

45

45

68 106

54

23

54

16 6

25

30

45

80

48

27

18 11

10 33 70

49 26 71

30

49

31

70

32

18 13

33

34

11 8 73

35

20 6 76

36

15 5 74

37

8 4 76

25 43 71

38 27 70

40

20

67

41

35 35 70

43

5 17 69

39 118 44

45

20 4 77

46

6 5 78

47

40

52

48

50

48

49

54 19 73

50

11 5 77

51

31

61

52

7 6 78

45

54

47

47

20 128 45

56

80

54

53 33 70

58

8 9 71

59

25 70 63

60

17 38 66

61

40 37 70

62

10

65

63

10 6 77

64

22 6 78

65

8 6 78

66

15 10 75

67

8 4 80

68

30 29 71

69

19 35 68

70

50 76 51

71

15 23 73

72

20 5 73

73

20 11 76

74

40 55 68

75

31

54

76

21 17 69

77

28 28 70

78

49 93 54

79

80

50

80

7 19 70

81

4 18 71

50 95 58

83

53

40

5 8 72

85

53

54

86

40

54

10 19 72

40 27 73

30 27 68

36 61 67

19 45 67

70

42

93

31 79 61

25 56 48

95

31 75 58

10 5 78

20 6 77

48 38 68

99

63

49

60

50

8 4 78

102

16 14 71

24 84 65

104

37 21 74

37 79 59

106

32 27 70

54 42 69

42 31 69

17 9 73

25 5 76

26 21 70

112

18 18 67

113

60 110 41

8 20 72

115

54 68 53

70

39

12 4 78

118

21 9 73

13 5 75

120

80

48

50 54 52

20 6 78

22 17 74

40 67 56

125

8 3 79

6 3 79

127

12 25 69

128

64 54 68

36 90 48

26 22 73

10 26 69

132

32 80 49

21 17 74

7 24 70

20 40 70

58 52 66

35 83 42

29 17 69

9 8 75

17 6 78

12 7 77

27 15 74

143

33 45 68

38 20 73

20 31 68

45 86 59

20 20 73

86 112 41

80 60 43

							Question 1 – Unit												5
Population	Infant	Life
Below	Mortality	Expectancy
Poverty	Rate	at Birth
Country	Line (%)	IMR*	LEB
Afghanistan	5			3	1													6										4
Albania										25	2					9							7
Algeria				36									69
Angola																		70										17	4											8
Argentina								27							19											73
Armenia							35								71
Australia	5.9											78
Austria								77
Azerbaijan							49
							10	Bangladesh											45					58				59
				11	Belarus			23											68
			12	Belgium
		13	Benin					33		99														54
			14	Bhutan				32									80			62
					15	Bolivia				64
		16	Bosnia and Herzegovina							74
Botswana					30		46
					18	Brazil								31		34							67
Bulgaria					72
														20	Burkina Faso			106
					21	Burundi				43
			22	Cambodia										40				86
Cameroon								48			95
		24	Canada						79
Central African Rep.		113
				26	Chad			118
Chile						75
		28	China
		29	Colombia
Congo					60		81
Congo, Dem. Rep.			128					52
Costa Rica							76
Côte d’Ivoire					37		102				47
Croatia
Cuba
Czech Rep.
Denmark
				38	Dominican Rep.
		39	Ecuador
Egypt				41
El Salvador
				42	Eritrea								50				66			51
Estonia
	44	Ethiopia
Finland
France
Gabon		85
Gambia					61
Georgia
Germany
Ghana				63
Greece
				53	Guatemala				56				65
Guinea		115
	55	Guinea-Bissau
Haiti			83
57	Honduras
Hungary
India
Indonesia
Iran
Iraq		104
Ireland
Israel
Italy
Jamaica
Japan
Jordan
Kazakhstan
Kenya
Korea, Dem. People’s Rep.
Korea, Rep. of
Kuwait
Kyrgyzstan
Lao People’s Dem. Rep.			93
Latvia
Lebanon
Lesotho
Liberia	157
Libya
Lithuania
82	Madagascar
Malawi		132
	84	Malaysia
Mali		143
Mauritania		120
87	Mauritius
88	Mexico
89	Moldova, Rep. of
	90	Mongolia
91	Morocco
92	Mozambique		127
Myanmar
94	Namibia
Nepal
96	Netherlands
97	New Zealand
98	Nicaragua
Niger	162
100	Nigeria			112
101	Norway
Oman
103	Pakistan
Panama
105	Papua New Guinea
Paraguay
107	Peru
108	Philippines
109	Poland
	110	Portugal
111	Romania
Russian Federation
Rwanda
114	Saudi Arabia
Senegal
116	Sierra Leone	182
117	Singapore
Slovakia
119	Slovenia
Somalia		125
121	South Africa
122	Spain
123	Sri Lanka
124	Sudan
Sweden
126	Switzerland
Syria
Tajikistan
129	Tanzania
130	TFYR Macedonia
131	Thailand
Togo
133	Trinidad and Tobago
134	Tunisia
135	Turkey
136	Turkmenistan
137	Uganda
138	Ukraine
139	United Arab Emirates
140	United Kingdom
141	United States
142	Uruguay
Uzbekistan
144	Venezuela
145	Viet Nam
146	Yemen
147	Yugoslavia
148	Zambia
149	Zimbabwe
* Reported number of infants dying under a year of age, per one thousand live births