Question

The price of bananas fluctuates on the world market. The prices? ($/tonne) for the years 2000—2004...

The price of bananas fluctuates on the world market. The prices? ($/tonne) for the years

2000—2004

are shown in the table.

2000

2001

2002

2003

2004

374.84

645.52

502.23

335.36

571.81

?a) Find a 33?-year moving average prediction for the price in 2005

?b) Find a prediction for 2005 with an exponential smoothing model with ?=0.2 beginning with the initial value.

?c) The actual price of bananas in 2005 was 541?$/tonne.

------Compute the absolute percentange error for the 4-year moving average prediction

------Compute the absolute percentage error or the prediction found in part b.

Homework Answers

Answer #1

a)

Year actual(A) forecast(F)
2000 374.84
2001 645.52
2002 502.23
2003 335.36 507.53
2004 571.81 494.37
2005 469.8

3?-year moving average prediction for the price in 2005 =469.8

b)

Year actual(A) forecast(F)
2000 374.84
2001 645.52 374.84
2002 502.23 428.98
2003 335.36 443.63
2004 571.81 421.97
2005 451.94

prediction for 2005 with an exponential smoothing model =451.94.

c)4-year moving average prediction F=(645.52+502.23+335.36+571.81)/4=513.73

therefore  absolute percentange error for the 4-year moving average prediction

=((|541-513.73|)/541)*100=5.04%

absolute percentage error or the prediction found in part b=((|451.94-541|)/541)*100=16.46%

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Consider the following data: Number of Deaths in the U.S. by Drug Overdose Year 2000 2001...
Consider the following data: Number of Deaths in the U.S. by Drug Overdose Year 2000 2001 2002 2003 2004 2005 2006 2007 2008 Deaths 17,055 17,511 14,316 13,342 17,776 14,516 11,152 18,656 16,643 Find the three-period moving average for the year 2004. If necessary, round your answer to one decimal place.
Table below gives the annual rate of inflation during a 5-year period. 2000 2001 2002 2003...
Table below gives the annual rate of inflation during a 5-year period. 2000 2001 2002 2003 2004 Annual rate of inflation 1.8% 2.1% 2.9% 2.4% 2.7% If a nominal house price at the end of 2000 was $10.8 million, find the real house price adjusted to prices prevailing at the end of the year 2003. Round your answer to three significant figures.
The table below contains average annual retail value data for crude oil in the US (actual...
The table below contains average annual retail value data for crude oil in the US (actual data is $/barrel). The data was obtained from the inflationdata.com. year actual year actual 1997 28.43 2007 75.66 1998 17.89 2008 103.67 1999 24.28 2009 60.91 2000 38.92 2010 79.93 2001 31.81 2011 94.73 2002 31.02 2012 92.20 2003 36.85 2013 95.79 2004 48.77 2014 88.47 2005 62.66 2015 43.22 2006 70.77 2016 37.02 Problem 2 (moving average), c onstruct the worksheet for three...
Consider the following realized annual returns: Year Stock A Index 2000 23.6% 47.3% 2001 24.7% 27.7%...
Consider the following realized annual returns: Year Stock A Index 2000 23.6% 47.3% 2001 24.7% 27.7% 2002 30.5% 86.9% 2003 9.0% 23.1% 2004 -2.0% 0.2% 2005 -17.3% -3.2% 2006 -24.3% -27.0% 2007 32.2% 27.9% 2008 4.4% -5.1% 2009 7.4% -11.3% a. Calculate the average of annual returns of the index. a. The average of annual returns of the index is ????%. (round to two decimals) b. Compute the standard deviation of annual returns of the index. b. The standard deviation...
The following data includes the year, make, model, mileage (in thousands of miles) and asking price...
The following data includes the year, make, model, mileage (in thousands of miles) and asking price (in US dollars) for each of 13 used Honda Odyssey minivans. The data was collected from the Web site of the Seattle P-I on April 25, 2005. year make model mileage price 2004 Honda Odyssey EXL   20 26900 2004 Honda Odyssey EX 21 23000 2002 Honda Odyssey 33 17500 2002 Honda Odyssey 41 18999 2001 Honda Odyssey EX 43 17200 2001 Honda Odyssey EX...
The following data includes the year, make, model, mileage (in thousands of miles) and asking price...
The following data includes the year, make, model, mileage (in thousands of miles) and asking price (in US dollars) for each of 13 used Honda Odyssey minivans. The data was collected from the Web site of the  Seattle P-I on April 25, 2005. year make model mileage price 2004 Honda Odyssey EXL   20 26900 2004 Honda Odyssey EX 21 23000 2002 Honda Odyssey 33 17500 2002 Honda Odyssey 41 18999 2001 Honda Odyssey EX 43 17200 2001 Honda Odyssey EX 67...
Listed below is the selling price for a share of PepsiCo Inc. at the close of...
Listed below is the selling price for a share of PepsiCo Inc. at the close of each year from 1998 to 2015. Year Price 1998 40.6111 1999 35.0230 2000 49.5625 2001 48.68 2002 42.22 2003 46.62 2004 52.20 2005 59.85 2006 62.00 2007 77.51 2008 54.77 2009 60.80 2010 65.33 2011 66.35 2012 68.43 2013 82.94 2014 94.56 2015 99.92 Plot the stock price in the order in which the data are presented. Determine the least squares trend equation. (Round...
The data set below contains the average yearly retail gasoline prices​ (cents/gallon) from 1990 to​ 2007,...
The data set below contains the average yearly retail gasoline prices​ (cents/gallon) from 1990 to​ 2007, from a regional sample of gasoline stations. Complete parts a through c. Full data set Year 1990 1991 1992 1993 1994 1995 1996 1997 1998 Price 9090 102102 112112 119119 123123 107107 9999 103103 9797 Year 1999 2000 2001 2002 2003 2004 2005 2006 2007 Price 115115 133133 153153 141141 191191 201201 190190 247247 285285 ​a) Create a histogram of the data and describe...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week Auto Sales 1 8 2 10 3 9 4 11 5 10 6 13 7 - Problem 2: Carmen’s decides to forecast auto sales by weighting the three weeks as follows: Weights Applied Period 3 Last week 2 Two weeks ago 1 Three weeks ago 6 Total Problem 3: A firm uses simple exponential smoothing with to forecast demand. The forecast for the week...
Problem:: The number of Starbucks stores grew after they first opened. The number of stores from...
Problem:: The number of Starbucks stores grew after they first opened. The number of stores from 1990-2011, as reported on their corporate website is shown in the chart below.. Carefully plot the data. You should be able to see that the data is NOT linear, but actually exponential. Year Number of Starbucks stores Year Number of Starbucks stores 1990 84 2001 4709 1991 116 2002 5886 1992 165 2003 7225 1993 272 2004 8569 1994 425 2005 10241 1995 677...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT