Question: Using the retention data from your Excel exercises in Homework 3, calculate a 95% confidence interval for an interval level variable -- such as GPA.
Using the retention data from your Excel exercises in Homework 3, calculate a 95% confidence interval for an interval level variable -- such as GPA. Assume you have a random, representative sample.
| High School GPA |
| 3.396589795 |
| 3.325261855 |
| 2.769711272 |
| 3.749101918 |
| 3.565378683 |
| 3.27294469 |
| 3.503461719 |
| 3.272368068 |
| 3.607063084 |
| 3.181459419 |
| 3.496018976 |
| 3.330767219 |
| 3.274376425 |
| 3.57990973 |
| 3.618499349 |
| 3.71394945 |
| 3.529362514 |
| 3.453737915 |
| 3.29338153 |
| 3.743678937 |
| 3.363614608 |
| 3.30708925 |
| 3.724226449 |
| 3.420120826 |
| 3.055898253 |
| 3.448693261 |
| 3.420268264 |
| 2.99 |
| 3.459367045 |
| 3.557010953 |
| 3.377463163 |
| 3.490245077 |
| 3.601400378 |
| 3.416130799 |
| 3.062515213 |
| 3.478932116 |
| 3.152620707 |
| 3.944115305 |
| 3.148774236 |
| 3.366327775 |
| 3.027820502 |
| 3.347634374 |
| 3.522693126 |
| 3.78509641 |
| 3.509397157 |
| 3.347009689 |
| 3.256676909 |
| 3.460161847 |
| 3.702418917 |
| 3.535388213 |
| 2.958435345 |
| 3.129974215 |
| 2.902245706 |
| 3.270415772 |
| 3.519229904 |
| 3.225568692 |
| 3.44623782 |
| 3.453925456 |
| 2.827269833 |
| 3.419573544 |
| 3.177482877 |
| 3.480215485 |
| 3.148125009 |
| 3.211471573 |
| 3.517916775 |
| 3.315120262 |
| 3.165758601 |
| 3.24178353 |
| 3.234124701 |
| 3.048844346 |
| 3.426420052 |
| 3.2906901 |
| 3.143090273 |
| 3.388160623 |
| 3.58489551 |
| 3.44942293 |
| 3.47582037 |
| 3.285451256 |
| 3.140210724 |
| 3.233011845 |
| 3.786723828 |
| 3.854913814 |
| 3.358031975 |
| 3.694802326 |
| 3.285350586 |
| 3.626020491 |
| 3.30442889 |
| 3.945748163 |
| 3.878104827 |
| 3.19319242 |
| 3.388542649 |
| 2.832856316 |
| 3.68920649 |
| 3.232489797 |
| 3.813494469 |
| 3.287382046 |
| 3.482177783 |
| 3.283242655 |
| 3.211615177 |
| 2.825571808 |
| 3.23280963 |
| 3.614382218 |
| 3.297297809 |
| 3.462080173 |
| 3.353386982 |
| 3.722919296 |
| 2.794997969 |
| 3.88421737 |
| 3.324574693 |
| 3.363804911 |
| 3.479297754 |
| 3.287675221 |
| 2.960949388 |
| 3.606776077 |
| 3.236524122 |
| 3.376614341 |
| 3.047805063 |
| 3.123079788 |
| 3.441587307 |
| 3.210585965 |
| 3.322428551 |
| 3.377679917 |
| 3.706906788 |
| 3.703714036 |
| 3 |
| 3.414824374 |
| 3.254142566 |
| 3.413515364 |
| 3.403973359 |
| 3.274722425 |
| 3.502321519 |
| 3.425344513 |
| 3.370649667 |
| 3.191774156 |
| 3.648509138 |
| 2.665797647 |
| 3.381741914 |
| 2.602511944 |
| 3.848788738 |
| 3.414714149 |
| 2.738629128 |
| 3.195636969 |
| 2.937239641 |
| 2.7635197 |
| 3.60024112 |
| 3.28541631 |
| 3.95 |
| 3.232459524 |
| 2.892065481 |
| 3.098929322 |
| 3.448072848 |
| 3.556111505 |
| 3.209398141 |
| 3.204918795 |
| 3.244420856 |
| 3.054045735 |
| 3.220611722 |
| 2.736189933 |
| 3.55 |
| 3.283995746 |
| 2.993786747 |
| 3.494751836 |
| 3.601037001 |
| 2.547539811 |
| 3.093041325 |
| 3.703501897 |
| 2.726591062 |
| 3.233687129 |
| 3.454736516 |
| 3.451750245 |
| 3.08064014 |
| 3.204632868 |
| 3.106078501 |
| 3.435109822 |
| 2.799667436 |
| 3.155508688 |
| 3.400188757 |
| 2.942785755 |
| 3.328179748 |
| 3.76066055 |
| 3.116543672 |
| 3.51219623 |
| 3.639398455 |
| 2.926650562 |
| 3.28355847 |
| 3.330812315 |
| 2.867233881 |
| 3.409358596 |
| 3.34423185 |
| 3.048235413 |
| 3.735121798 |
| 3.132915638 |
| 3.427530834 |
| 3.266957457 |
| 3.024577348 |
| 2.955219078 |
| 3.284401293 |
| 3.022952138 |
| 3.056759698 |
| 3.48326478 |
| 2.888615946 |
| 3.828108256 |
| 3.288663319 |
| 3.787956073 |
| 3.048504142 |
| 3.633158905 |
| 3.888833232 |
| 3.226325 |
| 3.050228927 |
| 3.442267924 |
| 3.322736068 |
| 3.286812403 |
| 3.61748722 |
| 3.467379096 |
| 3.23927227 |
| 3.004447974 |
| 3.03344046 |
| 2.898606247 |
| 3.993233545 |
| 3.110119452 |
| 3.493420362 |
| 3.523641076 |
| 3.377905356 |
| 3.577861096 |
| 3.476730422 |
| 3.811539939 |
| 3.241219947 |
| 3.197807451 |
| 3.738358985 |
| 3.325649172 |
| 3.527328792 |
| 3.635349954 |
| 4.024282753 |
| 3.538816655 |
| 3.088494396 |
| 3.257517627 |
| 3.56362546 |
| 3.462676382 |
| 3.362112566 |
| 3.272522485 |
| 3.444066679 |
| 3.396756972 |
| 3.383340327 |
| 3.332547936 |
| 2.956191195 |
| 3.238254024 |
| 3.602636485 |
| 3.346442201 |
| 3.70699365 |
| 3.283658431 |
| 3.364481793 |
| 3.218637138 |
| 3.478815704 |
| 3.765061041 |
| 3.855227779 |
| 3.870954509 |
| 3.130604626 |
| 3.154481047 |
| 3.187246747 |
| 3.17241668 |
| 3.147993237 |
| 3.753376874 |
| 3.685451062 |
| 3.492740676 |
| 2.970357935 |
| 3.247222042 |
| 3.122135262 |
| 3.288462289 |
| 2.840936584 |
| 3.115939866 |
| 3.675909912 |
| 3.311857602 |
| 3.640744486 |
| 3.758078871 |
| 3.107629604 |
| 3.191746726 |
| 3.453813023 |
| 2.937447824 |
| 2.790760645 |
| 3.232993626 |
| 3.033829108 |
| 2.596771772 |
| 3.424660578 |
| 3.598759986 |
| 3.395328158 |
| 3.542076951 |
| 3.154016153 |
| 3.54189372 |
| 2.726794186 |
| 2.745828628 |
| 3.418805582 |
| 3.27146043 |
| 3.02987689 |
| 3.615266762 |
| 2.810922885 |
| 3.639815846 |
| 2.906249617 |
| 3.02396655 |
| 3.331521546 |
| 2.833377018 |
| 2.380792387 |
| 3.119260132 |
| 3.056910756 |
| 3.454192674 |
| 3.248562861 |
| 3.004606628 |
| 3.463975488 |
| 3.319287646 |
| 3.362021155 |
| 3.159321439 |
| 3.698054925 |
| 3.239409597 |
| 3.240332669 |
| 3.200106001 |
| 3.579264136 |
| 3.220664561 |
| 3.275202327 |
| 3.457149559 |
| 3.275358773 |
| 3.438678743 |
| 3.466703174 |
| 2.765022697 |
| 3.509596369 |
| 3.415180664 |
| 3.799908485 |
| 2.996038213 |
| 3.337101339 |
| 3.517154276 |
| 3.796131736 |
| 3.337439472 |
| 3.622067936 |
| 3.114435663 |
| 3.391564244 |
| 3.78080311 |
| 3.398530087 |
| 3.389930892 |
| 3.003739455 |
| 2.908045809 |
| 3.375573304 |
| 3.451679821 |
| 2.858904149 |
| 3.173402211 |
| 3.240131983 |
| 2.952766304 |
| 3.282858609 |
| 3.709097734 |
| 3.524409758 |
| 3.073183526 |
| 3.312692086 |
| 3.349833456 |
| 3.397801975 |
| 3.520615573 |
| 3.307797216 |
| 3.103286137 |
| 3.216719094 |
| 3.485772605 |
| 3.483846329 |
| 3.328504646 |
| 3.155226351 |
| 3.502197643 |
| 3.163300707 |
| 2.851521095 |
| 3.325518126 |
| 3.687560029 |
| 3.202482157 |
| 3.274748051 |
| 3.409681662 |
| 3.826170095 |
| 3.541313423 |
| 3.305134233 |
| 3.07592438 |
| 2.983711492 |
| 3.143643 |
| 3.776345352 |
| 3.550840668 |
| 3.209879247 |
| 2.894622342 |
| 3.277126111 |
| 2.980778329 |
| 3.315895283 |
| 3.390258359 |
| 3.331099334 |
| 3.254222113 |
| 3.69107517 |
| 3.366550073 |
| 3.218454656 |
| 3.076940973 |
| 3.253763305 |
| 3.761784622 |
| 3.27567055 |
| 3.707688538 |
| 3.099816384 |
| 3.22807177 |
| 3.911159698 |
| 2.914494732 |
| 3.843017925 |
| 3.383674668 |
| 3.699635075 |
| 2.91656594 |
| 3.718573284 |
| 3.482988826 |
| 2.986854455 |
| 3.143025653 |
| 3.090335884 |
| 3.539807433 |
| 3.040046577 |
| 3.284336695 |
| 2.915610889 |
| 3.695318614 |
| 3.275442535 |
| 3.131224292 |
| 3.072369261 |
| 3.230404747 |
| 3.309516366 |
| 3.171502537 |
| 3.199433832 |
| 3.384945234 |
| 3.235782562 |
| 3.095970645 |
| 3.230873399 |
| 3.158491287 |
| 3.380537005 |
| 3.451403596 |
| 3.355018159 |
| 3.649910064 |
| 3.306364597 |
| 3.62249992 |
| 3.400775266 |
| 3.445752015 |
| 3.443951412 |
| 3.726288864 |
| 3.361039158 |
| 3.261488167 |
| 3.563718194 |
| 3.318941546 |
| 3.41040149 |
| 4.19 |
| 2.88086996 |
| 3.385049144 |
| 3.580847436 |
| 3.367347219 |
| 3.224657095 |
| 2.804644363 |
| 3.189376837 |
| 3.892097628 |
| 3.256779743 |
| 3.189520577 |
| 3.611697343 |
| 3.45839233 |
| 3.367765365 |
| 3.370238484 |
| 3.81492052 |
| 2.54295699 |
| 3.372023082 |
| 3.267997639 |
| 3.739560706 |
| 2.797814647 |
| 3.289796365 |
| 3.390438218 |
| 3.151463723 |
| 3.148043082 |
| 3.755438679 |
| 3.508299549 |
| 3.671315052 |
| 3.479405964 |
| 2.940394207 |
| 3.293155766 |
| 3.159529031 |
| 3.065854992 |
| 3.834298849 |
| 3.182880733 |
| 3.260278839 |
| 3.290971721 |
| 3.606575932 |
| 3.093831221 |
| 3.66 |
| 3.169843897 |
| 3.074258531 |
| 2.628623849 |
| 3.221437032 |
| 2.736076731 |
| 3.470447188 |
| 3.114936581 |
| 3.243443616 |
| 3.24067356 |
| 2.601852098 |
| 3.539550906 |
| 3.437148708 |
| 3.5256177 |
| 3.48862577 |
| 2.913031267 |
| 3.161518097 |
| 3.267676145 |
| 3.905692373 |
| 3.46982039 |
| 3.214284509 |
| 3.484966235 |
| 3.065974717 |
| 3.703148843 |
| 2.725831426 |
| 3.399189414 |
| 3.150842585 |
| 3.178950608 |
| 2.951076698 |
| 3.380265327 |
| 3.318566717 |
| 3.264837961 |
| 3.467628105 |
| 3.558723192 |
| 3.246532983 |
| 3.493787947 |
| 3.621985466 |
| 3.549805612 |
| 3.2732051 |
| 3.449053545 |
| 3.757966496 |
| 3.221916164 |
| 3.425639726 |
| 2.871984455 |
| 3.351044961 |
| 3.016583296 |
| 2.774548328 |
| 3.388077329 |
| 3.325802838 |
| 3.242785861 |
| 2.813166182 |
| 3.246611746 |
| 2.903695862 |
| 3.484426642 |
| 3.58429212 |
| 3.133758046 |
| 2.418121564 |
| 3.210145731 |
| 3.316379803 |
| 3.389766212 |
| 3.36406063 |
| 3.271975297 |
| 3.347293326 |
| 2.965111782 |
| 3.877932859 |
| 3.306745285 |
| 3.451293842 |
| 3.822482953 |
| 3.39903621 |
| 3.001554474 |
| 3.205805398 |
| 3.175604963 |
| 3.631184246 |
| 3.959118609 |
| 3.264154176 |
| 3.764408646 |
| 3.644994535 |
| 3.552841239 |
| 3.215441765 |
| 3.209362761 |
| 3.220741827 |
| 3.513696584 |
| 2.997865894 |
| 3.329241151 |
| 3.486065776 |
| 3.301865763 |
| 3.458570266 |
| 3.181451851 |
| 3.347025142 |
| 3.294506014 |
| 3.481300981 |
| 3.280781362 |
| 3.867965037 |
| 3.124761458 |
| 2.941163035 |
| 3.250534259 |
| 3.278400764 |
| 3.061411479 |
| 3.349996152 |
| 3.225794293 |
| 3.674561626 |
| 3.366812344 |
| 3.246876877 |
| 2.842904108 |
| 3.138428965 |
| 3.06126603 |
| 3.408672029 |
| 4.11 |
| 3.412453518 |
| 3.271963873 |
| 3.255557136 |
| 3.79510974 |
| 3.431578275 |
| 3.497267409 |
| 3.564238931 |
| 3.257180433 |
| 3.444567794 |
| 3.374195352 |
| 3.514185668 |
| 3.343288011 |
| 3.435785024 |
| 2.802868846 |
| 3.62171061 |
| 3.209248013 |
| 3.350440615 |
| 3.328221863 |
| 3.241191848 |
| 3.466633135 |
| 3.001043714 |
| 3.644133348 |
| 3.047920118 |
| 3.539578997 |
| 3.013582651 |
| 3.258139235 |
| 2.801196336 |
| 3.542792876 |
| 3.614891937 |
| 3.605915587 |
| 3.489160903 |
| 3.379467379 |
| 2.472992336 |
| 2.687317334 |
| 3.110289791 |
| 3.989235798 |
| 3.688730837 |
| 3.634221325 |
| 3.574646648 |
| 3.214300072 |
| 2.790333222 |
| 3.127257073 |
| 3.721544392 |
| 3.554424247 |
| 3.155579688 |
| 3.164605003 |
| 3.255454742 |
| 3.33378063 |
| 3.152524231 |
| 3.399884022 |
| 3.06598399 |
| 3.533892051 |
| 3.221487613 |
| 3.337479956 |
| 3.407554927 |
| 3.021696809 |
| 3.457208959 |
| 3.113982699 |
| 3.757396894 |
| 3.509660462 |
| 3.76209151 |
| 3.299084929 |
| 3.043712756 |
| 3.251527248 |
| 3.487158598 |
| 3.558513776 |
| 3.296986609 |
| 3.331335268 |
| 2.968579296 |
| 3.411850179 |
| 3.270895944 |
| 2.966845075 |
| 3.227155134 |
| 3.364082392 |
| 3.318188585 |
| 3.581442674 |
| 3.142303005 |
| 3.539129427 |
| 3.160584877 |
| 2.673218514 |
| 3.153244469 |
| 3.106733626 |
| 3.403304958 |
| 3.255697222 |
| 3.318896117 |
| 3.436342014 |
| 3.249528715 |
| 3.284385613 |
| 3.496070089 |
| 2.802144737 |
| 3.538125109 |
| 3.603502901 |
| 3.344853225 |
| 3.426822512 |
| 3.108349934 |
| 3.16382548 |
| 3.137316279 |
| 3.248093074 |
| 3.389697423 |
| 3.428240595 |
| 3.159725717 |
| 3.716650618 |
| 2.907816181 |
| 2.975074628 |
| 3.39546762 |
| 3.227865846 |
| 3.204904537 |
| 3.20789346 |
| 2.966227757 |
| 3.566733333 |
| 3.390166521 |
| 3.660621799 |
| 3.281987404 |
| 3.807238589 |
| 3.15077229 |
| 3.605062084 |
| 3.096680402 |
| 2.840586059 |
| 3.185433059 |
| 3.044979167 |
| 3.366967161 |
| 3.596050001 |
| 3.2713475 |
| 3.416408087 |
| 3.430210362 |
| 3.161066239 |
| 3.255588564 |
| 3.524735054 |
| 3.40546229 |
| 3.479188887 |
| 3.32479231 |
| 3.555668516 |
| 3.757085222 |
| 3.409296114 |
| 3.22 |
| 2.816798505 |
| 3.490675685 |
| 3.931429215 |
| 3.28892822 |
| 3.09506369 |
| 3.314830838 |
| 3.10709081 |
| 3.345706312 |
| 3.405592914 |
| 3.275771224 |
| 3.520050862 |
| 2.892544964 |
| 3.541611493 |
| 3.459106372 |
| 3.40559706 |
| 3.504112274 |
| 3.096015266 |
| 2.977589692 |
| 3.197336454 |
| 3.781400869 |
| 3.261033138 |
| 2.801627271 |
| 3.437516239 |
| 3.334673622 |
| 3.608500902 |
| 3.303927146 |
| 3.449003006 |
| 3.928071351 |
| 3.644750347 |
| 3.159796976 |
| 3.449264935 |
| 3.480920103 |
| 3.401250727 |
| 2.906235827 |
| 3.309374247 |
| 3.449946749 |
| 3.295978239 |
| 3.482509806 |
| 2.867709287 |
| 3.831787751 |
| 3.545528463 |
| 2.836024951 |
| 3.478141049 |
| 3.148500164 |
| 3.299522263 |
| 3.370142093 |
| 3.521291139 |
| 3.409984507 |
| 3.279245124 |
| 3.524055681 |
| 3.2 |
| 3.479777691 |
| 3.237865623 |
| 3.25107388 |
| 3.740984955 |
| 3.965139658 |
| 3.762763688 |
| 3.155914113 |
| 3.656977832 |
| 2.962252108 |
| 3.85320748 |
| 3.094895272 |
| 3.092448539 |
| 3.284905102 |
| 3.525615112 |
| 3.412433751 |
| 3.360822609 |
| 3.502216561 |
| 3.228794391 |
| 2.716987468 |
| 3.363984459 |
| 3.020828084 |
| 2.847591792 |
| 2.817867103 |
| 3.496249739 |
| 3.775584293 |
| 3.477709937 |
| 3.13196458 |
| 3.481637 |
| 3.301322612 |
| 3.224754774 |
| 3.906186283 |
| 2.8041825 |
| 3.085406067 |
| 2.938414759 |
| 3.475052276 |
| 3.214874478 |
| 3.404113571 |
| 3.710569886 |
| 3.803223301 |
| 3.0650186 |
| 3.438681332 |
| 2.998114744 |
| 3.403835 |
| 3.090932581 |
| 3.585787085 |
| 3.735366978 |
| 3.340876466 |
| 3.7157543 |
| 3.324525845 |
| 3.474584912 |
| 3.312496754 |
| 2.565972934 |
| 3.73372247 |
| 3.651649508 |
| 3.606489113 |
| 3.186896082 |
| 3.763217416 |
| 3.753529794 |
| 3.442458552 |
| 3.266277417 |
| 3.272455586 |
| 2.891838476 |
| 2.869633692 |
| 3.55 |
| 3.799581451 |
| 3.561573682 |
| 3.278659204 |
| 3.507915412 |
| 3.181822939 |
| 3.131833402 |
| 3.652671152 |
| 3.379170469 |
| 3.582613639 |
| 3.553397405 |
| 2.987367109 |
| 3.141263694 |
| 3.36871541 |
| 3.891591725 |
| 3.240713896 |
| 2.993992285 |
| 3.521635967 |
| 3.204236215 |
| 3.094048086 |
| 2.866756358 |
| 2.912603501 |
| 3.479097279 |
| 3.616953793 |
| 3.561875262 |
| 3.330032048 |
| 3.720017352 |
| 3.000979649 |
| 3.389268073 |
| 3.261301937 |
| 2.940137493 |
| 3.418085594 |
| 3.343235623 |
| 3.269035153 |
| 3.914479815 |
| 3.006780661 |
| 3.730544643 |
| 3.589638623 |
| 3.329345418 |
| 3.97300417 |
| 3.879252245 |
| 3.502121195 |
| 3.264012171 |
| 3.220930704 |
| 3.540570238 |
| 3.423175772 |
| 3.424024574 |
| 3.639409254 |
| 3.240423816 |
| 3.658585856 |
| 3.331176151 |
| 3.223864393 |
| 3.628848532 |
| 2.715650059 |
| 3.11029444 |
| 3.331078161 |
| 3.473894545 |
| 2.88186594 |
| 3.000179163 |
| 3.187019158 |
| 3.161858603 |
| 3.78478401 |
| 3.32296297 |
| 3.633899906 |
| 3.578262955 |
| 3.275788997 |
| 3.333664143 |
| 3.993306939 |
| 2.765661641 |
| 3.492910626 |
| 3.003412525 |
| 3.357138397 |
| 3.743548006 |
| 3.120545095 |
| 2.803058736 |
| 3.022128949 |
| 3.471279255 |
| 3.543058517 |
| 2.933892797 |
| 3.490129596 |
| 3.208331955 |
| 3.458419437 |
| 3.148646721 |
| 3.736796585 |
| 3.409159177 |
| 3.192867587 |
| 3.1911949 |
| 3.326583455 |
| 3.16522733 |
| 3.389574768 |
| 3.735836046 |
| 2.827654508 |
| 2.686509424 |
| 3.795739771 |
| 3.023248509 |
| 3.022114308 |
| 2.972011215 |
| 3.013797562 |
| 3.529980298 |
| 3.18315914 |
| 2.911946146 |
| 3.761528083 |
| 3.386574308 |
| 3.300832534 |
| 2.865737371 |
| 2.787830866 |
| 2.597206162 |
| 3.295966136 |
| 3.373087832 |
| 3.761574373 |
| 3.451246426 |
| 3.725973308 |
| 3.587157763 |
| 3.27953302 |
| 3.574820019 |
| 3.597688393 |
| 3.578229489 |
| 3.307527616 |
| 3.218847669 |
| 3.641946639 |
| 3.309172683 |
| 3.151302043 |
| 3.714957818 |
| 3.35685469 |
| 4.168658169 |
| 3.730162474 |
| 3.604176989 |
| 2.946802895 |
| 3.412427571 |
| 3.40893522 |
| 3.368480322 |
| 3.116300262 |
| 3.118474239 |
| 4.03406449 |
| 4.1 |
| 3.336486734 |
| 3.642455521 |
| 3.356071969 |
| 3.176726673 |
| 3.689638324 |
| 3.928216007 |
| 2.691027795 |
| 3.955813165 |
| 3.421106137 |
| 3.205286441 |
| 3.199207518 |
| 3.660520971 |
| 3.250724744 |
| 3.437191588 |
| 3.145006792 |
| 3.32730423 |
| 3.584542115 |
| 3.146047899 |
| 3.201530377 |
| 2.904145383 |
| 3.609196484 |
| 3.710578317 |
| 3.587717055 |
| 3.80795852 |
| 3.332822924 |
| 3.28578485 |
| 3.221645358 |
| 2.79938967 |
| 3.433083798 |
| 3.321641003 |
| 3.671699474 |
| 3.370705306 |
| 3.486862862 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
