The Bureau of Labor Statistics records the number of work stoppages each month that involve 1000 or.

The Bureau of Labor Statistics records the number of work stoppages each month that involve 1000 or more workers in the period. Are such work stoppages seasonal in nature? Are there more work stoppages in summer than in winter? a. Open the Stoppage workbook from the Chapter11 folder and save it as Stoppage Analysis. b. Restructure the data in the Work Stoppage worksheet into a two-way table, with each year in a separate row and each month in a separate column. c. Use the two-way table to create a boxplot and line plot of the work stoppage values. Which months have the highest work stoppage

View complete question »The Bureau of Labor Statistics records the number of work stoppages each month that involve 1000 or more workers in the period. Are such work stoppages seasonal in nature? Are there more work stoppages in summer than in winter? a. Open the Stoppage workbook from the Chapter11 folder and save it as Stoppage Analysis. b. Restructure the data in the Work Stoppage worksheet into a two-way table, with each year in a separate row and each month in a separate column. c. Use the two-way table to create a boxplot and line plot of the work stoppage values. Which months have the highest work stoppage numbers? Do work stoppages occur more often in winter or in summer? d. Adjust the work stoppage values assuming a 12-month cycle. Is there evidence in the scatterplot that the adjusted number of work stoppages has decreased over the past decade? e. Smooth adjusted values using one parameter exponential smoothing. Use a value of 0.15 for the smoothing parameter. f. Save your changes to the workbook. Summarize your findings regarding work stoppages of 1000 or more workers. Are they seasonal? Have they declined in recent years? Use whatever charts and tables you created to support your conclusions.

View less »