Mjb08a_E52_RETURNED - Price Quantity Demanded Elasticity Slope $1.00 10 $2.00 9 0.16-1 $3.00 8 0.29-1 $4.00 7 0.47-1 $5.00 6 0.69-1 $6.00 5 1.00-1

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
1. In Column C white space on the perfect tab create the price elasticity formula between the Price of $2 (P1) a 2. In Column D white space create the slope formula showing the rise over run between the Price of $2 and $1 3. Change the fill color to Green for the inelastic data portion of cell range C3:C11 4. Change the fill color to Orange for the unit elastic data portion of cell range C3:C11 5. Change the fill color to Red for the elastic data portion of cell range C3:C11
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Price Quantity Demanded Elasticity Slope $1.00 10 $2.00 9 0.16-1 $3.00 8 0.29-1 $4.00 7 0.47-1 $5.00 6 0.69-1 $6.00 5 1.00-1 $7.00 4 1.44-1 $8.00 3 2.14-1 $9.00 2 3.40-1 $10.00 1 6.33-1 Key 9370affde322f57ea133b5ee53f561f4a Student ID 000425711 First Name Matthew Last Name Brown Email [email protected] Assignment E52 Assignment Assignment E52 Excel Activity...
View Full Document

This note was uploaded on 05/01/2010 for the course BUS 5529 taught by Professor Wood during the Spring '10 term at Abilene Christian University.

Page1 / 3

Mjb08a_E52_RETURNED - Price Quantity Demanded Elasticity Slope $1.00 10 $2.00 9 0.16-1 $3.00 8 0.29-1 $4.00 7 0.47-1 $5.00 6 0.69-1 $6.00 5 1.00-1

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online