PH 520 West Coast University Week 7 Statistics Worksheet

User Generated

rzryqn2016

Health Medical

PH 520

West Coast University

PH

Description

By this week, you should have completed data collection on at least 30 participants who met the qualifications to complete the survey (e.g., at least 18 years or older, have other specific characteristics that make them a member of the population you intended to study).

The data for your short survey should be entered into the Excel database that you created last week. With this data set, complete the following:

  1. Calculate descriptive statistics for your main independent and other variables you have collected information on (example: demographic variables).
    1. Create a bar chart for the participants’ gender and ethnicity.
    2. Create a histogram for participants’ age.
  2. Calculate descriptive statistics for your dependent variable.
  3. Create a summary table of your descriptive statistics.
    1. Hint: For categorical variables, you should be calculating frequencies and percentages; for continuous variables, you should be calculating means and standard deviations.
  4. Use one hypothesis-testing statistic that examines the relationship between your independent variable and dependent variable.
    1. Hint: This test should be one of the following—independent samples t-test, paired t-test, one-way ANOVA, or Pearson’s chi-squared test.
    2. Write the null and alternate hypotheses.
    3. What is the calculated statistic value?
    4. What is the p and critical statistic value?
    5. Is the p value significant? Is calculated statistic value greater than critical value?
    6. What is your conclusion?

Want to see an example of a summary table? Click here: Summary Table

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

Due: Sunday, 11:59 p.m. (Pacific time)
Points: 150

Unformatted Attachment Preview

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 Number of Meds 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 1.00 0.00 3.00 5.00 0.00 3.00 1.00 10.00 7.00 4.00 3.00 2.00 0.00 0.00 0.00 4.00 0.00 6.00 0.00 2.00 8.00 1.00 7.00 4.00 1.00 3.00 0.00 0.00 0.00 1.00 0.00 5.00 1.00 0.00 5.00 3.00 4.00 18.00 9.00 3.00 4.00 0.00 5.00 6.00 0.00 1.00 Fracture 1.00 1.00 1.00 1.00 1.00 1.00 1.00 2.00 2.00 2.00 1.00 2.00 1.00 1.00 1.00 2.00 1.00 1.00 1.00 1.00 2.00 1.00 2.00 2.00 2.00 2.00 2.00 1.00 1.00 2.00 1.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 1.00 1.00 2.00 1.00 1.00 2.00 Ability 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 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 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 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.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 2 3 1 1 3 1 1 2 2 2 1 2 2 1 1 1 3 2 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 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 Variable Age Language Fracture Number of Meds Ability Smoke status Type Continuous Categorical Categorical Continuous Categorical Categorical Descriptive statistics (Quantitative data): Statistic No. of observations Mean Standard deviation (n-1) Age Number of Meds 66 74.73 6.36 66 3.27 3.55 66 2 English 29.000 43.94% Spanish 37 56.06% Descriptive statistics (Qualitative data): Statistic No. of observations No. of categories Category Frequency per category Rel. frequency per category (%) Language Fracture 66 2 No 55 83.33% Ability Yes 11 16.67% 66 3 can docan do with some difficulty 38 15.000 57.58% 22.73% Smoke status cannot do without help 13.000 19.70% 66 2 non-smoker 42 63.64% smoker 24 36.36% English Spanish 74 73 77 72 66 76 72 71 66 67 79 71 78 67 67 88 82 86 76 67 68 70 63 87 75 71 84 68 63 77 75 79 71 66 84 79 86 81 72 77 73 81 75 73 78 81 83 71 72 66 72 73 71 74 70 71 79 71 79 81 84 75 89 79 69 71 Z Test of Hypothesis for the Proportion Data Null Hypothesis p= Level of Significance Number of Items of Interest Sample Size 0.5 0.05 29 66 Intermediate Calculations Sample Proportion 0.439393939 Standard Error 0.0615 Z Test Statistic -0.9847 Upper-Tail Test Upper Critical Value 1.6449 p -Value 0.8376 Do not reject the null hypothesis English Spanish 74.00 77.00 73.00 75.00 77.00 79.00 72.00 71.00 66.00 66.00 76.00 84.00 72.00 79.00 71.00 86.00 66.00 81.00 67.00 72.00 79.00 77.00 71.00 73.00 78.00 81.00 67.00 75.00 67.00 73.00 88.00 78.00 82.00 81.00 86.00 83.00 76.00 71.00 67.00 72.00 68.00 66.00 70.00 72.00 63.00 73.00 87.00 71.00 75.00 74.00 71.00 70.00 84.00 71.00 68.00 79.00 63.00 71.00 79.00 81.00 84.00 75.00 89.00 79.00 69.00 71.00 Pooled-Variance t Test for the Difference Between Two Means (assumes equal population variances) Data Hypothesized Difference 0 Level of Significance 0.05 Engligh Speaking Sample Size 29 Sample Mean 73.241 Sample Standard Deviation 7.084 Spanish Speaking Sample Size 37 Sample Mean 75.89 Sample Standard Deviation 5.56 Intermediate Calculations Population 1 Sample Degrees of Freedom Population 2 Sample Degrees of Freedom Total Degrees of Freedom Pooled Variance Standard Error Difference in Sample Means t Test Statistic Two-Tail Test Lower Critical Value Upper Critical Value p -Value Do not reject the null hypothesis 28 36 64 39.3575 1.5559 -2.6505 -1.7035 -1.9977 1.9977 0.0933 English Data Sample Standard Deviation Sample Mean Sample Size Confidence Level Intermediate Calculations Standard Error of the Mean Degrees of Freedom t Value Interval Half Width Confidence Interval Interval Lower Limit Interval Upper Limit Spanish 7.084 73.241 29 95% 1.31547 28 2.0484 2.6946 70.55 75.94 Data Sample Standard Deviation Sample Mean Sample Size Confidence Level 5.56 75.89 37 95% Intermediate Calculations Standard Error of the Mean 0.914 Degrees of Freedom 36 t Value 2.0281 Interval Half Width 1.8544 Confidence Interval Interval Lower Limit Interval Upper Limit 74.04 77.75 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
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Please find attached the complete work. Kindly ask in case of any confusion

