Among the variables high school percentile, ACT English score, ACT math score, and ACT composite score, identify the one that appears to be the best predictor of cumulative GPA. Explain your reasoning.HSPGPAENGLISHMATHCOMP752.39242826633.37212324772.63162521662.77161919863.79292832963.34232623642.81131417783.09182322631.91221820512.61192220653.17172318943.79262626543.14232424762.21232423713.12211821743.42332729803.25242022552.34252524612.76212123661.95222623892.59222224903.58272826862.67242826432.1172522823.1191819472.78232523923.76212823573.33272123903.28322628552.33241821562.45232122673.56242023963.13293026634322531833.17232524613.03192521792.82192521602.89162019793.66253229622.43171819913.07262125773.48202823953.31222725803.63262726482.41162521842.93242224973.75202627352.19181719692.95252122702.37181921853.51262324943.29222525653.84191921873.14172721192.79172120723.12211923812.29172321901.5222623903.6232125943.82262426543.37181621592.03242223872.66282126542.14202522913.08282425703.07212321613.09262726562.53151818732.9191818903.67323030873.08282427472.02212420803.18323031693242123762.84232024822.44202223561.75222321753.33212426702.16282026583.09281924752.95242125722.43223127913.38262324953.81242624883.09222022472.37191918733.67272625903.24262126623.42252123642.75242727682.84302626863.22292629792.25212623953.01222522652.8222421753.31252323603.44232425472.32262524913.74263028462.93232526822.9242724873.15282626802.38262625742.46192120752.1202022983.88252526923.38323030673.06222222793.35252423662.85162221772.77272327893.28242022622.66182119532.22172019542.7302427742.46211922963.11212123572.43282326602.69212020493.51241823682.59242424943.14253127782.24192121762.88222422542.64121518632.94242824722.76172220943.9352932572.79162421723.15172120623.13252626753.32302731832.72232625692.41222224492.41212827923.94251924913.26242827791.71202221872.6272825832.56202322682.23221821923.6272928462.63181718602.73302528832.91272326672.65192021823.28211722903.16252623933.88272526853.16232423632.31222625782.89182721563.15272425572.97252121382.91202422813.07243028953.69293228282.62232324953.98283431873.25222524973.96262628682.57192624713.5242726883.16292626632.4211719843.33233028752.55231620592.85232627752.86201720783.35272325762.21231821943.2252926652.67252325773.43252120402.2261722673.3252726953.02292728852.37262826713.75242322963.72252927562.21221521883.47202523883.5242326853.2233126712.96221921993.4222722652.95272027772.71261924832.43212926642.42211919973.5222627542.55202422812.44252625802.47313231943.25262425372.64161817853.54261924953.66262927842.85232123753.05222021

