A
B
C
E
F
G
H
Chapter 4- Pie Chart
1
2
3
4
1 pt for correct graph, 1 pt for title, 1 pt for legend, 1 pt for %, 1 pt for leader lines, 1 pt for size adjustment.
Nebraska Age Distribution for 2000
Age
5
Number
6
Under 5
117.048
7
5 to 9 years
123.445
8
10 to 14 years
128.445
9
15 to 19 years
134.909
10
20 to 24 years
120.331
11
25 to 34 years
223.273
12
35 to 44 years
263.834
13
45 to 54 years
225.754
14
55 to 64 years
141.540
15
65 to 74 years
115.699
16
75 to 84 years
82.543
17
85 years and over
33.953
18
Total
1.710.774
19
20
D
Be sure to save your work.
20150617182713copy_of_project_2_11.xlsPie Chart
I
A
4
B
C
D
Population Growth
Year
Nebraska
Population
1960
1.411.330
6
1970
1.485.333
7
1980
1.569.825
8
1990
1.578.385
9
2000
1.711.263
10
11
12
13
14
15
Year
Hall County
Population
17
1960
35.757
18
1970
42.851
19
1980
47.690
20
1990
48.925
21
2000
53.534
22
23
24
25
26
27
28
F
G
2 pts for line graph, 4 pts for axis labels, 2 pts for title, 2 pts for size adjustment
5
16
E
Chapter 4 - Broken Line Graph
1
2
3
Be sure to save your changes
20150617182713copy_of_project_2_11.xlsBroken Line Chart
H
I
J
A
5
6
7
8
9
10
11
12
13
14
15
16
C
D
E
F
G
H
I
Chapter 4 - Bar Graph
1
2
3
4
B
1 pt for bar graph, 1 pt for title, 1 pt for x axis, 1 pt for y axis, 1 pt for size adjustment
GROSS RENT BY NEBRASKA CITIZENS IN 2000
RENT
NUMBER OF
RENTERS
No Cash Rent
12.714
Less than $200
12.512
$200 to $299
16.814
$300 to $499
71.777
$500 to $749
68.270
$750 to $999
17.168
$1,000 to $1,499
5.879
$1,500 or more
2.082
Be sure to save your changes
20150617182713copy_of_project_2_11.xlsColumn Chart
J
K
M
A
B
C
D
E
1
Project 2 - Chapter 4 Business Statistics
2
1 pt for each formula
3
Mean, Median, and Mode
Data Set 1
14
17
23
25
33
42
43
55
55
67
78
88
96
99
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Data Set 2
10
20
25
30
45
48
50
65
68
70
75
78
85
90
Data Set 3
16
32
53
26
94
14
15
70
86
66
15
30
26
62
Data Set 4
150
175
168
202
105
95
66
105
59
126
174
187
167
185
19 Mean
20 Median
21 Mode
22
23
Be sure to save your work.
20150617182713copy_of_project_2_11.xlsMean, Median, Mode
F
A
3
Occupation
Accountants and Auditors
Loan Officers
Tax Preparers
Computer and Mathematical Occupations
Community and Social Services Occupations
Sales and Related Occupations
Food Preparation and Serving Related Occupations
Office and Administrative Support Occupations
Payroll and Timekeeping Clerks
Human Resources Assistants, Except Payroll and Timekeeping
Computer Operators
Child Care Workers
22
Highest
Lowest
Range
Standard Deviation
Weighted Mean for Average Salary
http://www.bls.gov/oes/current/oes251011.htm
23
Be sure to save your work
17
18
19
20
21
C
D
E
Total Salary of
those in
Occupation
Mean Hourly
Wage
Chapter 4 - High, Low, Range, Standard Deviation
1 pt for each formula
Nebraska May 2005 Wages by Occupation
1
2
4
5
6
7
8
9
10
11
12
13
14
15
16
B
20150617182713copy_of_project_2_11.xlsHigh,Low,Range,Stan.Dev
Mean Annual Number
Employed
Salary
$54.580
$55.420
$36.110
$57.760
$30.290
$28.710
$16.360
$26.410
$31.060
$31.130
$27.740
$16.150
7.460
2.830
340
20.250
13.090
94.160
75.020
156.580
1.230
1.210
1.210
4.250
$26,24
$26,65
$17,36
$27,77
$14,56
$13,80
$7,87
$12,70
$14,93
$14,97
$13,34
$7,77
Purchase answer to see full
attachment