Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Choose a college of interest (Business and Economics, Math & Science, for example) and use the sample of enrolled students to best predict a student's

Choose a college of interest (Business and Economics, Math & Science, for example) and use the sample of enrolled students to best predict a student's college grade point average. Use goodness-of-fit measures to find the best predictive model. In order to estimate these models, first, filter the data to include only the enrolled students.

(I already filtered the data and I chose Business and Economics for my college of interest).

RESIDUAL OUTPUT
Observation Predicted College_GPA Residuals
1 3.35334844 0.07965156
2 3.66271472 0.22728528
3 3.27716652 0.24783348
4 3.02059902 0.32340098
5 2.54113307 0.37786693
6 3.15056499 -0.071565
7 2.72964144 0.15035856
8 3.03523462 -0.2252346
9 3.10257271 -0.1705727
10 3.20600717 0.43499283
11 3.41871601 -0.432716
12 3.59600137 -0.1240014
13 3.18666136 0.41233864
14 2.95967744 -0.2886774
15 3.17849041 0.28950959
16 2.88075581 -0.0217558
17 2.73206877 -0.1520688
18 3.40713248 0.30286752
19 3.35132978 -0.3123298
20 3.1645277 -0.0645277
21 3.13934197 0.32565803
22 3.07604121 -0.5800412
23 3.29552707 0.20447293
24 2.96784838 -0.2768484
25 2.66768646 0.35631354
26 3.18360929 0.19239071
27 3.28327065 0.19072935
28 3.12744607 -1.0334461
29 3.2833188 0.5396812
30 3.26661639 -0.2386164
31 3.18154248 -0.1155425
32 3.06078087 0.07121913
33 3.16044223 -0.0244422
34 3.06683686 0.01116314
35 3.3938908 -0.0688908
36 3.67326485 0.09073515
37 3.07536832 0.49963168
38 2.83720953 0.03879047
39 3.27137475 -0.3053747
40 3.40951166 0.52748834
41 3.07065811 -0.0956581
42 3.2165573 0.1564427
43 2.12093057 0.47406943
44 3.08389978 -0.1038998
45 3.16623399 0.09776601
46 3.46810221 0.45189779
47 3.36596538 0.17103462
48 3.07878091 -0.2537809
49 3.01274044 0.03325956
50 3.21251998 0.36348002
51 3.45377898 0.18922102
52 2.57009191 -0.1190919
53 2.97601933 -0.2750193
54 3.4632957 -0.0722957
55 3.46024364 0.01675636
56 2.87429116 0.66670884
57 2.85794927 -0.3509493
58 3.03451359 0.06448641
59 3.35712154 -0.0731215
60 2.62418832 -0.0891883
61 2.85655534 -0.8265553
62 2.92838757 0.36961243
63 2.90118318 0.14681682
64 3.02333872 0.12966128
65 3.22989528 -0.3408953
66 2.51868704 0.36931296
67 2.65651159 -0.8415116
68 3.54868198 0.41031802
69 3.12573978 -0.1787398
70 2.74293127 0.28606873
71 3.28838953 -0.0843895
72 2.805511 -0.229511
73 2.89808296 -0.109083
74 3.18702188 -0.0150219
75 3.50926932 -0.2372693
76 3.01444674 0.59555326
77 3.20026356 0.04773644
78 2.95186701 0.25813299
79 2.99711958 0.20188042
80 2.80685677 0.14614323
81 3.21386575 0.04913425
82 3.06212664 -0.3881266
83 3.21965752 -0.0596575
84 2.84744729 0.33955271
85 3.70320894 -0.4792089
86 3.07536832 0.38063168
87 2.67590555 0.20709445
88 2.62144862 0.34355138
89 2.43976542 0.08423458
90 3.4193889 0.5206111
91 3.02437212 0.31962788
92 3.58581176 0.05018824
93 2.99582196 0.07617804
94 3.00053217 -0.9215322
95 3.06755789 0.15744211
96 3.26661639 0.50238361
97 3.21184709 -0.3568471
98 3.07402254 0.00697746
99 3.49292742 0.27907258
100 3.27644548 0.25855452
101 3.11208943 0.19691057
102 2.5571626 0.2318374
103 3.3272256 0.0247744
104 3.04169928 0.15130072
105 3.48165626 -0.1986563
106 2.56874613 0.31025387
107 3.15433809 0.17166191
108 3.05359518 0.48740482
109 3.21965752 -0.0526575
110 2.90149555 0.20150445
111 3.17745701 -0.407457
112 3.09781435 0.06018565
113 3.4677417 0.3392583
114 3.10432715 -0.1783272
115 3.32277961 -0.3177796
116 3.13013762 0.00986238
117 3.10836448 0.13863552
118 2.47446787 -0.5884679
119 2.41520443 -0.7362044
120 2.89978926 0.04821074
121 3.26661639 0.11538361
122 2.97943192 0.24756808
123 3.32578353 -0.0087835
124 2.88551417 0.01948583
125 3.522511 -0.178511
126 3.09884776 -0.3328478
127 2.66364913 0.15835087
128 3.22441588 -0.3604159
129 2.66328861 0.10371139
130 3.20233037 -0.7413304
131 3.21759071 0.13040929
132 2.85314276 -0.2161428
133 2.88210159 0.31789841
134 3.29826677 0.29873323
135 3.27985807 -0.1488581
136 3.54599043 0.23900957
137 3.08627897 0.36972103
138 3.42554119 -0.1515412
139 3.33126293 -0.1972629
140 2.45269473 -0.9096947
141 2.98589657 0.25910343
142 3.36260094 -0.4266009
143 3.27985807 0.17114193
144 2.88075581 -0.4017558
145 3.09175836 0.17724164
146 3.38468645 -0.0076865
147 3.02639079 0.06360921
148 3.28771664 -0.0777166
149 3.161788 0.281212
150 3.37754891 -0.7735489
151 2.61911759 -0.0481176
152 2.76335864 -0.1033586
153 3.19891778 0.16808222
154 3.36731115 -0.2603112
155 3.19752386 -0.2485239
156 3.09678094 -0.0157809
157 3.03254307 0.50145693
158 2.64735538 -0.4503554
159 3.3462109 0.4717891
160 3.42859325 0.49340675
161 3.15056499 0.60743501
162 3.05561384 -0.6816138
163 3.23362023 0.01237977
164 3.08627897 0.03772103
165 3.00973652 0.04226348
166 3.29211449 0.05188551
167 3.3819949 0.1400051
168 3.03011574 0.61888426
169 2.90216844 -0.1001684
170 2.81745505 -0.080455
171 3.19307787 -0.3180779
172 3.52013182 -0.3461318
173 3.17611123 -0.3331112
174 2.29583674 -0.6118367
175 3.21324101 -0.488241
176 3.18252774 0.00647226
177 2.98894864 0.52305136
178 3.07334966 0.12865034
179 3.28637087 0.20062913
180 3.0804872 -0.1964872
181 3.33803995 -0.11004
182 3.12475452 -0.0507545
183 3.02778471 -0.0387847
184 3.23631178 -0.9493118
185 2.78445889 0.14954111
186 2.34207458 -1.3750746
187 3.17135287 0.41164713
188 2.98620894 -0.0892089
189 2.81983423 0.19316577
190 3.0338407 -0.0008407
191 2.54863113 0.22436887
192 3.20196985 0.19003015
193 3.08457267 0.44742733
194 2.93350645 0.36249355
195 3.12646081 -0.0044608
196 3.08663948 -0.4616395
197 3.26661639 0.24638361
198 3.13359835 -0.3125984
199 3.35101741 -0.2540174
200 3.13085866 -0.6138587
201 3.33606944 -0.4260694
202 2.99375515 0.25724485
203 3.05871406 0.05128594
204 3.21386575 0.23013425
205 3.10737922 0.19762078
206 3.16044223 0.28555777
207 2.9855842 0.2434158
208 3.42383489 0.09816511
209 3.50415044 0.43884956
210 3.49391268 0.29408732
211 3.06042035 -0.6654203
212 3.0777475 0.5112525
213 2.51563498 0.12536502
214 2.66297624 0.37902376
215 3.22270959 0.49029041
216 2.690493 0.521507
217 2.75213562 -0.0501356
218 3.07640173 -0.2164017
219 2.80044027 0.72955973
220 3.07020129 -0.2192013
221 2.94369606 0.49930394
222 2.58436699 -0.669367
223 2.76268575 0.20931425
224 2.99546144 -1.6724614
225 2.2713239 0.3366761
226 2.86580784 0.44719216
227 3.20264274 0.01035726
228 3.19343838 -0.1954384
229 2.96479632 -0.1517963
230 3.1509255 -0.1889255
231 2.98046532 0.13053468
232 3.00803023 0.03296977
233 3.16044223 0.28555777
234 3.41328477 0.24571523
235 2.62082388 -0.5468239
236 3.23155342 -0.0165534
237 2.6959724 0.3590276
238 3.19411127 -0.0501113
239 3.08695185 -0.5629519
240 3.08726422 0.61073578
241 3.03528277 0.60471723
242 3.07474358 -0.2967436
243 2.80313182 -0.0641318
244 3.06005983 -0.4850598
245 2.5370476 0.3139524
246 3.14684003 0.31015997
247 3.25979122 0.16220878
248 3.11689594 0.05910406
249 3.36493197 0.12206803
250 3.08726422 0.09873578
251 2.99101545 0.66998455
252 2.85898267 0.17501733
253 3.19550519 0.03649481
254 2.98962153 0.23037847
255 3.24349747 -0.0524975
256 3.10194797 -0.022948
257 2.51424105 -0.4642411
258 3.02980337 0.14019663
259 2.91209383 0.15290617
260 2.81507587 -0.4600759
261 3.29723336 0.26676664
262 2.95729826 0.29470174
263 3.14751292 -0.2635129
264 3.24412221 0.03687779
265 3.51842552 0.04757448
266 2.63473845 -0.1977384
267 3.37346344 -0.5284634
268 3.07097048 -0.1519705
269 3.19343838 0.40656162
270 3.10737922 -0.2533792
271 2.78513178 -0.7031318
272 2.83586375 -0.7708638
273 3.04650578 -0.2995058
274 3.03999298 -0.162993
275 3.05467673 0.29132327
276 2.783786 -0.085786
277 3.2230701 0.3109299
278 2.98046532 -0.5474653
279 3.08560608 0.40439392
280 2.99774432 0.36925568
281 3.08389978 0.02410022
282 3.1927655 -0.0667655
283 2.89094542 0.16105458
284 2.62212151 0.22787849
285 2.95491908 0.34508092
286 3.42998718 0.52901282
287 3.27106238 0.04593762
288 3.5783137 0.0566863
289 2.91307908 -0.3010791
290 2.73305403 0.29294597
291 3.16008171 0.04891829
292 3.31967939 0.21232061
293 2.99711958 0.31688042
294 2.98760286 0.46239714
295 2.55954178 0.49745822
296 3.39932205 -0.3423221
297 3.67461062 -0.6746106
298 3.00565105 0.57734895
299 3.06279953 0.23620047
300 2.87092672 0.53807328
301 2.80752966 0.19147034
302 3.14616714 -0.2821671
303 3.40951166 0.46848834
304 3.14917106 0.38482894
305 2.34584768 0.92215232
306 3.16556111 0.12543889
307 2.87936189 0.25063811
308 3.0951228 0.2888772
309 3.4622623 0.0397377
310 3.19886963 -0.6618696
311 3.25673915 -0.1427391
312 3.27856044 0.44043956
313 2.91235805 0.24964195
314 2.55985415 -0.2218541
315 3.0832269 -0.5732269
316 3.26728928 -0.1392893
317 3.23429312 0.28070688
318 3.26522246 0.25577754
319 3.24075777 0.07224223
320 3.09067681 -0.0406768
321 2.93857718 -0.0305772
322 2.85794927 0.09705073
323 2.9069268 -0.1719268
324 3.39999494 0.33800506
325 2.93723141 -0.0592314
326 3.31626681 0.08673319
327 3.03451359 -0.0145136
328 2.89673719 0.33526281
329 2.59150453 0.08349547
330 2.87051806 0.29848194
331 3.09817487 0.14082513
332 2.97534644 0.37465356
333 2.84232841 0.23767159
334 3.09207073 -0.2210707
335 3.28259776 0.52540224
336 3.25234131 -0.3893413
337 3.30845638 0.30354362
338 2.81678216 -0.0117822
339 2.93216068 -0.5811607
340 2.95797114 -0.0679711
341 2.82800518 0.04499482
342 3.11994801 0.08005199
343 2.19473331 0.32726669
344 2.96515683 -0.0401568
345 2.60717354 0.61282646
346 3.35577577 -0.0277758
347 2.65413241 0.01886759
348 2.91235805 -0.118358
349 2.67285348 0.26214652
350 3.30912927 0.24187073
351 3.09041259 -0.7744126
352 2.80752966 -0.9745297
353 3.3088169 0.2981831
354 3.05292229 0.28907771
355 2.99882588 0.16817412
356 3.12408163 0.04291837
357 1.7452596 0.6277404
358 2.79428798 -0.071288
359 2.75720635 0.09279365
360 3.25166842 -0.5006684
361 2.81880082 0.75019918
362 2.96143188 -0.1864319
363 3.28937479 -0.7563748
364 3.3635862 -0.0705862
365 3.3754821 0.4885179
366 3.02095954 -0.1619595
367 2.66908038 -0.1090804
368 3.3152334 -0.3082334
369 2.9964467 0.1785533
370 2.59051927 0.18148073
371 2.74324364 -0.3092436
372 3.30948979 0.18351021
373 3.04888496 0.22311504
374 2.79123592 0.54276408
375 2.78513178 0.00586822
376 3.10706685 -0.7960669
377 2.61431108 0.17068892
378 3.18733425 -0.0933342
379 3.34315883 0.03484117
380 2.70005787 0.71494213
381 3.12946473 0.07753527
382 2.54247885 0.33852115
383 2.57552316 0.27847684
384 2.95936507 -0.1733651
385 3.32924426 0.07475574
386 2.83819479 -0.0081948
387 3.18118196 0.12681804
388 2.75146274 0.39253726
389 2.9389377 0.0810623
390 2.88618706 0.02081294
391 2.68748908 0.22851092
392 2.9106999 0.0583001
393 2.48362408 -2.1196241
394 3.55685293 0.10614707
395 3.17678412 0.49321588
396 2.98589657 -0.1248966
397 2.77386062 0.09213938
398 2.53094347 -0.8419435
399 3.08353927 -0.4165393
400 3.07231625 0.57668375
401 3.45207269 0.28592731
402 2.95527959 0.04772041
403 2.54521855 -0.6822185
404 2.68232206 0.29967794
405 3.28802901 -0.604029
406 3.05530147 -0.3703015
407 3.41395765 -0.2419577
408 3.21251998 0.41748002
409 2.92295632 0.21404368
410 3.07101862 -0.2410186
411 3.02809708 -0.1410971
412 2.91613115 -0.1781312
413 2.90894546 0.17505454
414 2.79909449 0.61890551
415 3.05431621 0.24368379
416 3.32991715 -0.3179172
417 2.8722725 -0.4732725
418 2.58948587 0.01851413
419 3.3023041 -1.6523041
420 3.28771664 -0.1167166
421 2.69255981 -0.0105598
422 2.68205783 0.45694217
423 3.15568387 -0.3816839
424 3.02881812 0.02718188
425 2.79262984 0.34837016
426 3.00389661 -0.0618966
427 3.23972437 -0.2997244
428 2.92838757 0.13461243
429 3.34589853 0.01910147
430 2.73036248 -0.1983625
431 2.95455856 0.03744144
432 3.01247622 0.07252378
433 2.31554307 0.35245693
434 3.25539337 0.47160663
435 3.25606626 0.32993374
436 2.87904952 0.25395048
437 2.81135091 0.42264909
438 3.14140878 -0.3604088
439 3.04919733 0.16080267
440 3.36224042 -0.3052404
441 3.55550715 0.31649285
442 3.08493319 -0.1869332
443 3.39115111 0.44184889
444 3.27685415 0.00314585
445 2.89296409 -0.1569641
446 3.15981749 -0.3158175
447 2.97058808 -0.9195881
448 3.00730919 0.11469081
449 3.25162027 0.22337973
450 3.35680917 -1.1648092
451 1.87625898 0.64874102
452 3.2513079 0.0776921
453 3.03864721 -0.0816472
454 3.04237216 0.17762784
455 2.74567097 -0.901671
456 2.69152641 -1.0135264
457 3.02639079 0.44960921
458 3.051216 -1.869216
459 3.59770766 0.00229234
460 3.16080274 0.07619726
461 3.41359714 0.49840286
462 2.80623203 -0.340232
463 3.04578475 -0.3257847
464 2.74225838 -0.5302584
465 3.02432398 -0.299324
466 2.66225521 -0.7212552
467 3.013822 -0.229822
468 3.08116009 0.66683991
469 3.08623082 -0.1092308
470 2.99132782 -0.1853278
471 3.28704376 -0.8150438
472 2.73238114 -0.6243811
473 3.05188888 0.04211112
474 2.85830978 -0.2093098
475 3.16488822 -0.0908882
476 3.29350841 0.26149159
477 3.05561384 -0.4086138
478 2.73300588 0.06899412
479 3.03999298 -0.058993
480 3.28053095 -0.085531
481 2.87020569 -0.8252057
482 3.50926932 -0.0492693
483 3.33162345 0.37237655
484 3.24654954 0.08945046
485 3.27276867 -0.1767687
486 2.88241396 -0.154414
487 2.78952962 -0.0905296
488 2.83038436 -1.3153844
489 3.05494095 0.31105905
490 3.09750198 0.14749802
491 3.06042035 -0.1884203
492 2.77458165 0.08441835
493 2.99034256 0.18165744
494 3.11177706 0.45622294
495 2.94674813 0.11825187
496 2.28151351 -0.1915135
497 2.55850837 -0.0065084
498 2.44555719 0.85044281
499 2.45202184 0.48697816
Regression Statistics
Multiple R 0.57823121
R Square 0.33435134
Adjusted R Square 0.33166727
Standard Error 0.39974138
Observations 499
ANOVA
df SS MS F Significance F
Regression 2 39.8105228 19.9052614 124.568914 1.4614E-44
Residual 496 79.2574111 0.15979317
Total 498 119.067934
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -0.711862 0.23862646 -2.9831646 0.00299337 -1.1807053 -0.2430187 -1.1807053 -0.2430187
HSGPA 0.64646539 0.06057342 10.6724276 4.465E-24 0.52745327 0.76547751 0.52745327 0.76547751
SAT/ACT 0.00105501 0.00014523 7.26443397 1.4618E-12 0.00076967 0.00134035 0.00076967 0.00134035

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

STAT 2 Building Models For A World Of Data

Authors: Ann R Cannon

1st Edition

1464148244, 9781464148248

More Books

Students also viewed these Mathematics questions