Question
Asked Oct 21, 2019
1 views
Among the variables high school percentile, ACT English score, ACT math score, and ACT composite score, identify the one that appears to be the best predictor of cumulative GPA. Explain your reasoning.
HSP GPA ENGLISH MATH COMP
75 2.39 24 28 26
63 3.37 21 23 24
77 2.63 16 25 21
66 2.77 16 19 19
86 3.79 29 28 32
96 3.34 23 26 23
64 2.81 13 14 17
78 3.09 18 23 22
63 1.91 22 18 20
51 2.61 19 22 20
65 3.17 17 23 18
94 3.79 26 26 26
54 3.14 23 24 24
76 2.21 23 24 23
71 3.12 21 18 21
74 3.42 33 27 29
80 3.25 24 20 22
55 2.34 25 25 24
61 2.76 21 21 23
66 1.95 22 26 23
89 2.59 22 22 24
90 3.58 27 28 26
86 2.67 24 28 26
43 2.1 17 25 22
82 3.1 19 18 19
47 2.78 23 25 23
92 3.76 21 28 23
57 3.33 27 21 23
90 3.28 32 26 28
55 2.33 24 18 21
56 2.45 23 21 22
67 3.56 24 20 23
96 3.13 29 30 26
63 4 32 25 31
83 3.17 23 25 24
61 3.03 19 25 21
79 2.82 19 25 21
60 2.89 16 20 19
79 3.66 25 32 29
62 2.43 17 18 19
91 3.07 26 21 25
77 3.48 20 28 23
95 3.31 22 27 25
80 3.63 26 27 26
48 2.41 16 25 21
84 2.93 24 22 24
97 3.75 20 26 27
35 2.19 18 17 19
69 2.95 25 21 22
70 2.37 18 19 21
85 3.51 26 23 24
94 3.29 22 25 25
65 3.84 19 19 21
87 3.14 17 27 21
19 2.79 17 21 20
72 3.12 21 19 23
81 2.29 17 23 21
90 1.5 22 26 23
90 3.6 23 21 25
94 3.82 26 24 26
54 3.37 18 16 21
59 2.03 24 22 23
87 2.66 28 21 26
54 2.14 20 25 22
91 3.08 28 24 25
70 3.07 21 23 21
61 3.09 26 27 26
56 2.53 15 18 18
73 2.9 19 18 18
90 3.67 32 30 30
87 3.08 28 24 27
47 2.02 21 24 20
80 3.18 32 30 31
69 3 24 21 23
76 2.84 23 20 24
82 2.44 20 22 23
56 1.75 22 23 21
75 3.33 21 24 26
70 2.16 28 20 26
58 3.09 28 19 24
75 2.95 24 21 25
72 2.43 22 31 27
91 3.38 26 23 24
95 3.81 24 26 24
88 3.09 22 20 22
47 2.37 19 19 18
73 3.67 27 26 25
90 3.24 26 21 26
62 3.42 25 21 23
64 2.75 24 27 27
68 2.84 30 26 26
86 3.22 29 26 29
79 2.25 21 26 23
95 3.01 22 25 22
65 2.8 22 24 21
75 3.31 25 23 23
60 3.44 23 24 25
47 2.32 26 25 24
91 3.74 26 30 28
46 2.93 23 25 26
82 2.9 24 27 24
87 3.15 28 26 26
80 2.38 26 26 25
74 2.46 19 21 20
75 2.1 20 20 22
98 3.88 25 25 26
92 3.38 32 30 30
67 3.06 22 22 22
79 3.35 25 24 23
66 2.85 16 22 21
77 2.77 27 23 27
89 3.28 24 20 22
62 2.66 18 21 19
53 2.22 17 20 19
54 2.7 30 24 27
74 2.46 21 19 22
96 3.11 21 21 23
57 2.43 28 23 26
60 2.69 21 20 20
49 3.51 24 18 23
68 2.59 24 24 24
94 3.14 25 31 27
78 2.24 19 21 21
76 2.88 22 24 22
54 2.64 12 15 18
63 2.94 24 28 24
72 2.76 17 22 20
94 3.9 35 29 32
57 2.79 16 24 21
72 3.15 17 21 20
62 3.13 25 26 26
75 3.32 30 27 31
83 2.72 23 26 25
69 2.41 22 22 24
49 2.41 21 28 27
92 3.94 25 19 24
91 3.26 24 28 27
79 1.71 20 22 21
87 2.6 27 28 25
83 2.56 20 23 22
68 2.23 22 18 21
92 3.6 27 29 28
46 2.63 18 17 18
60 2.73 30 25 28
83 2.91 27 23 26
67 2.65 19 20 21
82 3.28 21 17 22
90 3.16 25 26 23
93 3.88 27 25 26
85 3.16 23 24 23
63 2.31 22 26 25
78 2.89 18 27 21
56 3.15 27 24 25
57 2.97 25 21 21
38 2.91 20 24 22
81 3.07 24 30 28
95 3.69 29 32 28
28 2.62 23 23 24
95 3.98 28 34 31
87 3.25 22 25 24
97 3.96 26 26 28
68 2.57 19 26 24
71 3.5 24 27 26
88 3.16 29 26 26
63 2.4 21 17 19
84 3.33 23 30 28
75 2.55 23 16 20
59 2.85 23 26 27
75 2.86 20 17 20
78 3.35 27 23 25
76 2.21 23 18 21
94 3.2 25 29 26
65 2.67 25 23 25
77 3.43 25 21 20
40 2.2 26 17 22
67 3.3 25 27 26
95 3.02 29 27 28
85 2.37 26 28 26
71 3.75 24 23 22
96 3.72 25 29 27
56 2.21 22 15 21
88 3.47 20 25 23
88 3.5 24 23 26
85 3.2 23 31 26
71 2.96 22 19 21
99 3.4 22 27 22
65 2.95 27 20 27
77 2.71 26 19 24
83 2.43 21 29 26
64 2.42 21 19 19
97 3.5 22 26 27
54 2.55 20 24 22
81 2.44 25 26 25
80 2.47 31 32 31
94 3.25 26 24 25
37 2.64 16 18 17
85 3.54 26 19 24
95 3.66 26 29 27
84 2.85 23 21 23
75 3.05 22 20 21
 
