Questions from Analytics

Q: The Excel file CD Interest Rates provides annual average interest

The Excel file CD Interest Rates provides annual average interest rates on 6-month certificate of deposits. Compare the Holt-Winters additive and multiplicative models using XLMiner with the default p...

Q: Construct an appropriate chart to show the proportion of funds

Construct an appropriate chart to show the proportion of funds in each investment category in the Excel file Retirement Portfolio

Q: The Excel file Olympic Track and Field Data provides the

The Excel file Olympic Track and Field Data provides the gold medal-winning distances for the high jump, discus, and long jump for the modern Olympic Games. Develop forecasting models for each of the...

Q: Financial analysts often use the following model to characterize changes

Financial analysts often use the following model to characterize changes in stock prices:Pt = P0e(µ-0.5σ2)t+σZ√tWhereP0 = current stock pricePt = price at time tµ = mean (logarithmic) change of the st...

Q: Apply cluster analysis to the Excel file Sales Data, using

Apply cluster analysis to the Excel file Sales Data, using the input variables Percent Gross Profit, Industry Code, and Competitive Rating. Create four clusters and draw conclusions about the grouping...

Q: Choose an appropriate forecasting technique for the data in the

Choose an appropriate forecasting technique for the data in the Excel file Coal Consumption and find the best forecasting model. Explain how you would use the model to forecast and how far into the fu...

Q: Choose an appropriate forecasting technique for the data in the

Choose an appropriate forecasting technique for the data in the Excel file DJIA December Close and find the best forecasting model. Explain how you would use the model to forecast and how far into the...

Q: Choose an appropriate forecasting technique for the data in the

Choose an appropriate forecasting technique for the data in the Excel file Federal Funds Rates and find the best forecasting model. Explain how you would use the model to forecast and how far into the...

Q: Search the Conference Board’s Web site to find economic forecasts

Search the Conference Board’s Web site to find economic forecasts and reports about their business cycle indicators. Write a short report about your findings

Q: Choose an appropriate forecasting technique for the data in the

Choose an appropriate forecasting technique for the data in the Excel file Mortgage Rates and find the best forecasting model. Explain how you would use the model to forecast and how far into the futu...