Share
Explore BrainMass

Hypothesis test analysis between all ages of the people

Part A - Ask 10 people from a particular group (coworkers, students, civic group, etc.) what ages they are. Get at least 3 from each sex (i.e. male/female). Conduct a hypothesis test analysis to determine if there is a statistical difference between the ages of the sexes in the group. Explain your results. Use alpha = .05. Use the "Hypothesis Test - Two Sample" spreadsheet. Use the INDEP tab.

Part B - Also ask those same people if they agree with something or if they do something. You can determine the question. For example, you may want to ask them if they eat popcorn when they go to the movies or if they support a political issue. It must be a yes/no question. Analyze if at least 58% support an issue or partake in an activity. Explain your results. Use alpha = .05. Use the "Hypothesis Test - One Sample" spreadsheet. Use the Hyp Test Prop" tab.
These spreadsheets will be really easy to use. You just enter the data in the yellow sections and read the output.

DATA

GROUP

Medical Student PART A

SEX AGE PART B

DO YOU SMOKE
Student #1 Male 34 No
Student #2 Male 33 No
Student #3 Female 25 No
Student #4 Female 27 No
Student #5 Female 24 No
Student #6 Male 30 Yes
Student #7 Female 26 No
Student #8 Male 28 Yes
Student #9 Male 31 Yes
Student #10 Female 29 Yes

Attachments

Solution Preview

See the attached files. Thanks.

Part A - Ask 10 people from a particular group (coworkers, students, civic group, etc.) what ages they are. Get at least 3 from each sex (i.e. male/female). Conduct a hypothesis test analysis to determine if there is a statistical difference between the ages of the sexes in the group. Explain your results. Use alpha = .05. Use the "Hypothesis Test - Two Sample" spreadsheet. Use the INDEP tab.

Part B - Also ask those same people if they agree with something or if they do something. You can determine the question. For example, you may want to ask them if they eat popcorn when they go to the movies or if they support a political issue. It must be a yes/no question. Analyze if at least 58% support an issue or partake in an activity. Explain your results. Use alpha = .05. Use the "Hypothesis Test - One Sample" spreadsheet. Use the Hyp Test Prop" tab.
These spreadsheets will be really easy to use. You just enter the data in the yellow sections and read the output.

DATA

GROUPMedical Student PART ASEX AGE PART BDO YOU SMOKE
Student #1 Male 34 No
Student #2 Male 33 No
Student ...

Solution Summary

Part A - Ask 10 people from a particular group (coworkers, students, civic group, etc.) what ages they are. Get at least 3 from each sex (i.e. male/female). Conduct a hypothesis test analysis to determine if there is a statistical difference between the ages of the sexes in the group. Explain your results. Use alpha = .05. Use the "Hypothesis Test - Two Sample" spreadsheet. Use the INDEP tab.

Part B - Also ask those same people if they agree with something or if they do something. You can determine the question. For example, you may want to ask them if they eat popcorn when they go to the movies or if they support a political issue. It must be a yes/no question. Analyze if at least 58% support an issue or partake in an activity. Explain your results. Use alpha = .05. Use the "Hypothesis Test - One Sample" spreadsheet. Use the Hyp Test Prop" tab.
These spreadsheets will be really easy to use. You just enter the data in the yellow sections and read the out

$2.19