The file Focus.txt in the Focus Database folder of the WeissStats CD contains information on the undergraduate students at the University of Wisconsin %u2013 Eau Claire (UWEC). Those students constitute the population of interest in the Focusing on Data Analysis section that appear at the end of each chapter of the book.
Thirteen variables are considered. Table 1.9 lists the variables and the names used for those variables in the data files. We call the database of information for those variables the Focus database.
Also provided in the Focus Database folder is a file called FocusSample.txt that contains data on the same 13 variables for a simple random sample of 200 of the undergraduate students at UWEC. Those 200 students constitute a sample that can be used for making statistical interferences in the Focusing on Data Analysis sections. We call this sample data the Focus sample.
Large data sets are almost analyzed by computer, and that is how you should handle both the Focus database and the Focus sample. We have supplied the Focus database and Focus sample in several file formats in the focus database folder.
If you use a statistical software package for which we have not supplied a Focus database file, you should (1) input the file Focus.txt into that software (2) ensure that the variables are named as indicated in table 1.9 and (3) save the worksheet to a file named Focus in the formate suitable to your software, that is, with the appropriate file extension Then, any time that you want to analyze the Focus database, you can simply retrieve your
Variable Variable name
Sex SEX
High School percentile HSP
Cumulative GPA GPA
Age AGE
Total earned credits CREDITS
Classification CLASS
School/college COLLEGE
Primary major MAJOR
Residency RESIDENCY
Admission type TYPE
ACT English score ENGLISH
ACT math score MATH
ACT composite score COMP
a) Find the linear correlation coefficient between cumulative GPA and high school percentile for the 200 UWEC undergraduate students in the Focus sample
b) Repeat part (a) for cumulative GPA and each of ACT English score, ACT math score, and ACT composite score.
c) Among the variables high school percentile, ACT English score, ACT math score, and ACT composite score, identify the one that appears to be the best predictor of cumulative GPA. Explain your reasoning.
Now perform a regression analysis on cumulative GPA, using the predictor variable identified in part (c), as follows.
d) Obtain and interpret a scatterplot.
e) Find and interpret the regression equation.
f) Find and interpret the coefficient of determination.
g) Determine and interpret the three sums of squares SSR, SSE, and SST