Purpose
The purpose of this project is to assess your ability to:
Collect and display data.
Use Excel.
- Calculate and interpret expected value.
- Calculate the mean, media, and mode of data sets.
- Determine whether data sets are normally distributed.
- Apply the Central Limit Theorem.
- Summarize and report findings.
- Overview
- This module you will turn in the third part of Project 2. This project consists of three parts.
Project 2-1: Identify the Distribution of a Sample – due in Module 9
Project 2-2: Find A Sampling Distribution of Sample Means – due in Module 10
Project 2-3: Final Submission – due in Module 11
- Data that follows a normal distribution pattern is predictable and can be used to draw conclusions. However, many data sets do not follow a normal distribution pattern, and a small sample may not follow the normal distribution even if it comes from a normally distributed population. The Central Limit Theorem tells us that the distribution of sample means will not only be normally distributed, but also, if we have enough samples, the sampling distribution will have a mean that is approximately the same as ?, and a standard deviation that is close to ??.
- To see this, let’s continue the experiment using sets of randomly generated integers.
- Action Items
Open your saved Excel file as submitted for Part 2.
Review your gradebook feedback and make any required corrections to Parts 1 or 2.
Complete the tab labeled “Part 3 – Calculate” by using Excel formulas to do the following:
Calculate the mean and standard deviation for each of the 4 data sets from Parts 1 and 2.
Calculate the expected standard deviation of the sampling distribution of the sample means.
Note, you may either calculate these directly on this tab using cell references, or calculate these using formulas on your original sheets and copy/paste the values into the designated area of the calculation sheet.
Explain how your graphs tables and calculations of the mean and standard deviations relate to the Central Limit Theorem.
View the Project 2 Final Report Example.Download Project 2 Final Report Example.
Download and complete the Probability Project 2-3 – Final Report.Download Probability Project 2-3 – Final Report.
Submit the completed first draft of your assignment. Your work will automatically be checked by Turnitin.
Access your Turnitin report by reviewing your Submission Details for this assignment. Revise your work as needed based on the feedback.