Consider the following time series data: Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy: a. Mean absolute error b. Mean squared error c. Mean absolute percentage error d. What is the forecast for week 7?

Question

Want to see more full solutions like this?

Answer 1

Textbook Question

Chapter 5, Problem 1P

Consider the following time series data:

Chapter 5, Problem 1P, Consider the following time series data:

Using the naïve method (most recent value) as the forecast

Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy:

a. Mean absolute error
b. Mean squared error
c. Mean absolute percentage error
d. What is the forecast for week 7?

Definition Definition Measure of central tendency that is the average of a given data set. The mean value is evaluated as the quotient of the sum of all observations by the sample size. The mean, in contrast to a median, is affected by extreme values. Very large or very small values can distract the mean from the center of the data. Arithmetic mean: The most common type of mean is the arithmetic mean. It is evaluated using the formula: μ = 1 N ∑ i = 1 N x i Other types of means are the geometric mean, logarithmic mean, and harmonic mean. Geometric mean: The nth root of the product of n observations from a data set is defined as the geometric mean of the set: G = x 1 x 2 ... x n n Logarithmic mean: The difference of the natural logarithms of the two numbers, divided by the difference between the numbers is the logarithmic mean of the two numbers. The logarithmic mean is used particularly in heat transfer and mass transfer. ln x 2 − ln x 1 x 2 − x 1 Harmonic mean: The inverse of the arithmetic mean of the inverses of all the numbers in a data set is the harmonic mean of the data. 1 1 x 1 + 1 x 2 + ...

(a)

Expert Solution

To determine

Find the value of mean absolute error.

Answer to Problem 1P

The mean absolute error is 4.4.

Explanation of Solution

Week	Time Series Value	Forecast	Forecast Error	Absolute Value of Forecast Error
1	18
2	13	18	−5	5
3	16	13	3	3
4	11	16	−5	5
5	17	11	6	6
6	14	17	−3	3
			Total	22

MAE=∑|er|n−k=225=4.4

Thus, the mean absolute error is 4.4.

(b)

Expert Solution

To determine

Obtain the mean squared error.

Answer to Problem 1P

The mean squared error is 20.8.

Explanation of Solution

The mean squared error is obtained as given below:

Absolute Value of Forecast Error	Squared Forecast Error
5	25
3	9
5	25
6	36
3	9
22	104

MSE=∑|er|2n−k=1045=20.8

Thus, the mean squared error is 20.8.

(c)

Expert Solution

To determine

Find the mean absolute percentage error.

Answer to Problem 1P

The mean absolute percentage error is 31.88.

Explanation of Solution

The mean absolute percentage error is obtained is given below:

Week	Time Series Value (yi)	Forecast	Forecast Error ei	Percentage Error yiei	Absolute percentage Error \|yiei\|
1	18
2	13	18	−5	−38.46	38.46
3	16	13	3	18.75	18.75
4	11	16	−5	−45.45	45.45
5	17	11	6	35.29	35.29
6	14	17	−3	−21.43	21.43
			Total	−51.30	159.38

MAPE=∑i=k+1n|yiei|100n−k=159.385=31.88

Thus, the mean absolute percentage error is 31.88.

(d)

Expert Solution

To determine

Obtain the forecast for week 7.

Answer to Problem 1P

The forecast for week 7 is 14.

Explanation of Solution

The forecast for week 7 is obtained as given below:

y^7=y6=14

Thus, the forecast for week 7 is 14.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

A hat contains slips of paper numbered 1 through 6. You draw two slips of paper at random from the hat,without replacing the first slip into the hat.(a) (5 points) Write out the sample space S for this experiment.(b) (5 points) Express the event E : {the sum of the numbers on the slips of paper is 4} as a subset of S.(c) (5 points) Find P(E)(d) (5 points) Let F = {the larger minus the smaller number is 0}. What is P(F )?(e) (5 points) Are E and F disjoint? Why or why not?(f) (5 points) Find P(E ∪ F )

