Hello I'm trying to resolve this in excel. I chose the two surveys. I would like to know what is the next step or how I can get the hypothesis test values: sample mean null etc. What column I have to choose? I choose pets and compassion to animals. Thank you!

In 2013 students from a Statistics class at FSEV UK were asked to survey their friends who were 15-30 years old, in order to explore the interests of young people.

The survey has a variety of questions, which are detailed in the Survey Key. For example, the column header "Music" is short for the question "I enjoy listening to music" and is rated 1-5, where 1 represents strongly disagree and 5 represents strongly agree.

There is also some categorical data present as well. Survey participants record their gender, how often they smoke/drink, their internet usage, and education (just to name a few!). Please perform a hypothesis test based on one of the categorical variables and one survey question. For example, you could choose to prove the following: Survey participants who identify as an "only child" enjoy meeting new people (Survey score ).

Here is an example: people who are right-handed (as identified in the data set) enjoy listening to music. Please be sure to use two columns for your testone that identifies your participants and one that provides a rating.

Performing the Test

Step 1: Write the null hypothesis/alternative hypotheses below for the hypothesis test you would like to carry out based on the data. Determine the tail type. Also include your desired confidence level.

:

:

Step 2: Create a new tab and take the data you're interested in studying (so only two columns), so you have plenty of space to make calculations.

Step 3: Perform the hypothesis test. You'll need to do something similar to what you did in the other parts, with one major difference. Since you're performing a test on a sampling distribution, you'll need to use the T-Statistic.

Analysis of Results:

Provide a paragraph that describes your test. What were your null/alternative hypotheses? Were you able to reject the null hypothesis. What was the p-value associated with your test?

In terms of this sampling distribution, what population does it represent? All young people ages 15-30? Or some other population? Explain why.