Question

ignore my answers i was just guessing

The manager of a travel agency has been using a seasonally adjusted forecast to predict demand for packaged tours. The actual and predicted values are as follows: Period Demand 140 Predicted 120 200 150 AWN- 194 169 100 80 136 128 O V 95 124 101 150 149 105 94 85 84 140 128 134

Answer 1

linear regression line Observation X 120 y 0.6711x+65.368 R2 0.5865 104 C 100 105 106 107 77 1 11 2 22 81 80 108 3 35 89 109 4 28 80 60 101 110 5 47 111 6 46 91 112 33 86 40 113 20 75 114 19 70 20 115 10 18 68 116 11 26 87 117 12 19 88 0 118 13 28 93 0 10 20 30 40 50 119 1.044 124.4J0

step 1: select the X and Y columns and insert X-Y chart

step 2: select the chart and select 'show trendline and value of R2'

Answer b: y = 65.368 + 0.671 x

Answer c: R² = 0.5865, R² represents the variation in the dependent variable eplained by indeoendent variable.

Answer d: if the value of x= 41, y= 65.368 + 0.671*41= 92.879