In addition to the in-school milk supplement program, the nurse would like to increase the use of daily vitamin supplements for the children by visiting homes and educating about the merits of vitamins. She believes that currently, about 50% of families with school-age children give the children a daily megavitamin. She would like to increase this to 70%. She plans a two-group study, where one group serves as a control and the other group receives her visits. How many families should she expect to visit to have 80% power of detecting this difference? Assume that drop-out rate is 5%.

A recent survey of 400 americans asked whether or not parents do too much for their young adult children. The results of the survey are shown in the data file. a) Construct the frequency and relative frequency distributions. How many respondents felt that parents do too much for their adult children? What proportion of respondents felt that parents do too little for their adult children? b) Construct a pie chart. Summarize the findings

Answer 2

Textbook Question

Chapter 5, Problem 1P

Consider the following time series data:

Chapter 5, Problem 1P, Consider the following time series data:

Using the naïve method (most recent value) as the forecast

Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy:

a. Mean absolute error
b. Mean squared error
c. Mean absolute percentage error
d. What is the forecast for week 7?

Definition Definition Measure of central tendency that is the average of a given data set. The mean value is evaluated as the quotient of the sum of all observations by the sample size. The mean, in contrast to a median, is affected by extreme values. Very large or very small values can distract the mean from the center of the data. Arithmetic mean: The most common type of mean is the arithmetic mean. It is evaluated using the formula: μ = 1 N ∑ i = 1 N x i Other types of means are the geometric mean, logarithmic mean, and harmonic mean. Geometric mean: The nth root of the product of n observations from a data set is defined as the geometric mean of the set: G = x 1 x 2 ... x n n Logarithmic mean: The difference of the natural logarithms of the two numbers, divided by the difference between the numbers is the logarithmic mean of the two numbers. The logarithmic mean is used particularly in heat transfer and mass transfer. ln x 2 − ln x 1 x 2 − x 1 Harmonic mean: The inverse of the arithmetic mean of the inverses of all the numbers in a data set is the harmonic mean of the data. 1 1 x 1 + 1 x 2 + ...

(a)

Expert Solution

To determine

Find the value of mean absolute error.

Answer to Problem 1P

The mean absolute error is 4.4.

Explanation of Solution

Week	Time Series Value	Forecast	Forecast Error	Absolute Value of Forecast Error
1	18
2	13	18	−5	5
3	16	13	3	3
4	11	16	−5	5
5	17	11	6	6
6	14	17	−3	3
			Total	22

MAE=∑|er|n−k=225=4.4

Thus, the mean absolute error is 4.4.

(b)

Expert Solution

To determine

Obtain the mean squared error.

Answer to Problem 1P

The mean squared error is 20.8.

Explanation of Solution

The mean squared error is obtained as given below:

Absolute Value of Forecast Error	Squared Forecast Error
5	25
3	9
5	25
6	36
3	9
22	104

MSE=∑|er|2n−k=1045=20.8

Thus, the mean squared error is 20.8.

(c)

Expert Solution

To determine

Find the mean absolute percentage error.

Answer to Problem 1P

The mean absolute percentage error is 31.88.

Explanation of Solution

The mean absolute percentage error is obtained is given below:

Week	Time Series Value (yi)	Forecast	Forecast Error ei	Percentage Error yiei	Absolute percentage Error \|yiei\|
1	18
2	13	18	−5	−38.46	38.46
3	16	13	3	18.75	18.75
4	11	16	−5	−45.45	45.45
5	17	11	6	35.29	35.29
6	14	17	−3	−21.43	21.43
			Total	−51.30	159.38

MAPE=∑i=k+1n|yiei|100n−k=159.385=31.88

Thus, the mean absolute percentage error is 31.88.

(d)

Expert Solution

To determine

Obtain the forecast for week 7.

Answer to Problem 1P

The forecast for week 7 is 14.

Explanation of Solution

The forecast for week 7 is obtained as given below:

y^7=y6=14

Thus, the forecast for week 7 is 14.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 3

Textbook Question

Chapter 5, Problem 1P

Consider the following time series data:

