Page 1 of 1
D L 0 4 8 = A B с E F G H 1 J K 4 5 Month number Jobs 6 October 1 104 Chart Title 7 November 2 102 150 8 December 3 99 1
Posted: Wed May 11, 2022 11:21 am
by answerhappygod
- 1 (62.88 KiB) Viewed 23 times
D L 0 4 8 = A B с E F G H 1 J K 4 5 Month number Jobs 6 October 1 104 Chart Title 7 November 2 102 150 8 December 3 99 100 9 January 4 94 50 10 February 5 93 y=-2.9643x + 107.29 11 March 6 89 0 2 1 3 5 6 7 12 April 87 7 13 May 8 14 a. Use the 'textbook' naïve method to forecast May jobs (Ft+1 = X4+ (X--X-1). 15 Answer =87 +(87-89) = 85 16 b. Use the four-period moving average to forecast jobs in May. 17 =average (D9:D12) 90.75 18 c. Use the trend method to forecast jobs in May. 19 Y = -2.9643*8 + 107.29 83.5756 20 21 IV. The table below lists data for vehicle miles per gallon and vehicle weight 22 A. Perform regression analysis to determine the slope and vertical intercept of the equation relating weight and MPG 23 B. What is the explanatory power (RSQ) of your regression equation? 24 C. Use that equation to predict MPG for a vehicle which weighs 2600 pound 25 26 MPG Weight MPG 27 41 1998 41 28 36 2199 36 29 35 2404 35 30 32 2611 32 31 30 3236 30 32 28 2806 28 33 20 3248 20 34 21 2812 21 35 18 3382 18 36 16 3736 16 37