Develop a regression for predicting college GPA of students using the dataset in t a Interpret the significance of the model b Identify the significant variables in predicting college GPA c Math Science college students have higher GPA compared to Business Economics students Test this hypothesis with 95 confidence level d Calculate the adjusted R2 , is it different from the R2 Edu Parent1 Edu Parent2 Gender HSGPA SAT ACT College College GPA 6 6 F 4 26 1430 Math Science 3 956 7 6 M 3 95 1340 Math Science 3 361 3 6 M 4 33 1200 Business Economics 3 433 7 7 F 4 27 1530 Business Economics 3 890 6 7 F 4 04 1270 Math Science 3 025 7 7 F 3 56 1280 Business Economics 2 564 7 6 M 4 15 1390 Math Science 3 825 4 4 M 4 00 1330 Business Economics 3 525 7 6 F 4 09 1150 Math Science 3 595 7 7 F 3 36 1130 Arts Letters 3 058 7 6 M 3 75 1240 Business Economics 3 344 6 7 F 3 82 1270 Math Science 3 106 6 6 M 4 32 1500 Math Science 3 426 7 7 F 4 20 1230 Arts Letters 3 116 7 6 F 3 92 1320 Math Science 3 396 6 6 F 3 83 1240 Arts Letters 3 926 7 7 M 3 95 1300 Arts Letters 3 277 7 4 F 3 89 1250 Math Science 3 357 6 7 F 3 87 1170 Arts Letters 2 733 7 6 M 3 82 1440 Math Science 1 847 7 7 M 3 96 1120 Math Science 3 471 7 7 F 4 21 1360 Math Science 3 123 7 7 F 3 59 950 Arts Letters 2 255 6 7 M 4 00 1340 Math Science 3 372 6 6 F 3 40 1000 Business Economics 2 919 7 6 F 4 27 1140 Arts Letters 3 386 7 7 F 4 00 1210 Business Economics 3 079 6 6 M 4 00 1250 Business Economics 3 296 3 3 F 3 61 1050 Business Economics 2 880 4 3 M 4 33 1320 Math Science 3 935 6 6 M 3 74 1260 Business Economics 2 810 5 3 M 4 25 1310 Math Science 2 498 7 7 M 4 04 1140 Business Economics 2 932 7 6 F 3 80 1210 Arts Letters 3 128 4 6 F 4 20 1140 Business Economics 3 641 4 4 F 3 95 1340 Arts Letters 3 580 6 6 F 3 72 1210 Math Science 2 287 7 4 F 3 58 1200 Arts Letters 3 080 6 6 M 3 45 1320 Math Science 2 270 7 6 F 4 17 1360 Business Economics 2 986 6 7 F 3 70 1150 Business Economics 2 947 6 6 F 4 05 1230 Math Science 3 602 6 6 F 4 00 1210 Business Economics 3 176 7 6 F 4 33 1430 Business Economics 3 472 6 6 F 3 04 1170 Math Science 2 880 7 6 F 3 86 1330 Business Economics 3 599 3 5 M 3 77 1170 Business Economics 2 671 6 6 F 3 88 1310 Business Economics 3 468 7 7 F 3 96 1240 Business Economics 2 988 6 6 M 3 55 1230 Business Economics 2 859 7 7 M 3 32 1230 Business Economics 2 580 3 6 F 3 75 1370 Business Economics 3 467 7 7 F 4 25 1300 Business Economics 3 710 6 6 F 4 18 1290 Business Economics 3 039 5 6 M 4 25 1350 Math Science 3 159 1 1 M 3 73 1160 Math Science 3 133 6 6 M 3 86 1250 Arts Letters 3 503 2 2 F 3 68 1030 Math Science 2 479 6 6 F 3 92 1160 Arts Letters 2 997 3 3 F 3 54 1020 Arts Letters 3 395 7 6 M 3 94 1260 Business Economics 3 100 5 4 F 3 85 1170 Arts Letters 3 397 6 6 F 3 90 1300 Math Science 3 205 6 3 M 3 80 1320 Math Science 3 090 4 5 F 3 84 1390 Arts Letters 3 338 3 5 F 3 91 1230 Math Science 2 918 7 7 F 4 25 1400 Math Science 3 639 3 3 F 3 64 1290 Math Science 3 431 7 6 F 3 95 1230 Business Economics 3 465 6 6 F 3 95 1170 Business Economics 2 496 3 3 F 4 11 1280 Business Economics 3 500 6 4 M 4 23 1260 Arts Letters 3 351 7 6 F 4 05 1320 Arts Letters 3 131 4 6 F 4 09 1130 Arts Letters 3 699 6 7 M 4 20 1430 Math Science 3 631 7 7 F 4 27 1260 Arts Letters 4 000 7 6 M 3 25 1120 Math Science 2 830 7 6 F 3 90 1290 Math Science 2 953 6 4 F 3 78 1260 Math Science 3 678 7 7 F 4 05 1310 Arts Letters 3 878 3 6 F 3 88 1140 Arts Letters 3 374 7 7 M 3 32 1220 Math Science 2 992 4 7 M 3 67 1190 Arts Letters 3 288 3 6 F 3 59 1180 Arts Letters 2 854 3 7 F 3 86 1110 Math Science 0 757 4 6 F 4 33 1540 Math Science 3 245 4 6 M 4 30 1280 Math Science 3 182 4 4 M 4 00 1260 Math Science 2 926 6 6 F 3 75 1190 Business Economics 2 691 6 1 M 3 71 930 Business Economics 3 024 7 6 M 3 79 1370 Business Economics 3 376 4 5 F 4 14 1250 Business Economics 3 474 6 4 F 3 73 1420 Math Science 3 813 6 6 F 3 95 1370 Arts Letters 3 680 7 6 F 3 85 1280 Business Economics 2 094 7 5 F 4 17 1190 Arts Letters 3 788 6 4 F 3 62 1180 Math Science 3 230 4 7 F 3 91 1190 Arts Letters 2 686 6 4 F 4 35 1210 Math Science 3 830 5 6 F 3 95 1110 Arts Letters 3 036

