introduction to engineering microsoft excel 1 agenda tables, charts, & graphs
TRANSCRIPT
![Page 1: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/1.jpg)
Introduction to EngineeringMicrosoft Excel 1
Agenda Tables, Charts, & Graphs
![Page 2: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/2.jpg)
Agenda
Overview: presenting data in graphical form
Types of graphs Bar charts, pie charts, scatter plots
Essential characteristics of good graphs Titles, axis labels, ticks, legends Plotting experimental and calculated values
Tabulating and graphing data in Excel
![Page 3: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/3.jpg)
Types of Data
Data values can be either numeric or character
Division Year Expenses
R&D 1995 $45,700
Purchasing 1995 $152,090
R&D 1997 $66,330
Purchasing 1997 $263,480
Numeric data may be either continuous orcategorical
Character data are categorical
![Page 4: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/4.jpg)
Types of Graphs
Scatter plots are used when all variables being plotted are numeric and continuous
Bar charts and pie charts are examples of graph types in which at least one of the variables is categorical
![Page 5: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/5.jpg)
270 college students were surveyed to find whether they had part-time jobs and how much they earned. Results:
How can we present this data graphically?
# of studentsmonthly earningmen women
$0 (no job) 44 45less than $200 20 18$200 - $399 34 33
$400 or more 37 39
Example: College students with jobs
![Page 6: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/6.jpg)
Microsoft Excel (Office97)menu bar
customizabletoolbars
Help!
currently active cell(s)cursor
(mouse)
fill handle
formula bar
![Page 7: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/7.jpg)
Enter the Data!
![Page 8: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/8.jpg)
Select the Data
![Page 9: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/9.jpg)
Choosing the graph type
1. Choose item “Chart”
2. Choose chart type “Column”
3. Choose chart sub-type “Clustered Column”
4. And…”Next”
![Page 10: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/10.jpg)
The graph looks good in the preview but it needs x-labels. So click on the Series option.
Select Series
![Page 11: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/11.jpg)
Adding Column Labels
1. Click on Category (X) Axis Labels
2. Select Label Set
4. Click Next
3. Click Icon to Return
![Page 12: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/12.jpg)
Enter the titles and then click finish
![Page 13: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/13.jpg)
Done!!!
Montly Earnings
0
20
40
60
80
100
$0 (no job) < $200 $200-$399 $400 or more
Salary Range
# of
Per
sons
Men
Women
Total
![Page 14: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/14.jpg)
Now it’s your turn!
# of StudentsMothly
EarningsMen Women Total
$0 (no job) 44 45 89< $200 20 18 38
$200-$399 34 33 67$400 or more 37 39 76
![Page 15: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/15.jpg)
Monthly Earnings of College Students
0
10
20
30
40
50
$0 less than$200
$200 -$399
$400 ormore
monthly earnings ($/mo)#
stu
den
ts
men
women
Vertical bar chart
Horizontal bar chart
![Page 16: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/16.jpg)
Pie Chart
$0
less than $200
$200 - $399
$400 or more
Monthly Earnings
![Page 17: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/17.jpg)
Scatter Plot
Motor Speed At Startup
0
500
1000
1500
2000
2500
3000
3500
0 5 10 15Time (sec)
Sp
eed
(rp
m)
Time (sec) Speed (rpm)
1 1210
2 1866
3 2301
4 2564
5 2742
6 2881
7 2879
8 2915
9 3010
![Page 18: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/18.jpg)
Use your imagination!
![Page 19: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/19.jpg)
Copying Excel Charts and Tables into Word
Select the Graph or ChartRight click and select copy OR press
ctrl-C (shortcut).Select the area in the Word document
where you want to place the chart or table
Right click and select paste OR press ctrl-V (shortcut)
![Page 20: Introduction to Engineering Microsoft Excel 1 Agenda Tables, Charts, & Graphs](https://reader036.vdocuments.us/reader036/viewer/2022062315/5697bfa51a28abf838c97c7a/html5/thumbnails/20.jpg)
Assignment #9 – Bar Chart
Use Excel to prepare a bar chart to graphically illustrate the birth/death data shown here.
Save your data on a floppy disk and make sure to bring it with you for the next lecture.
Year Births Deaths 1976 3,167,788 1,909,440 1980 3,612,258 1,989,841 1982 3,680,537 1,974,797 1984 3,669,141 2,039,369 1986 3,756,547 2,105,361 1988 3,909,510 2,167,999 1990 4,158,212 2,148,463 1991 4,110,907 2,169,518 1992 4,065,014 2,175,613 1993 4,000,240 2,268,553 1994 3,952,767 2,278,994
Number of Births and Deathsin the United States