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

Please encode the table below in excel in a continuous mannerand Compute

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!