3.Open the MS Excel sheet, provided with this examination. (Please see attached pictures is the data for my student number). Enter the last two digits of your student number in the highlighted cell (E2) of the sheet. This will generate the data. Perform the chi-square test on the developed

data, for the exponential and lognormal distribution.

Based on the 5% significance level,which distribution is the best? (10 points) How about a 1% significance level? (10 points)

Compare your results in both cases (5% significance level and 1% significance level) and provide a discussion of no more than 3 sentences (2.5 points). You may use MS Excel to only verify your CDF answers, but your solution needs to show all the calculations steps followed, as discussed in the relevant lecture.

*Instructions for developing data: Take the last two digits of your student number and enter

them in cell E2. For example, my student number is 201995600 then enter 00 in cell E2, as

an example shown in MS Excel sheet. The developed data is present in the cells E6 to E23.

\f