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
- Evaluate the integrals. Please show steps and clear writing (No cursive)
- the edges of a cube are expanding at a rate of 3 cm/ sec find the rate at which the volume of the cube is changing when each edge is 5 centimeters find the
- All major feature films of today engage their audience through the art of visual narrative; they tell stories with moving imagery. Name your favorite movie