The Answer is in the image, click to view ...

Question: Develop a regression for predicting college GPA of students using the dataset in t a. Interpret the significance of the model. b. Identify the significant

Develop a regression for predicting college GPA of students using the dataset in t a. Interpret the significance of the model. b. Identify the significant variables in predicting college GPA. c. "Math & Science" college students have higher GPA compared to "Business & Economics" students. Test this hypothesis with 95% confidence level. d. Calculate the adjusted R2 , is it different from the R2 ?

Edu_Parent1	Edu_Parent2	Gender	HSGPA	SAT/ACT	College	College_GPA
6	6	F	4.26	1430	Math & Science	3.956
7	6	M	3.95	1340	Math & Science	3.361
3	6	M	4.33	1200	Business & Economics	3.433
7	7	F	4.27	1530	Business & Economics	3.890
6	7	F	4.04	1270	Math & Science	3.025
7	7	F	3.56	1280	Business & Economics	2.564
7	6	M	4.15	1390	Math & Science	3.825
4	4	M	4.00	1330	Business & Economics	3.525
7	6	F	4.09	1150	Math & Science	3.595
7	7	F	3.36	1130	Arts & Letters	3.058
7	6	M	3.75	1240	Business & Economics	3.344
6	7	F	3.82	1270	Math & Science	3.106
6	6	M	4.32	1500	Math & Science	3.426
7	7	F	4.20	1230	Arts & Letters	3.116
7	6	F	3.92	1320	Math & Science	3.396
6	6	F	3.83	1240	Arts & Letters	3.926
7	7	M	3.95	1300	Arts & Letters	3.277
7	4	F	3.89	1250	Math & Science	3.357
6	7	F	3.87	1170	Arts & Letters	2.733
7	6	M	3.82	1440	Math & Science	1.847
7	7	M	3.96	1120	Math & Science	3.471
7	7	F	4.21	1360	Math & Science	3.123
7	7	F	3.59	950	Arts & Letters	2.255
6	7	M	4.00	1340	Math & Science	3.372
6	6	F	3.40	1000	Business & Economics	2.919
7	6	F	4.27	1140	Arts & Letters	3.386
7	7	F	4.00	1210	Business & Economics	3.079
6	6	M	4.00	1250	Business & Economics	3.296
3	3	F	3.61	1050	Business & Economics	2.880
4	3	M	4.33	1320	Math & Science	3.935
6	6	M	3.74	1260	Business & Economics	2.810
5	3	M	4.25	1310	Math & Science	2.498
7	7	M	4.04	1140	Business & Economics	2.932
7	6	F	3.80	1210	Arts & Letters	3.128
4	6	F	4.20	1140	Business & Economics	3.641
4	4	F	3.95	1340	Arts & Letters	3.580
6	6	F	3.72	1210	Math & Science	2.287
7	4	F	3.58	1200	Arts & Letters	3.080
6	6	M	3.45	1320	Math & Science	2.270
7	6	F	4.17	1360	Business & Economics	2.986
6	7	F	3.70	1150	Business & Economics	2.947
6	6	F	4.05	1230	Math & Science	3.602
6	6	F	4.00	1210	Business & Economics	3.176
7	6	F	4.33	1430	Business & Economics	3.472
6	6	F	3.04	1170	Math & Science	2.880
7	6	F	3.86	1330	Business & Economics	3.599
3	5	M	3.77	1170	Business & Economics	2.671
6	6	F	3.88	1310	Business & Economics	3.468
7	7	F	3.96	1240	Business & Economics	2.988
6	6	M	3.55	1230	Business & Economics	2.859
7	7	M	3.32	1230	Business & Economics	2.580
3	6	F	3.75	1370	Business & Economics	3.467
7	7	F	4.25	1300	Business & Economics	3.710
6	6	F	4.18	1290	Business & Economics	3.039
5	6	M	4.25	1350	Math & Science	3.159
1	1	M	3.73	1160	Math & Science	3.133
6	6	M	3.86	1250	Arts & Letters	3.503
2	2	F	3.68	1030	Math & Science	2.479
6	6	F	3.92	1160	Arts & Letters	2.997
3	3	F	3.54	1020	Arts & Letters	3.395
7	6	M	3.94	1260	Business & Economics	3.100
5	4	F	3.85	1170	Arts & Letters	3.397
6	6	F	3.90	1300	Math & Science	3.205
6	3	M	3.80	1320	Math & Science	3.090
4	5	F	3.84	1390	Arts & Letters	3.338
3	5	F	3.91	1230	Math & Science	2.918
7	7	F	4.25	1400	Math & Science	3.639
3	3	F	3.64	1290	Math & Science	3.431
7	6	F	3.95	1230	Business & Economics	3.465
6	6	F	3.95	1170	Business & Economics	2.496
3	3	F	4.11	1280	Business & Economics	3.500
6	4	M	4.23	1260	Arts & Letters	3.351
7	6	F	4.05	1320	Arts & Letters	3.131
4	6	F	4.09	1130	Arts & Letters	3.699
6	7	M	4.20	1430	Math & Science	3.631
7	7	F	4.27	1260	Arts & Letters	4.000
7	6	M	3.25	1120	Math & Science	2.830
7	6	F	3.90	1290	Math & Science	2.953
6	4	F	3.78	1260	Math & Science	3.678
7	7	F	4.05	1310	Arts & Letters	3.878
3	6	F	3.88	1140	Arts & Letters	3.374
7	7	M	3.32	1220	Math & Science	2.992
4	7	M	3.67	1190	Arts & Letters	3.288
3	6	F	3.59	1180	Arts & Letters	2.854
3	7	F	3.86	1110	Math & Science	0.757
4	6	F	4.33	1540	Math & Science	3.245
4	6	M	4.30	1280	Math & Science	3.182
4	4	M	4.00	1260	Math & Science	2.926
6	6	F	3.75	1190	Business & Economics	2.691
6	1	M	3.71	930	Business & Economics	3.024
7	6	M	3.79	1370	Business & Economics	3.376
4	5	F	4.14	1250	Business & Economics	3.474
6	4	F	3.73	1420	Math & Science	3.813
6	6	F	3.95	1370	Arts & Letters	3.680
7	6	F	3.85	1280	Business & Economics	2.094
7	5	F	4.17	1190	Arts & Letters	3.788
6	4	F	3.62	1180	Math & Science	3.230
4	7	F	3.91	1190	Arts & Letters	2.686
6	4	F	4.35	1210	Math & Science	3.830
5	6	F	3.95	1110	Arts & Letters	3.036

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Develop a regression for predicting college GPA of students using the dataset in the sheet "question 6". (40) a. Interpret the significance of the model. b. Identify the significant variables in...

