PH 520 West Coast University Week 7 Statistics Worksheet

By this week, you should have completed data collection on at least 30 participants who met the qualifications to complete the survey (e.g., at least 18 years or older, have other specific characteristics that make them a member of the population you intended to study).

The data for your short survey should be entered into the Excel database that you created last week. With this data set, complete the following:

  1. Calculate descriptive statistics for your main independent and other variables you have collected information on (example: demographic variables).
    1. Create a bar chart for the participants’ gender and ethnicity.
    2. Create a histogram for participants’ age.
  2. Calculate descriptive statistics for your dependent variable.
  3. Create a summary table of your descriptive statistics.
    1. Hint: For categorical variables, you should be calculating frequencies and percentages; for continuous variables, you should be calculating means and standard deviations.
  4. Use one hypothesis-testing statistic that examines the relationship between your independent variable and dependent variable.
    1. Hint: This test should be one of the following—independent samples t-test, paired t-test, one-way ANOVA, or Pearson’s chi-squared test.
    2. Write the null and alternate hypotheses.
    3. What is the calculated statistic value?
    4. What is the p and critical statistic value?
    5. Is the p value significant? Is calculated statistic value greater than critical value?
    6. What is your conclusion?

Want to see an example of a summary table? Click here: Summary Table

Need Excel help? Click on the Excel Function Help Workbook under Course Materials.

Due: Sunday, 11:59 p.m. (Pacific time)
Points: 150