Mathematics Homework Help

A Quick explanation and answer to these 5 questions, please

QUESTIONS:

1. Create a pivot table with rows that indicate where a student lives (on or off campus) and with columns that indicate whether a student owns a car (yes or no). In the cells of the table, give the count –the number of students–for each combination. Copy and paste your table into your problem set.

2. Based on the information in your table:

a. What is the sample size of the data set, overall?

b. What proportion of students in the sample own cars?

c. Create a 95 percent confidence interval for the proportion of students in the undergraduate population who own cars.

d. Interpret the confidence interval in a sentence: what does it tell you?

3. Again, use the information in your pivot table to answer the following questions:

a. How many students in the sample live off campus?

b. What proportion of off-campus students own cars?

c. How many students in the sample live on campus?

d. What proportion of on-campus students own cars?

e. Create a 95% confidence interval for the difference between the proportion of off-campus students who own cars and the proportion of on-campus students who own cars.

f. Interpret the confidence interval in a sentence: what does it tell you?

4. This questions looks at the number of students living together on and off campus.

a. Create a pivot table that shows the average number of students living together for off-campus and for on-campus students. Let the rows of the table indicate whether a student lives on or off campus, and the cells, the average number living together for each group. Include a copy of the table in your problem set.

b.Create a pivot table that shows the sample standard deviation of the number of students living together for off-campus and for on-campus students. Let the rows of the table indicate whether a student lives on or off campus, and the cells, the sample standard deviation of the number living together for each group. Include a copy of the table in your problem set.

5. Use the pivot tables created in problems #1 and #4 to answer the following questions:

a. How many students in the sample live off campus?

b. What are the mean and standard deviation of the variable “number living together” for off-campus students?

c. How many students live on campus?

d. What are the mean and standard deviation of the variable “number living together” for on-campus students?

e. Create a 95% confidence interval for the difference between the average number living together for off-campus students and the average number living together for on-campus students.

f. Interpret the interval from part e in a sentence: what does it show? Do the results provide evidence of a difference between off and on campus students in the number living together?