Clearly one would assume that private colleges and universities would have a higher annual total cost as tuition is higher at private institutions. Construct a 95% confidence interval to estimate how...


Clearly one would assume that private colleges and universities would have a higher annual total cost as tuition is higher at private institutions. Construct a 95% confidence interval to estimate how much more it would cost annually to attend a private institution and interpret these values in a clear sentence. This is asking you to construct a confidence interval estimate of the difference in mean tuition.


1)  Please perform an F-test for Equal Variances to determine which Two-sample t-test and SE to use. Copy and paste the necessary F-test output below and clearly state your conclusion


2) Then perform the appropriate two-sample t-test to get the necessary descriptive statistics to construct the confidence interval.  Show all necessary work and/or paste your Excel output.
































































































































































































































































































































































































































































































































































































































































































































































































































































































































SchoolType of TermLocationType of SchoolAverage Total SATTOEFL ScoreRoom and BoardAnnual Total CostAverage Indebtedness
ArizonaStateUniversity120108004.312.712.9
BallStateUniversity1109851412.58.21
Cal.StateUniv.-Fresno11095505.413.18.761
ClemsonUniversity130113013.912.49.983
CollegeofWilliam&Mary120129514.519.413.424
FloridaInternationalUniv.110113502.7104.139
FloridaStateUniversity110118014.511.516.5
GeorgeMasonUniversity1201055151713
GeorgiaStateUniversity010111507.415.48.08
MontclairStateUniversity120102505.310.24.5
NorthCarolinaStateUniv.11011451414.314.991
OregonStateUniversity010107214.415.510.5
PurdueUniversity110109514.515.211.839
SanDiegoStateUniversity11094516.213.66.75
SlipperyRockUniv.ofPenn.13095503.612.917
SUNY-Binghamton120103914.613.46.245
TexasA&MUniversity110115013.912.714.1
Univ.ofGeorgia01011801411.910.8
Univ.ofHawaii-Manoa110107504.712.63.617
Univ.ofHouston110106514.112.19.404
Univ.ofMaryland120117015.515.716.637
Univ.ofMass.-Amherst120110014.216.410.2
Univ.ofNevada-LasVegas11098005.512.310
Univ.ofNewHampshire130111014.418.69.66
Univ.ofNorthCarolina-C.H.110122514.515.29.406
Univ.ofTexas-Austin110121513.912.910.2
Univ.ofVermont110111515.122.421.5
VirginiaCommonwealthUniv.110100514.316.314.73
VirginiaTech130126513.514.910.327
WestVirginiaUniversity110102514.611.710.7
BabsonCollege121116517.626.418
BostonCollege121128517.526.815.855
BostonUniversity11112351727.914.463
BowdoinCollege12113451627.813.64
BryantCollege021108016.720.618
BucknellUniversity13112551525.412.5
CanisiusCollege111114305.918.814.824
CarnegieMellonUniversity111133516.125.615.683
CaseWesternReserveUniv.11113301522.226.031
ClarkUniversity111112114.424.417.5
ColbyCollege011127515.727.911.63
ColgateUniversity131130015.927.69.236
CollegeofHolyCross111127516.726.812.634
EmoryUniversity111131016.526.615.309
FordhamUniversity111115017.423.48.593
Franklin&MarshallCollege111126014.526.411.5
GeorgeWashingtonUniversity111123516.926.714.368
GeorgetownUniversity111133017.527.514.013
GettysburgCollege131120014.826.411.75
HarvardUniversity11114651728.911.65
IonaCollege12195517.319.818
LafayetteCollege111118516.326.711.499
LaSalleUniversity111110506.720.811.7
LehighUniversity11112251626.813.84
ManhattanCollege11195217.1229.268
NewYorkUniversity111126017.828.617.318
NiagaraUniversity121106505.417.611.577
NortheasternUniversity011105518.223.425.603
NorthwesternUniversity021135016.124.211.98
ProvidenceCollege111118516.722.917.5
RiceUniversity111139516182.323
RochesterInst.Technology021118506.121.817.5
SeattleUniversity011110015.319.512
SetonHallUniversity121103017.120.814.9
SienaCollege121109505.417.618.248
SouthernMethodistUniversity121115015.321.312.113
St.BonaventureUniversity131109815.117.514
StanfordUniversity021143017.327.812.774
SyracuseUniversity111118017.224.314.5
TulaneUniversity111127016.327.513.845
Univ.ofChicago011137017.328.814.073
Univ.ofMiami121114517.125.716.068
Univ.ofNotreDame121132014.823.816.572
Univ.ofPennsylvania111135517.528.617.621
Univ.ofPortland111113504.518.913.896
Univ.ofScranton011111506.621.613.5
VanderbiltUniversity111129517.127.314.5
VillanovaUniversity12112421724.817.125
WakeForestUniversity121128015.223.718.703
YaleUniversity111145016.728.913.574

