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

Openupthe small Excel database that is linked below.

Week 4 Database

With this database, you will:

Identify and list categorical and continuous variables.

Calculate frequencies and percentages for all of the categorical variables, and means, and standard deviations for the continuous variables.

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.Write the null and alternate hypothesesWhat is the proportion of English speaking patientsWhat is the standard error and z statistics Find critical z and p value. Is the p value significant? Conclusion?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.Write the null and alternate hypotheses.What is the calculated mean for each group? What is the confidence interval for each group?What is the critical t value?Is the p value significant? Conclusion?

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

ID
AA-31
AD-29
AF-02
AG-25
AG-45
AM-01
BS-52
CC-63
CK-42
CN-18
CR-03
DC-09
DH-33
EG-24
EG-46
EK-34
EM-51
FA-50
FP-04
GC-05
GK-11
GV-23
HC-10
HK-12
HL-17
HL-55
IH-54
JB-47
JC-22
JC-39
JJ-49
JK-13
JK-36
JMC-56
KC-59
KK-14
KK-35
KL-57
KP-64
KS-20
LC-06
MG-30
ML-41
MP-48
MR-32
MW-67
Age
74.00
73.00
77.00
72.00
66.00
76.00
72.00
77.00
75.00
79.00
71.00
71.00
66.00
67.00
79.00
66.00
71.00
78.00
67.00
67.00
84.00
88.00
79.00
86.00
81.00
72.00
77.00
82.00
86.00
73.00
76.00
81.00
75.00
73.00
78.00
81.00
83.00
71.00
72.00
66.00
67.00
68.00
72.00
70.00
63.00
73.00
Language Fracture Number of Meds Ability
1.00
0
1.00
1.00
0
0.00
1.00
0
3.00
1.00
0
5.00
1.00
0
0.00
1.00
0
3.00
1.00
0
1.00
2.00
0
10.00
2.00
1
7.00
2.00
1
4.00
1.00
0
3.00
2.00
0
2.00
1.00
0
0.00
1.00
0
0.00
1.00
0
0.00
2.00
0
4.00
1.00
0
0.00
1.00
1
6.00
1.00
0
0.00
1.00
1
2.00
2.00
0
8.00
1.00
0
1.00
2.00
0
7.00
2.00
0
4.00
2.00
0
1.00
2.00
0
3.00
2.00
1
0.00
1.00
0
0.00
1.00
0
0.00
2.00
0
1.00
1.00
0
0.00
2.00
0
5.00
2.00
0
1.00
2.00
0
0.00
2.00
1
5.00
2.00
0
3.00
2.00
0
4.00
2.00
0
18.00
2.00
1
9.00
2.00
0
3.00
1.00
0
4.00
1.00
0
0.00
2.00
0
5.00
1.00
0
6.00
1.00
0
0.00
2.00
0
1.00
1
1
2
1
1
1
1
2
3
1
2
2
1
1
1
1
1
1
1
1
3
3
1
1
3
1
1
3
3
2
1
3
1
1
2
3
3
2
3
2
1
1
1
1
1
1
Smoke status
1
1
2
1
1
1
1
2
1
1
2
2
1
1
1
1
1
1
1
1
2
2
1
1
2
1
1
2
2
2
1
2
1
1
2
1
1
2
1
2
1
1
1
1
1
1
OY-65
RG-07
RG-26
RO-53
RP-28
RR-27
SHC-58
SIC-62
SJ-08
SJ-43
SK-15
SKC-61
SWK-66
TP-19
WC-40
YJK-37
YK-16
YK-60
YL-68
YYK-38
71.00
87.00
75.00
71.00
84.00
68.00
74.00
70.00
63.00
71.00
79.00
71.00
79.00
81.00
84.00
75.00
89.00
79.00
69.00
71.00
2.00
1.00
1.00
1.00
1.00
1.00
2.00
2.00
1.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
0
0
0
0
1
0
0
0
0
0
0
0
0
1
1
0
0
1
0
0
0.00
0.00
5.00
1.00
0.00
0.00
14.00
4.00
5.00
4.00
6.00
6.00
9.00
3.00
5.00
7.00
3.00
0.00
0.00
4.00
2
3
1
1
3
1
1
2
2
2
1
2
2
1
1
1
3
2
1
1
2
2
1
1
2
1
1
2
2
2
1
2
2
1
1
1
2
2
1
1
Name
ID
Age
Language
Fracture
Number of Meds
Ability
Smoke status
Description
Participant ID number
Age in years
Preferred language
Fractured hip, leg, arm, or spine
Number of medications used regularly
Ability to take care of own personal needs
Past Smoke history
Answers
Actual age
1= English 2= Spanish
0= No, 1= Yes
Total number of meds
1= can do, 2= can do with some difficulty, 3= can not do without help
1= nonsmoker 2=smoker