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
You will get a plagiarism-free paper and you can get an originality report upon request.
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more