PH 520 West Coast University Week 4 Categorical and Continuous Variables Statistics Project

Open up the small Excel database that is linked below.

Click for more options

Week 4 Database

Click for more options

With this database, you will:

  1. Identify and list categorical and continuous variables.
  2. Calculate frequencies and percentages for all of the categorical variables, and means, and standard deviations for the continuous variables.
  3. Run a one-sample z test of proportions for one categorical variable. Here is an example in terms of wording: “Is the proportion of English speaking patients greater than 50%?” Using .05 level of significant test the appropriate hypotheses.
    1. Write the null and alternate hypotheses
    2. What is the proportion of English speaking patients
    3. What is the standard error and z statistics
    4. Find critical z and p value. Is the p value significant? Conclusion?
  4. Run an independent samples t-test to compare two groups of people (specified by a dichotomous variable) on one continuous variable. Using .05 level of significant test the appropriate hypotheses. In order to run this test statistics you have to re-arrange your data.
    1. Write the null and alternate hypotheses.
    2. What is the calculated mean for each group?
    3. What is the confidence interval for each group?
    4. What is the critical t value?
    5. Is the p value significant? Conclusion?

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

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Order Over WhatsApp Place an Order Online

Do you have an upcoming essay or assignment due?

All of our assignments are originally produced, unique, and free of plagiarism.

If yes Order Similar Paper