Questions from Analytics

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

Choose an appropriate forecasting technique for the data in the Excel file Prime Rate and find the best forecasting model. Explain how you would use the model to forecast and how far into the future i...

Q: Using the data in the Excel file Computer Repair Times,

Using the data in the Excel file Computer Repair Times, determine if the company can claim that its average repair time is less than 15 days

Q: Shafer Office Supplies has four distribution centers, located in Atlanta,

Shafer Office Supplies has four distribution centers, located in Atlanta, Lexington, Milwaukee, and Salt Lake City, and ships to 12 retail stores, located in Seattle, San Francisco, Las Vegas, Tuscon,...

Q: Use Excel’s filtering capability to

Use Excel’s filtering capability to(1) Extract all orders for control panels,(2) All orders for quantities of less than 500 units, and(3) All orders for control panels with quantities of less than 500...

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

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

Q: For the data in the Excel file New Account Processing,

For the data in the Excel file New Account Processing, perform chi-square tests for independence to determine if certification is independent of gender, and if certification is independent of having p...

Q: Data in the Excel File Microprocessor Data shows the demand

Data in the Excel File Microprocessor Data shows the demand for one type of chip used in industrial equipment from a small manufacturer.a. Construct a chart of the data. What appears to happen when a...

Q: Cluster the records in the Excel file Ten Year Survey.

Cluster the records in the Excel file Ten Year Survey. Create up to five clusters and analyze the results to draw conclusions about the survey

Q: The Excel file Energy Production & Consumption provides data on

The Excel file Energy Production & Consumption provides data on production, imports, exports, and consumption. Develop line charts for each variable and identify key characteristics of the time series...

Q: The Excel file Unemployment Rates provides data on monthly rates

The Excel file Unemployment Rates provides data on monthly rates for 4 years. Compare 3- and 12-month moving average forecasts using the MAD criterion. Explain why the 3-month model yields better resu...