Need Help-Computer Homework 7


Need Help-Computer Homework 7

Carefully read the instructions for Computer Homework 7and act accordingly. Carefully read the Late Assignment Submission Policy in the Syllabus. General Instructions: (a) Complete Computer Homework 7 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 the class discussions, lecture notes, and the assigned chapters for class 10. You are strongly advised to carefully read chapter 16 in Salkind, Neil J. Statistics for People Who (Think They) Hate Statistics (5th ed.). (Thousand Oaks, CA: Sage, 2014); and chapters 14 and 15 in Berman, Evan M. and XiaoHu Wang. Essential Statistics for Public Managers and Policy Analysts (3rd ed.). (Los Angeles, CA: Sage/CQ Press, 2012. You are strongly advised to watch the YouTube video “SPSS Aids on Regression with Dummy Variables” under the Announcements tab on CANVAS (b) You must use SPSS to complete Computer Homework 7, 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 7 folder under the Assignments tab on CANVAS by 12pm on October 25. (c) Use the question numbers to organize your responses in the required word document, without including the question words in your responses. (d) You should let your interpretations and explanations reflect what all the continuous variables in the Regression stand 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. (e) You will be deducted five points for each part of each question you did not answer. (f) You will be deducted two points for each wrong calculation and answer. (g) You will be deducted two points for each wrong interpretation. (h) You will score zero points for Computer Homework 7 if you fail to submit the specified PDF document and the specified Word document. Page 2 of 3 Computer Homework 7 i. Use your lecture notes and the assigned readings for class 10 to guide your interpretations. ii. Watch the CANVAS YouTube on “Regression with Dummy Variables” to recode Region in column A of the Dataset into four different dummy variables: Eastern Europe and Central Asia, Latin America and Caribbean, Middle East and North Africa, and Europe). If you are coding Region into Europe, Europe must be “1” and every other region must be “0”. Repeat the same process for every other specified region in (ii) above. iii. Use the most common region in column A in the Dataset as the reference dummy variable. A reference dummy variable must be omitted from the regression computation in SPSS. iv. In one single Regression Analysis at the risk level of 0.05, use SPSS to predict Education from the following independent variables: a. The three relevant dummy variables based on the information in (ii) and (iii) above. b. Sufficient Water c. Safe Sanitation d. GDP. e. Unemployment. Notes: Make sure you check standardized coefficients, if unchecked in SPSS. v. Use SPSS to calculate collinearity diagnostics for all the continuous independent variables. vi. In 100-300 total words, a. identify all the continuous variables from (iv) above b. explain why they are continuous variables. c. identify and explain the continuous variables that are independent variable(s) from (iv) above. d. identify and explain the continuous variables that are dependent variable(s) from (iv) above. vii. In 20-25 total words, use the information in (v) above to explain which of the continuous variables should be dropped from the Regression SPSS output for (iv) above and why. Note: In your explanation, use the real names of the continuous variables. Page 3 of 3 viii. In 20-25 total words, interpret the Adjusted R-square in the SPSS outputs for the Regression in (iv) above . ix. In 100-120 total words, interpret (a) the standardized Coefficient (Beta), (b) the Sig. value, and (c) the 95% Confidence Interval for B [in the Regression SPSS outputs in (iv) above] for each of the three relevant dummy variables in the Regression in relation to the reference dummy variable omitted from the Regression in the Regression SPSS outputs. Note: In your interpretation, use the real names of the dummy variables. x. In 100-120 total words, interpret (a) the Standardized Coefficient (Beta) and (b) the Sig. value [in the Regression SPSS outputs for (iv) above] for each of the continuous independent variables. Note: In your interpretation, use the real names of the continuous variables.

Need Help-Computer Homework 7

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: