The above link is the EXCEL sheet needed for the assignment.
I need help answering the questions provided (A to G) and with creating the Scatterplot in Excel.
Please use the above Data to make the Scatter Plot according to the parameters for Question D based on Question C's results.
Please provide a link to the excel scatterplot. Thank you so much!
Using the data from Chapter 1: UWEC Undergraduates (p. 34), and answer questions a, b, c, d, e, f, g (UWEC Undergraduates, p. 655)
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.
*****Question D is the one that needs a Scatter plot done in Excel******
Now perform a regression analysis on cumulative GPA, using the predictor variable identified in part C, as follows
D. Obtain and Interpret a Scatterplot
Recently Asked Questions
- Conditionals and if-statements 1.Which expression represents X is not equal to Y? X == Y X != Y X > Y X < Y X >= Y X <= Y 2. How can the game best determine if
- What educational endeavors can somebody plan to enact, based on the discussion of stigma community has towards normal ageing process and mental illness
- Common associated problems with pes cavus are