Computer Homework 1
(a) Complete Computer Homework 1 based on Dataset For Computer Homework_Midterm Exam_Final Exam.xlsx in the Computer Homework Module under the Modules tab on CANVAS and based on class discussions, Lecture notes, and the assigned chapters for Classes 1 and 2.
(b) You should let your interpretations and explanations reflect what Safe Sanitation stands for, as defined in the excel sheet Variable Meaning in the Dataset.
An explanation example that reflects what Air quality stands for in the Variable Meaning sheet of the Dataset: Given that the standard deviation is 15 and the mean is 100, it is possible to calculate the range of Air Quality scores within ±2 standard deviations as 100 –(2)(15) to 100 + (2)(15) = 100-30 to 100+30 = 70 to 130. Since Air quality in the Variable Meaning of the Dataset is used to mean % SO2 emission concentration per year, the range of Air Quality scores within ±2 standard deviations is 70% to 130% SO2 emission concentration per year.
(c) You must use SPSS to complete Computer Homework 1, and must submit (1) all the generated SPSS outputs in one single PDF document and (2) all the properly numbered written interpretations/responses in one single Word document in the Computer Homework 1 folder under the Assignments tab on CANVAS by 12pm on January 28.
(d) You will be deducted five points for each part of each question you did not answer.
(e) You will be deducted two points for each wrong calculation and answer.
(f) You will be deducted two points for each wrong interpretation.
(g) You will score zero points for Computer Homework 1 if you fail to submit the specified PDF document and the specified Word document.
Computer Homework 1:- Questions
1. Based on your understanding of relevant class discussions and CANVAS lecture notes,
a. Use SPSS to calculate the appropriate average for each of the following regions from the Dataset: Middle East and North Africa, Sub-Saharan Africa, Latin America and Caribbean, and East Asia and the Pacific.
Note that you must generate region scores using the following values to represent the four regions in column A of the Dataset: Middle East and North Africa = Middle East and North Africa, Sub-Saharan Africa = Sub-Saharan Africa, Latin America and Caribbean = Latin America and Caribbean, and East Asia and the Pacific = East Asia and the Pacific
2. In 150-200 total words, explain whether Region in column A of the Dataset is a nominal, ordinal, interval, or ratio variable.
Defend your explanation as clearly as possible based on relevant Lecture notes on CANVAS.
3. Use SPSS to calculate (i) the mean, (ii) the median, (iii) the mode, (iv) the range, (v) the standard deviation, (vi) the coefficient of variation, (vii) the variance, and (viii) an histogram for the Safe Sanitation scores (scores in column C of the Dataset) of each of the following Regions separately:
a. Middle East and North Africa
b. Sub-Saharan Africa
c. Latin America and Caribbean
d. East Asia and the Pacific, and
Note that your focus is not on the variable region but is on the Safe Sanitation scores for each of the specified regions.
4. Based on chapters 2 and 3 in Salkind, Neil J. Statistics for People Who (Think They) Hate Statistics (5th ed.). (Thousand Oaks, CA: Sage, 2014); and chapters 6 and 7 in Berman, Evan M. and XiaoHu Wang. Essential Statistics for Public Managers and Policy Analysts (3rd ed.). (Los Angeles, CA: Sage/CQ Press, 2012),
a. Compare in 150-250 total words (i) the means and (ii) standard deviations of the four regions in your SPSS outputs for Question 3 above.
b. In 100-150 total words, explain the region with the most representative mean.
Note that most of the Safe Sanitation scores of the region with the most representative mean must be clustered most closely around that region’s mean, as evident in that region’s histogram. The standard deviation for that same region must be greatly small.
c. In 150-250 total words,
i. Compare and discuss the coefficient of variations of the four regions in your SPSS outputs for Question 3 above.
ii. Explain the region with the most representative mean based on the comparison of the coefficient of variations in 4 (ci) above.
iii. Describe how your current conclusion is different from your conclusion for Question 4(b) above when you based your judgment solely on the means and the standard deviations of the four samples.
Note that when samples have different means on a ratio scale, it is misleading to use the standard deviations of the samples to determine the sample with the most representative mean. Instead, the coefficient of variation is more meaningful when samples have different means and are measured in different units on a ratio scale. So the sample with the most representative mean must have the lowest coefficient of variation.Computer Homework 1 Instructions and Questions.pdf