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: 1. Draw the scatter diagram of Y = ‘Annual % ROI’ against X = ‘Cost’

  

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:

 

1. Draw       the scatter diagram of Y = ‘Annual % ROI’ against X = ‘Cost’.
2. Obtain       b0 and b1 of the regression equation defined as y ̂ = b0 + b1X and the       coefficient of determination (r2) from the Excel regression output.        
3. Draw       the fitted regression line on the scatter diagram.
4. Calculate       the estimated ‘Annual % ROI’ when the ‘Cost’ (X) is $160,000.
5. 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