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
- Which one of the following coordination complexes would you expect to have the largest formation constant? (en is the bidentate ligand ethane-1,2 diamine,
- Hello, I'm having problem here with taxation question. i need someone to assist me with the assignment
- Explain how the addition of salts preserves foods (what happen to bacterial cell walls)? what can be converted back to Glycogen to go back into Glycolysis?