Can you review, assist and send the spreadsheet.

1. Open the file and save your working file as a .xlsx file in another folder.
2. Use the Data Analysis toolkit to prepare the descriptive statistics of the passenger counts. Place the out at C1.
3. In cell F1, create a BIN column starting with 35 and adding 2.5 to each until you get to 60.
4. Use the Data Analysis toolkit to prepare a histogram using the Passenger Data as Input and the BIN range you created starting in F1. Does the histogram look generally normal? Visually, perhaps, but we will use a Chi-Squared Goodness of Fit test to determine if the data is normal or not.
5. Reference the example 5.41 on page 208 for instructions on constructing a model to test the Chi-Square goodness of fit. The model is shown on page 208, figure 5.28. Build this model and test the passenger data.
6. Your spreadsheet should look something like the image shown below (click on the image to open it in a new tab):

B C D E F G H I J K L M N P R S T U Passengers Passengers BIN BIN Frequency 36 35.00 35 Histogram 55 Mean 45.68 37.50 37.5 47 Standard Error 1.04358357 40.00 40 45 Median 45 42 50 42 5 48 Mode 45 45.00 45 43 Standard Deviation 5.217917848 47 50 47.5 42 Sample Variance 27.22656567 50.00 50 56 Kurtosis 0.707219447 52 50 52 5 Frequency 40 Skramers 0.$2316313 55.00 55 Frequency 47 Range 22 57 50 57.5 44 Minimum 36 60.00 46 Maximum 58 More 53 Sum 1142 45 Count 25 35 375 40 425 45 47.5 50 525 55 575 60 More BIN Chi-Square Goodness of Fit Test (Normality) Observed Data Normal Assumptions hi-Square Cake Bin Freg Cum Probability BIN Probability Expected Frequent (Obs x Exp)"2 Expected 35.00 0.0203 0.0203 0.5085 0.5085 37.50 0.0585 0.0381 0.9535 0.0023 40.00 0.1352 0.0797 1.9924 0.0000 42 50 0.2711 0.1329 3.3236 0.1377 45.00 0 4452 0.1770 4,4260 1.4970 47.50 0.6364 0.1882 4.7056 0.3561 50.00 0.7961 0.1596 3.9940 2 2444 52 50 0 9044 0.1083 2.7065 2.7065 55.00 0.9530 0.0536 1.4641 0.1962 57.50 0.9983 0.02 53 0.6322 0.2139 60.00 0.$970 0.0047 0.2179 2.5067 A Chi Sq statistic 10.6692 Chi Sq Critical Val 18 3070