# Practice Activities II

Anonymous
account_balance_wallet \$25

### Question Description

Complete the practice activities under the "Week 3 Spreadsheets: Practice" section in MyEducator®:

• "Week 3 Practice: Excel Basics"
• "Week 3 Practice: Formulas and Functions"
• "Week 3 Practice: Charting"

TeacherSethGreg
School: University of Virginia

Attached.

The table below contains information about the median annual income and 2010
unemployment rate for Americans with various levels of education. Use charts to analyze the
relationship between education and income as well as education and unemployment.
Education Attained
Less than a high school diploma
Some college, no degree
Associate degree
Bachelor's degree
Master's degree
Professional degree
Doctoral degree

Median Annual Earnings
\$23,088
\$32,552
\$37,024
\$39,884
\$53,976
\$66,144
\$83,720
\$80,600

Unemployment Rate (%)
14.9
10.3
9.2
7.0
5.4
4.0
2.4
1.9

Education and Income
\$90,000
\$80,000
\$70,000
\$60,000
\$50,000
\$40,000
\$30,000
\$20,000
\$10,000
\$0

\$83,720

\$80,600

2.4

1.9

\$66,144
\$53,976
\$32,552

\$37,024

\$39,884

\$23,088

Unemployment Rate (%)
16.0
14.0
12.0
10.0
8.0
6.0
4.0
2.0
0.0

14.9
10.3

9.2
7.0

5.4

4.0

Apple, Inc. is one of the most successful companies in the
world. The table below details the revenue for Apple in each
quarter from 2007-2011.

Quarter
Q1
Q2
Q3
Q4
Total

Revenues in millions of dollars
2007
2008
2009
2010
2011
\$7,123 \$10,430 \$11,880 \$15,683 \$26,741
\$5,286 \$7,980 \$9,084 \$13,499 \$24,667
\$5,563 \$7,561 \$9,734 \$15,700 \$28,571
\$6,606 \$11,520 \$12,207 \$20,343 \$28,270
\$24,578 \$37,491 \$42,905 \$65,225 \$108,249

\$120,000
\$100,000
\$80,000
\$60,000
\$40,000
\$20,000
\$0
2007

Apple Revenue by Quarter

2008

2009
Q1

Q2

Q3

2010
Q4

2011

PC Shipments 3Q 2011

The personal computer market is undergoing a
transition due to increase tablet sales. The table
below details shipments from the top PC
manufacturers to PC retailers and customers in the
third quarters of 2010 and 2011.
Company
HP
Dell
Apple
Toshiba
Acer
Others

3Q11 Shipments
5,132,614
3,886,864
2,300,000
1,486,100
1,378,768
3,580,989

3Q10 Shipments
4,459,120
4,188,687
1,893,600
1,545,630
1,848,511
3,635,684

20%

8%

8%

13%
HP

Dell

Apple

PC Shipments 3Q 2011

PC Shipments 3Q 2010

29%

21%

25%

10%
9%

24%
11%

22%

Toshiba

Acer

Others

HP

Dell

Apple

Toshiba

Acer

Others

Others

The population of Utah is growing rapidly. It has increased nearly 25% since 2000. The table below details the estim
to 2009. Complete the tasks to look for trends or patterns in the population growth in the State.
County
Beaver County
Box Elder County
Cache County
Carbon County
Daggett County
Davis County
Duchesne County
Emery County
Garfield County
Grand County
Iron County
Juab County
Kane County
Millard County
Morgan County
Piute County
Rich County
Salt Lake County
San Juan County
Sanpete County
Sevier County
Summit County
Tooele County
Uintah County
Utah County
Wasatch County
Washington County
Wayne County
Weber County
Total Population

2000
6,016
42,872
91,872
20,354
928
240,293
14,371
10,946
4,748
8,399
33,989
8,271
6,079
12,395
7,155
1,431
1,964
901,051
14,373
22,808
18,868
29,987
41,615
25,253
371,648
15,417
91,256
2,529
197,426
2,244,314

2001
6,003
43,632
93,798
19,691
921
244,578
14,540
10,665
4,657
8,515
34,724
8,386
5,951
12,300
7,289
1,397
1,921
914,334
13,583
23,144
18,912
30,929
43,726
25,697
387,853
16,090
94,624
2,507
200,883
2,291,250

2002
6,040
44,522
97,277
19,745
888
249,835
14,796
10,553
4,550
8,716
35,648
8,473
5,994
12,222
7,400
1,387
1,928
924,534
13,776
23,230
18,948
31,763
45,577
26,173
397,269
16,735
99,432
2,514
204,548
2,334,473

2003
5,990
45,229
100,177
19,665
887
256,173
14,782
10,497
4,457
8,793
36,061
8,599
6,007
12,151
7,444
1,365
2,007
936,378
13,727
23,337
18,956
32,666
47,333
26,180
409,465
17,382
104,274
2,459
207,497
2,379,938

Population in Selected Counties
1,200,000
1,000,000
800,000
600,000

Davis County
Salt Lake County
Utah County

400,000
200,000

Weber County

200,000
2000 2001 20...

flag Report DMCA
Review

Anonymous
Goes above and beyond expectations !

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors