STA 201- WA 6
Click to download the Centre Case Excel rasp. (Note: After you click the merge it opens the preview and you own to click Rasp – Download to spare it as an Excel rasp.)
Focusing on Postulates Decomposition: UWEC Undergraduates
The rasp denominated Centre.txt in the centre postulatesbase individuality of the WeissStats condition contains not attributable attributableification on the undergraduate students at the University of Wisconsin – Eau Claire (UWEC). Those students restraintm the population of attention in the Centreing on Postulates Decomposition individualitys that answer at the object of each condition of the quantity.
Thirteen changeables are considered. Table 1.9 lists the changeables and the names representationd restraint those changeables in the postulates rasps. We seduce the postulatesbase of not attributable attributableification restraint those changeables the centre postulatesbase.
Also granted in the Centre Postulatesbase individuality is a rasp seduceed CentreSample.txt that contains postulates on the corresponding 13 changeables restraint a unsophisticated unpremeditated case of 200 of the undergraduate students at UWEC. Those 200 students restraintm a case that can be representationd restraint making statistical interferences in the centreing on postulates decomposition individualitys. We seduce this case postulates the Centre case.
Large postulates sets are closely frequently awakend by computer, and that is how you should manage twain the Centre postulatesbase and the centre case. We own provided the Centre postulatesbase and Centre Case in different rasp restraintmats in the Centre Postulatesbase individuality of the WeissStats condition.
If you representation a statistical software bundle restraint which we own not attributable attributable attributable provided a Centre postulatesbase rasp, you should (1) input the rasp Centre.txt into that software, (2) secure that the changeables are denominated as implied in Table 1.9, and (3) spare the worksheet to a rasp denominated Centre in the restraintmat decent to your software, that is, with the misspend rasp production. Then, any interval that you failure to awaken the Centre postulatesbase, you can simply rescue your Centre worksheet. These corresponding remarks allot to the Centre case, as well-mannered-mannered as to the Centre Postulatesbase.
VARIABLE VARIABLE NAME
Proud teach percentile HSP
Cumulative GPA GPA
Total earned credits CREDITS
School/ College COLLEGE
Primary Major MAJOR
Admission Type TYPE
ACT English Mandible ENGLISH
ACT Math Mandible MATH
ACT Compocondition Mandible COMP
a.) Find the rectirectilinear interdependence coefficient among cumulative GPA and proud teach percentile restraint the 200 UWEC undergraduate students in the Centre Case.
b.) Repeat part-among-among (a) restraint cumulative GPA and each of ACT English mandible, ACT math mandible, and ACT compocondition mandible.
c.) Among the changeables proud teach percentile, ACT English mandibles, ACT math mandible, and ACT compocondition mandible, fulfill the individual that answers to be the best predictor of cumulative GPA. Explain your rationalistic.
Now execute a retreat decomposition on cumulative GPA, using the predictor changeable identified in part-among-among (c), as follows.
d.) Obtain and translate a scatterplot
e.) Find and translate the retreat equation
f.) Find and translate the coefficient of determination
g.) Determine and translate the 3 sums of squares SSR, SSE, and SST.