For these project assignments throughout the course you will need to

  
For these project assignments throughout the course you will need to reference the data in the ROI Excel spreadheet. Download it here.
Using the ROI data set:For each of the two majors:
 

Draw       the scatter diagram of Y = ‘Annual % ROI’ against X = ‘Cost’.
Obtain       b0 and b1 of the regression equation defined as y ̂ = b0 + b1X and the       coefficient of determination (r2) from the Excel regression output.        
Draw       the fitted regression line on the scatter diagram.
Calculate       the estimated ‘Annual % ROI’ when the ‘Cost’ (X) is $160,000.
Test       the hypothesis:  

o H0: β1 = 0
o Ha: β1 ≠ 0
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.
   
Grading Criteria Assignments
Maximum Points
 
Meets or exceeds established assignment criteria
40
 
Demonstrates an understanding of lesson concepts
20
 
Clearly presents well-reasoned ideas and concepts
30
 
Uses proper mechanics, punctuation, sentence structure,   and spelling
10
 
Total
100

 

"Are you looking for this answer? We can Help click Order Now"