excel charts
TRANSCRIPT
Lesson 8
And
Student Survey
By; Antonio Zermeno P.2
Example Survey for Google
FormWhat do you think of Snooki being pregnant?
I really don't care 14
I wish her and the baby the best! 8
I'm so excited to see their baby! 2
I feel bad for the baby 6
I'll give her a chance and see if she changes 4
0
2
4
6
8
10
12
14
16
I really don’t careI wish her and the baby the best!I'll give her a chance and see If she changesI feel bad for the babyIm so excited to see their baby!
What do you think of Snooki Being pregnant?
Chico Temperatures Chart
Average Monthly Temperatures for Chico, California(in Fahrenheit)
Month Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec
High 54 61 65 72 81 90 95 94 89 78 63 54
Low 35 39 41 44 55 57 61 59 55 48 41 36
Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec
High 54 61 65 72 81 90 95 94 89 78 63 54
Low 35 39 41 44 55 57 61 59 55 48 41 36
0
10
20
30
40
50
60
70
80
90
100
Tem
pera
ture
s in
Fah
ren
heit
Temperatures for Chico, California
Concession Sales ChartCONCESSION SALES
Mountain College Musk Oxen
Food Game 1 Game 2 Game 3 Game 4 Total
Hot Dogs $ 3,500 $ 3,950 $ 4,280 $ 3,850 $ 15,580
Sandwiches 1,450 1,050 950 300 3,750
Chips 2,250 2,100 2,450 2,200 9,000
Popcorn 1,750 1,900 2,100 2,200 7,950
Pretzels 750 775 900 525 2,950
Total $ 9,700 $ 9,775 $ 10,680 $ 9,075 $ 39,230
$-
$500
$1,000
$1,500
$2,000
$2,500
$3,000
$3,500
$4,000
$4,500
Hot Dogs Sandwiches Chips Popcorn Pretzels
Sa
les
In
Do
lla
rs
Concession SalesGame 1 Game 2 Game 3 Game 4
Coronado Foundries ChartFactory Units Produced Scrap Generated*
Colorado 7,259 110
Iowa 1 8,723 129
Iowa 2 10,548 245
Kansas 5,211 50
Nevada 4,527 45
Oklahoma 9,914 149
Texas 1 11,204 190
Texas 2 8,564 100
Texas 3 6,799 75
Utah 1 7,612 150
Utah 2 8,247 125
Total 88,608 1,368
*Scrap is generated during the manufacturing process.
-
50
100
150
200
250
300
4,000 5,000 6,000 7,000 8,000 9,000 10,000 11,000 12,000
Un
its O
f S
cra
p
Units Produced
Production and Scrap Report
Education Pays Chart
Median Income by Education LevelEducation Level Men Women
No high school diploma $ 22,138 $ 13,076
High School diploma $ 31,683 $ 20,179
Some college or associate's degree $ 39,601 $ 25,736
Bachelor's degree $ 53,693 $ 26,250
Graduate or professional degree $ 71,918 $ 47,319
Source: U.S. Census Bureau, 2005 American Community Survey
http://www.census.gov/prod/2006pubs/acs-02.pdf, page 13
$-
$10,000
$20,000
$30,000
$40,000
$50,000
$60,000
$70,000
$80,000
No high school
diploma
High School diploma
Some college or
associate's degree
Bachelor's degree
Graduate or professional
degree
Med
ian
In
co
me
Education Level
EDUCATION PAYS
Men Women
Family Expenses Chart
MONTHLY CASH FLOW
Sources of Income
Salary $ 3,200
Expenses
Housing 975
Groceries 315
Taxes 275
Utilities 300
Contributions 200
Insurance 125
Savings 300
Entertainment 225
Total Uses of Cash $ 2,715
Surplus $485
Housing36%
Groceries12%
Taxes10%
Utilities11%
Contributions7%
Insurance5%
Savings 11%
Entertainment8%
Where Our Money Goes
Grain Sales Chart
Annual Sales (in thousands)
Segment Sales
Alfalfa $ 1,723
Corn 3,627
Soybeans 2,785
Wheat 895
Total $ 9,030
Alfalfa19%
Corn40%
Soybeans31%
Wheat10%
Annual Sales by segment
McDonald’s Restaurants Chart
McDonald's CorporationRestaurants
Company operated 8,785
Franchises 18,687
Affiliated 4,195
Total 31,667
Source: McDonald's Corporation 2006 Annual Report
http://www.mcdonalds.com/corp/invest/pub/2006_Annual_Report.html
28%
59%
13%
Total RestaurantsCompany operated Franchises Affiliated
Populations Of Large Cities
ChartMost Populated Cities in the World
Population
City (in millions)
Tokyo/Yokohama 33.2
New York 17.8
Sao Paulo 17.7
Seoul/Incheon 17.5
Mexico City 17.4
Osaka/Kobe/Kyoto 16.425
Manila 14.75
Mumbai 14.35
Delhi 14.3
Jakarta 14.25
Source: http://www.citymayors.com/statistics/largest-cities-population-125.html
Largest cities in the world by land area, population, and density as of January 6, 2007
accessed June 13, 2007
0
5
10
15
20
25
30
35
Po
pu
lati
on
in
Millio
ns
World's 10 Largest Cities
Red Cross Chart
Operating ExpensesYears ending June 30(in millions)
Year Expenses
1997 $ 1,721.8 1998 $ 1,790.9 1999 $ 2,062.7 2000 $ 2,226.6 2001 $ 2,489.0 2002 $ 3,259.8 2003 $ 3,071.0 2004 $ 3,199.5 2005 $ 3,427.9 2006 $ 5,628.1
Source: Annual Reports of the American Red Cross
http://www.redcross.org
$-
$1,000.0
$2,000.0
$3,000.0
$4,000.0
$5,000.0
$6,000.0
1997 1998 1999 2000 2001 2002 2003 2004 2005 2006
(in
mil
lio
ns
)
Year
American Red CrossOperating Expenses
Running Times Chart
Running Times10-Week Workout Program
Week Time
1 35.5
2 35.25
3 35.25
4 35
5 35.25
6 34.75
7 34.5
8 34.15
9 34.25
10 34
33
33.5
34
34.5
35
35.5
36
1 2 3 4 5 6 7 8 9 10
Tim
e in
Min
ute
s
Week
Study And Grades ChartRelationship of Study Time to Test Grades
Student Study Time Test Grade
Anderson 5.25 87
Block 1 56
Chen 5.25 95
Davis 3.25 64
Evans 4.5 75
Franks 4 74
Gomez 4.25 78
Herrera 4.75 88
Ingram 5.5 94
Johnson 0.5 66
Kyle 3 76
Langford 3.75 75
Montrose 3.25 74
Newman 5.5 84
Ross 4.5 85
Theisen 6 90
Williams 2.25 61
Wong 5.75 91
0
10
20
30
40
50
60
70
80
90
100
0 2 4 6 8 10 12 14 16 18 20
Ex
am
Gra
de
s
Hours Of Study
Relationship Between Exam Grades And Study Time
Triangle Growth Charts
FINANCIAL HIGHLIGHTS
Triangle Software Corporation
(in thousands) Year Ending December 312006 2007 2008 2009 2010
Net Revenues $2,700 $3,800 $4,600 $6,000 $8,600Net Income 700 900 1,200 1,500 2,300Total Assets 2,700 3,900 5,300 7,300 10,000Stockholders' Equity 2,200 3,300 4,400 5,200 7,000Return on Net Revenues 25.9% 23.7% 26.1% 25.0% 26.7%
$0
$1,000
$2,000
$3,000
$4,000
$5,000
$6,000
$7,000
$8,000
$9,000
$10,000
2006 2007 2008 2009 2010D
ollars
In
Th
ou
san
ds
Triangle Software Revenue And Income
Net Revenues Net Income
$0
$1,000
$2,000
$3,000
$4,000
$5,000
$6,000
$7,000
$8,000
$9,000
$10,000
2006 2007 2008 2009 2010
Do
llars
In
Th
ou
san
ds
Triangle Software Revenue And Income
Net Revenues Net Income
The End.
Thanks for watching my powerpoint, I
hope you enjoyed it.