Expert answer: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 attachedThe write-up should include the explanation for the summary outputand what method of Decision Theory you used? maybe Forecasting? Liner Programming?
_____________2017_12_03_______4.39.12.png
qm_670___2_yr_schools_in_al_total_graduates.xlsx
qm_670___pell_and_loan_recipients_who_graduated_within_150_25_timeframe.xlsx
Unformatted Attachment Preview
Institution
Alabama Southern Community College
Bevill State Community College
Bishop State Community College
Central Alabama Community College
Chattahoochee Valley Community College
Enterprise State Community College
Gadsden State Community College
George C Wallace Community College-Dothan
George C Wallace State Community College-Hanceville
George C Wallace State Community College-Selma
H Councill Trenholm State Community College
J F Drake State Community and Technical College
J F Ingram State Technical College
James H Faulkner State Community College
Jefferson Davis Community College
Jefferson State Community College
John C Calhoun State Community College
Lawson State Community College-Birmingham Campus
Lurleen B Wallace Community College
Marion Military Institute
Northeast Alabama Community College
Northwest-Shoals Community College
Reid State Technical College
Shelton State Community College
Snead State Community College
Southern Union State Community College
2016 total degree/certif-seeking students who graduated
423
749
835
404
334
340
1143
835
995
371
201
142
238
1083
242
1052
1224
585
410
249
538
668
67
875
689
1060
2015 total degree/certif-seeking students who graduated
361
747
739
476
364
292
993
835
946
337
241
123
187
988
274
1062
1366
617
349
244
604
719
83
849
651
1127
2014 total degree/certif-seeking students who graduated
424
806
727
587
312
488
1380
972
895
376
298
166
266
906
274
1268
1311
893
377
271
641
756
112
662
592
1136
Institution
Alabama Southern Community College
Bevill State Community College
Bishop State Community College
Central Alabama Community College
Chattahoochee Valley Community College
Enterprise State Community College
Gadsden State Community College
George C Wallace Community College-Dothan
George C Wallace State Community College-Hanceville
George C Wallace State Community College-Selma
H Councill Trenholm State Community College
J F Drake State Community and Technical College
J F Ingram State Technical College
James H Faulkner State Community College
Jefferson Davis Community College
Jefferson State Community College
John C Calhoun State Community College
Lawson State Community College-Birmingham Campus
Lurleen B Wallace Community College
Marion Military Institute
Northeast Alabama Community College
Northwest-Shoals Community College
Reid State Technical College
Shelton State Community College
Snead State Community College
Southern Union State Community College
2016 Total Degree/certif-seeking graduates within 150% of normal time
151
166
129
87
37
51
185
173
379
63
67
25
89
260
66
90
206
75
126
72
140
82
31
122
196
209
2016 Pell Grant recipients – total number that completed an award within 150% of normal time
15
36
20
18
11
13
79
36
181
59
14
9
0
0
13
44
67
56
80
27
99
27
16
53
122
81
Subsidized Loan recipients not receiving Pell Grants – total number completed an award within 150% of normal time
1
0
0
1
0
2
0
0
31
0
0
0
0
0
0
4
11
0
0
14
0
5
0
0
8
5
2015 Total Degree/certif-seeking
2014 Total Degree/certif-seeking
graduates within
graduates
150%within
of normal
150%time
of normal time
118
106
152
134
80
64
101
82
56
37
37
43
195
177
167
144
327
211
58
76
82
69
16
20
83
95
118
99
83
50
80
62
211
166
82
85
95
73
73
73
164
183
95
87
30
27
104
77
223
187
173
179
…
Purchase answer to see full
attachment
