Using Excel, show the functions to solve the equation.

A real estate company is analyzing the selling prices of residential homes in a given community' 140 homes that have been sold in the past month are randomly selected and their selling prices recorded' The statistician working on the project has stated that in order to perform various statistical tests, the data must be distributed according to a normal distribution' In order to determine whether the selling prices of homes included in the random sample are normally distributed, the statistician divides the data into 6 classes of equal size and records the number of observations in each class' She then performs a chisquare goodnessoffit test for normal distribution. The results are summarized in the table. Observed Expected Complete the five step hypothesis Chi Square Goodness of fit test at level of significance 0105' 10 6.2 23 19.026 39 47.782 40 47.55 27 19.026 3 3.192