Problem 30 Using multiple regression analysis on excel (please show work) Do sch

Question

Problem 30 Using multiple regression analysis on excel (please show work) Do schools with higher Sat scores charge more in tuition and fees ? Are private schools more expensive than public schools when sat scores are in consideration ? Discuss how accurate you believe these results are using information related to recession models . regression mouel. nc sider.) How does this compare to the models e1 30 A sample of nine public universities and nine private New fork Tan Problems 27 and 28? Tigers universities was taken. The total cost for the yeardo (including room and board) and the median SAT score (maximum total is 2400) at each school were Baltimore Or SAT scores would have a better reputation and Oakland Athletics would charge more tuition as a result of that. The Los Ange data is in the table below. Use regression to help an-Seattle Mariners swer the following questions based on this sample data. Do schools with higher SAT scores charge fToronto Blue Jays more in tuition and fees? Are private schools more Minnesota Twins expensive than public schools when SAT scores are Kansas City Royals t les Angels s sample Seattle Mariners Tampa Bay Rays vp Texas Rangers MEDIAN SAT 1990 1620 1810 1540 1540 1600 1560 1890 1620 1630 1840 1980 1930 CATEGORY TOTAL COST (S) Public Public Public Public 21,700 15,600 16,900 15,400 23,100 21,400 16,500 Develop a regre ber of victories on the results accurate this n number of vic Public Public million. Public Public /2 Public 32 In 2009, the games during page lists th run-average of each tea one measu and a lovw is one me 23,500 20,200 30,400 41,500 Private Private 27,100 34,800 32,100 31,800 32,100 r nu Private (a) Deve 2010 1590 1720 pred pre Printed by gary broughan (garybroughan41@live.com) on 129/2016 from206.115 188.114 thonz GPrivate (b) Dev te 146 46 Pinted by gary broughan (garybroughan41 @live.comj on 1/29/2018 from

Explanation / Answer

The regression line for the public schools is Y = 6871.72 + 7.41X

The regression line for the private  schools is Y = 28842.27 +2.92X

hence the schools with higher sat score charge more in tution fees

The intercept for the private schools is greater than public schools. hence private schools more expensive than public schools when sat scores are in consideration.

Coefficients Standard Error t Stat P-value Intercept 6871.719075 11567.15505 0.594072 0.571156 SAT 7.412955064 6.832652065 1.084931 0.313898

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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