Question

Given the below information, what is the market value (in dollars) of a MBA?

AutoSave OF BAT-Exam 4 - QSearch Sheet Saved to my Mac Formulas Review View Share Home Insert Draw Page Layout Data Comments nsert A Calibri (Body) General 12 wraa Text Delete w = E 3 IU Av Sensitivity Pasto Idcas Merge & Center v F ttio Table EFormat w Ptulor F32 M A C D. H N P Salary (Y) Experience X 1 Person Regression Statistics Multi 468 340233 62.250 0.85267187 R Square 50.000 Adjusted R Square 4 3 0.83425585 Standard Error 5 4 140,000 11635,9369 Observations 6 110.000 80,050 95,772 ANOVA Significaace E df 5268865527 46.3005598 0.0001372 Regression Residual 1 6268865527 10 87,752 8 1083160213 135395027 11 79.290 10 Total 12 9 7352025740 14 have MBAS Lower 95,0 % Upper 95.0 % Coefficients tandard Erro 45897.1275 8042.47675 5.70683994 0.00045081 27351.1429 64443.1122 27351.1425 4.122 P-value 14 1 Stat Lower 95% Upper 95 % 15 Intercept X Variable 1 8799.4706 1293.19324 6.80445147 0.0001372 5817.36166 11781.5796 5817.36166 11781.5796 17 Equation is Y= 8799.47x+45897.13 18 value is less than .05, so we would reject the null hypothesis. The model is significant at 5%. 19 20 160,000 22 140.00 23 120.000 24 25 100.000 26 80,000 27 60,000 28 43,000 30 20,000 31 32 4. 10 17 33 Experience Question 7 Question 11 Question S E - + 120%

Answer 1

The market value (in dollars) of a MBA is

Y = 8799.47x + 45897.13

945582 = 8799.47x + 45897.13

8799.47x = 899684.87

x = 899684.87/8799.47

x = 102.243

The market value (in dollars) of a MBA is 102.243.