Question: STAT2000-24W-24106 Nadia B. Assignment Title: Exploring the Normal Distribution with Excel Objective: To understand and apply the concepts of the normal distribution using Microsoft Excel.
STAT2000-24W-24106 Nadia B. Assignment Title: Exploring the Normal Distribution with Excel Objective: To understand and apply the concepts of the normal distribution using Microsoft Excel. Instructions: 1 Data Collection: Collect data from at least 40 students in your college on their heights (in inches). Ensure that the data is accurate and representative of the population. 2 Data Analysis: Enter the collected heights into a new Excel spreadsheet. Calculate the mean and standard deviation of the heights using Excel functions. Create a histogram of the heights using Excel's built-in histogram tool. 3 Normal Distribution: Based on the mean and standard deviation calculated earlier, use Excel functions to calculate the probability density function (PDF) of the normal distribution for heights. Plot the normal distribution curve on the histogram to visualize how well the heights follow a normal distribution. Calculate the probability of a randomly selected student being taller than 70 inches and shorter than 65 inches using Excel functions for the normal distribution. 4 Discussion: Write a brief report (200-300 words) discussing your findings. Include interpretations of the mean, standard deviation, shape of the distribution, and the probabilities calculated. Reflect on any limitations of your analysis and suggest improvements for future studies
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
