- Question Two 2 The Following Regression And Correlation Analysis Output Is From An Independent Study Of The Shares Com 1 (56.22 KiB) Viewed 13 times
QUESTION TWO (2) The following regression and correlation analysis output is from an independent study of the shares company of employee, x2 consecutive dividends, x3 beginning inventory that might affect the gross profit of a sample of 20 firms. Use it to answer the questions that follows. The correlation matrix y Y X1 X2 X ANOVA Source Regression Error Total Intercept X1 X2 X3 1.00000 0.76961 0.58244 0.805854 df 3 Least Square Estimates 16 19 Coefficients H1=- 8.254988 0.042144 0.001154 0.003951 X1 0.76961 1.000000 0.648481 0.679212 Cor(X1, X3)=- Cor (X2, X3)=_ SS 8562.20 * 1155.19 Standard Error 6.624736 0.019461 0.136537 0.001359 X2 0.58244 0.648481 1.000000 0.597565 MS ** 186.94 t-stat 1.246086 2.165538 0.008452 2.907882 X3 0.80585 0.67921 0.59757 1.00000 F 15.27 P-value A. What is the sample size of this data? B. Write out the estimated regression equation? C. Compute SS for the Error Source*, and the MS for the regression source** 0.23067 0.0458 0.99361 0.010272 SSE= MSR= D. List down the correlations between all the pairs of the variables. Cor(y,X1)=---- Cor(y,X2)=- Cor(y,X3)=- Cor(X1, X2)=- E. Conduct a global test of hypothesis to determine whether all of the regression coefficients are significant. Use @=0.05 Ho H1=- Test Statistic F: Critical F=- Decision = F. Is the variable X2 significant? Conduct a test hypothesis. Use @-0.05. Ho=--------... ,Pvalue= Decision=