Can someone PLEASE answer this question using excel, with the equations, and as much detail as possible! Thank you so so much!!!

Questions 30, 31, 32, 33 and 34 refer to the data in the file that accompanies this book named CalfPrices.xlsx representing the selling price of 3-month-old calves at a livestock auction during the past 22 weeks. 30. Prepare a line graph of these data. Do the data appear to be stationary or nonstationary? 31. Compute the two-period and four-period moving average predictions for the data set. a. Prepare a line graph comparing the moving average predictions against the original data. b. Compute the MSE for each of the two moving averages. Which appears to provide the best fit for this data set? c. Compute forecasts for the next 2 weeks using the two-period and four-period moving average techniques. 32. Use Solver to determine the weights for a four-period weighted moving average on the data set that minimizes the MSE. a. What are the optimal values for the weights? b. Prepare a line graph comparing the weighted moving average predictions against the original data. c. What are the forecasts for weeks 23 and 24 using this technique? 33. Create an exponential smoothing model that minimizes the MSE for the data set. Use Solver to estimate the optimal value of a. a. What is the optimal value of a? b. Prepare a line graph comparing the exponential smoothing predictions against the original data. c. What are the forecasts for weeks 23 and 24 using this technique? c. What are the forecasts for weeks 23 and 24 using this technique? 34. Use Holt's method to create a model that minimizes the MSE for the data set. Use Solver to estimate the optimal values of a and B. a. What are the optimal values of a and B? b. Are these values surprising? Why or why not? Week 10 11 Price $176 $172 $174 $177 $173 $171 $172 $173 $174 $173 $171 $172 $174 $177 $180 $178 $176 $179 $175 $176 $174 $175 12 13 14 15 16 17 18 19 20 21 22 23 24 Questions 30, 31, 32, 33 and 34 refer to the data in the file that accompanies this book named CalfPrices.xlsx representing the selling price of 3-month-old calves at a livestock auction during the past 22 weeks. 30. Prepare a line graph of these data. Do the data appear to be stationary or nonstationary? 31. Compute the two-period and four-period moving average predictions for the data set. a. Prepare a line graph comparing the moving average predictions against the original data. b. Compute the MSE for each of the two moving averages. Which appears to provide the best fit for this data set? c. Compute forecasts for the next 2 weeks using the two-period and four-period moving average techniques. 32. Use Solver to determine the weights for a four-period weighted moving average on the data set that minimizes the MSE. a. What are the optimal values for the weights? b. Prepare a line graph comparing the weighted moving average predictions against the original data. c. What are the forecasts for weeks 23 and 24 using this technique? 33. Create an exponential smoothing model that minimizes the MSE for the data set. Use Solver to estimate the optimal value of a. a. What is the optimal value of a? b. Prepare a line graph comparing the exponential smoothing predictions against the original data. c. What are the forecasts for weeks 23 and 24 using this technique? c. What are the forecasts for weeks 23 and 24 using this technique? 34. Use Holt's method to create a model that minimizes the MSE for the data set. Use Solver to estimate the optimal values of a and B. a. What are the optimal values of a and B? b. Are these values surprising? Why or why not? Week 10 11 Price $176 $172 $174 $177 $173 $171 $172 $173 $174 $173 $171 $172 $174 $177 $180 $178 $176 $179 $175 $176 $174 $175 12 13 14 15 16 17 18 19 20 21 22 23 24