In: Math
PSY-520 Graduate Statistics
Topic 5 – Benchmark – Correlation and Regression Project
Directions: Use the following information to complete the questions below. While APA format is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.
This benchmark assignment assesses the following programmatic competencies: 3.1: Interpret psychological phenomena using scientific reasoning
(a) and (b):
Let us consider the following variables: Score in Tests, Hours of Study and Financial Condition of the Student's Family...
Here, we just want to find a linear relationship among these variables... In this regard, we can collect a sample of students (say from 10 respondents) and then ask them about the number of hours that they study per day. Analyse their financial condition and then rate it on a predetermined scale (say 1 to 5)...
Later on we can determine the linear relationship among these variables...
Process/Instrument: Multiple Regression in Excel/R/Minitab/ SPSS etc...
Sample Solution:
X1 values | X2 values | Y values |
7 | 3 | 18 |
4 | 3 | 11 |
3 | 3 | 12 |
5 | 2 | 13 |
6 | 4 | 17 |
9 | 5 | 21 |
9 | 4 | 24 |
3 | 4 | 7 |
3 | 3 | 11 |
9 | 3 | 19 |
Mean = 5.8 | Mean = 3.4 | Mean = 15.3 |
So, the linear equation is:
Score = 3.72 + 1.92*Hours + 0.125*Economic Condition
Excel Solution:
Score | Hour | Financial |
18 | 7 | 3 |
11 | 4 | 3 |
12 | 3 | 3 |
13 | 5 | 2 |
17 | 6 | 4 |
21 | 9 | 5 |
24 | 9 | 4 |
7 | 3 | 4 |
11 | 3 | 3 |
19 | 9 | 3 |
The Excel output is:
The Regression Equation is:
Score = 3.72 + 1.92*Hours + 0.125*Economic Condition.