Data: Use Excel and the undergraduate data set Fall 2020. Assignment: You have a sample of 50 randomly selected undergraduate students. First, evaluate the relationship between GPA, School Status & Satisfaction with Advisement and Expected Salary. Second, evaluate the relationship between GPA, School Status (O=FT/1=PT) & Satisfaction with Advisement and Annual Salary in 5 Years. Describe the output of each model. Is the model significant, how strong is the relationship? Are the coefficients significant? What do the models predict for Expected Salary and Annual Salary in 5 Years for a part-time student with a GPA of 3.5 and Satisfaction with Advisement of 3.8? Build one other regression model using GPA as the outcome lice, dependent) variable and School Status, Employment Status (Omunemployed, 1-employed), # of Affiliations, an Satisfaction with Advisement as independent variables. Describe the output of your model in terms of significance, strength, and the variables. If you needed to share the output of your model with the undergraduate Dean of Students, what would you tell her about the relationships you had found? Summarize your conclusions in memo format, addressed to me. Your report should be well organized and be written in a professional manner. Submission: Submit your memo and any accompanying tables in Canvas. 200+ SE ESSET ***NONS 3 un pt DI ID Num Age Height Class Major School GPA Grad 1001 19 69 ID02 50 21 67 y 3.19 ur IDOS 20 m 69 un 3.11 ID04 18 79 in 3.02 fr 1005 of 19 67 y 4.00 ID06 so 21 70 Y 275 ID07 20 68 y 3.24 f ID08 21 71 y 2.93 jr 1009 m 20 62 y 3.26 50 ID 10 me 19 70 n 3.21 50 1011 a 36 y 3.23 67 110 ID12 un 3.77 19 65 SO a un 3.71 ID 13 20 65 ir ID14 un 3.20 21 65 jr mr y 2.94 ID 15 19 66 so m y 3.22 ID 16 20 60 un un 3,34 ID17 19 64 fr ib un 3.00 ID18 20 67 mr n3.72 ID19 23 70 jr er un 2.50 ID20 20 70 50 of y 2.74 ID21 20 63 SO me ID22 19 67 50 m un 3.00 ID23 19 65 SO mr ID24 20 63 m un 2.60 ID25 22 63 sr of ID26 21 65 sr ID27 21 73 jr ID28 30 71 ID29 20 66 SO ib un 3.18 ID30 24 62 SO ID31 19 69 SO mr ID32 33 67 sr ID33 19 64 fr Expected Annual Salary Employment Number of Satisfaction Salary in 5 Years 40 Status Arillations Advisement Spending School Status 70 50 un 50 60 pt 50 60 O PT 50 DI 0 400 57 5 PT 40 pt 450 PT 5 100 50 300 1 100 1 PT 500 pl SO 2. PT 75 5 050 un 40 0 60 PT 500 pt 45 D PT 1 65 500 DE 50 0 PT 70 4 P 350 30 0 FT 120 DE 300 PT 40 60 4 200 PT 45 65 5 550 ET 40 00 5 425 FT 0 40 80 4 000 Ft D 50 00 3 000 pl FT 40 5 65 400 un PT 1 50 4 80 pl FT 50 75 350 PT un 0 50 2 400 75 PT un 0 4 80 400 100 PT 2 45 5 500 65 FT 0 3 600 40 FT 90 0 3 400 FT 60 1 3 500 FT 150 3 6 1000 FT 60 2 4 300 FT 40 65 0 2. 450 PT 50 75 5 PT 50 75 5 600 FT 55 85 4 400 PT 30 50 3 700 45 75 5 500 45 90 6 350 FT 210 y 3.55 DE pt y 3.62 y 3.63 n 2.38 y 2.45 n 3.28 EOEESS 888888888 pl * 550 un pt n333 un 2.87 n 3.14 n 3.44 OOO Page
