Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started