Test #3 Part 2(1) . Excel ?? Help ? Tel me what you want to do File Insert Page
ID: 2907093 • Letter: T
Question
Test #3 Part 2(1) . Excel ?? Help ? Tel me what you want to do File Insert Page Layout Formules Data Review View Home General % Cut Merge & Center . s-% , 1.01£2, condition. Formatting Copy ??? Alignment B 1 u . :-;;? ?,: ? Paste ?FormatPartet Font B25 Question 5: If you were to get the below results after running a Durbin-Watson test on d Consumer Price Index by month what would you say about this data? ata forecasting the 4 Durbin-Watson Calculations 67.309 634 6 Sum of Squared Difference of Residuals Sum of Squared Residuals Durbin-Watson Statistic ? Question 1 ? Question 2 : Question 3 Question 4 Ouestion | Question 6 arstion 7 1 e Chinese diffeencesFrom the Yeat 3 Pat21)-ae E F8 F9 F10Explanation / Answer
Answer
we know that when the Durbin watson test statistic is between 0 and 2, then there is a positive autocorrelation between the two variables and when the durbin watson test statistic is between 2 and 4, then there is a negative autocorrelation between the two variables.
so, in this case the Durbin watson test statistic is 0.106, which suggests that there is positive autocorrelation between the consumer price index and month