Consider the following time series data Month 1 2 3 4 5 6 7 8 9 10 11 12 Value 90 89 86 91 90 91 88 86 91 93 90 88 a) Construct a time series plot in Excel. Label the axes and graph. c) Develop a smoothing model forecast with α = 0.35. Compute MSE and forecast for month 13 d) Which model is the better predictor? Why?

Consider the following time series data Month 1 2 3 4 5 6 7 8 9 10 11 12 Value 90 89 86 91 90 91 88 86 91 93 90 88 a) Construct a time series plot in Excel. Label the axes and graph. c) Develop a smoothing model forecast with α = 0.35. Compute MSE and forecast for month 13 d) Which model is the better predictor? Why?

Calculus: Early Transcendentals

8th Edition

ISBN:9781285741550

Author:James Stewart

Publisher:James Stewart

Chapter1: Functions And Models

Section: Chapter Questions

Problem 1RCC: (a) What is a function? What are its domain and range? (b) What is the graph of a function? (c) How...

See similar textbooks

Similar questions

For the data set, perform exponential smoothing with alpha = 0.1 to determine the forecast for week 20. week Sales (1000s of gallons) 1 17 2 21 3 19 4 23 5 18 6 16 7 20 8 18 9 22 10 20 11 15 12 22 13 31 14 34 15 31 16 33 17 28 18 32 19 30
Year Percent of workers paid hourly rates 1979 61.2 1980 60.7 1981 61.3 1982 61.3 1983 61.8 1984 61.7 1985 61.8 1986 62.0 1987 62.7 1990 62.8 1992 62.9 The percent of female wage and salary workers who are paid hourly rates is given above for the years 1979-1992. a. Using "year" as the independent variable and "percent" as the dependent variable, make a scatter plot of the data. b. Does it appear from inspection that there is a relationship between the variables? c. Find the estimated percents for 1991 and 1988. d. Use the two points in part C to plot the least squares line on your graph from part A.
the data contained in the datafile named crudecost shows the U.S. refiner acquisition cost of crude oil in dollars per barrel (energy information administration website,February 3, 2014).a. construct a time series plot. What type of pattern exists in the data?
Sunspot Numbers Listed below in order by row are annual sunspot numbers beginning with 1980. Is the best model a good model? Carefully examine the scatterplot and identify the pattern of the points. Which of the models fits that pattern?
For the data set, perform a 3 month moving average to determine the forecast for month 13. Show all work in an Excel file. month rate 1 9.5 2 9.3 3 9.4 4 9.6 5 9.8 6 9.7 7 9.8 8 10.5 9 9.9 10 9.7 11 9.6 12 9.6
2. The number of public branch libraries in the United States for several years is given in the table: Year Public Library Branches G500 1994 6223 1995 6172 1996 Branches 6205 1997 6332 1998 6435 a. Graph the data b. Find an equation for a model of these data. Year b. Using your model, estimate the number of branch libraries in 2000 c. Use the graph to estimate in what year(s) there are 6500 branch Libraries
the table shows the percent of households with internet access for selected years from 2009 and projected through 2015. Year Percent of households 2009 67 2010 70 2011 72.5 2012 75 2013 76.5 2014 77.2 2015 78 Use the model to predict the percent of households with internet access in 2022.
I have this much done, but need help with E, i,ii,iii Which asks: Choose a year other than the one from part 2c. A birth year or the first year might be a good choice(I picked 1990) .i. Use the trend line equation to estimate the y-value for the year of your choice. Find the relative change in the y-value for your chosen year compared to the last year’s value you found in part 2c iii. Interpret the meaning of your relative change value. F.Should we use the trend line model to estimate the y-value for 2020? Why or why not? Note: Hey there! Thank you for the question. As you have posted multiple sub-parts, we have helped you solve the first three parts, according to our policy. Please re-post the other parts with complete background information. Step 2 Calculation: As it is required to build a scatterplot with a trendline, we need to use Excel, where this feature is available. The independent or predictor variable is year, which we have denoted as x, and the dependent…
a. Obtain the linear trend equation for the following data on new checking accounts at Fair Savings Bank and use it to predict expected new checking accounts for periods 16 through 19. (Round your intermediate calculations and final answers to 2 deci places.) Period New Accounts Period, New Accounts Period New Accounts 1 2 3 4 Y Y16 Y17 Y18 Y19 200 214 211 220 235 6 7 8 9 10 237 248 250 258 267 11 12 13 14 15 281 275 287 288 316
Listed below are the numbers of deaths resulting from motor vehicle crashes. Let x represent the year, with 1975 coded as x = 1, 1980 coded as x = 6, 1985 coded as x = 11, and so on. Construct a scatterplot and identify the mathematical model that best fits the given data. Use the best model to find the projected number of deaths for the year 2028. x (year) 1975 1980 1985 1990 1995 2000 2005 2010 D y (deaths) 44,533 51,122 43,809 44,590 41,798 41,960 43,436 32,697 (...) Choose the correct graph below. O A. O B. O C. D. 52000- 52000- 52000- 52000- DDDD 00 X X X X 32000+ 32000 32000+ 32000+ 0 40 0 40 0 40 0 40 What is the equation of the best model? Select the correct choice below and fill in the answer boxes to complete your choice. Enter only nonzero values. (Type integers or decimals rounded to three decimal places as needed.) O A. y= X B. y = + In x O C. y = + O D. X y=² O E. y = x² + X + Use the best model to find the projected number of such deaths for the year 2028. The projected…
Weekly sales of copy paper at Cubicle Suppliers are in the table below. Compute a three-period moving average and a four-period moving average for weeks 5, 6, and 7. Compute each forecast. Which model is more accurate? Forecast week 8 with the more accurate method. Week Sales (cases) 1 17 2 21 3 27 4 31 5 19 6 17 7 21