Description
I am attaching two different spreadsheets. So we are predicting student graduation rates at 2 year colleges in Alabama for students receiving Financial Aid (Pell grants and subsidized student loans).
The summary output should be like the photo attached
The write-up should include the explanation for the summary output
and what method of Decision Theory you used? maybe Forecasting? Liner Programming?
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
It is done. Have a look and inform me if you need anything
Institution
Professor
Studnt
Course
Date:
Special Instructions
Project Description
The 2016 Total Degree/certif-seeking graduates within 150% of normal time(Y-input) is compared aga
2016 Pell Grant recipients - total number that completed an award within 150% of normal time (X-inp
A regression function of data analysis toolpack is used to produce the regression.
The output is generated and presented in the 'Regression results' Tab
Interpretation of the results and conclusion is presented in the 'Analysis and Conclusion' Tab
SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
ANOVA
Regression
Residual
Total
Intercept
2016 Total Degree/certif-seeking graduates within 150% of normal time
RESIDUAL OUTPUT
Observation
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
0,676668529
0,457880298
0,435291977
31,98780489
26
df
SS
MS
F
Significance F
1 20741,34 20741,34 20,27067 0,000147
24 24557,27 1023,22
25 45298,62
Coefficients
Standard Error t Stat
P-value Lower 95% Upper 95%Lower 95.0%
0,373833154 11,77363 0,031752 0,974933 -23,9258 24,67342 -23,9258
0,355898791 0,079048 4,502296 0,000147 0,192751 0,519046 0,192751
PROBABILITY OUTPUT
nt recipients - total number that completed
2016anPell
award
Residuals
Grantwithin
recipients
150%- of
total
normal
Percentile
number
timethat completed an award within 150% of normal time
54,11455059 -39,1146
1,923077
0
59,45303245
-23,453
5,769231
0
46,28477719 -26,2848
9,615385
9
31,33702797
-13,337
13,46154
11
13,54208842 -2,54209
17,30769
13
18,52467149 -5,52467
21,15385
13
66,21510948 12,78489
25
14
61,94432...