Reference no: EM13845080

Case Study: UWEC Undergraduates

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

The Focus sample contains information on the undergraduate students at the University of Wisconsin - Eau Claire (UWEC).  Open the Focus sample worksheet (Focus Sample) and do the following.

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.

Attachment:- WA6_FocusSample.xls