Can you also show a pixture od the answrs in excel
Compute the correlation between motivation and GPA.
Test for the significance of the correlation coefficient at the .05 level using a two-tailed test.
True or false? The more highly you are motivated, the more you will study. Which did you select and why?
able[[Motivation,GPA,Motivation,GPA],[1,3.4,6,2.6],[6,3.4,7,2.5],[2,2.5,7,2.8],[7,3.1,2,1.8],[5,2.8,9,3.7],[4,2.6,8,3.1],[3,2.1,8,2.5],[1,1.6,7,2.4],[8,3.1,6,2.1],[6,2.6,9,4.0],[5,3.2,7,3.9],[6,3.1,8,3.1],[5,3.2,7,3.3],[5,2.7,8,3.0],[6,2.8,9,2.0]]
1.Compute the correlation between motivation and GPA 2. Test for the significance of the correlation coefficient at the .05 level using a two-tailed test 3.True or false The more highly you are motivated, the more you will study.Which did you select and why?
Motivation
GPA 3.4 3.4 2.5 3.1 2.8 2.6 2.1 1.6 3.1 2.6 3.2 3.1 3.2 2.7 2.8
Motivation 6 7 7 2 9 8 8 7 6 9
GPA 2.6 2.5 2.8 1.8 3.7 3.1 2.5 2.4 2.1 4.0 3.9 3.1 3.3 3.0 2.0
1
6 2 7 5 4 3 1 8 6
6 5 5 6
8 7 8 6