Question: Please encode the table below in excel in a continuous manner and Compute the correlation between two variables using Correlation to determine if there is
Please encode the table below in excel in a continuous manner
and Compute the correlation between two variables using Correlation to determine if there is significant relationship between Age and Achievement.
Kindly follow the steps on how to get the value after selecting the data as shown in the picture. Note that the level of significance determines if there is significant relationship/correlation or not. If the significant level is 0.05, any value less than or equal to 0.05 means that there is significant relationship between two continuous data. Also, the relationship can be positive or negative. Level of relationship can be determined from the r value. Refer to the level of relationship based on the given rules below.
r = below + .20 - extremely low relationship
r = + .20 - +.39 - low relationship
r = + .40 - +.59 - moderate relationship
r = + .60 - +.79 - high relationship
r = + .80 - + 1.0 - very high relationship
To use SPSS software, you can get the value with this sequence
Analyze ? Correlate ? Bivariate ? Transfer continuous data to the right ? Option ? tick means and standard deviations ? continue ? Ok
Then transfer the results in Microsoft Word Application. Give your interpretation to the results. Use the given format
Format:
Introduction
Hypothesis
Results and Discussions
Table and Graph
Interpretation
Conclusion

Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
