In the attached spreadsheet is a problem I need assistance with on…
QuestionAnswered step-by-stepIn the attached spreadsheet is a problem I need assistance with on…In the attached spreadsheet is a problem I need assistance with on the ‘Pearson Correlation’ 1. For the output labeled ‘pearson r output here’ , I need to verify this is correct.2. for the p-values, I need to verify I have the correct formulas3. I do not understand what is being asked for the reporting nor description. We have a horrible text 🙁 I need asssistance with this portion as well. Study Time Final Exam Score Student Satisfaction Survey Score 24 166 42 14 99 27 22 154 36 22 166 40 Pearson-r Output Here 16 124 29 Study Time Final Exam Score Student Satisfaction Survey Score24 168 38 Study Time 1.0000 18 134 35 Final Exam Score 0.7646 1.0000 18 135 32 Student Satisfaction Survey Score 0.5889 0.8328 1.000020 139 32 22 159 38 p-values 15 116 27 p-value (Study Time/Exam Score) 0.00000 18 136 32 p-value (Student Satisfaction/Exam) 0.00000 24 168 40 17 128 30 23 163 38 Reporting 20 139 34 Study Time and Exam Score 16 100 28 Student Satisfaction and Exam Score 22 158 37 23 163 38 Description of your results: 18 133 32 20 144 34 25 177 42 23 162 38 22 154 36 21 148 35 20 136 33 26 180 42 26 183 43 18 133 32 17 126 30 22 154 37 21 148 35 21 145 34 25 172 42 25 179 42 22 154 39 22 158 37 25 179 42 17 111 31 20 145 34 22 149 35 25 173 41 21 137 32 28 189 45 23 160 38 20 141 33 22 159 38 20 147 35 20 143 34 22 156 37 14 98 26 14 101 47 15 105 27 15 111 45 15 109 28 16 115 29 16 120 46 16 121 29 17 126 30 17 200 47 17 128 32 17 201 47 17 128 32 17 202 48 18 131 31 18 132 32 18 133 31 18 133 30 18 134 31 18 134 31 18 210 49 18 135 35 19 135 32 18 148 36 20 136 32 21 155 36 20 150 37 21 136 32 19 137 33 20 150 35 20 140 34 20 155 36 20 139 33 20 141 33 20 141 33 20 141 36 20 144 34 21 144 34 20 144 35 20 103 24 20 108 26 21 144 34 20 144 34 20 109 25 21 148 35 21 155 38 21 148 35 21 148 35 22 148 35 21 149 37 22 151 36 22 151 36 22 151 36 22 151 37 22 152 36 22 152 36 22 152 36 22 152 36 22 156 38 22 156 37 22 157 37 22 157 38 22 158 37 22 158 37 22 159 38 22 159 37 22 159 38 22 159 39 22 160 38 22 160 39 23 160 38 23 162 38 23 163 38 23 163 38 23 163 38 23 163 40 24 164 39 23 166 39 24 165 39 24 166 41 24 166 39 24 167 39 24 168 41 24 168 40 24 168 41 25 168 40 25 170 42 25 171 40 25 175 41 25 175 41 25 177 44 25 178 42 25 178 42 25 179 45 26 180 42 26 180 44 26 181 43 26 182 43 28 186 44 28 186 44 MathStatistics and ProbabilityMathematics MISCShare Question
