Using excel. For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. a. Construct a time series plot. What type of pattern exists in the data? b. Compare the three-month moving average approach with the exponential smoothing approach for α=\alpha =α= .2. Which provides more accurate forecasts using MSE as the measure of forecast accuracy? c. What is the forecast for next month?

The number of pounds of steam used per month by a chemical plant is thought to be related to the average ambient temperature (in F) for that month. The past year's usage and temperatures are in the following table: Usage/ Month Temp. 1000 Month 21 185.79 July. 24 214.47 Aug. 32 288.03 Sept. 47 424.84 Oct. 50 454.58 Nov. 59 539.03 Dec. Jan. Feb. Mar. Apr. May June Temp. 68 74 62 50 41 30 Identify which are the independent and dependent variables. Usage/ 1000 621.55 675.06 562.03 452.93 369.95 273.98

at 2 presented based on the Health Information National Trends Survey (HINTS) LALYSIS

In Table L-1, the total value of imports of Indonesian goods and services from China for the 2010-2019 period is reported on a quarterly basis. With this data you are asked to analyze it with the Trend model and Seasonal Index. Question: a. Calculate a moving average with the average period length of 4 or MA (4) [why four?] And put the results in a column. Beware of selecting the rows to place the average result. b. Calculate the moving average with the length of the average period is 2 from the data in column MA (4) and the result is given the symbol MA (2x4) and the result is placed in a column. Beware of selecting the rows to place the average result. c. Calculate the ratio to the Moving Average (Y / MA (2x4)) and place it in a new column! d. Calculate a seasonal index and interpret the results! e. Create a Deseasonalized data series and place it in a new column! f. Plot the Dessasonalized data series and read the long-term movement patterns of data! Remember that understanding of…

Section 2.1, question 9