21. Excel's Solver is used in a time-series weighted moving average problem to: a. Predict estimates for more than one period into the future c. Maximize the MSE b. Minimize the mean square error (MSE) d. None of the above 22. Regarding regression analysis involving only one independent variable: a. The best method for solving is a visual fit of a line to the data; b. The best method for solving requires a "hyperplane fit to the data. c. The least squares method is mathematically the best way to apply it; d. The dependent variable is used to predict the value of the independent variable. I 23. The least squares method is based upon: a. Minimizing the unexplained variation. b. Maximizing the unexplained variation. c. Minimizing the explained variation. d. Maximizing the total variation. FCA RO and x represen