MENU

Fun & Interesting

Normal distribution data using Excel (pdf, continuity correction, normal approximation, graph)

Maths.tutor 4u 2,613 5 months ago
Video Not Working? Fix It Now

In Excel using data analysis, a random data set for normal distribution is generated for n = 1500, mean = 15, and S.D. = 4. Using descriptive statistics, selected bin size and bins required to create frequency, and empirical rule used to construct a probability distribution table using the histogram function of data analysis. The normal approximation is done using continuity correction, and at the end, visualization of the data set is done with a graph to analyze the data.

Comment