This is the link to data for part 1 and now it's part 2http://wiki.stat.ucla.edu/socr/index.php/SOCR_Data_Dinov_020108_HeightsWeights

TASKS FOR PART II:
Chi-Square Goodness-of-fit Test:
Set I Dataset:
Dataset Link: http://wiki.stat.ucla.edu/socr/index.php/SOCR_Data_Dinov_020108_HeightsWeights
Null and Alternative Hypothesis:
The appropriate null and alternative hypothesis here is,
Histogram chart of the data:
Cell References in Excel:
1. In F column, the classes are mentioned. (F2: F6).
2. In G column, the observed frequencies are calculated. (G2:G6)
3. In H column, the class probabilities are calculated. (H2:H6)
4. In I column, the expected frequencies are calculated. (I2:I6)
5. In J column, the class components are calculated. (J2:J6)
6. From F7 to J7, total is calculated.
7. In F9 cell, mean is calculated using the formula “=AVERAGE(B2:B201)”.
8. In F10 cell, standard deviation is calculated using the formula “=STDEV.S(B2:B201)”.
9. In I9 degrees of freedom is calculated and in I10 p-value is calculated.
Necessary Formulas in Excel:
1. Observed Frequency:
For the first class, use the formula “=COUNTIFS(B2:B201,">=62.50",B2:B201,"<65")”.
…. For the last class, use the formula “=COUNTIFS(B2:B201,">=72.50")”.
2. Class probability:
For the first class, use the formula “=NORM.DIST(65,F9,F10,TRUE)-NORM.DIST(62.5,F9,F10,TRUE)”.
…..For the last class, use the formula “=1-NORM.DIST(72.5,F9,F10,TRUE)”.
3. Expected Frequency:
For the first class, use the formula “=ROUND($G$7*H2,1)”…...
For the last class, use the formula “=ROUND($G$7*H6,1)”.
4. Class component:
For the first class, use the formula “=((G2-I2)*(G2-I2))/I2”…..
For the last class, use the formula “=((G6-I6)*(G6-I6))/I6”.
5.Total:
Total row is calculated using the SUM function and the sum is taken over all previous rows of the...