Question

In: Math

Consider the following price data from 2002 to 2010 Year 2002 2003 2004 2005 2006 2007...

Consider the following price data from 2002 to 2010

Year 2002 2003 2004 2005 2006 2007 2008 2009 2010
Price 3.34 3.56 3.61 4.06 4.25 4.37 4.68 4.59 4.81

a. Compute the simple price index using 2002 as the base year. (Round your answers to 2 decimal places.)

Year Price index
2002
2003
2004
2005
2006
2007
2008
2009
2010

b. Update the index numbers with a base year revised from 2002 to 2005. (Round your answers to 2 decimal places.)

Solutions

Expert Solution

Consider the following price data from 2002 to 2010
Year 2002 2003 2004 2005 2006 2007 2008 2009 2010
Price 3.34 3.56 3.61 4.06 4.25 4.37 4.68 4.59 4.81
(a) Compute the simple price index using 2002 as the base year.
Solution:
Price index = (Current year price/Base year price)*100
YEAR Price Price Index
2002 3.34 100
2003 3.56 106.59
2004 3.61 108.08
2005 4.06 121.56
2006 4.25 127.25
2007 4.37 130.84
2008 4.68 140.12
2009 4.59 137.43
2010 4.81 144.01
(b) Update the index numbers with a base year revised from 2002 to 2005.
Solution:
Price index = (Current year price/Base year price)*100
YEAR Price Price index
2002 3.34 82.27
2003 3.56 87.68
2004 3.61 88.92
2005 4.06 100
2006 4.25 104.68
2007 4.37 107.64
2008 4.68 115.27
2009 4.59 113.05
2010 4.81 118.47

Related Solutions

