SBA 215 Project Week 7 solution

5 Oct No Comments

Using the ROI data set:

For each of the two majors:

Draw the scatter diagram of Y = ‘Annual % ROI’ against X = ‘Cost’.

The obtained two diagrams are given below,

Obtain b0 and b1 of the regression equation defined as y ̂ = b0 + b1X and the coefficient of determination (r2) from the Excel regression output.  

For Business Major, the obtained output is given below.

SUMMARY OUTPUT      
       
     
Multiple R0.9701     
R Square0.9410     
Adjusted R Square0.9377     
Standard Error0.0027     
Observations20     
       
ANOVA      
 dfSSMSFSignificance F 
Regression10.00220.0022287.22070.0000 
Residual180.00010.0000   
Total190.0023    
       
 CoefficientsStandard Errort StatP-valueLower 95%Upper 95%
Intercept0.11800.002448.58620.00000.11290.1231
Cost-2.11204E-071.24622E-08-16.947586191.64456E-12-2.37386E-07-1.85022E-07

From the above output we can see that b0 = 0.1180 and b1= -2.11204E-07 thus the regression equation is,

Y = 0.1180-2.11204E-07*X

For Engineering Major, the obtained output is given below.

SUMMARY OUTPUT      
       
     
Multiple R0.9754     
R Square0.9515     
Adjusted R Square0.9488     
Standard Error0.0033     
Observations20     
       
ANOVA      
 dfSSMSFSignificance F 
Regression10.00390.0039352.87380.0000 
Residual180.00020.0000   
Total190.0041    
       
 CoefficientsStandard Errort StatP-valueLower 95%Upper 95%
Intercept0.12680.002062.73720.00000.12250.1310
Cost-2.1455E-071.14214E-08-18.784934832.83396E-13-2.38545E-07-1.90554E-07

From the above output we can see that b0 = 0.1268 and b1= -2.1455E-07 thus the regression equation is,

Y = 0.1268-2.1455E-07*X

Draw the fitted regression line on the scatter diagram.

The plots are given below,

Calculate the estimated ‘Annual % ROI’ when the ‘Cost’ (X) is $160,000.

The estimated ‘Annual % ROI’ when the ‘Cost’ (X) is $160,000 is,

For Business Major = 8.42% and for Engineering Major = 9.25%

Test the hypothesis: 

H0: β1 = 0

Ha: β1 ≠ 0

From the above output, the p-values for both the Business Major and Engineering Major are very small indicating that the above null hypothesis is rejected.

Write a paragraph or more on any observations you make about the regression estimates, coefficient of determination, the plots, and the results of your hypothesis tests.

In working this out, both the regression model are significant at 5% significance level (the F test has small p-value). The coefficient of determination indicated that the models are good fit to the data. Thus the above models can be used to predict the dependent variable Annual ROI from the independent variable cost.




Click following link to download this document

SBA 215 Project Week 7 solution.docx

To view and download a complete answer, scroll down to the bottom to pay Pay to view


Would you like your assignment done free from plagiarism by an expert? Place your order now and it shall be done within the time frame you indicate.