Run a Regression in excel and Give a write-up explanation for the results you got

User Generated

xelfgny999

Mathematics

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

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 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.20802756 0.04327546 -0.0630273 3.37985567 51 ANOVA df Regression Residual Total ج | SS 5 23.2521787 514.054096 50 537.306275 MS F Significance 4.65043574 0.40709647 0.84133329 11.4234244 45 Intercept Coefficients Standard Erro t Stat P-value 15.5185816 2.17057084 7.14953935 6.1 183E-09 3.4499E-05 2.9701E-05 1.16153667 0.25154786 0.13142346 0.20199232 0.65063591 0.51858999 0.01430403 0.03263569 0.43829402 0.6632701 -0.0339223 0.06857495 -0.4946754 0.62323587 -0.0001243 0.00231802 -0.0536238 0.95747227 Lower 95% Upper 95% Lower 95.0% Upper 95.0% 11.1468275 19.8903357 11.1468275 19.8903357 -2.5325-05 9.432E-05 -2.532E-05 9.432E-05 -0.27541 0.53825687 -0.27541 0.53825687 -0.0514276 0.08003569 -0.0514276 0.08003569 -0.1720394 0.10419469 -0.1720394 0.10419469 -0.004793 0.00454443 -0.004793 0.00454443
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags