PUB 550 GCU Calculating Confidence Intervals Excel & SPSS Statistics Report For this assignment, students will utilize Excel and SPSS Statistics and the “E

PUB 550 GCU Calculating Confidence Intervals Excel & SPSS Statistics Report For this assignment, students will utilize Excel and SPSS Statistics and the “Example Dataset.”

Using the “Example Dataset,” complete the following:

Based on a normal distribution curve, calculate the probability of an individual being 60 years or older in this population. Show the Excel and SPSS formulas or your hand calculations. Include screenshots as needed to illustrate this.
Using the sample standard deviation of age as an estimate of the population standard deviation, calculate by hand the standard error of the mean. Show your calculations and the answer.
Calculate by hand a 95% confidence interval for “Age” based on the sample mean. Use SPSS to verify your answer. Include your calculations and screenshots of the SPSS output.
Interpret the confidence interval for age and explain the three pieces of information needed to calculate a confidence interval.

Submit one Word document that includes all of the assignment deliverables.

APA style is not required, but solid academic writing is expected.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. A local community organization was interested in learning about general health behaviors in the area and the
relationships between health behaviors and environmental and social determinants. They decided to conduct a
brief survey based on a convenient sample of people visiting the local shopping mall. They offered a $5 incentive
for completing the survey. The Topic 1 Example dataset includes 30 observations from this survey. Use this data to
complete the relevant assignments in this course.
Education Level
1
2
3
Less than High School
Graduated High School
Graduated College
Annual Income = US Dollars
ehaviors in the area and the
ts. They decided to conduct a
all. They offered a $5 incentive
from this survey. Use this data to
ID
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
Sex
Female
Male
Female
Male
Female
Female
Female
Male
Female
Male
Female
Male
Female
Male
Male
Male
Female
Male
Male
Female
Female
Female
Male
Male
Female
Male
Female
Female
Male
Male
Smoker
No
No
Yes
No
Yes
Yes
No
Yes
Yes
No
No
No
Yes
No
No
No
No
Yes
Yes
No
Yes
No
No
No
No
Yes
Yes
No
No
Yes
Education_Level***
2
2
3
1
1
2
3
1
2
2
3
1
1
3
2
1
2
3
2
1
2
3
2
1
1
3
3
1
3
3
Minutes_Exercise
90
50
65
20
50
25
110
50
40
80
120
80
60
150
75
80
110
80
100
0
50
200
60
65
40
65
70
45
75
50
Age
45
58
31
54
30
18
39
37
44
24
42
50
20
35
61
59
36
35
29
32
26
42
52
49
21
48
40
53
46
42
Employed
Yes
No
Yes
No
Yes
No
Yes
Yes
Yes
No
Yes
Yes
No
Yes
Yes
No
Yes
Yes
No
No
No
Yes
No
No
No
Yes
Yes
No
Yes
Yes
Annual_Income*Neighborhood
51000
B
23000
C
35000
B
10000
C
28000
B
5000
C
46000
A
36000
B
51000
C
12000
A
78000
A
34000
D
15000
B
28000
B
28000
A
24000
B
55000
D
62000
B
32000
D
7000
C
17000
B
64000
D
5000
A
14000
D
20000
C
72000
A
85000
A
15000
B
64000
C
27000
B
Course Code
PUB-550
Class Code
PUB-550-O500
Criteria
Content
Percentage
100.0%
Question 1
15.0%
Question 2
15.0%
Question 3
15.0%
Question 4
15.0%
Question 5
35.0%
Mechanics of Writing (includes spelling,
punctuation, grammar, language use)
5.0%
Total Weightage
100%
Assignment Title
Calculating Confidence Intervals
Unsatisfactory (0.00%)
Calculation of probability of an individual being 60 years or
older, including associated hand calculations and screenshots,
is not included.
Mean and standard deviation for Age and associated Excel
output table are not included.
Hand calculations for the standard error of the mean are not
included.
Hand calculations for a 95% confidence interval for Age and
SPSS output screenshots verifying the answer are not
included.
Interpretation of the confidence interval for age, explanation
of the three pieces of information needed to calculate the
confidence interval, and discussion of the age cut-off are not
included.
Surface errors are pervasive enough that they impede
communication of meaning. Inappropriate word choice or
sentence construction is used.
Total Points
70.0
Less than Satisfactory (74.00%)
Calculation of probability of an individual being 60 years or
older, including associated hand calculations and screenshots,
is incomplete or incorrect.
Mean and standard deviation for Age and associated Excel
output table are incomplete or incorrect.
Hand calculations for the standard error of the mean are
incomplete or incorrect.
Hand calculations for a 95% confidence interval for Age and
SPSS output screenshots verifying the answer are incomplete
or incorrect.
Interpretation of the confidence interval for age, explanation
of the three pieces of information needed to calculate the
confidence interval, and discussion of the age cut-off are
incomplete or incorrect.
Frequent and repetitive mechanical errors distract the
reader. Inconsistencies in language choice (register) or word
choice are present. Sentence structure is correct but not
varied.
Satisfactory (79.00%)
Calculation of probability of an individual being 60 years or
older, including associated hand calculations and screenshots,
is partially complete and correct.
Mean and standard deviation for Age and associated Excel
output table are partially complete and correct.
Hand calculations for the standard error of the mean are
partially complete and correct.
Hand calculations for a 95% confidence interval for Age and
SPSS output screenshots verifying the answer are partially
complete and correct.
Interpretation of the confidence interval for age, explanation
of the three pieces of information needed to calculate the
confidence interval, and discussion of the age cut-off are
included but lack details and supporting information.
Some mechanical errors or typos are present, but they are
not overly distracting to the reader. Correct and varied
sentence structure and audience-appropriate language are
employed.
Good (87.00%)
Calculation of probability of an individual being 60 years or
older, including associated hand calculations and screenshots,
is mostly complete and correct.
Mean and standard deviation for Age and associated Excel
output table are mostly complete and correct.
Hand calculations for the standard error of the mean are
mostly complete and correct.
Hand calculations for a 95% confidence interval for Age and
SPSS output screenshots verifying the answer are mostly
complete and correct.
Interpretation of the confidence interval for age, explanation
of the three pieces of information needed to calculate the
confidence interval, and discussion of the age cut-off are
complete and include details and supporting information.
Prose is largely free of mechanical errors, although a few may
be present. The writer uses a variety of effective sentence
structures and figures of speech.
Excellent (100.00%)
Calculation of probability of an individual being 60 years or
older, including associated hand calculations and screenshots,
is complete and correct.
Mean and standard deviation for Age and associated Excel
output table are complete and correct.
Hand calculations for the standard error of the mean are
complete and correct.
Hand calculations for a 95% confidence interval for Age and
SPSS output screenshots verifying the answer are complete
and correct.
Interpretation of the confidence interval for age, explanation
of the three pieces of information needed to calculate the
confidence interval, and discussion of the age cut-off are
extremely thorough with substantial details and supporting
information.
Writer is clearly in command of standard, written, academic
English.
Comments
Points Earned

Purchase answer to see full
attachment