ࡱ> *,)q F#bjbjt+t+ !@AA,]DDDDDDD8,& 8&"HHHHHH$   DHHHHH DDHH8HDHDHX"z"DDDDH|]|DDH TUX:Chain-weight GDP calculations Student Instruction Sheet Introduction In this exercise, we will calculate chain-weight real GDP figures from raw data. Formally, chain-weight real GDP (Yt) for year t is calculated from the prices (p) and quantities (q) of goods at certain time periods (t):  EMBED Equation.DSMT4  Where the summation operator works over the implied index of goods. Note that the figure for year t depends on the figure for year (t 1), and year (t 1) GDP depends on year (t2), etc. in a chain back to the base year. Because of this chain, real GDP is most easily calculated using a multi-step process. Note that the first term under the square root is a Laspeyres relative quantity index (1+growth rate), and the second term is a Paasche relative quantity index. We first calculate these individual indexes (in growth rate form) for each year, and later calculate GDP levels. For reference and later use, calculate nominal GDP for each year:  EMBED Equation.DSMT4  For each year (except the first year) calculate the growth rate of real GDP using the current years prices (this is a Paasche index):  EMBED Equation.DSMT4  For each year (except the first year) calculate the growth rate of real GDP using the previous years prices (this is a Laspeyres index):  EMBED Equation.DSMT4  For each year (except the first year) calculate the chain-weight growth rate of real GDP by taking the geometric average of the two fixed-weight growth rates calculated in the previous two steps. The geometric average is the mathematically correct method of taking the average of growth rates.  EMBED Equation.DSMT4  Declare any year a base year (b). This means you are declaring that real GDP equals nominal GDP for that year:  EMBED Equation.DSMT4  Calculate the level of chain-weight real GDP for the year after the base year by using the base year and one plus the chain-weight growth rate computed in step 4:  EMBED Equation.DSMT4  Calculate the level of chain-weight real GDP for all successive years the same way: for year (b+2), use Yb+1 and  EMBED Equation.DSMT4 , etc. Calculate the level of chain-weight real GDP for the year before the base year rearranging the formula used in step 6, taken back one period:  EMBED Equation.DSMT4  (  EMBED Equation.DSMT4  Calculate the level of chain-weight real GDP for each previous year the same way: for year (b-2), use  EMBED Equation.DSMT4  and  EMBED Equation.DSMT4 , etc. Instructions The goal of this assignment is to calculate chain-weight real GDP on an Excel spreadsheet for years 1-5 using year 3 as the base year given the following data: Year12345Prices Good 1$20$21$22$23$24 Good 2$60$59$58$57$56Quantities Good 17576777879 Good 22530354045 Enter the data into a spreadsheet. Include the labels as above, so Prices appears in cell A3, $20 appears in cell B4, etc. The following numbered steps correspond to the step numbers above. Label the next row (row 9) Nominal GDP, and calculate nominal GDP for each year using the formula above. Make sure to start the formula with an equal sign, and use an asterisk (*) for multiplication. For example, for Year 1, in cell B9 you should type: =(B4*B7+B5*B8). If you entered the formula correctly, the cell should read 3000. Label the next row (row 10) Chain weight GDP calculations, and rows 11 through 14 Real growth rate of output (Paasche index), Real growth rate of output (Laspeyres index), Real growth rate of output (chain-weight), and Real chain-weight GDP (Year 3 = base year) respectively. In row 11, enter a formula to calculate the real growth rate of output for year 2 (cell C11) using the current years prices based on the formula above. Use the cell addresses containing the data rather than typing in the numbers directly. Remember to use parentheses to separate the numerator and denominator, and use / as the division operator. The correct syntax is =(C4*C7+C5*C8)/(C4*B7+C5*B8)-1. If you entered the formula correctly, you should get 10.36%. [To change the cell format to percentage form, click on the % button on the standard Excel toolbar. To increase the number of decimal places, click the appropriate button on the toolbar (it appears next to the comma button).] Copy cell C11 to cells D11 through F11 to make the calculation for the remaining years. In row 12, enter a formula to calculate the real growth rate of output for year 2 (cell C12) using the previous years prices based on the formula above. If you entered the formula correctly, you should get 10.67%. Copy the cell formula through year 5 as you did above. Note that the Laspeyres index always gives a higher growth rate than the Paasche index. To understand why, consider the data for year 1 and 2. The price of good 1 rose, and the price of good 2 fell. What is important is the relative price of good 1 to good 2 fell. As a result, consumers relatively substituted away from good 1 and towards good 2. This is reflected in the fact that the percentage increase in quantity of good 2 is larger than for good 1. (The quantity of good 1 rose despite the higher price because of general economic growth what matters is the relative percentage increase.) The Paasche and Laspeyres growth rate figures are each a weighted average of the growth of the two goods, using the prices of the goods as weights. The difference is the Paasche index uses current prices, where the price of good 2 has fallen and the price of good 1 has risen. That means that the low growth of good 1 has a relatively strong weight, and the fast growth of good 2 has a low weight, so the overall growth rate is lower. For the Laspeyres index, the previous years prices are used as weights, so the slow growth good 1 has a lower weight, and the fast-growth good 2 has a higher weight the result is a higher figure. But which figure is correct? A reasonable compromise is to average the two (geometrically) this is the chain-weight method. It is possible to demonstrate that the chain-weight index is also very close to an ideal index (see assignment for Figure 3). In row 13, enter a formula to calculate the real chain-weight growth rate of output for year 2 using the equation above and the Excel SQRT square-root function. The formula should refer to the appropriate cells in rows 11 and 12. If you typed the formula correctly, the cell will read 10.51%. Copy the formula through year 5. In row 14, declare year 3 the base year by setting real GDP (in row cell D14) equal to nominal GDP using a simple formula setting the value equal to the value in cell D9. The cell should read 3274. Calculate the level of chain-weight real GDP for year 4 by creating an Excel formula based on the appropriate equation above. Make sure to use the cell addresses for base year (year 3) real GDP and the chain-weight growth rate of real GDP in year 4. The correct figure is 4032.3. Copy the year 4 formula to year 5. Calculate the level of GDP for year 2 by creating an Excel formula based on the appropriate equation above. Remember that this uses year 3s chain-weight GDP level and growth rate. If you typed the formula correctly, the cell should read 3408.2. Copy the year 2 formula to year 1. Other assignments Calculate fixed-weight GDP level and growth using year 3 as the base year, and compare results to the chain-weight results. Carefully chosen figures will reveal a bias such that the level of fixed-weight GDP is above chain-weight GDP for every year except the base year. The growth rate of fixed-weight GDP is lower than chain-weight before the base year, and higher after the base year. Calculate the chain-weight and fixed-weight price indexes using the deflator formula:  EMBED Equation.DSMT4  and compare the results. The price indexes exhibit the opposite bias as the quantity indexes. PAGE  PAGE 3 8 $%<=>?xy 7 8 9 : c d { | } ~  ƿ jEHUj A CJUVmH j EHUj> A CJUVmH jFEHUj A CJUVmH jYEHUj A CJUVmH jUjFW@ UV jU6H*65889F#$@A;  b + $$$$ HA HA & F HA$89F#$@A;  b + º{vqlgb  ?  A  C  E  G  HI  J  K  L  M  R  S    m  -        I    $ + , - . 7 8 9 ; @ A X Y Z [    ' ( ) * | j!EHUj@#A CJUVmH jEHUj A CJUVmH j jEHUj A CJUVmH jEHUji A CJUVmHH*6H*6 jEHUj A CJUVmH jU jEHUj A CJUVmH0 ("""""",#-#3#4#5#7#8#>#?#@#A#B#F#0JmH0J j0JU j'EHUj A CJUVmH 5B*hnH  B*hnH  jU jD$EHUju A CJUVmH04$$$T ,Or$$P$$Tֈ ,Or$$ |wsnid_Z                                          "  &  /0  1  2  3  4  5  <="xxDd$$T ,Or$$$T ,Or$$ !$'()>\oYid & F & F & F HA$$T ,Or$$$ !$'()>\oYi Z",#5#6#7#B#C#D#E#F#ý~xpnnnnph       2  U  o  6    i   |                     ! Z",#5#6#7#B#C#D#E#F#h&`#$ & F HA & F & F 0/ =!"#$%YDd pB  S A? 29&^Dw_P>D`!9&^Dw_P> "exMLA춥@`"T zijJBHĘHBjz11&n~pH<Bј Pꛝݶfμ޼ "Qp@|JXf3V܉[tpȃ) Bw(X3K|*ѹX*P4us("6|x6~9FHi uo,y*#Ƅ t+ r2;Z?Ρ Fj>AcXVb,gHo fX A&˖3VE4s``zb*DN..%`h4mg܍;as/MPgsQPe\y8 v~[dϊKsl^g,,엞WѩF#9`Ro_O&1 =7)V|4w(srzPj_W/Y(ߩmFzk7g3eN32?+ivKK5l˯ blDhΦf&J泲nCe1_{Y}X+:BBW<;@OOst;w-l$7UPgUvVq.i B$1+\PI5AKq"Tk#mjFi^Hk$_UB0K@sI{$<鴏&'7B#xhX|)M&OG_gHv4ۻ)Ìc4z^p _-&TxKwqX7^fQVI14' ?{nW`ouxfKDd<B  S A? 2WESbN'dl 3`!+ESbN'dl d` hxSkAF4ew ƀ 6x tYL@ҤɊͩԓC=Idfv`q7oy?f s#ȡDȱ%DZbbnvUh^ EE1%FXnB&3',*OhN{<RzB%蛨*($y.i;`TQ$΃N8O *+_] &s{ZVTVqvOm H ?ƣ0nbaM"DdB  S A? 2Z* =jU[("Զr`!Z* =jU[("Զr" `\xUkA~of7H6M{ň D!ش nKh idE z2Ļ xC޼xȞZ4nPpf>f|{of LP+AYqF. g$ΐfEVkaB XiM}42Mw)Xr[US! O|aG3eϸ@aBM LEH7(y@f=r|U)6(>&̄qvP_lۿ9VUe|%+ca[V]*;Jmy &W{X 98::@߱Is[ gm:wP>a0klUJיw`(elUENlɕVZ|BQ"V0(<퓨FEFP%qo7r^Ry`f : n|!uV4kbB'gSdփ7쏳g` vs9OHi,QMT3(I$di ,IE^#[(Zչ֓[bԉϤ qPeh52xnS|*ܽR lm팸cE*9\ ~+6nn+;-j֤=*n'H [] `Lx gfW^O}C no< dOx[M*xžֵvG kd?\򩽛݋6OU˝qθunkT*`v^W WtU_݈Wˏw ./BDLÉ b"Ds$φ$KNc%G^婑trN,lBn-tO!Ł7AJַ @j gs^O}b ,I~x*$>@V1S }\wRZ}I]g 5~Tc5o۬NkpPbZնɔ/OhDd<B  S A? 2Em;!?@ABCDEFGHIJKNLe]PQRSTUVWXYZ[\^_`abcdfRoot EntryF F8ET:UU-2Data !*WordDocumentE!@ObjectPoolHOU:UU_1079444806FOU@OUOle CompObjiObjInfo  !"#&)*+,-./256789<?@ABEHIJKLORSTUX[\]^_befghilopqruxyz{~ FMathType 5.0 Equation MathType EFEquation.DSMT49q|zhzDSMT5WinAllBasicCodePagesTimes New RomanSymbolMT Extra!/ED/APG_APAPAE%B_AC_AE*_HA@AHA*_D_E_E_A  Y t ==  Equation Native _1092657421 F8PU8PUOle CompObj i@p t"-1 q t " @p t"-1 q t"-1 " () @p t q t " @p t q t"-1 " ()  Y t"-1 FMathType 5.0 Equation MathType EFEquation.DSMT49q(zbhzDSMT5WinAllBasicCodePagesTimes New RomanSymbolCourier NewMT Extra!/ED/APG_APAPAE%B_AC_AE*_HA@AHA*_D_E_E_A  PY t ==@p t q t "ObjInfo Equation Native D_1092657678F@|PU ٌPUOle   FMathType 5.0 Equation MathType EFEquation.DSMT49qؔzbhzDSMT5WinAllBasicCodePagesTimes New RomanSymbolCourier NewMT Extra!/ED/APG_APAPAE%B_AC_AE*_HA@AHA*_D_E_ECompObjiObjInfoEquation Native _1092657726 'FPUPU_A  Y tP == @p t q t " @p t q t"-1 " "-1 FMathType 5.0 Equation MathType EFEquation.DSMT49qOle $CompObj%iObjInfo'Equation Native (بzzhzDSMT5WinAllBasicCodePagesTimes New RomanSymbolCourier NewMT Extra!/ED/APG_APAPAE%B_AC_AE*_HA@AHA*_D_E_E_A  Y tL == @p t"-1 q t " @p t"-1 q t"-1 " "-1_1092657857F@QU@QUOle 0CompObj1iObjInfo3 FMathType 5.0 Equation MathType EFEquation.DSMT49q8zzhzDSMT5WinAllBasicCodePagesTimes New RomanSymbolCourier NewMT Extra!/ED/APG_APAPAE%B_AC_AE*_HA@AHA*_D_E_E_A  Y t ==Equation Native 4T_1092658070"FnQUvQUOle :CompObj ;i Y tP "Y tL FMathType 5.0 Equation MathType EFEquation.DSMT49qzzhzDSMT5WinAllBasicCodePagesTimes New RomanSymbolCourier NewMT Extra!/ED/APObjInfo!=Equation Native >_1092658103$FbQUbQUOle CG_APAPAE%B_AC_AE*_HA@AHA*_D_E_E_A  Y b ==PY b FMathType 5.0 Equation MathType EFEquation.DSMT49qPzzhzDSMT5WinAllBasicCodePagesCompObj#%DiObjInfo&FEquation Native Gl_10926582811)F@O'RU@O'RUTimes New RomanSymbolCourier NewMT Extra!/ED/APG_APAPAE%B_AC_AE*_HA@AHA*_D_E_E_A  Y b++1 ==Y b "1++Y b++1 ()Y FMathType 5.0 Equation MathType EFEquation.DSMT49qOle MCompObj(*NiObjInfo+PEquation Native QzrhzDSMT5WinAllBasicCodePagesTimes New RomanSymbolCourier NewMT Extra!/ED/APG_APAPAE%B_AC_AE*_HA@AHA*_D_E_E_A  Y b++2 FMathType 5.0 Equation MathTy_1092658367.F܂RU܂RUOle VCompObj-/WiObjInfo0Ype EFEquation.DSMT49qDzhzDSMT5WinAllBasicCodePagesTimes New RomanSymbolCourier NewMT Extra!/ED/APG_APAPAE%B_AC_AE*_HA@AHA*_D_E_E_A  Y b ==Y b"-1 "1++Y b ()Equation Native Z`_1092658412,@3FRURUOle `CompObj24ai FMathType 5.0 Equation MathType EFEquation.DSMT49qHzhzDSMT5WinAllBasicCodePagesTimes New RomanSymbolCourier NewMT Extra!/ED/APG_APAPAE%B_AC_AE*_HA@AHA*_D_E_E_A  Y b"-1 ObjInfo5cEquation Native dd_10928294278F DSU DSUOle j== Y b 1++Y b () FMathType 5.0 Equation MathType EFEquation.DSMT49q2zRhzDSMT5WinAllBasicCodePagesTimes New RomanSymbolCourier NewMT Extra!/ED/APCompObj79kiObjInfo:mEquation Native n_1092658549=F3SU3SUG_APAPAE%B_AC_AE*_HA@AHA*_D_E_E_A  Y b"-1 FMathType 5.0 Equation MathType EFEquation.DSMT49qzhzDSMT5WinAllBasicCodePagesOle sCompObj<>tiObjInfo?vEquation Native wTimes New RomanSymbolCourier NewMT Extra!/ED/APG_APAPAE%B_AC_AE*_HA@AHA*_D_E_E_A  Y b"-1 FMathType 5.0 Equation MathType EFEquation.DSMT49q_1092661998;6BF SU TUOle |CompObjAC}iObjInfoDEquation Native <1Table SummaryInformation(GDocumentSummaryInformation8 zhzDSMT5WinAllBasicCodePagesTimes New RomanSymbolCourier NewMT Extra!/ED/APG_APAPAE%B_AC_AE*_HA@AHA*_D_E_E_A  P t == PY t Y tZOh+'0 (4 P \ ht|bG28<EHS|b‹Af߮V,+>(<.m'(I/1,\Fu&@1F.ǃ !=.&#E]<ú(ӖLr7`[4%*]/Ս˻Y4Mٯ xo۶Uvw.6]V79&F3s{&Uh>|l(يTݩ|Rd<^s /+gWF9_6MTeuAVE^.z(׾iXt-5 cs~~(9(};:x:nSpN8yQ"_pf<_``̚yLjǐF#_9(WfC {ib*r\2!-RUTwDqkw:?7`~;M~M8ODdB  S A? 2qy+6.9R`!qy+6.9R$` @C[xTAkQy4 dcۃ(#<&"aEI#IdAo^C.xƙdkf_޼y3~3!(/O@0(\“RH,RBv|HNÀ4}Hv#[%;Dc<҂_SYzΟSKFYdVIKa=6lsbױ0PF-2:/> `hjpk΃f3;y4A;/k*<,ȚbɔWEk>Dd|B  S A? 25X*xfaJ!D`! X*xfaJ!p`0xSMKQ=N"U3GAZ t u MLth)IJͪA2p/tUpzsB\;g4`\C!)8"yMK:%UYFR\s2e9"$r-B*Of~S9eZB l - ÙHiǰ*fI_[M0V&R r3*M%pECgGH_9eb"f1=PkY{ZzXav-SXIGݶ?dOي(3=O$ՊhCi4N}?:JǠ;9ۈk֗v=hK؉9f!g;'Z?ƫ׿HU/o}B^iYUnxOY41]p6XǬJ]&,jiE;e 8EM},YҚ]i Zqf1UVTi1V|{4T*IDjs|枟ĉ~Bßiu8(p\1j=i7k6N5.l!WxgjiUi:yӂ6߈E2fiKc9 0wue7̼kfd/&{dz宗ܞlRt s-[.M= z(l qhx*\*2BHS$B,! 91vL8EC\ LJ5pFC. >2%G"BvyKwDddB   S A ?  2w+>0ЎMSnX`!w+>0ЎMSn^ (+xUMlRA}PJIx`jIlh 65H\0DhL~Ei('ML7CIzn}\VWU.zنM"}Nfp"2;1 *a,Y غsC[Wjf3t|^vsp6lǿ:LQb=ɵp튏pTi\minc5rrZJ9*4C}Yv<׮(>^n41'EJU[7+Gy{Qg|AɇR[X/.?zi<ɜm 2st$ Qd&{Zd?nWÞ:aRYPʆ ͖YTt*G*߮=DdhB  S A ?  2 ͙{U!`! ͙{U@h|xRKAިaWCeB nŐ4ӶRfQ^JWWt1\ʹ(T 7oyߛGB.#K!–3OcʓА@"#:bl sWPEnڇX$hD<2zI_%+RF@/UjN3'5 82LqC_lf?H7kkXu+m{ Zl* SiP*ol<""?5W̗@ÛZ]l}){NHwPj,5*NC"ΗIa#-OV,:5xT3ތ.[t-+kzs֪*O*cY'EuuϷx;}6eE<LzU}6gMGTջFnZT%)Dd|B   S A ?  27|r!I@$`! |r!I@p`h0xSMKQ=N"U3GAZj !q uLL`)IJʀ ]5 q ;$B}wΜ1i8'ч: 1&BRn5XqVQi*9 ]bF_OFY1+ ZdMVΊkZ #B$\J=!CVDY?vvT+R(+oANw󭽠>F\̷A[]N5wPXsJe _MOe᪷tdCіg+xnLA,G&π܌w1%ad3U_k\&E\A):ݠ9GλDdpB  S A ?  2lF}*h$@ HU'`!@F}*h$@ @xAkQgJvӴ1J[*z dYi]uє)Bkz< /"(E:fj Gv͛iE?:HQ)*.(:!!HTځgu A Lc=̎xe=L_Wՙ+#IguGjZN)Y}bF nM[}yt0Fj>YC1.ଈ'5R4MLʽ(Z'wjXߢyL:m#,18p|/PmPw[V[O*ݧ=Gɩ9܄VkAσYfk}r>--7,F8pYFENC;\v7áy~Zvʟed@I#)@A^:ʝ̕'u JBcï柎 o;rf1(4<Fʇ.k.Қ 3zChain-weight GDP calculationsMihai Miles CahillGDPileile Normal.dotl Miles CahillGDP18eMicrosoft Word 8.0l@Vn @YhET@:LU\Z՜.+,D՜.+,H hp|   E5 1 Chain-weight GDP calculations Title(PX _PID_GUID MTWinEqnsAN{6E15A681-0238-4D14-896E-8C4F17395D9E}  [(@(NormalCJmH 0@0 Heading 1$@&>*<A@<Default Paragraph Font,@,Header  !&)@& Page Number&>@&Title$5F @   bF  F#F# F#$<>x79c{} @XZ  ' ) F::::::::::::: !!,G+,47ADG Miles CahillE:\JEE paper\jeesi2.doc Miles CahillE:\JEE paper\jeesi2.doc Miles CahillE:\JEE paper\jeesi2.doc Miles CahillE:\JEE paper\jeesi2.doc Miles CahillE:\JEE paper\jeesi2.doc Miles CahillE:\JEE paper\jeesi2.doc Miles CahillE:\JEE paper\jeesi2.doc Miles CahillE:\JEE paper\jeesi2.doc Miles CahillE:\JEE paper\jeesi2.doc Miles CahillE:\JEE paper\jeesi2.docB>&s2} n l :  ($Kܔ^u*Vhh.hh. hhOJQJo(hh.hh.hha.: B>^u*(n l @F@G:Times New Roman5Symbol3& :Arial;Wingdings"h#if3iY\ 5!0RChain-weight GDP calculations Miles Cahill Miles CahillCompObjj  FMicrosoft Word Document MSWordDocWord.Document.89q