Selecting Variables into a Regression Equation Assignment

Selecting Variables into a Regression Equation - Assignment Example and $100,000p.a., Above $100,000), density of population in neighborhood (low, medium, or high). The data comprises of 31 observations for each variable. Using step wise approach to predicting the relationship between the dependent variable and independent variables, the correlations between these variables are determined as follows: From the above table, the significant relationships are indicated between number of injuries and parenting status and density of population. There is a positive relationship between number of injuries and parenting status and there is a negative relationship between number of injuries and density of population. Using MS Excel the following regression output is achieved. The regression model is only able to explain 5.8% of the total variations observed in 31 data entries (Kedem & Fokianos, 2002). The above table indicates coefficients of correlation between dependent variable and independent variables. The following regression equation is achieved: From the regression equation, it could be predicted that there is a negative relationship but not significant (p