Question

The administrator of a new engineering program at a local college wants to estimate the grade point average in the new program. He thought that the high school GPA, the verbal score on the Scholastic Aptitude Test (SAT), and the mathematics score on the SAT would be good predictors of the engineering GPA. The data on 12 students are: SAT Math SAT EngineeringHigh School 1 Male 0 # Female GPA GPA 507 587 559 3.25 3.81 2.81 2.14 3.5 2.56 2.89 3.13 1.8 3.92 2.69 2.53 1.90 1.53 2.65 3.03 3.07 2.50 1.31 2.95 0.84 2.68 500 430 500 520 533 487 433 570 351 506 577 501 500 10 500 320 12 13 2.63 15 16 1. Develop a correlation matrix 17 2. What is the sample size? 18 3. Conduct a global test of hypothesis to determine whether any of the regression coefficients are significant. (level of significance 0.05) 19 4. Test the regression coetficients individually. Would you consider omitting any variables? If so, which ones? 20 Use the 6 steps of hypothesis testing to show which coefficients. 21 22 5. What would the Engineering GPA be calculated if you are male with a High Scholl GPA of 3.00, an SAT verbal score of 500, and an SAT Math score of 450 23 6. What tis the Standard Error of Estimate? 25

Please help with this statistics problem on EXCEL. If you could please list a step by step on EXCEL if possible. Thank you for your time!

Answer 1

Gven dlata 0533.81 500 u30 562 uoo 281 559 1 533 u 5201 433 516 26S3.S 3.033s6 3.01 9 25 3.13 13118 3- 50 Suo 351 go 2910 500 506 541 3201 501 10 368 63

covelation ai SAT math 0. Gendes obsewation

.8203111 u5113 11.18510 3 IGISE 06 u3 t8 as Total 2426 66 5· 13 여 121 131 M I 00니 GiPA | o-oo o s 2y|-o.。。υ씨' Sf Tven ad-o.oosuolo.ooo 608|-5.589 S 1888 5·13 G&S 226 I 06 ho do oS

)wlun f- valus c aipha 4 -0 SAT vebal SAT matb Geirdea 500 O. co 3u0226 So 0618 12893 '1 |0.000 8616 ( Staundald estwate 0.121860222