check_circle

Expert Answer

Step 1

After copying the given data in to EXCEL software,

  • Go to Data > Data analysis > Select Regression > OK.
  • Place the variable GPA in the first column and place the remaining variables one by one in 2nd, 3rd,4th, and 5th
  • Give the Y range as range of GPA with label.
  • Give the X range as range of HSP, ENGLISH, MATH, and COMP with labels.
  • Click on labels.
  • Click OK.
Step 2

The result obtained using E...

SUMMARY OUTPUT
Regression Statistics
Multiple R
0.551978237
R Square
0.304679974
Adjusted R Square
0.290416999
Standard Error
0.434592121
Observations
200
ANOVA
df
Significance F
SS
MS
F
Regression
4
16.13828871 4.034572177 21.36160066
1.25962E-14
Residual
195
36.82971079 0.188870312
Total
52.9679995
199
Coefficients Standard Error
Lower 95%
Upper 95%
tStat
P-value
1.011278294
0.240141849
Intercept
4.2111706 3.87798E-05|
0.537669567 1.484887021
HSP
0.012087057
0.007720466 0.016453647
0.002214066 5.459211502 1.44348E-07
0.013702578 0.064378789 0.948734568-0.026142124 0.027906435
ENGLISH
0.000882155
МАТH
-0.013209782
0.01231048 -1.073051704 0.284574036
0.03748856 0.011068997
COMP
0.056620354
0.022923837 2.469933523 0.014372979
0.011409869 0.101830839
help_outline

Image Transcriptionclose

SUMMARY OUTPUT Regression Statistics Multiple R 0.551978237 R Square 0.304679974 Adjusted R Square 0.290416999 Standard Error 0.434592121 Observations 200 ANOVA df Significance F SS MS F Regression 4 16.13828871 4.034572177 21.36160066 1.25962E-14 Residual 195 36.82971079 0.188870312 Total 52.9679995 199 Coefficients Standard Error Lower 95% Upper 95% tStat P-value 1.011278294 0.240141849 Intercept 4.2111706 3.87798E-05| 0.537669567 1.484887021 HSP 0.012087057 0.007720466 0.016453647 0.002214066 5.459211502 1.44348E-07 0.013702578 0.064378789 0.948734568-0.026142124 0.027906435 ENGLISH 0.000882155 МАТH -0.013209782 0.01231048 -1.073051704 0.284574036 0.03748856 0.011068997 COMP 0.056620354 0.022923837 2.469933523 0.014372979 0.011409869 0.101830839

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Math

Statistics

Advanced Topics in Statistics

Related Statistics Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: ​If other factors are held constant, how does sample variance influence the likelihood of rejecting ...

A: It is given that r2 and cohen’s d.

question_answer

Q: Note here that the Y column (minutes spent) is the first, and the X column (number of copiers servic...

A: Hey, since there is multiple sub part questions posted, we will answer first three sub part question...

question_answer

Q: If x is a binomial random variable, use the binomial probability table to find the probabilities bel...

A: a.The binomial probability table for n=15 and p=0.7.From the binomial probability table for n=15 and...

question_answer

Q: The mean of a normal probability distribution is 380: the stardard deviation is 16. a. About 68 % of...

A: a) About 68% of the observations between the value 1 is 364 and the value 2 is 396. The mean of the ...

question_answer

Q: The symbol ∩ represents the intersection of events. The intersection of two events A and B results i...

A: Given dataEvent A = {E1, E4, E6}Event B = { E2, E4, E7}A ∩ B = { E4} 

question_answer

Q: Twelve jurors are randomly selected from a population of 5million residents. Of these 5 million​ res...

A: a).The proportion of the jury described is from a minority race is 2/12 = 0.17.b).The number of resi...

question_answer

Q: The patient recovery time from a particular surgical procedure is normally distributed with a mean o...

A: Consider a random variable X which follows normal distribution indicating the recovery time of a ran...

question_answer

Q: The student council is hosting a drawing to raise money for scholarships. They are selling tickets f...

A: From the provided information, the total number of tickets they will sell = 700. So,

question_answer

Q: It is estimated that in the general population about 9 out of every 1000 or 0.009 children are diagn...

A: In the study included 92 six-month old babies who had a sibling with autism. twenty-eight of these b...