Find central tendencies and measures of positions of the


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

Solution Preview :

Prepared by a verified Expert
Basic Statistics: Find central tendencies and measures of positions of the
Reference No:- TGS02776373

Now Priced at $20 (50% Discount)

Recommended (91%)

Rated (4.3/5)