Your Perfect Assignment is Just a Click Away
We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!

How It Works
Order Now
glass
pen
clip
papers
heaphones

PH 520 West Coast University Week 7 Statistics Worksheet

Oct 7, 2022 | Nursing

Oct 7, 2022 | Nursing

PH 520 West Coast University Week 7 Statistics Worksheet

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:
Calculate descriptive statistics for your main independent and other variables you have collected information on (example: demographic variables).

Create a bar chart for the participants’ gender and ethnicity.
Create a histogram for participants’ age.

Calculate descriptive statistics for your dependent variable.
Create a summary table of your descriptive statistics.

Hint: For categorical variables, you should be calculating frequencies and percentages; for continuous variables, you should be calculating means and standard deviations.

Use one hypothesis-testing statistic that examines the relationship between your independent variable and dependent variable.

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.
Write the null and alternate hypotheses.
What is the calculated statistic value?
What is the p and critical statistic value?
Is the p value significant? Is calculated statistic value greater than critical value?
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
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

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Nurse Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Nurse Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Nurse Papers is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Nurse Papers , we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.