{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

mjb08a_e42_RETURNED

# mjb08a_e42_RETURNED - o False Price Demand 1 Demand 2...

This preview shows pages 1–4. Sign up to view the full content.

1. In Cell A2:A21 on the perfect tab enter the numbers 1 through 20 in increasing order 3. In Cell C2:C21 create a formula that refers to Demand 1 and minuses 1 from each corresponding cell on the same r o 4. In Cell D2:D21 create a formula that refers to Demand 1 and adds 1 from each corresponding cell on the same row 6. Create a Scatter graph with smooth lines without markers. 8. Move the graph to fit in the cell range F1:N21. 2. In Cell B2:B21 enter the number sequence 20 through 1 ensuring that you maintain the price demand relationship b e and quantity. 5. In Cell E2:E21 enter the number sequence 1 through 20 ensuring that you maintain the price supply relationship be t w quantity. 7. Add the graph series one at a time. Make Price data the Y axis, and Demand 1 data, Demand 2 data, Demand 3 dat a data your X axis. Use a cell reference to name each series. 9. Answer the True False Questions in the Blue area of the True/False Table. Be sure to use only a capital T for True

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

View Full Document

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: o False. Price Demand 1 Demand 2 Demand 3 Supply Answer T or F Question 1. Supply Increases 2. Quantity Supplied Increases (from Demand 1 to Demand 3) 3. Demand Decreases from Demand 1 to Demand 2 4. Supply Decreases 5. Price Increases and Quantity Demanded Increases from Demand 1 to Demand 3. 6. Price Increases and Quantity Demanded Decreases from Demand 1 to Demand 2 7. A shift in Demand from Demand 1 to Demand 3 is caused by a change in price. 8. A shift in Demand from Demand 1 to Demand 2 could be caused be a reduction incom 9. The change in Quantity Supplied is caused by an increase in the number of suppliers. 10. The change in Quantity Supplied is caused by changing equilibriums with demand a me. . nd supply. Key 9370affde322f57ea133b5ee53f561f4a Student ID 000425711 First Name Matthew Last Name Brown Email [email protected] Assignment E42 Assignment Assignment e42 Excel Activity...
View Full Document

{[ snackBarMessage ]}

### Page1 / 4

mjb08a_e42_RETURNED - o False Price Demand 1 Demand 2...

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

View Full Document
Ask a homework question - tutors are online