Emphasis Heading 1 4. Find the mean and standard deviation of the DRIVE variable

Question

Emphasis Heading 1 4. Find the mean and standard deviation of the DRIVE variable by using AVERAGE(A2:A36) and STDEV(A2:A36). Assuming that this variable is normally distributed, what percentage of data would you predict would be less than 40 miles? This would be based on the calculated probability. Use the formula NORM.DIST(40, mean, stdex.IRUE). Now determine the percentage of data points in the dataset that fall within this range. To find the actual percentage in the dataset, sort the DRIVE variable and count how many of the data points are less than 40 out of the total 35 data points. That is the actual percentage. How does this compare with your prediction? (15 points) Mean Standard deviation Predicted percentage Actual percentage Comparison

Explanation / Answer

Mean = 51.2 miles
Standard deviation = 25.49948 miles

Predicted percentage = 33.0249%
Actual percentage = 40%

Comparison = Based on the given sample data, it can be observed that the actual percentage of data points lying outside the range, that is, below 40 is higher than the predicted percentage of data points lying below 40. The predicted percentage is under-estimating the actual percentage.

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.