Please help! Trying to make sure my steps are correct and running out of time.

Use the variable Green Beans to forecast the number of green beans for month 169 using a five-month moving average. What is the forecast for month 169? Round your answer to 1 decimal place.

Use the variable Green Beans to forecast the number of green beans for month 169 using an exponential smoothing constant, = 0.6. What is the forecast for month 169? Round your answer to 1 decimal place.

Use the variable Green Beans to forecast the number of green beans using a 5-month moving average and a model with an exponential smoothing constant, = 0.6 . Which model produces a more accurate forecast the five month moving average (Forecast A) or the exponential smoothing constant, = 0.6 (Forecast B)? Use the MSE to support your answer.

Month GreenBns 184336 1 2 147677 3 124821 4 103125 80031 5 81518 123193 7 263758 9 260146 10 234632 208237 11 189759 12 158418 13 135750 14 111393 15 94549 16 17 76863 18 75177 142850 19 20 236556 21 249682 22 219228 196034 23 24 171884 25 150779 129530 26 108632 27 93087 28 78399 29 30 71150 31 130649 231016 32 33 237804 34 221846 200997 35 182613 36 37 153198 38 129225 108630 39 94416 40 41 79158 74180 42 150302 43 44 238716 45 252750 233453 46 208994 47 48 182898 159966 49 50 137845 51 112011 92054 52 53 74526 54 59839 92882 55 56 188295 57 203871 195770 58 172487 59 146418 60 61 119449 99720 62 63 73778 64 57434 40918 65 66 38204 67 104744 68 211443 283175 69 258051 70 71 231991 72 207702 177110 73 149802 74 75 124896 106506 76 96501 77 78 85694 79 156221 80 287056 330800 81 301270 82 83 273872 84 253184 222082 85 86 191636 87 176013 88 145535 89 124352 90 113486 91 187132 92 328410 361060 93 94 313380 95 284483 248737 96 97 229513 98 209327 180431 99 154790 100 135005 101 102 116360 183040 103 253331 104 250742 105 231844 106 107 207878 108 190465 109 172659 110 150960 129729 111 112 103921 113 87548 114 73907 115 127207 116 226162 117 258410 217852 118 119 213348 120 184418 121 166632 122 137737 118908 123 95360 124 125 77110 126 71457 151051 127 269075 128 129 306632 275252 130 247042 131 132 224681 133 202515 161518 134 143916 135 114495 136 137 99028 138 87436 156197 139 140 269042 297034 141 142 268790 143 241566 144 224297 145 192814 146 172568 148658 147 121526 148 149 92856 80224 150 151 135849 152 250870 282133 153 255912 154 227381 155 202607 156 178636 157 158 148003 128520 159 160 112655 94363 161 162 84908 163 156250 164 273944 165 296589 166 283497 167 255806 230661 168 co Month GreenBns 184336 1 2 147677 3 124821 4 103125 80031 5 81518 123193 7 263758 9 260146 10 234632 208237 11 189759 12 158418 13 135750 14 111393 15 94549 16 17 76863 18 75177 142850 19 20 236556 21 249682 22 219228 196034 23 24 171884 25 150779 129530 26 108632 27 93087 28 78399 29 30 71150 31 130649 231016 32 33 237804 34 221846 200997 35 182613 36 37 153198 38 129225 108630 39 94416 40 41 79158 74180 42 150302 43 44 238716 45 252750 233453 46 208994 47 48 182898 159966 49 50 137845 51 112011 92054 52 53 74526 54 59839 92882 55 56 188295 57 203871 195770 58 172487 59 146418 60 61 119449 99720 62 63 73778 64 57434 40918 65 66 38204 67 104744 68 211443 283175 69 258051 70 71 231991 72 207702 177110 73 149802 74 75 124896 106506 76 96501 77 78 85694 79 156221 80 287056 330800 81 301270 82 83 273872 84 253184 222082 85 86 191636 87 176013 88 145535 89 124352 90 113486 91 187132 92 328410 361060 93 94 313380 95 284483 248737 96 97 229513 98 209327 180431 99 154790 100 135005 101 102 116360 183040 103 253331 104 250742 105 231844 106 107 207878 108 190465 109 172659 110 150960 129729 111 112 103921 113 87548 114 73907 115 127207 116 226162 117 258410 217852 118 119 213348 120 184418 121 166632 122 137737 118908 123 95360 124 125 77110 126 71457 151051 127 269075 128 129 306632 275252 130 247042 131 132 224681 133 202515 161518 134 143916 135 114495 136 137 99028 138 87436 156197 139 140 269042 297034 141 142 268790 143 241566 144 224297 145 192814 146 172568 148658 147 121526 148 149 92856 80224 150 151 135849 152 250870 282133 153 255912 154 227381 155 202607 156 178636 157 158 148003 128520 159 160 112655 94363 161 162 84908 163 156250 164 273944 165 296589 166 283497 167 255806 230661 168 co