View the step-by-step solution to:

# WITH EXCEL FUNCTIONS Find confidence intervals for M using Excel. You found x-bar for each quantitative data set, so find the 92% confidence...

WITH EXCEL FUNCTIONS

Find confidence intervals for M using Excel. You found x-bar for each quantitative data set, so find the 92% confidence intervals about the mean. Use the instructions of previous Excel Assignments to find the confidence intervals. You found the percentages of each category choose one category and find the 96% confidence interval for the true proportion (here you can use the calculator and place answer on excel).

Person Gender Number of Vehicles Amount Spent on Gas Make of Car Agree/Disagree on red light cameras

1 Male 1 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 4 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 4 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 2 30 Jeep Agree

35 Female 1 25 Ford Agree

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents