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.

свернуть