I am working on a lab report for Engineering Statistics, and we are to do a statistical analysis on data that we pulled. I have attached my data in addition to the portion of the report that I need help with. I am suppose to use the chi-square goodness-of-fit test which can be done in excel, but I am not exactly sure how to best do that.

Task:

Chi-Square Goodness-of-Fit Test: use the data you collected/selected in Part I, and perform Goodness of Fit test to verify if your sample data follow a specific assumed distribution, such as normal distribution, exponential distribution, gamma distribution, etc. Using a Chi-Square Goodness of Fit Test with a significance level of 0.05, test the hypothesis that if the data samples follow the assumed distribution. For the hypothesis test, start with the data classes from your histogram and merge them to ensure each class has a sufficient number of observations. Then, for each data class, calculate the following: ? Numbers of observations in the data. ? Class probability. ? Class expected value. ? Chi-square component values. Finally, for each test, calculate the chi-square value, describe the degrees of freedom, and explain your conclusion.

EXAMPLE SETUP Class Observed Class Expected Class Frequency Probability (of) Frequency (ei) Component XS2 Count Calculate using For each class, 2 12 collected data. distribution. multiply by n. Total n 1.0 n statisticPetal Length of Iris Flowers (3) Iris-setosa Iris-versicolor |Iris-virginica 1.4 4.7 6 1.4 4.5 5.1 1.3 4.3 5.9 1.5 4 5.6 1.4 4.6 5.8 1.7 4.5 6.6 1.4 4.7 4.5 1.5 3.3 6.3 1.4 4.6 5.8 1.5 3.9 6.1 1.5 3.5 5.1 1.6 4.2 5.3 1.4 4 5.5 1.1 4.7 5 1.2 3.6 5.1 1.5 4.4 5.3 1.3 4.5 5.5 1.4 4.1 6.7 1.7 4.5 6.9 1.5 3.9 5 1.7 4.8 5.7 1.5 4 4.9 1 4.9 6.7 1.7 4.7 4.9 1.9 4.3 5.7 1.6 4.4 6 1.6 4.8 4.8 1.5 5 4.9 1.4 4.5 5.6 1.6 3.5 5.8 1.6 3.8 6.1 1.5 3.7 6.4 1.5 3.9 5.6 1.4 5.1 5.1 1.5 4.5 5.6 1.2 4.5 6.1 1.3 4.7 5.6 1.4 4.4 5.5 1.3 4.1 4.8 1.5 4 5.4 1.3 4.4 5.6 1.3 4.6 5.1 1.3 4 5.1 1. 6 3.3 5.9 1.9 4.2 5.7 1.4 4.2 5.2 1.6 4.2 5 1.4 4.3 5.2 1.5 3 5.4 1.4 4.1 5.1