ࡱ > H K
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G J R o o t E n t r y F -+0I W o r k b o o k + S u m m a r y I n f o r m a t i o n ( D o c u m e n t S u m m a r y I n f o r m a t i o n 8 0 \ p David B a = = x N; 8 X@ " 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 h 8 C a m b r i a 1 , 8 C a l i b r i 1 8 C a l i b r i 1 8 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 < C a l i b r i 1 > C a l i b r i 1 ? C a l i b r i 1 4 C a l i b r i 1 4 C a l i b r i 1 C a l i b r i 1
C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i "$"#,##0_);\("$"#,##0\) ! "$"#,##0_);[Red]\("$"#,##0\) " "$"#,##0.00_);\("$"#,##0.00\) ' " "$"#,##0.00_);[Red]\("$"#,##0.00\) 7 * 2 _("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_) . ) ) _(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_) ? , : _("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_) 6 + 1 _(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 0.0 ff + ) , *
P P
` a >
@
& & D
@ D | | G b*}- }
00\);_(* }- }
00\);_(* }- }
00\);_(* }- }
00\);_(* }- }
00\);_(* }- }
00\);_(* }- }
00\);_(* }- }
00\);_(* }- }
00\);_(* }- }
00\);_(* }- }
00\);_(* }- }
00\);_(* }- }
00\);_(* }- }
00\);_(* }- }
00\);_(* }- }
00\);_(* }- } >
00\);_(* }- } ?
00\);_(* }- } @
00\);_(* }A } A
00\);_(* ;_(@_) }- } B
00\);_(* }A } C
00\);_(* ;_(@_) }- } D
00\);_(* }A } E
00\);_(* ef ;_(@_) }A } F
00\);_(* ef ;_(@_) }- } +
00\);_(* }- } ,
00\);_(* }- } -
00\);_(* }- } .
00\);_(* }- } :
00\);_(* }- } ;
00\);_(* }A } 1
00\);_(* ;_(@_) }A } 2
00\);_(* ? ;_(@_) }A } 3
00\);_(* 23 ;_(@_) }- } 4
00\);_(* }A } 0
a 00\);_(* ;_(@_) }A } (
00\);_(* ;_(@_) }A } 7
e 00\);_(* ;_(@_) } } 5
??v00\);_(* ̙;_(@_)
} } 9
???00\);_(* ;_(@_) ??? ??? ???
??? } } )
} 00\);_(* ;_(@_)
}A } 6
} 00\);_(* ;_(@_) } } *
00\);_(* ;_(@_) ??? ??? ???
??? }- } =
00\);_(* } } 8
00\);_(* ;_(@_)
}- } /
00\);_(* }U } <
00\);_(* ;_(@_) }A } "
00\);_(* ;_(@_) }A }
00\);_(* ef ;_(@_) }A }
00\);_(* L ;_(@_) }A }
00\);_(* 23 ;_(@_) }A } #
00\);_(* ;_(@_) }A }
00\);_(* ef ;_(@_) }A }
00\);_(* L ;_(@_) }A }
00\);_(* 23 ;_(@_) }A } $
00\);_(* ;_(@_) }A }
00\);_(* ef ;_(@_) }A }
00\);_(* L ;_(@_) }A }
00\);_(* 23 ;_(@_) }A } %
00\);_(* ;_(@_) }A }
00\);_(* ef ;_(@_) }A }
00\);_(* L ;_(@_) }A }
00\);_(* 23 ;_(@_) }A } &
00\);_(* ;_(@_) }A }
00\);_(* ef ;_(@_) }A }
00\);_(* L ;_(@_) }A }
00\);_(* 23 ;_(@_) }A } '
00\);_(* ;_(@_) }A }
00\);_(* ef ;_(@_) }A }
00\);_(* L ;_(@_) }A } !
00\);_(* 23 ;_(@_)
20% - Accent1M
2 0 % - A c c e n t 1 ef %
20% - Accent2M "
2 0 % - A c c e n t 2 ef %
20% - Accent3M &
2 0 % - A c c e n t 3 ef %
20% - Accent4M *
2 0 % - A c c e n t 4 ef %
20% - Accent5M .
2 0 % - A c c e n t 5 ef %
20% - Accent6M 2
2 0 % - A c c e n t 6 ef %
40% - Accent1M
4 0 % - A c c e n t 1 L %
40% - Accent2M #
4 0 % - A c c e n t 2 L湸 %
40% - Accent3M '
4 0 % - A c c e n t 3 L %
40% - Accent4M +
4 0 % - A c c e n t 4 L %
40% - Accent5M /
4 0 % - A c c e n t 5 L %
40% - Accent6M 3
4 0 % - A c c e n t 6 Lմ %
60% - Accent1M
6 0 % - A c c e n t 1 23 %
60% - Accent2M $
6 0 % - A c c e n t 2 23ٗ %
60% - Accent3M (
6 0 % - A c c e n t 3 23֚ %
60% - Accent4M ,
6 0 % - A c c e n t 4 23 %
60% - Accent5M 0
6 0 % - A c c e n t 5 23 % !
60% - Accent6M 4
6 0 % - A c c e n t 6 23 % " Accent1A A c c e n t 1 O % # Accent2A ! A c c e n t 2 PM % $ Accent3A % A c c e n t 3 Y % % Accent4A ) A c c e n t 4 d % & Accent5A - A c c e n t 5 K % ' Accent6A 1 A c c e n t 6 F % ( Bad9 B a d % ) Calculation C a l c u l a t i o n } % *
Check Cell
C h e c k C e l l % ??? ??? ??? ??? + C o m m a ,( C o m m a [ 0 ] -& C u r r e n c y .. C u r r e n c y [ 0 ] / Explanatory TextG 5 E x p l a n a t o r y T e x t % 0 Good; G o o d a % 1 Heading 1G H e a d i n g 1 I}% O 2 Heading 2G H e a d i n g 2 I}% ? 3 Heading 3G H e a d i n g 3 I}% 23 4 Heading 49 H e a d i n g 4 I}%
5 Inputu I n p u t ̙ ??v% 6 Linked CellK L i n k e d C e l l } % 7 NeutralA N e u t r a l e % 3 N o r m a l % 8 Noteb
N o t e 9 Outputw O u t p u t ???% ??? ??? ??? ??? :$ P e r c e n t
; Title1 T i t l e I}%
< TotalM T o t a l % O O = Warning Text? W a r n i n g T e x t % X T a b l e S t y l e M e d i u m 9 P i v o t S t y l e L i g h t 1 6 ` 6 Per 100K Homicide Calc $W
Raw MPDC Data le Raw Census Data y Projected Census Data b Z 3 A @ @
A : Victim Black Males Females Hispanic White Other Total <1% Asian Total population Male Female Median age (years) (X)
Under 5 years 18 years and over 65 years and over One race Black or African American! American Indian and Alaska Native* Native Hawaiian and Other Pacific Islander Some other race Two or more races RACE One Race Asian Indian Chinese Filipino Japanese Korean
Vietnamese Other Asian [1] Native Hawaiian Guamanian or Chamorro Samoan Other Pacific Islander [2] Some Other Race Two or More Races, White; American Indian and Alaska Native [3] White; Asian [3]$ White; Black or African American [3] White; Some Other Race [3]I http://www.census.gov/population/www/documentation/twps0056/twps0056.html Total
population" American
Indian,
Eskimo,
and Aleut Asian
and
Pacific
Islander
Other
race Hispanic
origin
(of any
race) White, not
of Hispanic
origin Actual OVERALL CHANGE Projected
Straight Line HOMICIDE VICTIMS
POPULATION# HOMICIDE PER 100K RESIDENTS BY RACE B 1 1 R K2 3 t h3 4 $5 5 c c B
7 4F
d MbP?_ * + % , & ffffff?' ffffff?( ?) ? " , B 333333?333333?s& <3 U } } $ }
, , , , , , , ,
, , ,
, , ,
7 T 8@ <@ @@ D@ H@ L@ P@ T@ X@ \@ `@ d@ h@
% m@
Z Z % j@ Z Z % k@ Z Z % j@ Z Z % @n@ Z Z % D l@ Z Z % g@ Z Z % D f@ Z Z % c@
Z Z %
D e@ Z Z % D d@ Z Z % D `@
Z Z %
D \@ Z Z
% $@ Z # Z $ % 4@ Z # Z $ % @ Z # Z $ % @ Z Z % "@ Z Z % D @ Z Z % @ Z Z % D @ Z Z % @
Z Z
%
D @ Z Z
% D @ Z Z
% D
Z Z
%
D @ Z Z
D D
D D D D
8 D D
D D D D
T 8@ <@ @@ D@ H@ L@ P@ T@ X@ \@ `@ d@ h@
B (A Z B 4LA Z
B @A Z B A Z B |A Z
B @AA Z B A Z B A Z B @A Z
B RA
Z B A Z B @A Z
B A Z
B pA Z
B PA Z
B (A Z
B 0,A
Z
B 8A Z
B @A Z
B H3A Z
B PA
Z
B X A Z
B `:
A
Z
B h
A Z
B p A
Z
B xA A
Z D D
D D D D
E 9 E D D
D D D D
T
8@ <@ @@ D@ H@ L@ P@ T@ X@ \@ `@ d@ h@
E , F K\۵P@
D D j@ F ~XN@(
L L j@ F Ġ P@(
F Y^O@(
F Ҟ2R@( F /SQ@(
F %\ M@(
F IDL@(
F ]=@WH@(
F & J@( F {J@( F o>bE@(
F zF`@B@(
E , F (e@ D D
j@ F l~&@(
L L j@ F Th@( F m
@(
F m;@( F ;CڶZ@(
F <*8-@( F
Mڍ@( F Q#?(
F %6n?(
F 0h @( F (
F EA?( T X ##& 4 X & > X D E
X
`
h
T
lat e Me (ye )
yea ear r an One lac can ! Ind las
*
wai the
Is (
n
c 4 N C h a r t 3 ] @ P P PZaajk & ffffff?' ffffff?( ?) ? " 333333?333333? 3 & <3 P H 0 (
@ 3 d 2 3
M R R
R R I3~ S S 4
3 Q :
B l a c k Q ;
Q ;
Q 3 _ M
ff 6 f O @ "B ` M M < R R R R 8]h S S 4 E S S 4
3 Q :
W h i t e Q ;
Q ;
Q 3 _ M
3f f PM @ "B ` M M < R R R R 3Yl S S 4 E S S 4 D $ % 0 3 O & Q R R S S 4 $ % 3 O & Q 4 F A _ D 3 O C
E 3 b R R R R V V
- & ! u, O
. ( Q R n'JS S 4 3 * & ! ! R R u, u, -$͒ S S 4 5 2 3 M
M R R ͒n] S S 4 3 "
b 3 O
a ) # % 0 3 O & Q 4 2 3 M
N M R R R R R R ͒] S S 4 < -$͒ S S 4 S S 4 S S 4 D C
E -$͒
[ S S
4
e e e * v e n - U S i
> @ ͒ ʒ g g D
' :X d
d MbP?_ * + % , & ffffff?' ffffff?( ?) ? " , 333333?333333?n=& <3 U '
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
, , ! , " , # , $ , % , & ,
~
X@~
\@~
`@~
d@~
h@
B @b@> U@ c@> U@ b@> S@ ^@> @U@ Y@> S@
0 *@> @ 0@> "@ 5@> &@ $@
> Q ? *@> $@
B
@> @ @> @ @> @ @> @ @> @
B > ?> ? @> ? @> ? >
B @> @ @> ? @> @ > @> @
B
> > @> @ > >
B ?> ? @> ? @> @ ?> ? @> @
B > > > > >
B e@> ? f@> ? @g@> ? b@> ? ``@> ?
~
D@~
H@~
L@~
P@~
T@
B g@> T@ `j@> @T@ @j@> @U@ d@> U@ d@> U@
B 7@> $@ ?@> (@ 4@> @ 8@> (@ 2@> "@
B $@> @ "@> @ $@> @ @> ? @> @
~
?
6 > > > ?> ?
B @> @ @> @ @> @ @> @ @> @
B @> ? @> ? > > @> ?
~
?
6 @> ? @> ? > @> @
~
?
6 > > > >
B m@> ? `p@> ? o@> ? h@> ? h@> ? ~
8@~
<@~
@@
* @j@> @T@ @g@> @S@ h@> T@
* ;@> $@ =@> (@ <@> (@
!
! * ! @> @ @> @ @> @
"
" $ " @> ? > ?
"
#
# * # @> @ *@> @ @> @
$
$ * $ @> ? @> @ >
%
% * % @> ? @> ? @> @
&
& * & > > > > | 0T b x b b b b b b T T b b b r b b r r T * J J J R J J J > @ > : g g D
@ >@
0 ~
@
? @ @ @ X9v?
? @ @
1 ~
GA
? ^@ V@
? V" @
@ Zd;?
? o@ V@
? (A @ @ x&1?
? @ D@
? @A N@ @ rh|?
? P@ 4@
? Ě@ >@ @ ;On?
? @ D@
? @ p@ @ ;On?
? |@ >@
u@ $@ @ MbP?
? @ ?
? o@ w@@ @
r@ $@
? C@ n@ @ ~jt?
! R@
" [@
# =@
$ U@
% ~
? @ ffffff@
& ? @ r@
' @@ 4@
( ? 0@ N@
) ? (@ N@
* ? (@ >@ : * F v v | v v @ Z Z Z Z Z Z N Z $ $ $ . $ $ $ $ > @
g g D
z g
d MbP?_ * + % , & ffffff?' ffffff?( ?) ? " , 333333?333333? & <3 U }
A }
}
A }
A
, , , , B , B , B , B , B , B
, B , B ,
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
A 2
5
5
5
5
5
5
5
5
5
A 2
5
5
5
5
5
5
5
5
5
A 2
3 A @ @ @ $@ (@ ,@ 0@ 4@ 8@ <@A @@ D@ H@ L@ P@ T@ X@ \@ `@ d@A h@
B C h"A
Z 2 B 0j"A D D
D @ A B N"A( &
L L
L @ A B 3"A( B "A( B P!A( B !A( B !A(
B !A(
B n!A( C 6u!A Z
2 B b!A D D
D @ A
B !A(
&
L L
L @ A B !A(
B !A(
B !A(
B B "A(
B p"A(
B ."A(
B E"A(
C \"A Z
B C cA Z B A( &
L L
L @ A B A( B [A( B A( B A(
B TA( B A( B (A(
B 4LA( C @A Z
B A( & L L
L @ A
B |A( B @AA( B A( B A( B @A(
B RA( B A( B @A( C A Z
B C A Z B pA( B PA( B (A( B A( B A(
B A( B A( B pA(
B PA( C (A Z
B 0,A(
B 8A( B @A( B H3A( B PA( B X A(
B `:
A( B h
A( B p A( C xA A Z C C C
B 4 C C C
B C ! C D D ! C @ D D
B
C !
C | D D !
C ` D D
B C ! C ܫ D D ! C @ @ D D < ? @ @ @ @ @ @ @ "@
< ? @ @ @ @ @ @ @ "@ K & ! , b b b D
?
H P X ` h
BJ
D
VT
,
j
,
> @ g g D
Oh +'0 @ H X h
Mitch David Microsoft Excel @ 7,@ +0 ՜. +,0 H P X ` h p
x Per 100K Homicide Calc Raw MPDC Data Raw Census Data Projected Census Data Worksheets
F& Microsoft Office Excel 2003 Worksheet Biff8 Excel.Sheet.8 9q C o m p O b j r