Question

QUESTION 7 The data set Beer Large, which can be found in StatCrunch Shared Data Sets, gives the Alcohol, Carbohydrates and Calories for different brands of beer. The explanatory variable is x + Carbohydrates and the response variable is Y - Calories. Use this information to answer: Calculate the correlation between carbohydrates and calories. (4 decimal places)

Answer 1

The correlation between carbohydrates and calories is calculated by using the function "=CORREL(array1, array2)" where in array1 dray carbs data and in array2 drag calorie data.

B D F H I K M N 0 P Carbs A Calories 94 171 111 Calories 196 193 Calories 150 E Calories 154 221 163 Carbs 19.7 Carbs 21.9 21.8 7.8 8.9 2.6 13.7 5.8 5 Carbs 10.2 116 9.9 10 Calories 218 194 Carbs 5.5 12.1 12.1 Carbs 9.9 11.5 12.2 1 2 3 4 5 6 7 8 9 G Calories 103 144 144 110 157 157 157 135 151 130 225 161 14 103 142 153 188 129 158 153 5.9 18.4 22.3 13.7 13.1 10.5 10.5 7.5 6.2 147 123 115 110 116 13 8.3 11.2 11.2 11.8 16 20.2 6.6 8 288 131 205 200 25 17 136 132 3.2 8 12.5 6.5 200 18 7.6 95 157 133 169 8.9 10.2 137 145 4.4 10.6 10 10 138 174 148 96 149 110 143 110 13.1 140 14 11.1 13.5 12 11 12.5 146 7 160 15 113 7 95 3.2 99 3.1 162 64 155 195 15 Correlation 0.5186 12 13 14 166 15 20 15 15 14.5 14 1.9 10 2.4 13.1 7 156 148 215 147 174 12 17.7 145 13 13.3 14.1 55 145 150 135 14 13 8.3 114 146 143 110 96 128 110 110 7 12 155 152 110 175 113 95 155 10 12 98 135 145 120 149 163 152 170 6.6 12 9.6 10.8 146 144 3.2 11.4 6.2 6.2 6.2 11.4 17.9 6.7 2.6 14.2 15.6 13.9 11.6 142 162 180 15.3 13.9 16.8 16.2 16 110 128 146 12.9 11.9 12.01 12 12.1 14.15 12.66 17.3 32.1 177 14.3 3.5 179 222 158 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 98 144 188 166 165 105 163 154 11.4 12.3 165 313 7.3 10.5 13.4 14.6 163 153 13.9 12.5 18 19.9 190 330 214 150 271 5.7 7.4 12.2 5.3 12.5 160 202 220 147 123 110 149 104 152 162 16.6 9.3 18.9 21.5 10.4 10.6 8.6 160 160 157 14.1 6.6 19.4 13.4 16.7 19.3 314 138 190 166 222 16.86 23.94 9.6 16 16 195 215 231 14.8 8.7 9.8 197 130 222 160 20 14.1 119 238 149 11 175

The correlation between carbs and calories is 0.5186.