Find central tendencies and measures of positions of the raw data using Excel. Specifically: a.) Find the mean, standard deviation of sample, variance of sample and mode of each quantitative data set. b.) Find the five number summary of the continuous quantitative data set only.
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