Reference no: EM131980113
Person Gender Number of Vechicles Amount Spent on Gas Make of Car Agree/Disagree on red light cameras
1 Male 5 20 Toyota Strongly Agree
2 Female 2 25 Ford Disagree
3 Male 2 32 Honda Agree
4 Male 4 25 Chevy Agree
5 Female 2 22 Subaru Strongly Disagree
6 Male 1 36 BMW Strongly Agree
7 Female 3 25 Saturn Agree
8 Female 5 40 Jeep Agree
9 Female 2 20 Ford Agree
10 Male 4 32 Toyota Agree
11 Male 3 35 Toyota No Opinion
12 Male 2 25 Chevy Strongly Disagree
13 Male 5 45 Ford Agree
14 Female 4 32 Ford Agree
15 Male 2 26 Subaru Agree
16 Female 3 25 Toyota Agree
17 Female 5 22 Jeep Disagree
18 Male 4 25 Ford No Opinion
19 Female 2 30 Chevy Agree
20 Female 3 35 Volkswagen Agree
21 Female 2 28 Ford Agree
22 Male 2 20 Honda Agree
23 Male 3 36 Honda Strongly Agree
24 Female 2 21 Nissan Agree
25 Female 5 25 Toyota Agree
26 Female 2 35 Hyundai Agree
27 Male 3 25 Jeep Disagree
28 Male 2 32 Ford Strongly Disagree
29 Male 4 40 Ford Agree
30 Male 2 36 Honda Agree
31 Male 5 28 Chevy Agree
32 Female 2 20 Hyundai Disagree
33 Female 3 30 Volkswagen No Opinion
34 Male 5 30 Jeep Agree
35 Female 5 25 Ford Agree
Make frequency distributions for each question. (Remember frequency distributions are frequency tables). Follow the rules for creating a grouped frequency distribution. You will have 3 frequency distributions. Place them on your Excel Spreadsheet. Also make a contingency table on the opinion question using the answers and gender.