1<br>School<br>Type of Term Location Type of School Average Total SAT TOEFL Score Room and Board Annual Total Cost Average Indebtedness<br>2 ArizonaStateUniversity<br>3 BallStateUniversity<br>4 Cal.StateUniv.-Fresno<br>5 ClemsonUniversity<br>6 CollegeofWilliam&Mary<br>7 FloridalnternationalUniv.<br>8 FloridaStateUniversity<br>9 GeorgeMasonUniversity<br>10 GeorgiaStateUniversity<br>11 MontclairStateUniversity<br>12 NorthCarolinaStateUniv.<br>13 OregonStateUniversity<br>14 PurdueUniversity<br>15 SanDiegoStateUniversity<br>16 SlipperyRockUniv.ofPenn.<br>17 SUNY-Binghamton<br>18 TexasA&MUniversity<br>19 Univ.ofGeorgia<br>20 Univ.ofHawaii-Manoa<br>21 Univ.ofHouston<br>22 Univ.ofMaryland<br>1080<br>985<br>2<br>4.3<br>12.7<br>12.9<br>1<br>1<br>12.5<br>8.21<br>1<br>1<br>955<br>5.4<br>13.1<br>8.761<br>1<br>3<br>1130<br>1<br>3.9<br>12.4<br>9.983<br>1<br>1295<br>1<br>4.5<br>19.4<br>13.424<br>1<br>1<br>1135<br>2.7<br>10<br>4.139<br>1<br>1<br>1180<br>1<br>4.5<br>11.5<br>16.5<br>1<br>1055<br>1<br>17<br>13<br>1115<br>7.4<br>15.4<br>8.08<br>1<br>1025<br>5.3<br>10.2<br>4.5<br>1<br>1<br>1145<br>1<br>4<br>14.3<br>14.991<br>1<br>1072<br>1<br>4.4<br>15.5<br>10.5<br>11.839<br>1<br>1<br>1095<br>1<br>4.5<br>15.2<br>1<br>1<br>945<br>1<br>6.2<br>13.6<br>6.75<br>1<br>3<br>955<br>3.6<br>12.9<br>17<br>1<br>1039<br>1<br>4.6<br>13.4<br>6.245<br>1<br>1<br>1150<br>1<br>3.9<br>12.7<br>14.1<br>1<br>1180<br>1<br>4<br>11.9<br>10.8<br>1<br>1<br>1075<br>4.7<br>12.6<br>3.617<br>1<br>1<br>1065<br>1<br>4.1<br>12.1<br>9.404<br>1<br>1170<br>1<br>5.5<br>15.7<br>16.637<br>23 Univ.ofMass.-Amherst<br>1<br>1100<br>1<br>4.2<br>16.4<br>10.2<br>24 Univ.ofNevada-LasVegas<br>25 Univ.ofNewHampshire<br>1<br>1<br>980<br>5.5<br>12.3<br>10<br>1<br>3<br>1110<br>1<br>4.4<br>18.6<br>9.66<br>26 Univ.ofNorthCarolina-C.H.<br>1<br>1<br>1225<br>1<br>4.5<br>15.2<br>9.406<br>27 Univ.ofTexas-Austin<br>1<br>1<br>1215<br>1<br>3.9<br>12.9<br>10.2<br>28 Univ.ofVermont<br>1<br>1<br>1115<br>1<br>5.1<br>22.4<br>21.5<br>16.3<br>29 VirginiaCommonwealthUniv<br>30 VirginiaTech<br>31 WestVirginiaUniversity<br>32 BabsonCollege<br>33 BostonCollege<br>34 BostonUniversity<br>35 BowdoinCollege<br>36 BryantCollege<br>37 BucknellUniversity<br>38 CanisiusCollege<br>39 CarnegieMellonUniversity<br>1<br>1<br>1005<br>1<br>4.3<br>14.73<br>1<br>1265<br>1<br>3.5<br>14.9<br>10.327<br>11.7<br>26.4<br>1<br>1<br>1025<br>1<br>4.6<br>10.7<br>1<br>1<br>1165<br>1<br>7.6<br>18<br>1<br>1<br>1285<br>1<br>7.5<br>26.8<br>15.855<br>27.9<br>27.8<br>1<br>1<br>1<br>1235<br>1<br>7<br>14.463<br>1<br>1<br>1345<br>1<br>13.64<br>1<br>1080<br>1<br>6.7<br>20.6<br>18<br>1<br>3<br>1<br>1255<br>1<br>5<br>25.4<br>12.5<br>1<br>1<br>1<br>1143<br>5.9<br>18.8<br>14.824<br>1<br>1<br>1<br>1335<br>1<br>6.1<br>25.6<br>15.683<br>40 CaseWesternReserveUniv.<br>1<br>1<br>1<br>1330<br>1<br>22.2<br>26.031<br>41 ClarkUniversity<br>42 ColbyCollege<br>43 ColgateUniversity<br>44 CollegeofHolyCross<br>45 EmoryUniversity<br>46 FordhamUniversity<br>47 Franklin&MarshallCollege<br>48 GeorgeWashingtonUniversi<br>49 GeorgetownUniversity<br>50 GettysburgCollege<br>1<br>1<br>1<br>1121<br>1<br>4.4<br>24.4<br>17.5<br>1<br>1<br>1275<br>1<br>5.7<br>27.9<br>11.63<br>1<br>1<br>1300<br>1<br>5.9<br>27.6<br>9.236<br>1275<br>26.8<br>26.6<br>1<br>1<br>1<br>1<br>6.7<br>12.634<br>1<br>1<br>1<br>1310<br>1<br>6.5<br>15.309<br>1<br>1<br>1<br>1150<br>1<br>7.4<br>23.4<br>8.593<br>1<br>1<br>1<br>1260<br>1235<br>1<br>4.5<br>26.4<br>11.5<br>1<br>1<br>1<br>6.9<br>26.7<br>14.368<br>1<br>1<br>1330<br>1<br>7.5<br>27.5<br>14.013<br>1<br>1<br>1200<br>1<br>4.8<br>26.4<br>11.75<br>3440 575 543<br>*52 669 7<br>-52 5450X<br>++ 6 54t354 m47 7<br>*55 6674t 674<br>