Year 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Dividend $         7.46 $         7.91...
Year 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Dividend $         7.46 $         7.91 $         8.38 $         8.80 $         9.24 $         9.70 $       10.28 $       10.79 $       11.33 $       12.01 Find both the arithmetic growth rate and the geometric growth rate of the dividends for Davy's Crock Pot Stores. Assuming the January​ 1, 2011 price of the stock is $110.00​, determine the current required rate of return for the company​ (use the geometric growth rate to calculate the...
Consider the data in the following table: Year 2004 2005 2006 2007 2008 2009 Stock A...
Consider the data in the following table: Year 2004 2005 2006 2007 2008 2009 Stock A -10% 20% 5% -5% 2% 9% Stock B 21% 7% 30% -3% -8% 25% Use the above information to answer the following questions. Round your answers to four decimal places (i.e. 0.0105). 1. Estimate the average return for stock A. 2. Estimate the average return for stock B. 3. Estimate the volatility of stock A. 4.Estimate the volatility of stock B. 5 .Estimate the...
Year   Percentage 2000   28 2001   32 2002   36 2003   40 2004   44 2005   51 2006   53...
Year   Percentage 2000   28 2001   32 2002   36 2003   40 2004   44 2005   51 2006   53 2007   57 2008   60 2009   66 Forecast the percentage of tax returns that will be electronically filed for 2010 using exponential smoothing with trend adjustment. alpha= 0.3 and beta= 0.4. Then calculate MAD. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- Quarter   Price Q1 2017   186.3 Q2 2017   190.9 Q3 2017   195.2 Q4 2017   195.2 Q1 2018   198.7 Q2 2018   201.2 Forecast the price index for Q3 2018 using a​ three-period...
year Percentage 2000 28 2001 32 2002 37 2003 43 2004 47 2005 52 2006 56...
year Percentage 2000 28 2001 32 2002 37 2003 43 2004 47 2005 52 2006 56 2007 58 2008 61 2009 66 Forecast the percentage of tax returns that will be electronically filed for 2010 using exponential smoothing with trend adjustment. Set alphaα =0.5 and β=0.6
Number of U.S. New Car Dealerships, 2003–2009 Year Dealerships 2003 21,725 2004 21,650 2005 21,640 2006...
Number of U.S. New Car Dealerships, 2003–2009 Year Dealerships 2003 21,725 2004 21,650 2005 21,640 2006 21,495 2007 20,770 2008 20,010 2009 18,460 (a) Use Excel, MegaStat, or MINITAB to fit three trends (linear, quadratic, exponential) to the time series. (A negative value should be indicated by a minus sign. Do not round the intermediate calculations.Round your final answers to 4 decimal places.) FILL IN "_____" IN LINEAR AND QUADRATIC      Linear yt =  -498.035t + ____   Quadratic yt =  -146.25t2 +  671.96t...
India's Current Account Assumptions​ (millions USD) 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013...
India's Current Account Assumptions​ (millions USD) 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 ​Goods: exports ​77,939 ​102,175 ​123,876 ​153,530 ​199,065 ​167,958 ​230,967 ​307,847 ​298,321 ​319,110 ​329,633 ​Goods: imports ​-95,539 ​-134,692 ​-166,572 ​-208,611 ​-291,740 ​-247,908 ​-324,320 ​-428,021 ​-450,249 ​-433,760 ​-415,529      Balance on goods ​-17,600 ​-32,517 ​-42,696 ​-55,081 ​-92,675 ​-79,950 ​-93,353 ​-120,174 ​-151,928 ​-114,650 ​-85,895 ​Services: credit ​38,281 ​52,527 ​69,440 ​86,552 ​106,054 ​92,889 ​117,068 ​138,528 ​145,525 ​148,649 ​156,252 ​Services: debit ​-35,641 ​-47,287 ​-58,514 ​-70,175 ​-87,739 ​-80,349 ​-114,739 ​-125,041...
PepsiCo Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 6,585    7,205   ...
PepsiCo Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 6,585    7,205    7,350    8,332 8,263   9,368 Qtr2 7,697    8,599    9,607    10,945 10,592   14,801 Qtr3 8,184    8,950    10,171    11,244   11,080   15,514 Qtr4 10,096    10,383    12,346    12,729   13,297   18,155 (b) State the model found when performing a regression using seasonal binaries. (A negative value should be indicated by a minus sign. Round your answers to 4 decimal places. yt =___...
PepsiCo Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 6,585    7,205   ...
PepsiCo Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 6,585    7,205    7,350    8,333 8,263   9,368 Qtr2 7,697    8,599    9,607    10,945 10,592   14,801 Qtr3 8,184    8,950    10,171    11,244   11,080   15,514 Qtr4 10,096    10,383    12,346    12,729   13,297   18,155 (b) State the model found when performing a regression using seasonal binaries. (A negative value should be indicated by a minus sign. Round your answers to 4 decimal places. yt =___...
Coca-Cola Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 5,206 5,131 6,090...
Coca-Cola Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 5,206 5,131 6,090 7,410 7,180 7,516 Qtr2 6,310 6,480 7,720 9,060 8,232 8,665 Qtr3 6,037 6,422 7,677 8,314 8,040 8,417 Qtr4 5,551 5,920 7,318 7,100 7,498 10,485 Click here for the Excel Data File (a-1) Use MegaStat or Minitab to deseasonalize Coca-Cola’s quarterly data. (Round your answers to 3 decimal places.) 1 2 3 4 2005 2006 2007 2008 2009 2010 mean (a-2) State the adjusted four...
Coca-Cola Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 5,200 5,117 6,075...
Coca-Cola Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 5,200 5,117 6,075 7,380 7,150 7,800 Qtr2 6,304 6,465 7,705 9,045 8,220 8,659 Qtr3 6,031 6,410 7,662 8,305 8,025 8,411 Qtr4 5,545 5,905 7,303 7,040 7,480 10,479 (a-1) Use MegaStat or Minitab to deseasonalize Coca-Cola’s quarterly data. (Round your answers to 3 decimal places.) 1 2 3 4 2005 2006 2007 2008 2009 2010 mean (a-2) State the adjusted four quarterly indexes. (Round your answers to 3...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT