# wk2 Cal assgnnnnnnn

IMPORTANT NOTE REGARDING WORD LIMIT REQUIREMENTS:

Please note that each and every assignment has its own word limit.

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.

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

General Requirements

You are required to cite at least FIVE sources to complete this assignment. Sources must be published within the last 5 years and appropriate for the discussion question criteria and public health content.

Prepare this assignment according to the guidelines found in the APA Style Guide. An abstract is not required.

While APA style is required, solid academic writing is expected as well, and documentation of sources should be presented using APA formatting guidelines.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

PLEASE make sure APA citation and permalink for articles are complete and correct.

PLEASE add the links/sites below to the reference list if you use any of these readings and make sure everything is in proper APA format.

https://apastyle.apa.org/learn/quick-guide-on-refe…

Read Chapters 4 and 5 in Using and Interpreting Statistics: A Practical Text for the Behavioral, Social, and Health Sciences.

URL:

http://www.gcumedia.com/digital-resources/macmillan-learning/2016/using-and-interpreting-statistics_a-practical-text-for-the-behavioral-social-and-health-sciences_ebook_3e.php

View “The Best Stats You’ve Ever Seen,” by Rosling (2006), located on the TED website.

URL:

https://www.ted.com/talks/hans_rosling_shows_the_best_stats_you_ve_ever_seen

View the following tutorials from the SPSS Tutorials media.

• Frequency Tables and Histograms
• Descriptive Statistics

URL:

http://lc.gcumedia.com/psy380/spss-tutorials/v1.1/

View the following terms in The Visual Learner: Statistics media.

• Confounding
• Histogram

View the following calculations in The Visual Learner: Statistics media.

• Frequency Distribution
• Measure of Center ‘Mean’
• Measure of Center ‘Median’
• Measure of Center ‘Mode’
• Range and Standard Deviation
• Variance

URL:

http://lc.gcumedia.com/hlt362v/the-visual-learner/the-visual-learner-v2.1.html

The “Sampling Distribution” simulation, located on the Rice Virtual Last in Statistics website, will be used for a discussion question in this topic.

URL:

http://onlinestatbook.com/stat_sim/sampling_dist/index.html

For assistance with using Excel software, use the “Excel Training: Create and Format PivotTables and Pivot Charts” video library, located on the Microsoft website.

URL: