Week12345678Value1813161117141713 The Excel file data.xlsx contains time-series values for 8 consecutive weeks. The variables are:Week: The serial number of a week.Value: The time-series value observed for a week.Prepare an Excel file with the following computations -1. Using the naïve method compute the following:a. Forecast for the next week (week 2 - week 8)b. Mean forecast errorc. Mean absolute errord. Mean squared errore. Mean percentage errorf. Mean absolute percentage error2. Using the average of all the historical data compute the following:a. Forecast for the next week (week 2-week 8)b.Mean forecast errorc. Mean absolute errord. Mean squared errore. Mean percentage errorf. Mean absolute percentage error3. Using the moving average method (k-2) compute the following:a. Forecast for the next week (week 3 - week 8)b. Mean forecast errorc. Mean absolute errord. Mean squared errore. Mean percentage errorf. Mean absolute percentage error4. Using the exponential smoothing method (a=0.8) compute the following:a. Forecast for the next week (week 2 - week 8)b. Mean forecast errorc. Mean absolute errord. Mean squared errore. Mean percentage errorf. Mean absolute percentage error

Given the time series values for 8 consecutive weeks as Week Value 1 18 2 13 3 16 4 11…

Answered: The Excel file data.xlsx contains…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Blood pressure: A blood pressure measurement consists of two numbers: the systolic pressure, which is the maximum pressure taken when the heart is contracting, and the diastolic pressure, which is the minimum pressure taken at the beginning of the heartbeat. Blood pressures were measured, in millimeters of mercury (mmHg), for a sample of 10 adults. The following table presents the results. Use a TI-84 calculator to answer the following. Diastolic Systolic Diastolic Systolic 134 87 118 115 130 76 113 77 116 70 123 77 133 91 119 69 112 75 Based on results published in the Journal of Human Hypertension Send data to Excel If the systolic pressures of two patients differ by 16 millimeters, by how much would you predict their diastolic pressures to differ? Round the answer to three decimal places. Their diastolic pressures would differ by millimeters. X $ Part: 3/4 Part 4 of 4 Predict the diastolic pressure for a patient whose systolic pressure is 140 millimeters. Round the answer to one…
The table below contains real data for the first two decades of AIDS reporting. Year # AIDS cases diagnosed # AIDS deaths Pre-1981 91 29 1981 319 121 1982 1,170 453 1983 3,076 1,482 1984 6,240 3,466 1985 11,776 6,878 1986 19,032 11,987 1987 28,564 16,162 1988 35,447 20,868 1989 42,674 27,591 1990 48,634 31,335 1991 59,660 36,560 1992 78,530 41,055 1993 78,834 44,730 1994 71,874 49,095 1995 68,505 49,456 1996 59,347 38,510 1997 47,149 20,736 1998 38,393 19,005 1999 25,174 18,454 2000 25,522 17,347 2001 25,643 17,402 2002 26,464 16,371 Total 802,118 489,093 Graph "year" versus "# AIDS cases diagnosed" (plot the scatter plot). Do not include pre-1981 data. Perform linear regression. Write the equations. (Round your answers to the nearest whole number. Round r to four decimal places.) (a) Linear Equation: 9 - (b) a = (c) b= (d) (e) n-
Answer for the following question
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?
Question 9 The first quartile (Q1) corresponds to the The median corresponds to the th The third quartile (Q3) corresponds to the th percentile. percentile. th percentile.
Develop a frequency distribution for the variable "Yearly Salary." Start with your Bin with 40,000 and increment it by 15,000 up to 130,000
You collect data of average annual returns for Amazon Stock and Microsoft Stock and make the following table: (This data can be copied into Excel.) Year Amazon Return Microsoft Return 2013 0.5896 0.1221 2014 -0.2218 0.2416 2015 1.1778 0.1944 2016 0.1095 0.1200 2017 0.5596 0.3766 2018 0.2843 0.1874 2019 0.3216 0.5526 You use this data to answer the research question: are true population Amazon Returns greater than true population Microsoft Returns?
Johnson Filtration, Inc., provides maintenance service for water-filtration systems throughout southern Florida. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Time bo + b₁ Months + b₂ Type + b3 Person Round your answers to three decimal places. bo b₁ b₂ b3 Repair Time in Hours 2.8 3.0 4.7 1.9 2.9 4.8 4.2 4.9 4.3 4.4 0000 Months Since Last Service 2 6 8 3 a. Develop the estimated regression equation to predict the repair time given the number of months since the last maintenance service, the type of repair, and the repairperson who performed the service. Assume that ₂ = 1 if the type of repair is electrical and 3 = 1 if Dave Newton performed the service. Enter negative value as negative number. 2 7 9 8 4 6 Type of Repair Electrical Mechanical Electrical Mechanical…
Which of the following is the most appropriate type of chart for determining the number of observations at or below a specific value? Select one: a. A histogram. b. A pie chart. c. A time-series chart. d. A cumulative frequency ogive.
For question 4, Using the actual Year-3 numbers check your forecast accuracy, by calculating CFE, MSE, MAD, MAPE, and the tracking signal on microsoft Excel can you show step by step?
sQ. 16 Explain the method of simple averages of computing the indices of seasonal variations.
Bilue Green Hazel Brown Brown Brown Blue Blue Birown Brown Brown Hazel Blue Hazel Brown Brown Brown Brown Brown Blue Brown Hazel Green Brown Brown Blue Brown Brown Hazel Brown Green Hazel Brown Brown Brown Brown The data above is a random sample of eye colors collected from a group of 40 MVCC students

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS