Use Statistical Analysis to show which assessment tool correlates better with sc
ID: 3349914 • Letter: U
Question
Use Statistical Analysis to show which assessment tool correlates better with score and score time.
Anxiety Assessment Tool Tool 1 Tool 2 Tool 3 Score Score time 1 0 None 5 153 2 2 Mild 7 189 4 7 Mild-Moderate 7 51 1 1 Mild 3 66 2 5 Mild-Moderate 6 216 3 6 Moderate 0 115 2 2 None 0 154 3 5 Mild-Moderate 3 74 2 5 Mild-Moderate 0 59 2 5 Mild 0 88 2 3 Mild 0 105 1 3 Mild 0 47 4 7 Moderate-High 0 61 1 0 None 0 85 3 6 Mild 0 81 2 4 Mild 7 103 3 6 Mild 0 54 3 6 Moderate 8 409 2 6 Mild-Moderate 10 330 2 3 Mild 0 91 2 0 None 0 85 2 3 Mild 0 266 1 3 Mild 0 103 2 4 Mild 0 60 3 6 Mild-Moderate 0 258 1 1 None 10 138 1 3 Mild 2 224 1 1 None 5 149 3 5 Mild-Moderate 7 119 3 7 Moderate-High 7 114 4 7 Moderate-High 10 89 3 5 Moderate 0 84 1 4 Mild 10 194 3 7 Moderate-High 9 90 3 5 Mild-Moderate 6 253 1 7 Moderate 6 160 5 8 Moderate-High 6 335 2 4 None 9 191 2 1 Mild 8 176 2 7 Moderate 0 93 3 7 Moderate 8 153 3 7 Moderate 4 237 1 0 None 8 109 1 2 None 6 137 1 0 None 5 133 1 7 Moderate 0 122 1 0 None 0 120 1 3 Mild 7 104 3 5 Mild-Moderate 7 65 2 10 Moderate-High 3 198 3 8 Moderate-High 5 128 2 2 Mild 3 86 2 2 Mild 8 125 2 5 Moderate 9 112 1 0 None 0 233 4 7 Mild-Moderate 10 127 2 3 Mild 5 128 4 10 High 0 140 1 2 Mild 6 112 1 0 None 4 131 2 1 Mild 5 106 2 3 Mild 7 167 2 1 None 8 238 2 0 None 7 406 2 2 None 0 104 1 0 None 0 81 1 1 None 5 257 1 1 Mild 7 70 4 6 Moderate 9 114 4 9 Moderate-High 0:00 213 2 3 Mild 9 395 2 3 Mild 4 195 1 5 Mild 7 300 1 0 None 0 150 3 6 Moderate-High 0 83 2 3 Mild 4 129 2 2 Mild 6 230 2 2 Mild 3 166 2 2 Mild 5 116 2 3 Mild 0 122 2 1 Mild 0 82 2 2 Mild 8 182 1 2 Mild 4 137 1 1 Mild 6 113 1 1 None 0 133 1 0 None 7 252 2 5 Mild 10 306 1 4 Mild 3 98 4 8 Moderate-High 3 140 1 1 None 0 119 3 7 Moderate 0 120 1 0 None 0 79 2 4 Mild-Moderate 3 212Explanation / Answer
The Correlation Analysis is the Best Statistical Analysis tools for checking these two variables are correlated or not. Correlation measured that there is linear relationship between score and score time variables.
Using Excel command " CORREL(array1, array2)" , we get correlation between score and score time. where array1 is score data and array2 is score time data.
here correlation = 0.36
which represents weak linear relation between score and score time variables.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.