Directions: Complete #1 through #3 below. Access the file "WA3 Data Set (Movies)" from the Writing Assignment's page. The file consists of a data table of 100 randomly selected movies recording their Run Time (in minutes), Budget (in dollars), Review (in number of stars), Rating, Genre, Amount Grossed (in dollars), and Gender of Lead Character. You may complete each part by hand, or with the aid of statistical software such as Excel, SPSS, StatCrunch, etc.

1. Display a contingency table (of counts) comparing the response variables of RATING and GENRE.List RATING responses on the top row of your table, and GENRE responses on the left-most column of your table.

2. Using the data in your contingency table answer the following questions:

a) What percentage of R-rated movies were Dramas?

b) What percentage of Dramas were R-rated?

c) What percentage of movies were R-Rated Dramas?

3. Display a side-by-side bar chart accurately displaying the data given by your contingency table.

Movie	Run Time (minutes)	Budget ($)	Stars	Rating	Genre	USGross ($)	Lead Gender
White Noise	101	30000000	2	PG-13	Horror	56094360	M
Coach Carter	136	45000000	3	PG-13	Drama	67264877	M
Elektra	100	65000000	2	PG-13	Action	24409722	F
Racing Stripes	110	30000000	3	PG	Comedy	49772522	NA
Assault on Precinct 13	109	30000000	3	R	Action	20040895	M
Are We There Yet?	94	20000000	2	PG	Comedy	82674398	M
Alone in the Dark	96	20000000	1.5	R	Horror	5178569	M
Indigo	105	25000000	3.5	R	Drama	51100486	M
Boogeyman	88	20000000	2	PG-13	Horror	46752382	M
The Wedding Date	90	40000000	2.5	PG-13	Comedy	31726995	F
Hitch	113	55000000	3	PG-13	Comedy	1.78E+08	M
Pooh's Heffalump Movie	68	20000000	3.5	G	Adventure	18081626	NA
Because of Winn-Dixie	106	15000000	3	PG	Comedy	32647042	F
Constantine	122	75000000	3	R	Action	75976178	M
Son of the Mask	86	100000000	2	PG	Comedy	17018422	M
Cursed	105	35000000	2	PG-13	Horror	19294901	F
Man of the House	100	50000000	2.5	PG-13	Comedy	19699706	M
Be Cool	150	75000000	2.5	PG-13	Comedy	55849401	M
The Jacket	103	28500000	1.5	R	Thriller	6301131	M
The Pacifier	97	56000000	2	PG	Comedy	1.13E+08	M
Hostage	108	75000000	2.5	R	Action	34636443	M
Robots	89	80000000	3.5	PG	Adventure	1.28E+08	NA
The Upside of Anger	117	12000000	3.5	R	Drama	18761993	F
Ice Princess	99	25000000	2.5	G	Comedy	24381334	F
The Ring Two	111	50000000	2.5	PG-13	Horror	75941727	F
Miss Congeniality 2: Armed and Fabulous	115	60000000	2	PG-13	Comedy	48478006	F
Guess Who	103	35000000	3	PG-13	Comedy	68915888	M
Beauty Shop	105	25000000	3	PG-13	Comedy	36351350	F
Sin City	126	40000000	4	R	Action	74098862	M
Fever Pitch	103	40000000	3.5	PG-13	Comedy	42071069	M
Kung Fu Hustle	99	20000000	3.5	R	Action	17104669	M
Sahara	123	130000000	3	PG-13	Adventure	68671925	M
The Amityville Horror	89	18500000	2.5	R	Horror	64538396	M
The Interpreter	118	90000000	3.5	PG-13	Thriller	72708161	F
King's Ransom	98	25000000	1.5	PG-13	Comedy	4008527	M
A Lot Like Love	107	25000000	2.5	PG-13	Comedy	21835784	M
The Hitchhiker's Guide to the Galaxy	103	45000000	3.5	PG	Comedy	51019112	M
XXX: State of the Union	100	60000000	1.5	PG-13	Action	26873932	M
Crash	107	6500000	3.5	R	Drama	54557348	NA
House of Wax	113	35000000	2.5	R	Horror	32064800	M
Kingdom of Heaven	144	110000000	3.5	R	Adventure	47398413	M
Kicking and Screaming	90	45000000	2.5	PG	Comedy	52842724	M
Mindhunters	106	27000000	2	R	Thriller	4476235	M
Monster-in-Law	95	45000000	2	PG-13	Comedy	82931301	F
Star Wars Episode III: Revenge of the Sith	140	115000000	4	PG-13	Adventure	3.8E+08	M
The Longest Yard	113	82000000	2.5	PG-13	Comedy	1.58E+08	M
Madagascar	86	75000000	3	PG	Adventure	1.93E+08	NA
The Sisterhood of the Traveling Pants	145	25000000	3.5	PG	Drama	39053061	F
Cinderella Man	144	88000000	4	PG-13	Drama	61649308	M
Lords of Dogtown	107	25000000	3	PG-13	Action	11273517	M
Batman Begins	140	150000000	4	PG-13	Action	2.05E+08	M
The Perfect Man	101	10000000	1.5	PG	Comedy	16535005	F
Herbie: Fully Loaded	95	50000000	3	G	Comedy	66010682	F
Bewitched	100	80000000	2	PG-13	Comedy	63313159	F
Land of the Dead	97	15000000	3.5	R	Horror	20700082	M
War of the Worlds	116	132000000	4	PG-13	Action	2.34E+08	M
Rebound	103	45000000	2	PG	Comedy	16809014	M
Dark Water	105	60000000	3.5	PG-13	Thriller	25473093	F
Fantastic Four	123	87500000	2	PG-13	Action	1.55E+08	M
Charlie and the Chocolate Factory	115	150000000	4	PG	Comedy	2.06E+08	M
Wedding Crashers	113	40000000	3.5	R	Comedy	2.09E+08	M
Bad News Bears	113	35000000	3.5	PG-13	Comedy	32868349	M
Hustle & Flow	115	2800000	3.5	R	Drama	22202809	M
The Island	136	120000000	2.5	PG-13	Action	35818913	M
Must Love Dogs	98	35000000	3	PG-13	Comedy	43894863	F
Sky High	102	60000000	3	PG	Adventure	63939454	M
Stealth	121	138000000	2.5	PG-13	Action	32116746	M
Deuce Bigalow: European Gigolo	83	22000000	1.5	R	Comedy	22400154	M
Four Brothers	109	30000000	2.5	R	Drama	74494381	M
The Skeleton Key	104	40000000	3	PG-13	Horror	47907715	F
The Great Raid	133	20000000	2.5	R	Action	10166502	M
The 40-Year-Old Virgin	111	26000000	4	R	Comedy	1.09E+08	M
Valiant	76	35000000	2.5	G	Adventure	19471912	NA
The Brothers Grimm	119	80000000	2.5	PG-13	Adventure	37899638	M
The Cave	97	30000000	2	PG-13	Horror	15007991	M
Undiscovered	97	27000000	2	PG-13	Comedy	74888996	F
The Constant Gardener	129	25500000	4	R	Drama	33579798	M
Transporter 2	87	32000000	3	PG-13	Action	43095856	M
The Exorcism of Emily Rose	114	18000000	3	PG-13	Horror	75072454	M
The Man	83	20000000	2	PG-13	Comedy	8330720	M
An Unfinished Life	108	30000000	2.5	PG-13	Drama	8535575	M
Corpse Bride	77	30000000	4	PG	Adventure	53359111	NA
Cry Wolf	91	1000000	2.5	PG-13	Thriller	10047674	M
Just Like Heaven	95	58000000	2.5	PG-13	Comedy	48318130	M
Lord of War	121	42000000	3	R	Action	24149632	M
Flightplan	93	55000000	2.5	PG-13	Action	89706988	F
A History of Violence	96	32000000	4	R	Drama	31493782	M
Roll Bounce	106	10000000	3	PG-13	Comedy	17380866	M
Capote	114	7000000	4.5	R	Drama	28750530	M
Into the Blue	109	50000000	2	PG-13	Adventure	18782227	F
Serenity	119	39000000	4	PG-13	Action	25514517	M
Wallace & Gromit: The Curse of the Were-Rabbit	85	30000000	4	G	Adventure	56068547	NA
Waiting...	93	1125000	2	R	Comedy	16124543	M
Domino	133	50000000	2	R	Action	10169202	F
Elizabethtown	133	54000000	2.5	PG-13	Drama	26850426	F
The Fog	101	18000000	2	PG-13	Horror	29511112	M
Doom	113	70000000	2	R	Horror	28212337	M
North Country	123	30000000	4	R	Drama	18324242	F
The Weather Man	101	20000000	3	R	Drama	12482775	F
Chicken Little	80	60000000	3	G	Adventure	1.35E+08	NA