Question

In: Economics

The following table reports the Consumer Pirce Index for the Los Angeles area on a monthly...

The following table reports the Consumer Pirce Index for the Los Angeles area on a monthly basis from January 1998 to December 2000 (base year=1982-1984). Eliminating the data for 2000, use Excel to forecast the index for all of 2000 using a three-and -six month average. Which provides a better forecast for 2000 using the data provided?

Salvatore Chapter 6 Appendix Problem 3 (p.261)
Time CPI forecast(w=0.3) (A-F)^2 forecast(w=0.7) (A-F)^2
Jan-98 161.0 166.63 166.63
Feb-98 161.1 164.94
Mar-98 161.4 163.79
Apr-98 161.8 163.07
May-98 162.3 162.69
Jun-98 162.2 162.57
Jul-98 162.1 162.46
Aug-98 162.6 162.35
Sep-98 162.6 162.43
Oct-98 163.2 162.48
Nov-98 163.4 162.70
Dec-98 163.5 162.91
Jan-99 164.2 163.08
Feb-99 164.6 163.42
Mar-99 165.0 163.77
Apr-99 166.6 164.14
May-99 166.2 164.88
Jun-99 165.4 165.28
Jul-99 165.8 165.31
Aug-99 166.3 165.46
Sep-99 167.2 165.71
Oct-99 167.2 166.16
Nov-99 167.1 166.47
Dec-99 167.3 166.66
Jan-00 167.9 166.85 1.10
Feb-00 169.3 167.17 4.55
Mar-00 170.7 167.81 8.37
Apr-00 170.6 168.67 3.71
May-00 171.1 169.25 3.41
Jun-00 171.0 169.81 1.42
Jul-00 171.7 170.16 2.36
Aug-00 172.2 170.63 2.48
Sep-00 173.3 171.10 4.85
Oct-00 173.8 171.76 4.17
Nov-00 173.5 172.37 1.28
Dec-00 173.5 172.71 0.62

Solutions

Expert Solution

Time CPI 3-Month Moving Average 6-Month Moving Average Error for 3-M MA Absolute Error for 3-M MA Error for 6-M MA Absolute Error for 6-M MA
Jan-98 161
Feb-98 161.1
Mar-98 161.4
Apr-98 161.8
May-98 162.3
Jun-98 162.2
Jul-98 162.1
Aug-98 162.6
Sep-98 162.6
Oct-98 163.2
Nov-98 163.4
Dec-98 163.5
Jan-99 164.2
Feb-99 164.6
Mar-99 165
Apr-99 166.6
May-99 166.2
Jun-99 165.4
Jul-99 165.8
Aug-99 166.3
Sep-99 167.2
Oct-99 167.2
Nov-99 167.1
Dec-99 167.3
Jan-00 167.9 167.2 166.8 0.7 0.7 1.1 1.1
Feb-00 169.3 167.4 167.2 1.9 1.9 2.1 2.1
Mar-00 170.7 168.2 167.7 2.5 2.5 3.0 3.0
Apr-00 170.6 169.3 168.3 1.3 1.3 2.3 2.3
May-00 171.1 170.2 168.8 0.9 0.9 2.3 2.3
Jun-00 171 170.8 169.5 0.2 0.2 1.5 1.5
Jul-00 171.7 170.9 170.1 0.8 0.8 1.6 1.6
Aug-00 172.2 171.3 170.7 0.9 0.9 1.5 1.5
Sep-00 173.3 171.6 171.2 1.7 1.7 2.1 2.1
Oct-00 173.8 172.4 171.7 1.4 1.4 2.2 2.2
Nov-00 173.5 173.1 172.2 0.4 0.4 1.3 1.3
Dec-00 173.5 173.5 172.6 0.0 0.0 0.9 0.9
MAD for 3 month moving average = (sum of the absolute errors)/no. of observation
MAD for 3 month moving average = (.7+1.9+2.5+1.3+.9+.2+.8+.9+1.7+1.4+.4+0)/10
MAD for 3 month moving average = 1.27
MAD for 6 month moving average = (sum of the absolute errors)/no. of observation
MAD for 6 month moving average = (1.1+2.1+3.0+2.3+2.3+1.5+1.6+1.5+2.1+2.2+1.3+.9)/10
MAD for 6 month moving average = 2.19

Since MAD is greater for the 6 month moving average, than the 3 month moving average, then it is good to go with the 3 month moving average that represents superior accuracy in the forecast.

Rahul Sunny answered 1 year ago
Next > < Previous

Related Solutions