ID
MR-32
SJ-08
AG-45
DH-33
EK-34
KS-20
EG-24
FP-04
GC-05
LC-06
MG-30
RR-27
YL-68
MP-48
SIC-62
CR-03
DC-09
EM-51
KL-57
OY-65
RO-53
SJ-43
SKC-61
YYK-38
AG-25
BS-52
HL-55
KP-64
ML-41
AD-29
JC-39
JMC-56
MW-67
AA-31
SHC-58
CK-42
JK-36
RG-26
YJK-37
AM-01
JJ-49
AF-02
CC-63
IH-54
FA-50
KC-59

Age
63.00
63.00
66.00
66.00
66.00
66.00
67.00
67.00
67.00
67.00
68.00
68.00
69.00
70.00
70.00
71.00
71.00
71.00
71.00
71.00
71.00
71.00
71.00
71.00
72.00
72.00
72.00
72.00
72.00
73.00
73.00
73.00
73.00
74.00
74.00
75.00
75.00
75.00
75.00
76.00
76.00
77.00
77.00
77.00
78.00
78.00

Language Fracture Number of Meds
Ability
1.00
0
0.00
1.00
0
5.00
1.00
0
0.00
1.00
0
0.00
2.00
0
4.00
2.00
0
3.00
1.00
0
0.00
1.00
0
0.00
1.00
1
2.00
1.00
0
4.00
1.00
0
0.00
1.00
0
0.00
2.00
0
0.00
1.00
0
6.00
2.00
0
4.00
1.00
0
3.00
2.00
0
2.00
1.00
0
0.00
2.00
0
18.00
2.00
0
0.00
1.00
0
1.00
2.00
0
4.00
2.00
0
6.00
2.00
0
4.00
1.00
0
5.00
1.00
0
1.00
2.00
0
3.00
2.00
1
9.00
2.00
0
5.00
1.00
0
0.00
2.00
0
1.00
2.00
0
0.00
2.00
0
1.00
1.00
0
1.00
2.00
0
14.00
2.00
1
7.00
2.00
0
1.00
1.00
0
5.00
2.00
0
7.00
1.00
0
3.00
1.00
0
0.00
1.00
0
3.00
2.00
0
10.00
2.00
1
0.00
1.00
1
6.00
2.00
1
5.00

Smoke status
1
2
1
1
1
2
1
1
1
1
1
1
1
1
2
2
2
1
2
2
1
2
2
1
1
1
1
3
1
1
2
1
1
1
1
3
1
1
1
1
1
2
2
1
1
2

1
2
1
1
1
2
1
1
1
1
1
1
1
1
2
2
2
1
2
2
1
2
2
1
1
1
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
2
2
1
1
2

CN-18
EG-46
HC-10
SK-15
SWK-66
YK-60
HL-17
JK-13
KK-14
TP-19
JB-47
KK-35
GK-11
RP-28
WC-40
HK-12
JC-22
RG-07
GV-23
YK-16

79.00
79.00
79.00
79.00
79.00
79.00
81.00
81.00
81.00
81.00
82.00
83.00
84.00
84.00
84.00
86.00
86.00
87.00
88.00
89.00

2.00
1.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
1.00
2.00
2.00
1.00
2.00
2.00
1.00
1.00
1.00
2.00

1
0
0
0
0
1...


Anonymous
Awesome! Perfect study aid.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags