A group of students student gathered following information from web sites of few

Question

A group of students student gathered following information from web sites of few universities. Regress salary offers on their annual tuition and median GMAT score of students admitted to those programs and interpret these results. Please use Excel.
Salary Tuition GMAT $105,100 $72,693 695 $115,478 $80,486 708 $112,318 $77,003 706 $102,637 $70,805 688 $117,520 $75,473 721 $108,975 $72,890 707 $105,063 $59,815 702 $99,647 $60,819 685 $92,316 $51,130 679 $91,608 $64,811 670 $92,039 $65,713 667 $89,678 $49,710 660 $86,252 $40,673 639 $82,764 $38,422 655 $78,080 $56,697 672 $83,515 $32,424 646 $82,754 $62,210 658 $73,748 $28,986 653 $83,536 $55,801 643 $88,782 $30,985 512 A group of students student gathered following information from web sites of few universities. Regress salary offers on their annual tuition and median GMAT score of students admitted to those programs and interpret these results. Please use Excel.
Salary Tuition GMAT $105,100 $72,693 695 $115,478 $80,486 708 $112,318 $77,003 706 $102,637 $70,805 688 $117,520 $75,473 721 $108,975 $72,890 707 $105,063 $59,815 702 $99,647 $60,819 685 $92,316 $51,130 679 $91,608 $64,811 670 $92,039 $65,713 667 $89,678 $49,710 660 $86,252 $40,673 639 $82,764 $38,422 655 $78,080 $56,697 672 $83,515 $32,424 646 $82,754 $62,210 658 $73,748 $28,986 653 $83,536 $55,801 643 $88,782 $30,985 512 A group of students student gathered following information from web sites of few universities. Regress salary offers on their annual tuition and median GMAT score of students admitted to those programs and interpret these results. Please use Excel.
Salary Tuition GMAT $105,100 $72,693 695 $115,478 $80,486 708 $112,318 $77,003 706 $102,637 $70,805 688 $117,520 $75,473 721 $108,975 $72,890 707 $105,063 $59,815 702 $99,647 $60,819 685 $92,316 $51,130 679 $91,608 $64,811 670 $92,039 $65,713 667 $89,678 $49,710 660 $86,252 $40,673 639 $82,764 $38,422 655 $78,080 $56,697 672 $83,515 $32,424 646 $82,754 $62,210 658 $73,748 $28,986 653 $83,536 $55,801 643 $88,782 $30,985 512

Explanation / Answer

On solving given regression using excel, we have

Hence regression line is y = 55526.34 + 0.6287(Tuition) + 4(GMAT)

Regression Statistics Multiple R 0.7950795 R Square 0.6321515 Adjusted R Square 0.5888752 Standard Error 8286.6421 Observations 20

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.