Question

Use Excel file to submit your work During Evaluation of internal operations, the administrator is concerned that the use of labor and consumable supplies fail to vary directly with the volume of service. To examine the situation, the following data were assembled Volume (Visits) Labor (Hours) Supplies (Units) 7 4 1 8 4 1 12 7 2 11 7 2 17 9 5 20 12 8 22 13 9 24 14 9 1.Use the multiple regression analysis to examine the relationship between the volume and the use of labor and supplies.(Show the result of the analysis) 2.Write the result as APA format. Let α = 0.05.

Answer 1

1. Use the multiple regression analysis to examine the relationship between the volume and the use of labor and supplies.(Show the result of the analysis).

Here, we have to use the multiple regression analysis for the prediction of the dependent variable volume based on the independent variables the use of labor and supplies. The regression model by using excel is given as below:

Regression Statistics
Multiple R	0.993477037
R Square	0.986996624
Adjusted R Square	0.981795273
Standard Error	0.878678253
Observations	8
ANOVA
	df	SS	MS	F	Significance F
Regression	2	293.0146226	146.5073113	189.757759	1.92815E-05
Residual	5	3.860377358	0.772075472
Total	7	296.875
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	2.150943396	1.672409236	1.286134608	0.254730969	-2.148121406	6.450008198
Labor	1.243396226	0.417811859	2.975971598	0.030943254	0.169376651	2.317415802
Supplies	0.452830189	0.456946698	0.99099127	0.367193386	-0.721788693	1.62744907

The regression equation is given as below:

Volume = 2.15 + 1.24*Labor + 0.45*Supplies

2. Write the result as APA format. Let α = 0.05.

The P-value for this regression model is given as 0.00001928 which is very less. P-value is less than level of significance α = 0.05. So, we reject the null hypothesis. There is sufficient evidence to conclude that given regression model is statistically significant for the prediction of the dependent variable volume. The coefficient of determination or the value of R square is given as 0.9870, which means about 98.70% of the variation in the dependent variable volume is explained by the independent variables labor and supplies. The coefficient of the independent variable labor is statistically significant as corresponding p-value is less than α = 0.05. The coefficient of the independent variable supplies is not statistically significant as the corresponding p-value is greater than α = 0.05.