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

Openupthe small Excel database that is linked below.

Week 4 Database

Don't use plagiarized sources. Get Your Custom Essay on
PH 520 West Coast University Week 4 Categorical and Continuous Variables Statistics Project
Just from \$13/Page

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
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
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

Pages (275 words)
Standard price: \$0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back

## Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
\$0.00
Team of Professionals. We’ve Got Your Back.