Chat with us, powered by LiveChat MA215 Grantham University ROI Data Project | acewriters
+1(978)310-4246 credencewriters@gmail.com
Select Page

Project Week 7Using 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:
H0: β1 = 0Ha: β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.Data attached
w7_cruzj_major.xlsx

Unformatted Attachment Preview

School Type
Private
Private
Private
Public
Private
Public
Private
Private
Private
Private
Private
Private
Private
Private
Private
Public
Public
Private
Private
Private
Best College ROI by Majo 2013: Payscale.com
Cost
\$222.700,00
\$176.400,00
\$212.200,00
\$125.100,00
\$212.700,00
\$92.910,00
\$214.900,00
\$217.800,00
\$225.600,00
\$217.300,00
\$226.500,00
\$215.500,00
\$223.500,00
\$226.600,00
\$189.300,00
\$89.700,00
\$87.030,00
\$218.200,00
\$229.900,00
\$148.800,00
30 Year ROI
\$1.786.000,00
\$1.758.000,00
\$1.714.000,00
\$1.535.000,00
\$1.529.000,00
\$1.501.000,00
\$1.485.000,00
\$1.483.000,00
\$1.444.000,00
\$1.442.000,00
\$1.441.000,00
\$1.438.000,00
\$1.428.000,00
\$1.414.000,00
\$1.397.000,00
\$1.382.000,00
\$1.376.000,00
\$1.343.000,00
\$1.339.000,00
\$1.321.000,00
Annual ROI
7,70%
8,40%
7,80%
9,10%
7,40%
10,10%
7,30%
7,20%
7,00%
7,10%
7,00%
7,20%
7,00%
7,00%
7,50%
9,90%
10,00%
6,90%
6,70%
8,10%
School Type
Private
Private
Private
Private
Private
Public
Private
Private
Public
Private
Public
Private
Public
Private
Public
Public
Public
Public
Private
Public
Cost
\$221.700,00
\$213.000,00
\$230.100,00
\$222.600,00
\$225.800,00
\$87.660,00
\$224.900,00
\$221.600,00
\$125.100,00
\$215.700,00
\$92.530,00
\$217.800,00
\$89.700,00
\$229.600,00
\$101.500,00
\$115.500,00
\$104.500,00
\$69.980,00
\$219.400,00
\$64.930,00
30 Year ROI
Annual ROI
\$2.412.000,00
8,70%
\$2.064.000,00
8,30%
\$1.949.000,00
7,90%
\$1.947.000,00
8,00%
\$1.938.000,00
8,00%
\$1.937.000,00
11,20%
\$1.915.000,00
7,90%
\$1.878.000,00
7,90%
\$1.854.000,00
9,80%
\$1.794.000,00
7,90%
\$1.761.000,00
10,60%
\$1.752.000,00
7,70%
\$1.727.000,00
10,70%
\$1.716.000,00
7,50%
\$1.703.000,00
10,20%
\$1.694.000,00
9,70%
\$1.690.000,00
10,10%
\$1.685.000,00
11,50%
\$1.676.000,00
7,60%
\$1.668.000,00
11,70%

Our essay writing service fulfills every request with the highest level of urgency
attachment

error: Content is protected !!