The Chi-Square goodness of fit test to test whether thenormality assumption is true for column 1 is performed in followingsteps in excel.Step 1: Write the data value in excel. The screenshot is shownbelow,AStep 2: The mean and standard deviation for the data values areobtained using the excel functions =AVERAGE() and STDEV(). Thescreenshot is shown below,Step 3: The Z score for each data values are obtained using theformula,Z score =(X-mu)/(sigma)The screenshot is shown below,Step 4: The observed value are obtained by counting the Z scoreas follows,The observed values are,Observed valuesZ scoreCountZ<-14-1<Z<050<Z<18Z>13Step 5: The expected values are obtained in excel. Thescreenshot is shown below,The expected values are,Expected valuesZ scoreCountZ<-13.173-1<Z<06.8270<Z<16.827Z>13.173Step 6: The Chi-Square statistic is obtained using theformula,chi^(2)=sum((" Observed-Expected ")^(2))/(" Expected ")Z scoreObserved, <img alt="0" src="https://studymeta.oss-cn-hongkong.aliyuncs.com/9/9d14353e1ec1eee5e65b97ca7c21f2fd.jpg" aria-describe ... See the full answer