Chapter 5, Problem 1P, Consider the following time series data:

Using the naïve method (most recent value) as the forecast

Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy:

a. Mean absolute error
b. Mean squared error
c. Mean absolute percentage error
d. What is the forecast for week 7?

Definition Definition Measure of central tendency that is the average of a given data set. The mean value is evaluated as the quotient of the sum of all observations by the sample size. The mean, in contrast to a median, is affected by extreme values. Very large or very small values can distract the mean from the center of the data. Arithmetic mean: The most common type of mean is the arithmetic mean. It is evaluated using the formula: μ = 1 N ∑ i = 1 N x i Other types of means are the geometric mean, logarithmic mean, and harmonic mean. Geometric mean: The nth root of the product of n observations from a data set is defined as the geometric mean of the set: G = x 1 x 2 ... x n n Logarithmic mean: The difference of the natural logarithms of the two numbers, divided by the difference between the numbers is the logarithmic mean of the two numbers. The logarithmic mean is used particularly in heat transfer and mass transfer. ln x 2 − ln x 1 x 2 − x 1 Harmonic mean: The inverse of the arithmetic mean of the inverses of all the numbers in a data set is the harmonic mean of the data. 1 1 x 1 + 1 x 2 + ...

(a)

Expert Solution

To determine

Find the value of mean absolute error.

Answer to Problem 1P

The mean absolute error is 4.4.

Explanation of Solution

Week	Time Series Value	Forecast	Forecast Error	Absolute Value of Forecast Error
1	18
2	13	18	−5	5
3	16	13	3	3
4	11	16	−5	5
5	17	11	6	6
6	14	17	−3	3
			Total	22

MAE=∑|er|n−k=225=4.4

Thus, the mean absolute error is 4.4.

(b)

Expert Solution

To determine

Obtain the mean squared error.

Answer to Problem 1P

The mean squared error is 20.8.

Explanation of Solution

The mean squared error is obtained as given below:

Absolute Value of Forecast Error	Squared Forecast Error
5	25
3	9
5	25
6	36
3	9
22	104

MSE=∑|er|2n−k=1045=20.8

Thus, the mean squared error is 20.8.

(c)

Expert Solution

To determine

Find the mean absolute percentage error.

Answer to Problem 1P

The mean absolute percentage error is 31.88.

Explanation of Solution

The mean absolute percentage error is obtained is given below:

Week	Time Series Value (yi)	Forecast	Forecast Error ei	Percentage Error yiei	Absolute percentage Error \|yiei\|
1	18
2	13	18	−5	−38.46	38.46
3	16	13	3	18.75	18.75
4	11	16	−5	−45.45	45.45
5	17	11	6	35.29	35.29
6	14	17	−3	−21.43	21.43
			Total	−51.30	159.38

MAPE=∑i=k+1n|yiei|100n−k=159.385=31.88

Thus, the mean absolute percentage error is 31.88.

(d)

Expert Solution

To determine

Obtain the forecast for week 7.

Answer to Problem 1P

The forecast for week 7 is 14.

Explanation of Solution

The forecast for week 7 is obtained as given below:

y^7=y6=14

Thus, the forecast for week 7 is 14.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 4

Textbook Question

Chapter 5, Problem 1P

Consider the following time series data:

Chapter 5, Problem 1P, Consider the following time series data:

Using the naïve method (most recent value) as the forecast

Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy:

a. Mean absolute error
b. Mean squared error
c. Mean absolute percentage error
d. What is the forecast for week 7?

Definition Definition Measure of central tendency that is the average of a given data set. The mean value is evaluated as the quotient of the sum of all observations by the sample size. The mean, in contrast to a median, is affected by extreme values. Very large or very small values can distract the mean from the center of the data. Arithmetic mean: The most common type of mean is the arithmetic mean. It is evaluated using the formula: μ = 1 N ∑ i = 1 N x i Other types of means are the geometric mean, logarithmic mean, and harmonic mean. Geometric mean: The nth root of the product of n observations from a data set is defined as the geometric mean of the set: G = x 1 x 2 ... x n n Logarithmic mean: The difference of the natural logarithms of the two numbers, divided by the difference between the numbers is the logarithmic mean of the two numbers. The logarithmic mean is used particularly in heat transfer and mass transfer. ln x 2 − ln x 1 x 2 − x 1 Harmonic mean: The inverse of the arithmetic mean of the inverses of all the numbers in a data set is the harmonic mean of the data. 1 1 x 1 + 1 x 2 + ...

