# Outstanding Multiple Linear Regression Equations Homework Help

Students seeking multiple linear regression equations homework help can now breathe a sigh of relief. Our statistics homework helpers have an arsenal of statistics tools needed to produce top-grade solutions. We urge you to get our multiple linear regression equations homework help if you are facing time crunch, do not have in-depth knowledge of the topic assigned to you, or stressed by your upcoming deadline. We have an anti-dote to all your homework worries. So talk to us now.

## Multiple Regression Equations

In this homework you will examine regression assumptions in multiple regression equations present given the dataset posted to Moodle for this week. Use the notes and other resources posted in Moodle for this week to support your investigation. Report all relevant tables and charts to justify your work and be sure they are formatted to class expectations.
Response variable: The response variable is also known as the dependent variable which all other independent or explanatory variables depends on. Hence, for the purpose of this study the selected response variable is total expenditure because all other variables depend on this. The number of admission will increase the total expenditure or reduce it. Similarly, number of births and personnel were all depending on the total expenditure.

## Descriptive statistics Estimates

Table 1: Descriptive statistics
Admission Births Payroll Exp Personnel Tot Exp
Mean 6831.84 874.05 30500.89 861.5 67139.81
Median 4777 480 20739.5 589.5 43364.5
Variance 44171146 1131385 1.07E+09 675021.6 4.95E+09
Std deviation 6646.138 1063.67 32715.84 821.597 70386.44
Skewness 1.6109 1.5898 2.2307 1.7909 2.0073
Kurtosis 3.0956 2.5195 6.0754 3.1891 4.5156
Minimum 111 0 1053 50 2082
Maximum 37375 5691 188865 4087 367706

A normal bell shaped distribution has exactly 3. A distribution with kurtosis less than 3 is called platykurtic compared to a normal distribution, its tail are shorter and thinner and often its central peak is lower and broader. From the descriptive table above payroll expense has a kurtosis value closer to 3 as we can see above; hence its distribution will likely be bell-shaped.

## Correlation matrix

Table 2: correlation with response variable

Admissions Births Payroll Exp. Personnel Tot. Exp.
Births 0.855624 1
Payroll Exp. 0.848209 0.659576079 1
Personnel 0.879457 0.697463374 0.95187 1
Tot. Exp. 0.90249 0.713219085 0.982541 0.964709 1
From the correlation table above the variable payroll expense has the highest correlation with the response variable with the correlation coefficient between both variable (r=0.9825). This means there is a strong positive correlation between both variable total expenditure and payroll expense.
Scatter plot between Total expenditure and payroll expense. ## Evidence of Multi collinearity

Table 3: Correlation matrix of independent variable
Births 0.855624455 1
Payroll Exp. 0.848209291 0.659576 1
Personnel 0.879456785 0.697463 0.951870085 1
Multicollinearity is a phenomenon in which one predictor variable in a multiple regression model can be linearly predicted from the others with a substantial degree of accuracy. From the table above, there is multicollinearity between payroll expense and personnel. Similarly, there is multicollinearity between Admission and Births, Admission and Payroll expense, Admission and personnel with the correlation coefficients between these variables greater than 0.80.

## Multiple Regression Assumptions

No Multicollinearity: The greatest assumptions of multiple regression analysis are that the independent variables were not highly correlated. From the table 3 above which shows the correlation matrix of all independent variable in this study, we observe a high correlation between pairs of independent variable in this study which means this assumption is violated.
Linearity: This assumption states that there must be linear relationship between the response variable and the independent variable this assumption is not violated.
Homoscedasticity: The variance of error terms is identical around the values of the independent variables, according to this assumption. The distribution of points across all values of the independent variables can be determined by plotting uniform residuals versus expected values. This assumption is also not violated.
##### Multiple regression equation
Table 4: Multiple regression model
Coefficient B(Std. Err.) t-value p-value
Intercept -2607.73(934.288) -2.791 0.006
Admission Births Payroll Exp Personnel 2.493(0.285)-1.781(1.179)-1.409(0.063)13.101(2.793) 8.748 -1.510 22.261 4.691 1.02E-15 0.133 1.92E-55 5.11E-06