Questions from Business Analytics

Q: For this exercise, use the Wikipedia database. Use MATCH and

For this exercise, use the Wikipedia database. Use MATCH and/or INDEX functions to find the following: a. The row numbers corresponding to the first and last instance of name Affaire_Réveillon in col...

Q: Use http://www.fao.org/faostat/en

Use http://www.fao.org/faostat/en/#data to extract an annual dataset for any topic of your interest that would aid in constructing a statistical forecasting model analysis. Download the relevant datas...

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 a simple three-period moving average. b. Compute MA...

Q: The Excel file New Registered Users provides data on new registrations to

The Excel file New Registered Users provides data on new registrations to an App on a monthly basis for four years. Compare the 3- and 12-month moving average forecasts using the MAD criterion. Explai...

Q: The Excel file Closing Stock Prices provides data for four stocks and

The Excel file Closing Stock Prices provides data for four stocks and the Dow Jones Industrial Average over a one-month period. a. Develop a spreadsheet for forecasting each of the stock prices and th...

Q: The Excel file Stock Prices provides data for four stocks and the

The Excel file Stock Prices provides data for four stocks and the stock exchange average over a 12 day period. a. Use Excel’s Data Analysis Exponential Smoothing tool to forecast each of the stock pri...

Q: Compute the Euclidean distance between the following set of points:

Compute the Euclidean distance between the following set of points: a. (1.06, 9.2) and (0.89, 10.3) b. (1.6, 0.628, 9.077) and (2.2, 1.555, 5.088)

Q: Extract the records and code the non-numerical data Company in

Extract the records and code the non-numerical data Company in the Excel file Train Journey Decisions. Apply the discriminant analysis to classify the occupied seats for the train passengers in the Re...

Q: The Excel file Auto Options provides data on options ordered together for

The Excel file Auto Options provides data on options ordered together for a particular automobile model. By examining the correlation matrix, suggest some Associations.

Q: The Excel file Automobile Options 2 provides data on options ordered together

The Excel file Automobile Options 2 provides data on options ordered together for a particular model of automobile. Consider the following rules: Rule 1: If Fastest Engine, then Traction Control. Rule...