Questions from Business Analytics

Q: For the data in the Excel file Airport Passengers, do the

For the data in the Excel file Airport Passengers, do the following: a. Develop a spreadsheet for forecasting the number of airport passengers using simple exponential smoothing with smoothing constan...

Q: For the coal production example using double exponential smoothing, experiment with

For the coal production example using double exponential smoothing, experiment with the spreadsheet model to find the best values of  and  that minimize MAD.

Q: Consider the prices for the Stock Exchange in the Excel file Stock

Consider the prices for the Stock Exchange in the Excel file Stock Prices. Use simple linear regression to forecast the data. What would be the forecasts for the next three days?

Q: Consider the data in the Excel file Internet Users. Use simple

Consider the data in the Excel file Internet Users. Use simple linear regression to forecast the data. What would be the forecast for the next three years?

Q: Develop a multiple linear regression model with categorical variables that incorporate seasonality

Develop a multiple linear regression model with categorical variables that incorporate seasonality for forecasting the deaths caused by accidents in the United States. Use the data for years 1976 and...

Q: Develop a multiple regression model with categorical variables that incorporate seasonality for

Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting sales using the last three years of data in the Excel file Auto Sales.

Q: Develop a multiple regression model with categorical variables that incorporate seasonality for

Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting 2010 housing starts using the 2008 and 2009 data in the Excel file Housing Starts.

Q: Develop a multiple regression model with categorical variables that incorporate seasonality for

Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting for the data in the Excel file Tourists Arrival.

Q: Experiment with the Holt-Winters Additive Model for Seasonality spreadsheet to

Experiment with the Holt-Winters Additive Model for Seasonality spreadsheet to find the best combination of  and  to minimize MAD.

Q: Enhance the Yield Rates database file to perform a database query that

Enhance the Yield Rates database file to perform a database query that finds the rate associated with any date and term. (This is a challenging question because you will not be able to use the term he...