PUB 550 GCU Confidence Intervals and Normal Distribution Questions The purpose of this assignment is to practice calculating confidence intervals. For thi

PUB 550 GCU Confidence Intervals and Normal Distribution Questions The purpose of this assignment is to practice calculating confidence intervals.

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.