Week 4 stastics

I don’t know how to handle this Health & Medical question and need guidance.

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.

Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount