ࡱ> !# y bjbj ..{{TTTTThhhh tlhxzzzzzz$"TTT777 TTx7x77<ßx0.d0g# .g#(<g#T<(77g# : PRINCPLES OF ECONOMICS LAB ELASTICITY & EXCEL OBJECTIVES: The purpose of this lab is to allow the student to use excel to carry out elasticity computations. It provides an opportunity to refine excel formulae & graphing techniques. (a) Write down the formula for arc-elasticity of good X & point elasticity of good X (b) Using Excel calculate the own price arc elasticity of good X. Use the data in Table 1. Table1 Price of XQuantity of X$525$155Using Excel calculate the Cross-price arc elasticity of good X with respect to the price of good Y. Use the data in Table 2. Table 2 Quantity of XPrice of Y25$255$5 Identify whether the demand for good X is elastic, inelastic or unit elastic according to your calculations. Explain why. Identify whether goods X & Y are substitutes or complements. Explain why. (a) Write down the formula for arc Income elasticity of good X. (b) Using Excel calculate the arc income elasticity of the following good. (c) Based on your calculations explain whether the good is a necessity, a comfort or a luxury. (d) Based on your calculations, would you classify the good as a normal good or an inferior good? Explain why. IncomeDemand of Good X$250500$7502000 (a) Write down the formula the arc Supply elasticity of a good. Calculate the arc supply elasticity of the following good. Explain in detail what factors affect the supply elasticity of a good. Price of Good XQuantity Supplied of Good X$1530$2560 Consider the following demand function: Q = 5 (1/2) P Using excel calculate values for Q when you make up values for P. Use the following values for P: 0,1,2,3,4,10. Using excel plot the demand curve (with P on the vertical axis & Q on the horizontal axis). Using Excel, calculate the values of own-price point elasticity at the end points and the mid-point of the demand curve. Do these values agree with what you learned in class? Consider the following demand function:  EMBED Equation.3  Using excel calculate values for Q when you make up values for P. Use the following values for P: 1, 1.5, 2, 2.5, 3, 4, 5, 6, 7, 8, 9, 10, ..,16, 17. Using excel plot the demand curve (with P on the vertical axis & Q on the horizontal axis). 1< S m 1h90jh2EHUjWB h2CJUVaJjh2U h25 h25\h201C mpkd$$IfTl0   04 laT $$Ifa$$h^ha$h^h & F $$Ifa$pkdx$$IfTl0   04 laT K S a l vv $$Ifa$$h^ha$h^hpkd$$IfTl0   04 laTl m p t $$Ifa$pkdh$$IfTl0   04 laTt u w z $$Ifa$pkd$$IfTl0   04 laTz { | B C - |ss $$Ifa$ & F & Fh^hpkdX$$IfTl0   04 laT $$Ifa$lkd$$Ifl0,"LL04 la $$Ifa$lkdD$$Ifl0,"LL04 la H ww $$Ifa$ & F & Fh^hlkd$$Ifl0,"LL04 la $$Ifa$lkd,$$Ifl0,"LL04 la $$Ifa$lkd$$Ifl0,"LL04 la  ~ & Fh^h & Flkd$$Ifl0,"LL04 lah & F & Fh^h,1h/ =!"#$% v$$If!vh#v :V l05 4Tv$$If!vh#v :V l05 4Tv$$If!vh#v :V l05 4Tv$$If!vh#v :V l05 4Tv$$If!vh#v :V l05 4Tv$$If!vh#v :V l05 4Tr$$If!vh#vL:V l05L4r$$If!vh#vL:V l05L4r$$If!vh#vL:V l05L4r$$If!vh#vL:V l05L4r$$If!vh#vL:V l05L4r$$If!vh#vL:V l05L4)Dd hJ  C A? "2ŚȖzD62D]Rg`!_ŚȖzD62D]R@ |-xcdd``ed``baV d,FYzP1n:&B@?b } UXRY7&,e`abM-VK-WMc^<  X.0谂d*!5#sP@Oh0Ow՜.+,0( hp   0PRINCPLES OF ECONOMICS LAB ELASTICITY & EXCEL Title  F Microsoft Word 97-2003 Document MSWordDocWord.Document.89q^ 666666666vvvvvvvvv666666>6666666666666666666666666666666666666666666666666hH6666666666666666666666666666666666666666666666666666666666666666662 0@P`p2( 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p8XV~_HmH nH sH tH @`@ NormalCJ_HaJmH sH tH DA D Default Paragraph FontVi@V 0 Table Normal :V 44 la (k ( 0No List 2>@2 Title$a$5\DCD Body Text Indent h^hPK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭V$ !)O^rC$y@/yH*񄴽)޵߻UDb`}"qۋJחX^)I`nEp)liV[]1M<OP6r=zgbIguSebORD۫qu gZo~ٺlAplxpT0+[}`jzAV2Fi@qv֬5\|ʜ̭NleXdsjcs7f W+Ն7`g ȘJj|h(KD- dXiJ؇(x$( :;˹! I_TS 1?E??ZBΪmU/?~xY'y5g&΋/ɋ>GMGeD3Vq%'#q$8K)fw9:ĵ x}rxwr:\TZaG*y8IjbRc|XŻǿI u3KGnD1NIBs RuK>V.EL+M2#'fi ~V vl{u8zH *:(W☕ ~JTe\O*tHGHY}KNP*ݾ˦TѼ9/#A7qZ$*c?qUnwN%Oi4 =3N)cbJ uV4(Tn 7_?m-ٛ{UBwznʜ"Z xJZp; {/<P;,)''KQk5qpN8KGbe Sd̛\17 pa>SR! 3K4'+rzQ TTIIvt]Kc⫲K#v5+|D~O@%\w_nN[L9KqgVhn R!y+Un;*&/HrT >>\ t=.Tġ S; Z~!P9giCڧ!# B,;X=ۻ,I2UWV9$lk=Aj;{AP79|s*Y;̠[MCۿhf]o{oY=1kyVV5E8Vk+֜\80X4D)!!?*|fv u"xA@T_q64)kڬuV7 t '%;i9s9x,ڎ-45xd8?ǘd/Y|t &LILJ`& -Gt/PK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 0_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!0C)theme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK] .  l t z  :8@0(  B S  ?nv]`333/\g&@<nO76FxrLF <*Z`Ն1}xq~LGhh^h`o(.^`o(.^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.hh^h`.^`o(()^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.hhh^h`.h88^8`.hL^`L.h  ^ `.h  ^ `.hxLx^x`L.hHH^H`.h^`.hL^`L.z^`zo(()^`o(()q~O71}g<*Z`rLF<~        l                 MB290 @@UnknownG*Ax Times New Roman5Symbol3. *Cx ArialA$BCambria Math"hwF5G2G)OwOw!20 3QHP $P 2!xx /PRINCPLES OF ECONOMICS LAB  ELASTICITY & EXCELColorado CollegeJeffrey Moore(       CompObjr