Graphing Example

# Graphing Example - 60 \$4.90 Step 2 Select A12,…,C22 65...

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

0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 \$0 \$5 \$10 \$15 \$20 \$25 \$30 \$35 \$40 \$45 Rain/Umbrellas Inches of Rain Umbrellas

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

View Full Document
Quantity Demand Suppy Step 1. Create a schedule A2,. .,B7 Qty D S 0 \$60 \$0 Step 2. Select A2,…,C10 1 \$40 \$7 2 \$27 \$14 Step 3. Click Chart Wizard ICON above 3 \$20 \$20 4 \$15 \$30 Step 4. Select Chart Type XY(Scatter) Then Select 5 \$10 \$40 Chart Sub-Type on right (1st column, second row.) 6 \$5 \$50 7 \$0 \$60 Step 5. Click on Next. Step 6. Type in the 1. Chart Title, 2. the x axis label, and 3. the y axis label Step 7. Click on Next. Step 8. Type Chart Tiltle Step 9. Click on Finish Step 10. Copy and paste into your MS Word document. 0 1 2 3 4 5 6 7 8 \$0 \$10 \$20 \$30 \$40 \$50 \$60 \$70 Market for Apples D S Quantity Price
Given: 85 \$3.40 72 80 \$3.70 73 75 \$4.00 75 70 \$4.30 77 65 \$4.60 79 60 \$4.90 81 Reset Schedule for Excel: Be sure to Right Click Cell and clear contents for each blank cell. Bushels Demand Supply Step 1. Create a schedule A12,. .,c22---Be sure to Right Click Cell an

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: 60 \$4.90 Step 2. Select A12,…,C22 65 \$4.60 Step 3. Click Chart Wizard ICON above 70 \$4.30 Step 4. Select Chart Type XY(Scatter) Then Select Chart Sub-Type 72 \$3.40 Step 5. Click on Next. 73 \$3.70 Step 6. Type in the 1. Chart Title, 2. the x axis label, and 3. the y ax 75 \$4.00 \$4.00 Step 7. Click on Next. 77 \$4.30 Step 8. Type Chart Tiltle 80 \$3.70 Step 9. Click on Finish 81 \$4.90 Step 10. Copy and paste into your MS Word document. 85 \$3.40 Thousands of Bushels Demanded Price per bushel Thousands of Bushels Supplied 55 60 65 70 75 80 85 90 \$0.00 \$1.00 \$2.00 \$3.00 \$4.00 \$5.00 \$6.00 Kansa City Grain Market Demand Supply Bushels Price nd clear contents for each blank cell. e on right (1st column, second row.) xis label...
View Full Document

## This note was uploaded on 06/22/2011 for the course ECON 141 taught by Professor Doug during the Spring '09 term at Park.

### Page1 / 4

Graphing Example - 60 \$4.90 Step 2 Select A12,…,C22 65...

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

View Full Document
Ask a homework question - tutors are online