Extracted text: 1 School Type of Term Location Type of School Average Total SAT TOEFL Score Room and Board Annual Total Cost Average Indebtedness 2 ArizonaStateUniversity 3 BallStateUniversity 4 Cal.StateUniv.-Fresno 5 ClemsonUniversity 6 CollegeofWilliam&Mary 7 FloridalnternationalUniv. 8 FloridaStateUniversity 9 GeorgeMasonUniversity 10 GeorgiaStateUniversity 11 MontclairStateUniversity 12 NorthCarolinaStateUniv. 13 OregonStateUniversity 14 PurdueUniversity 15 SanDiegoStateUniversity 16 SlipperyRockUniv.ofPenn. 17 SUNY-Binghamton 18 TexasA&MUniversity 19 Univ.ofGeorgia 20 Univ.ofHawaii-Manoa 21 Univ.ofHouston 22 Univ.ofMaryland 1080 985 2 4.3 12.7 12.9 1 1 12.5 8.21 1 1 955 5.4 13.1 8.761 1 3 1130 1 3.9 12.4 9.983 1 1295 1 4.5 19.4 13.424 1 1 1135 2.7 10 4.139 1 1 1180 1 4.5 11.5 16.5 1 1055 1 17 13 1115 7.4 15.4 8.08 1 1025 5.3 10.2 4.5 1 1 1145 1 4 14.3 14.991 1 1072 1 4.4 15.5 10.5 11.839 1 1 1095 1 4.5 15.2 1 1 945 1 6.2 13.6 6.75 1 3 955 3.6 12.9 17 1 1039 1 4.6 13.4 6.245 1 1 1150 1 3.9 12.7 14.1 1 1180 1 4 11.9 10.8 1 1 1075 4.7 12.6 3.617 1 1 1065 1 4.1 12.1 9.404 1 1170 1 5.5 15.7 16.637 23 Univ.ofMass.-Amherst 1 1100 1 4.2 16.4 10.2 24 Univ.ofNevada-LasVegas 25 Univ.ofNewHampshire 1 1 980 5.5 12.3 10 1 3 1110 1 4.4 18.6 9.66 26 Univ.ofNorthCarolina-C.H. 1 1 1225 1 4.5 15.2 9.406 27 Univ.ofTexas-Austin 1 1 1215 1 3.9 12.9 10.2 28 Univ.ofVermont 1 1 1115 1 5.1 22.4 21.5 16.3 29 VirginiaCommonwealthUniv 30 VirginiaTech 31 WestVirginiaUniversity 32 BabsonCollege 33 BostonCollege 34 BostonUniversity 35 BowdoinCollege 36 BryantCollege 37 BucknellUniversity 38 CanisiusCollege 39 CarnegieMellonUniversity 1 1 1005 1 4.3 14.73 1 1265 1 3.5 14.9 10.327 11.7 26.4 1 1 1025 1 4.6 10.7 1 1 1165 1 7.6 18 1 1 1285 1 7.5 26.8 15.855 27.9 27.8 1 1 1 1235 1 7 14.463 1 1 1345 1 13.64 1 1080 1 6.7 20.6 18 1 3 1 1255 1 5 25.4 12.5 1 1 1 1143 5.9 18.8 14.824 1 1 1 1335 1 6.1 25.6 15.683 40 CaseWesternReserveUniv. 1 1 1 1330 1 22.2 26.031 41 ClarkUniversity 42 ColbyCollege 43 ColgateUniversity 44 CollegeofHolyCross 45 EmoryUniversity 46 FordhamUniversity 47 Franklin&MarshallCollege 48 GeorgeWashingtonUniversi 49 GeorgetownUniversity 50 GettysburgCollege 1 1 1 1121 1 4.4 24.4 17.5 1 1 1275 1 5.7 27.9 11.63 1 1 1300 1 5.9 27.6 9.236 1275 26.8 26.6 1 1 1 1 6.7 12.634 1 1 1 1310 1 6.5 15.309 1 1 1 1150 1 7.4 23.4 8.593 1 1 1 1260 1235 1 4.5 26.4 11.5 1 1 1 6.9 26.7 14.368 1 1 1330 1 7.5 27.5 14.013 1 1 1200 1 4.8 26.4 11.75 3440 575 543 *52 669 7 -52 5450X ++ 6 54t354 m47 7 *55 6674t 674
Jun 10, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?