The Los Angeles Times regularity reports the air quality index for various areas os Southern California....
The Los Angeles Times regularity reports the air quality index for various areas os Southern California. A sample of air quality index values for San Bernardino provides the following data: 56, 84, 116, 96, 90, 110, 120, 98, and 100 a) compute the mean, median, and the mode of the data observed and interpret b) compute the first quartile and interpret c) compute the range d) compute the sample variance and sample standard deviation e) A sample of air quality...
The monthly expenditures on food by single adults living in one neighborhood of Los Angeles are...
The monthly expenditures on food by single adults living in one neighborhood of Los Angeles are normally distributed with a mean of $410 and a standard deviation of $75. Determine the percentage of samples of size 9 that have mean expenditures within $20 of the population mean expenditure of $410.
1. A SRS of 30 commuters to the Los Angeles metropolitan area are selected, and each...
1. A SRS of 30 commuters to the Los Angeles metropolitan area are selected, and each is asked how far they commute to work each day. In the sample, the mean distance is 64 miles and the standard deviation is 12 miles. Is there evidence that the average commute to work for this population is more than 60 miles? a. Yes, since the p-value is less than 0.05. b. No, since the p-value is less than 0.05. c. No, since...
SecuriCorp operates a fleet of armored cars that make scheduled pickups and deliveries in the Los Angeles area.
SecuriCorp operates a fleet of armored cars that make scheduled pickups and deliveries in the Los Angeles area. The company is implementing an activity-based costing system that has four activity cost pools: Travel, Pickup and Delivery, Customer Service, and Other. The activity measures are miles for the Travel cost pool, number of pickups and deliveries for the Pickup and Delivery cost pool, and number of customers for the Customer Service cost pool. The Other cost pool has no activity measure...
Your company has sent you on business to the Los Angeles (LA) metropolitan area. Upon your...
Your company has sent you on business to the Los Angeles (LA) metropolitan area. Upon your arrival at LAX, you make your way to the Klunker Car Rental counter. As usual, the line at the counter is long, so you enter and begin your wait. While waiting you notice that Klunker is offering a special deal on gas. They are selling gas for $1.579 per gallon. However, you must purchase a full tank when you rent the car. Klunker also...
Your company has sent you on business to the Los Angeles (LA) metropolitan area. Upon your...
Your company has sent you on business to the Los Angeles (LA) metropolitan area. Upon your arrival at LAX, you make your way to the Klunker Car Rental counter. As usual, the line at the counter is long, so you enter and begin your wait. While waiting you notice that Klunker is offering a special deal on gas. They are selling gas for $1.579 per gallon. However, you must purchase a full tank when you rent the car. Klunker also...
Economics Cost-Benefit Analysis: The Los Angeles area has long been plagued by urban smog. Suppose that...
Economics Cost-Benefit Analysis: The Los Angeles area has long been plagued by urban smog. Suppose that one of several ozone-reducing policy options is being evaluated by economists using benefit-cost analysis. Since the policy will be implemented over time, economists assume that per resident benefits will accrue in increments of $500 at the end of each of the next three years. Find the present value of benefits (PVB) for each resident, assuming an annual discount rate of 9%.
The following table reports the average prices of gasoline and apples, as well as the consumer...
The following table reports the average prices of gasoline and apples, as well as the consumer price index for three years. Gasoline (price per pound) Red Delicious Apples (Price per Pound) Consumer Price Index 1982 -1984 =100) 1995 $1.15 $0.83 152.4 2005 $2.30 $0.95 195.3 2015 $2.45 $1.36 237.0 What was the percentage increase in the price of gasoline from 1995 to 2015? ______% What was the percentage increase in the price of apples from 2005 to 2015? ______% Did...
a). Consider the following. Fewer than 5% of adults in Los Angeles ride the bus to...
a). Consider the following. Fewer than 5% of adults in Los Angeles ride the bus to work. State the Type I and Type II errors in complete sentences. Type I error: We believe that at least 5% of adults in Los Angeles ride the bus to work when the percentage really is fewer than 5%. Type II error: We believe that fewer than 5% of adults in Los Angeles ride the bus to work when the percentage really is greater...
In a murder trial in Los Angeles, the prosecution claims that the defendant was cut on...
In a murder trial in Los Angeles, the prosecution claims that the defendant was cut on the left middle finger at the murder scene, but the defendant claims the cut occurred in Chicago, the day after the murders had been committed. Because the defendant is a sports celebrity, many people noticed him before he reached Chicago. Twenty-two people saw him casually, one person on the plane to Chicago carefully studied his hands looking for a championship ring, and another person...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT