1 / 29

Statistics for Business and Economics

Statistics for Business and Economics. Chapter 13 Time Series: Descriptive Analyses, Models, & Forecasting Lyn Noble Revisions by Peter Jurkat. Index Number. Measures change over time relative to a base period Price Index measures changes in price e.g. Consumer Price Index (CPI)

loman
Download Presentation

Statistics for Business and Economics

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Statistics for Business and Economics Chapter 13 Time Series:Descriptive Analyses, Models, & Forecasting Lyn Noble Revisions by Peter Jurkat

  2. Index Number • Measures change over time relative to a base period • Price Index measures changes in price • e.g. Consumer Price Index (CPI) • Quantity Index measures changes in quantity • e.g. Number of cell phones produced annually

  3. Simple Index Number Based on price/quantity of a single commodity where Yt = value at time t Y0 = value at time 0 (base period)

  4. Simple Index Number Example Year $1990 1.2991991 1.0981992 1.0871993 1.0671994 1.0751995 1.1111996 1.2241997 1.1991998 1.031999 1.1362000 1.4842001 1.422002 1.3452003 1.5612004 1.8522005 2.272006 2.572 The table shows the price per gallon of regular gasoline in the U.S for the years 1990 – 2006. Use 1990 as the base year (prior to the Gulf War). Calculate the simple index number for 1990, 1998, and 2006.

  5. Simple Index Number Solution 1990 Index Number (base period) 1998 Index Number Indicates price had dropped by 20.7% (100 – 79.3)between 1990 and 1998.

  6. Simple Index Number Solution 2006 Index Number Indicates price had risen by 98% (100 – 198) between 1990 and 2006.

  7. Simple Index Numbers 1990–2006

  8. Simple Index Numbers 1990–2006

  9. Class Exercise Example US copper and steel prices & production: Calculate the simple (un-weighted) copper price index for the current period to closest 10% Enter: A for 90%, B for 100%, C for 110%

  10. Composite Index Number • Made up of two or more commodities • A simple index using the total price or total quantity of all the series (commodities) • Disadvantage: Quantity of each commodity purchased is not considered

  11. Composite Index Number Example The table on the next slide shows the closing stock prices on the last day of the month for Daimler–Chrysler, Ford, and GM between 2005 and 2006. Construct the simple composite index using January 2005 as the base period. (Source: Nasdaq.com)

  12. Simple Composite Index Solution First compute the total for the three stocks for each date.

  13. Simple Composite Index Solution Now compute the simple composite index by dividing each total by the January 2005 total. For example, December 2006:

  14. Simple Composite Index Solution

  15. Simple Composite Index Solution

  16. Class Exercise Example US copper and steel prices & production: Calculate the simple (un-weighted) composite price index for copper and steel for the current period to nearest 10%. Enter: A for 90%, B for 100%, C for 110%

  17. Weighted Composite Price Index • Weights prices by quantities purchased before computing totals • Weighted totals used to compute composite index • Laspeyres Index • Uses base period quantities as weights • Paasche Index • Uses quantities from each period as weights

  18. Laspeyres Index • Uses base period quantities as weights • Appropriate when quantities remain approximately constant over time period • Example: Consumer Price Index (CPI)

  19. Calculating a Laspeyres Index Note: t0 subscript stands for base period where Pit= price for each commodity at time t Qit= quantity of each commodity at time t t0 = base period

  20. Laspeyres Index Number Example The table shows the closing stock prices on 1/31/2005 and 12/29/2006 for Daimler–Chrysler, Ford, and GM. On 1/31/2005 an investor purchased the indicated number of shares of each stock. Construct the Laspeyres Index using 1/31/2005 as the base period.

  21. Base Value Weighted total for base period (1/31/2005): Weighted total for current period 12/29/2006:

  22. Laspeyres Index Solution Indicates portfolio value had decreased by 13.3% (100–86.7) between 1/31/2005 and 12/29/2006.

  23. Class Exercise Example US copper and steel prices & production: Calculate the Laspeyresprice index for the current period to nearest 1%. Enter: A for 93.6%, B for 95.5%, C for 102.3%

  24. Paasche Index • Uses quantities for each period as weights • Appropriate when quantities change over time • Compare current prices to base period prices at current purchase levels • Disadvantages • Must know purchase quantities for each time period • Difficult to interpret a change in index when base period is not used

  25. Calculating a Paasche Index Weights are quantities for time period t where Pit= price for each commodity at time t Qit= quantity of each commodity at time t t0 = base period

  26. Paasche Index Number Example The table shows the 1/31/2005 and 12/29/2006 prices and volumes in millions of shares for Daimler–Chrysler, Ford, and GM. Calculate the Paasche Index using 1/31/2005 as the base period. (Source: Nasdaq.com)

  27. Paasche Index Solution

  28. Paasche Index Solution 12/29/2006 prices represent a 24.8% (100 – 75.2) decrease from 1/31/2005 (assuming quantities were at 12/29/2006 levels for both periods)

  29. Class Exercise Example US copper and steel prices & production: Calculate the Paascheprice index for the current period (enter rounded whole number) Enter: 1 for 93.5%, 2 for 95.5%, 3 for 102.3%

More Related