For this assignment, you will need to use \"Practice Data_2_.xls \" dataset to p
ID: 3302037 • Letter: F
Question
For this assignment, you will need to use "Practice Data_2_.xls " dataset to perform and interpret TWO Pearson correlation analyses: Study hours per week (STUDY_HR) & GPA SAT & GPA FOR EACH ANALYSIS ABOVE, state the following: A clear and concise research question: (e.g., “Is there a relationship between X and Y?”) Null hypothesis (e.g., "There is no relationship between X and Y.") Research hypothesis (non-directional) (e.g., "There is a relationship between X and Y.") Basic descriptive analysis of each of the variables used (e.g., mean, median, mode, minimum, maximum, and range) Your correlational findings in a format/template below. (Please use the template carefully and appropriately to adapt it to your own analyses.)Please include the EXCEL output (e.g., tables and such) using the Data Toolpak.I would suggest that you do all of the above for STUDY_HR and GPA and then repeat the process for SAT and GPA. (It would make it easier to follow and grade.) “There is a strong, positive relationship between happiness and sleep (r=.70), such that those who tend to have more hours of sleep report higher levels of happiness. This is a significant relationship (p=.034)”
Explanation / Answer
There is no data provided. I am giving you example how to solve in excel.
The Excel Correl function calculates the Pearson Correlation Coefficient for two sets of values.
The syntax of the function is:
CORREL( array1, array2 )
Where array1 is a set of independent variables and array2 is a set of dependent variables. These arrays should be of equal length.
Example
Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.
Data1
Data2
3
9
2
7
4
12
5
15
6
17
Formula
Description
Result
=CORREL(A2:A6,B2:B6)
Correlation coefficient of the two data sets in columns A and B.
0.997054486
Hope this will helpful to you. Thanks and God bless you ;-)
Data1
Data2
3
9
2
7
4
12
5
15
6
17
Formula
Description
Result
=CORREL(A2:A6,B2:B6)
Correlation coefficient of the two data sets in columns A and B.
0.997054486
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.