The file P02 11 xlsx contains data on 148 houses sold in a certain suburban region a Create a histogram of the selling prices Is there any visual evidence that the distribution of selling prices is not normal b Test the selling prices for normality using the chi square test Is there enough evidence...

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt ...

The file P02_11.xlsx contains data on 148 houses sold in a certain suburban region. a. Create a

Question:

The file P02_11.xlsx contains data on 148 houses sold in a certain suburban region.
a. Create a histogram of the selling prices. Is there any visual evidence that the of selling prices is not normal?
b. Test the selling prices for normality using the chi-square test. Is there enough evidence at the 5% significance level to conclude that selling prices are not normally distributed? If so, what is there about the that is not normal?
c. Use the Lilliefors test and the Q-Q plot to check for normality of selling prices. Do these suggest the same conclusion as in part b? Explain.

Distribution
The word "distribution" has several meanings in the financial world, most of them pertaining to the payment of assets from a fund, account, or individual security to an investor or beneficiary. Retirement account distributions are among the most...