(a)

Expert Solution

To determine

Find the value of mean absolute error.

Answer to Problem 1P

The mean absolute error is 4.4.

Explanation of Solution

Week	Time Series Value	Forecast	Forecast Error	Absolute Value of Forecast Error
1	18
2	13	18	−5	5
3	16	13	3	3
4	11	16	−5	5
5	17	11	6	6
6	14	17	−3	3
			Total	22

MAE=∑|er|n−k=225=4.4

Thus, the mean absolute error is 4.4.

(b)

Expert Solution

To determine

Obtain the mean squared error.

Answer to Problem 1P

The mean squared error is 20.8.

Explanation of Solution

The mean squared error is obtained as given below:

Absolute Value of Forecast Error	Squared Forecast Error
5	25
3	9
5	25
6	36
3	9
22	104

MSE=∑|er|2n−k=1045=20.8

Thus, the mean squared error is 20.8.

(c)

Expert Solution

To determine

Find the mean absolute percentage error.

Answer to Problem 1P

The mean absolute percentage error is 31.88.

Explanation of Solution

The mean absolute percentage error is obtained is given below:

Week	Time Series Value (yi)	Forecast	Forecast Error ei	Percentage Error yiei	Absolute percentage Error \|yiei\|
1	18
2	13	18	−5	−38.46	38.46
3	16	13	3	18.75	18.75
4	11	16	−5	−45.45	45.45
5	17	11	6	35.29	35.29
6	14	17	−3	−21.43	21.43
			Total	−51.30	159.38

MAPE=∑i=k+1n|yiei|100n−k=159.385=31.88

Thus, the mean absolute percentage error is 31.88.

(d)

Expert Solution

To determine

Obtain the forecast for week 7.

Answer to Problem 1P

The forecast for week 7 is 14.

Explanation of Solution

The forecast for week 7 is obtained as given below:

y^7=y6=14

Thus, the forecast for week 7 is 14.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 5

Textbook Question

Answer 6

Textbook Question

Answer 7

(a)

Expert Solution

To determine

Find the value of mean absolute error.

Answer to Problem 1P

The mean absolute error is 4.4.

Explanation of Solution

Week	Time Series Value	Forecast	Forecast Error	Absolute Value of Forecast Error
1	18
2	13	18	−5	5
3	16	13	3	3
4	11	16	−5	5
5	17	11	6	6
6	14	17	−3	3
			Total	22

MAE=∑|er|n−k=225=4.4

Thus, the mean absolute error is 4.4.

(b)

Expert Solution

To determine

Obtain the mean squared error.

Answer to Problem 1P

The mean squared error is 20.8.

Explanation of Solution

The mean squared error is obtained as given below:

Absolute Value of Forecast Error	Squared Forecast Error
5	25
3	9
5	25
6	36
3	9
22	104

MSE=∑|er|2n−k=1045=20.8

Thus, the mean squared error is 20.8.

(c)

Expert Solution

To determine

Find the mean absolute percentage error.

Answer to Problem 1P

The mean absolute percentage error is 31.88.

Explanation of Solution

The mean absolute percentage error is obtained is given below:

Week	Time Series Value (yi)	Forecast	Forecast Error ei	Percentage Error yiei	Absolute percentage Error \|yiei\|
1	18
2	13	18	−5	−38.46	38.46
3	16	13	3	18.75	18.75
4	11	16	−5	−45.45	45.45
5	17	11	6	35.29	35.29
6	14	17	−3	−21.43	21.43
			Total	−51.30	159.38

