Question: Using the Afrobarometer Dataset a multiple regression analysis was performed with the outputs below. Based on these results a) What is the possible research question?
Using the Afrobarometer Dataset a multiple regression analysis was performed with the outputs below. Based on these results
a) What is the possible research question?
b) What is the null hypothesis for the question?
c) What research design would align with this question?
d) What dependent variable was used and how is it measured?
e) What independent variables are used and how are they measured? What is the justification for including these predictor variables?
f) If you found significance, what is the strength of the effect?
g) Explain your results for a lay audience, and explain what the answer to your research question.
| Descriptive Statistics | |||
| Mean | Std. Deviation | N | |
| Trust in Government Index (higher scores=more trust) | 8.0244 | 4.20829 | 9482 |
| Q1. Age | 36.88 | 14.231 | 9482 |
| Q101. Gender of respondent | 1.49 | .500 | 9482 |
| Education Category | 1.46 | .957 | 9482 |
| Employment Status | .3342 | .47174 | 9482 |
| Lived Poverty Index (average index of 5 poverty items) | 1.237 | .9486 | 9482 |
| Correlations | |||||||
| Trust in Government Index (higher scores=more trust) | Q1. Age | Q101. Gender of respondent | Education Category | Employment Status | Lived Poverty Index (average index of 5 poverty items) | ||
| Pearson Correlation | Trust in Government Index (higher scores=more trust) | 1.000 | .081 | -.015 | -.174 | -.073 | -.022 |
| Q1. Age | .081 | 1.000 | -.111 | -.265 | -.004 | .042 | |
| Q101. Gender of respondent | -.015 | -.111 | 1.000 | -.104 | -.127 | .001 | |
| Education Category | -.174 | -.265 | -.104 | 1.000 | .260 | -.231 | |
| Employment Status | -.073 | -.004 | -.127 | .260 | 1.000 | -.192 | |
| Lived Poverty Index (average index of 5 poverty items) | -.022 | .042 | .001 | -.231 | -.192 | 1.000 | |
| Sig. (1-tailed) | Trust in Government Index (higher scores=more trust) | . | <.001 | .071 | <.001 | <.001 | .016 |
| Q1. Age | .000 | . | .000 | .000 | .333 | .000 | |
| Q101. Gender of respondent | .071 | .000 | . | .000 | .000 | .478 | |
| Education Category | .000 | .000 | .000 | . | .000 | .000 | |
| Employment Status | .000 | .333 | .000 | .000 | . | .000 | |
| Lived Poverty Index (average index of 5 poverty items) | .016 | .000 | .478 | .000 | .000 | . | |
| N | Trust in Government Index (higher scores=more trust) | 9482 | 9482 | 9482 | 9482 | 9482 | 9482 |
| Q1. Age | 9482 | 9482 | 9482 | 9482 | 9482 | 9482 | |
| Q101. Gender of respondent | 9482 | 9482 | 9482 | 9482 | 9482 | 9482 | |
| Education Category | 9482 | 9482 | 9482 | 9482 | 9482 | 9482 | |
| Employment Status | 9482 | 9482 | 9482 | 9482 | 9482 | 9482 | |
| Lived Poverty Index (average index of 5 poverty items) | 9482 | 9482 | 9482 | 9482 | 9482 | 9482 |
| Model Summaryb | ||||||||||
| Model | R | R Square | Adjusted R Square | Std. Error of the Estimate | Change Statistics | PRESS | ||||
| R Square Change | F Change | df1 | df2 | Sig. F Change | ||||||
| 1 | .196a | .038 | .038 | 4.12777 | .038 | 75.693 | 5 | 9476 | <.001 | 161664.856 |
| a. Predictors: (Constant), Lived Poverty Index (average index of 5 poverty items), Q101. Gender of respondent, Q1. Age, Employment Status, Education Category | ||||||||||
| b. Dependent Variable: Trust in Government Index (higher scores=more trust) |
| ANOVAa | ||||||
| Model | Sum of Squares | df | Mean Square | F | Sig. | |
| 1 | Regression | 6448.498 | 5 | 1289.700 | 75.693 | <.001b |
| Residual | 161456.874 | 9476 | 17.039 | |||
| Total | 167905.372 | 9481 | ||||
| a. Dependent Variable: Trust in Government Index (higher scores=more trust) | ||||||
| b. Predictors: (Constant), Lived Poverty Index (average index of 5 poverty items), Q101. Gender of respondent, Q1. Age, Employment Status, Education Category |
| Coefficientsa | ||||||||||
| Model | Unstandardized Coefficients | Standardized Coefficients | t | Sig. | 95.0% Confidence Interval for B | Collinearity Statistics | ||||
| B | Std. Error | Beta | Lower Bound | Upper Bound | Tolerance | VIF | ||||
| 1 | (Constant) | 9.749 | .233 | 41.754 | <.001 | 9.291 | 10.206 | |||
| Q1. Age | .010 | .003 | .034 | 3.171 | .002 | .004 | .016 | .907 | 1.102 | |
| Q101. Gender of respondent | -.297 | .087 | -.035 | -3.426 | <.001 | -.467 | -.127 | .958 | 1.044 | |
| Education Category | -.763 | .049 | -.174 | -15.613 | <.001 | -.859 | -.667 | .821 | 1.217 | |
| Employment Status | -.411 | .095 | -.046 | -4.346 | <.001 | -.597 | -.226 | .901 | 1.110 | |
| Lived Poverty Index (average index of 5 poverty items) | -.321 | .046 | -.072 | -6.914 | <.001 | -.412 | -.230 | .926 | 1.079 | |
| a. Dependent Variable: Trust in Government Index (higher scores=more trust) |
| Collinearity Diagnosticsa | |||||||||
| Model | Dimension | Eigenvalue | Condition Index | Variance Proportions | |||||
| (Constant) | Q1. Age | Q101. Gender of respondent | Education Category | Employment Status | Lived Poverty Index (average index of 5 poverty items) | ||||
| 1 | 1 | 4.583 | 1.000 | .00 | .00 | .00 | .01 | .01 | .01 |
| 2 | .706 | 2.548 | .00 | .00 | .00 | .02 | .60 | .10 | |
| 3 | .336 | 3.694 | .00 | .00 | .01 | .31 | .35 | .36 | |
| 4 | .231 | 4.458 | .00 | .15 | .03 | .33 | .00 | .44 | |
| 5 | .121 | 6.165 | .00 | .40 | .44 | .08 | .03 | .00 | |
| 6 | .025 | 13.637 | .99 | .45 | .52 | .26 | .01 | .09 | |
| a. Dependent Variable: Trust in Government Index (higher scores=more trust) |
| Residuals Statisticsa | |||||
| Minimum | Maximum | Mean | Std. Deviation | N | |
| Predicted Value | 5.5758 | 10.4233 | 8.0244 | .82471 | 9482 |
| Residual | -9.94770 | 8.82649 | .00000 | 4.12668 | 9482 |
| Std. Predicted Value | -2.969 | 2.909 | .000 | 1.000 | 9482 |
| Std. Residual | -2.410 | 2.138 | .000 | 1.000 | 9482 |
| a. Dependent Variable: Trust in Government Index (higher scores=more trust) |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