\f\f1) Using the SILVERSPRING data set, develop a multiple linear regression model to predict asking price based on assessed value, size and number of bedrooms. a) Interpret the meaning of the slope...

Section I: Multiple Choice Instructions: There may be anywhere from 0 to 5 correct answers for each question. Put an "X" in front of each correct answer. 1) You are conducting a regression predicting...

Determine if I or II is higher or if theyr are equal: For a regression line, the uncertainty associated with the slope estimate, u, is higher when I. there is a lot of scatter around the regression...

Monday, February 29, 2016 Lecture 2/29 ! Multiple Regression Analysis! Regression Review - Can test r, t, or F to see if regression equation is signicant ! F: look at \"F\" and \"Sig\" on computer...

A college admission officer is trying to predict a students' college grade point average (GPA) based on their 1. High school GPA 2. Scholastic Aptitude Test (SAT) Score 3. Quality of recommendation...

Answers are given in blue. Please solve using Excel functions only! \fA business statistics professor at State College would iike to deveiob a regression modei to predict the final exam scores for...

Answers are given in blue! I need the excel function that will get me those answers! A business statistics professor at State College would iike to deveiob a regression modei to predict the final...

Midterm Examination Questions - Spring 2016 1. The final examination grades of random samples of students from three different classes are shown below. Class A Class B Class C 92 91 85 85 85 93 96 90...

What role could an asset allocation fund play? What makes an asset allocation scheme effective?

For each of the independent transactions listed below, indicate which accounts are needed to record the entry and which account will be debited, credited, or left blank. At most each transaction with...

Ordinary losses are generally preferable to capital losses because net capital losses are subject to significant deduction limitations .

Isaac Jabis co-founded Bamboo Computer with Joan Banks back in 1976 in Jabiss family garage. At age 21, Isaac Jabis coproduced the first PC and Bamboo Computer; at 25 Jabis was running Bamboo with a...

1. Discuss what you think is meant by the following statements: a) Splitting an egg into half to get two chickens. b) We cannot study time by taking apart a clock.

5. Give some examples of hidden knowledge.

3. Try to clarify how you think when you are going to write a note aimed at influencing the leader of the department. Remember, it is not what you think, but how you think that should be clarified....