MAPE=∑i=k+1n|yiei|100n−k=159.385=31.88

Thus, the mean absolute percentage error is 31.88.

(d)

Expert Solution

To determine

Obtain the forecast for week 7.

Answer to Problem 1P

The forecast for week 7 is 14.

Explanation of Solution

The forecast for week 7 is obtained as given below:

y^7=y6=14

Thus, the forecast for week 7 is 14.

Answer 8

(a)

Expert Solution

To determine

Find the value of mean absolute error.

Answer to Problem 1P

The mean absolute error is 4.4.

Explanation of Solution

Week	Time Series Value	Forecast	Forecast Error	Absolute Value of Forecast Error
1	18
2	13	18	−5	5
3	16	13	3	3
4	11	16	−5	5
5	17	11	6	6
6	14	17	−3	3
			Total	22

MAE=∑|er|n−k=225=4.4

Thus, the mean absolute error is 4.4.

Answer 9

(a)

Expert Solution

Answer 10

(a)

Expert Solution

Answer 11

Expert Solution

Answer 12

To determine

Find the value of mean absolute error.

Answer 13

Answer to Problem 1P

The mean absolute error is 4.4.

Answer 14

Explanation of Solution

Week	Time Series Value	Forecast	Forecast Error	Absolute Value of Forecast Error
1	18
2	13	18	−5	5
3	16	13	3	3
4	11	16	−5	5
5	17	11	6	6
6	14	17	−3	3
			Total	22

MAE=∑|er|n−k=225=4.4

Thus, the mean absolute error is 4.4.

Answer 15

(b)

Expert Solution

To determine

Obtain the mean squared error.

Answer to Problem 1P

The mean squared error is 20.8.

Explanation of Solution

The mean squared error is obtained as given below:

Absolute Value of Forecast Error	Squared Forecast Error
5	25
3	9
5	25
6	36
3	9
22	104

MSE=∑|er|2n−k=1045=20.8

Thus, the mean squared error is 20.8.

Answer 16

(b)

Expert Solution

Answer 17

(b)

Expert Solution

Answer 18

Expert Solution

Answer 19

To determine

Obtain the mean squared error.

Answer 20

Answer to Problem 1P

The mean squared error is 20.8.

Answer 21

Explanation of Solution

The mean squared error is obtained as given below:

Absolute Value of Forecast Error	Squared Forecast Error
5	25
3	9
5	25
6	36
3	9
22	104

MSE=∑|er|2n−k=1045=20.8

Thus, the mean squared error is 20.8.

Answer 22

(c)

Expert Solution

To determine

Find the mean absolute percentage error.

Answer to Problem 1P

The mean absolute percentage error is 31.88.

Explanation of Solution

The mean absolute percentage error is obtained is given below:

Week	Time Series Value (yi)	Forecast	Forecast Error ei	Percentage Error yiei	Absolute percentage Error \|yiei\|
1	18
2	13	18	−5	−38.46	38.46
3	16	13	3	18.75	18.75
4	11	16	−5	−45.45	45.45
5	17	11	6	35.29	35.29
6	14	17	−3	−21.43	21.43
			Total	−51.30	159.38

MAPE=∑i=k+1n|yiei|100n−k=159.385=31.88

Thus, the mean absolute percentage error is 31.88.

Answer 23

(c)

Expert Solution

Answer 24

(c)

Expert Solution

Answer 25

Expert Solution

Answer 26

To determine

Find the mean absolute percentage error.

Answer 27

Answer to Problem 1P

The mean absolute percentage error is 31.88.

Answer 28

Explanation of Solution

The mean absolute percentage error is obtained is given below:

Week	Time Series Value (yi)	Forecast	Forecast Error ei	Percentage Error yiei	Absolute percentage Error \|yiei\|
1	18
2	13	18	−5	−38.46	38.46
3	16	13	3	18.75	18.75
4	11	16	−5	−45.45	45.45
5	17	11	6	35.29	35.29
6	14	17	−3	−21.43	21.43
			Total	−51.30	159.38