Order Your Paper From the most reliable Essay writing Service. 

.

 


13) The values of Alabama building contracts (in millions of dollars) for a 12 month period follow..

1 answer below »

13) The values of Alabama building contracts (in millions of dollars) for a 12 month period follow 240 350 230 260 280 320 220 310 240 310 240 230 Submit answers to question below in an excel file-Use Excel Solver a) Construct a time series plot. What type of pattern exists in the data? b) Use a 0.3 to compute the exponential smoothing values for the time series. c) Use Excel Solver to find the value that minimizes MSE (Hint: Minimize the sum of squared error.) If you are unable to download Solver, calculate manually as you have your other problems in this chapter.