(a) Forecast PRICE for 2021-25 (I recommend using Excel or some other spreadsheet package). Graph your predicted PRICE vs. the actual PRICE for this time period. (b) Calculate the root mean square error. The formula for root mean square error is sqrt(sum((price; - predictedprice;)*2)/5) (c) Compute the elasticities of this price equation with respect to CNY, INCOME, POP, and PS based on 2021 actual price. (d) Suppose that climate change reduced the crop yield (CNY) by 10% lower than the projected yields in the table above from 2021-25. Plot the crop price with and without climate change by plotting the original predicted price in (a) and the new predicted price in (d). (e) Suppose the government increased the price support level to $2.00 for 2021-25. Graph the original predicted price in (a) against the new predicted price with PS=2. (f) Suppose the population projections were low, and the new ones are 1% higher. Plot the original predicted price in (a) against the new population projections in (f).Suppose you estimated the following price forecasting equation for an annual crop: Dependent Variable: PRICE Method: Least Squares Variable Coefficient Std. Error t-Statistic Prob. C -11.30310 4.432247 -2.550197 0.0196 PRICE(-1) 0.257996 0.131677 1.959308 0.0649 INCOME -0.000164 8.63E-05 -1.899769 0.0728 POP 0.066704 0.023783 2.804759 0.0113 CNY -0.017009 0.005124 -3.319135 0.0036 PS 0.475428 0.204047 2.329994 0.0310 where: C is a constant or the intercept PRICE is the price per bushel in the current year PRICE(-1) is the price per bushel in the previous year INCOME is consumer disposable income POP is the population of the U.S. CNY is the average national yield of the crop in bushels per acre PS is the government set price support for the crop Suppose that you wanted to use this equation and the following values for the independent variables to forecast PRICE for 2021-25: PRICE PRICE(-1) CNY INCOME POP PS 2021 1.940000 1.500000 119.8000 13545 243.9340 1.820000 2022 2.540000 1.940000 84.60000 14477 246.3290 1.770000 2023 2.360000 2.540000 116.3000 15313 248.7770 1.650000 2024 2.280000 2.360000 118.5000 16236 251.5230 1.570000 2025 2.400000 2.280000 108.6000 16693 249.6967 1.620000