Lesson 8- Excel/Data Analysis - Graphing (charting) the data
Most presentations and displays of data are enhanced by attractive and informative charts. Charts are a pictorial
presentation of data - often found in tables. Some data can be represented by mo
XL07: Tables - Information and Display
Organizing Data, Finding Information in Tables and Table Display
Freezing panes This allows one or more rows (and/or columns) to be always visible when you are scrolling. You can freeze the top row,
the left column o
Math/Logic Skills
-IF statements (logical condition, value if
true, value if false)
- ratios
-percents
-order of operations
-creating formulas
Excel Skills
-IF function
-Nested IF function
-Absolute and relative referencing
- COUNTIF(S)
-AVERAGEIF(S)
-SUM
Histogram
A histogram is similar to a column chart but with a few very important differences.
The vertical height represents the frequency of occurrence of the range of values indicated in the width of the column. This means that the width of
the column h
XL07: Tables - Information and Display
Organizing Data, Finding Information in Tables and Table Display
Freezing panes This allows one or more rows (and/or columns) to be always visible when you are scrolling. You can freeze the top row,
the left column o
Excel Skills
-IF function
-Nested IF function
-Absolute and relative referencing
- COUNTIF(S)
-AVERAGEIF(S)
-SUMIF(S)
Math/Logic Skills
-IF statements (logical condition, value if
true, value if false)
- ratios
-percents
-order of operations
-creating for
Data interpretation and understanding often depends on the units. If someone tells you that she has a good
job and earns 50,000 Canadian dollars a year, this will probably not mean very much to you. This is because
you may not know how much a Canadian dol
These are the results a quiz for a class of COL 110
students. The maximum mark on the quiz is 40.
Name
Shaikha
Khawla
Salma
Rabea
Nada
Marwa
Badriya
Muna
Maisoona
Layla
Hawaa
Amina
Asma
Quiz Mark
31
12
26
19
20
19
10
34
23
14
23
23
13
Using x 100 Using %
1. What is a histogram?
2. Construction of a histogram
3. Interpretation of data with a
histogram
data with a histogram
Country
China
India
United States
Indonesia
Brazil
Pakistan
Population
Bangladesh
1,400,000,000
Population
1,306,314,000
1,200,000,000
Favorite Team
Campus
Emirates
Barcelona
Chelsea
Barcelona
Chelsea
Real Madrid
Arsenal
Real Madrid
Juventus
Real Madrid
Chelsea
Arsenal
UOS
UOS
ZU (dubai)
Ku
UOS
SWC
ZU (dubai)
SWC
ZU
SWC
UOS
Shj
Shj
Dxb
AD
Shj
ajman
Dxb
ajman
dxb
ajman
Shj
Aisha Darwish
R