This document contains instructions for a time series analysis assignment using data on monthly dollar sales and quarterly earnings per share. Students are asked to use the MINITAB software to:
1) Plot the raw time series data and assess whether each series is stationary or non-stationary.
2) Compute autocorrelations at various time lags and test if they are significantly different from zero.
3) Take the first differences of the raw data and re-examine stationarity by plotting the differenced data and computing autocorrelations.
This document contains instructions for a time series analysis assignment using data on monthly dollar sales and quarterly earnings per share. Students are asked to use the MINITAB software to:
1) Plot the raw time series data and assess whether each series is stationary or non-stationary.
2) Compute autocorrelations at various time lags and test if they are significantly different from zero.
3) Take the first differences of the raw data and re-examine stationarity by plotting the differenced data and computing autocorrelations.
This document contains instructions for a time series analysis assignment using data on monthly dollar sales and quarterly earnings per share. Students are asked to use the MINITAB software to:
1) Plot the raw time series data and assess whether each series is stationary or non-stationary.
2) Compute autocorrelations at various time lags and test if they are significantly different from zero.
3) Take the first differences of the raw data and re-examine stationarity by plotting the differenced data and computing autocorrelations.
This document contains instructions for a time series analysis assignment using data on monthly dollar sales and quarterly earnings per share. Students are asked to use the MINITAB software to:
1) Plot the raw time series data and assess whether each series is stationary or non-stationary.
2) Compute autocorrelations at various time lags and test if they are significantly different from zero.
3) Take the first differences of the raw data and re-examine stationarity by plotting the differenced data and computing autocorrelations.
Important instruction: Write down all the commands of MINITAB used to compute the answers (e.g., Stat -> Time Series -> Time Series Plot).
Q.1:John Mosby, owner of several Mr. Tux rental stores, is beginning to forecast his most important business variable, monthly dollar sales. One of his employees, Virginia Perot, gathered the sales data. John decides to use all 96 months of data he has collected. The data is stored in the file sales.xls a. Use MINITAB to plot the data as a time series. b. Do you think that the series is stationary or not? If not, identify the components. c. Compute the autocorrelations for time lags 1 and 2. Test to determine whether these autocorrelation coefficients are significantly different from zero at the 0.05 level of significance. d. Compute the autocorrelation confidents for twenty four time lags. Is this time series stationary? e. Compute the first differences of the data. f. Compute the autocorrelations for time lags 1 and 2 using the differenced data. g. Use MINITAB to plot the differenced data and compute the autocorrelation coefficients for the differenced data for first six time lags. h. Is this time series stationary? If not which component is present. Q.2: An analyst would like to determine whether there is a pattern to earnings per share for the Price Company, which operates a wholesale/retail cash-and-carry business in several states under the name Price Club. The data are shown in the following table.
Quarterly Earnings per Share for the Price Company: 1986-1993
b. Do you think that the series is stationary or not? c. Plot linear, quadratic and exponential trend to the following data set. Write the best model in terms of the accuracy measures. d. Compute the autocorrelations for time lags 1 and 2. Test to determine whether these autocorrelation coefficients are significantly different from zero at the 0.05 level of significance. e. Compute the autocorrelation confidents for the first six time lags. Is this time series stationary? f. Compute the first differences of the data. g. Compute the autocorrelations for time lags 1 and 2 using the differenced data. h. Use MINITAB to plot the differenced data and compute the autocorrelation coefficients for the differenced data for first six time lags. Is this time series stationary?
Secure immediate PDF access to every chapter of Test Bank for Statistics for Business Decision Making and Analysis 3rd Edition Stine Foster 0134497163 9780134497167.
