week 4 stastics

Open up the small Excel database that is linked below.

Week 4 Database

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.