Explore BrainMass

# Chi-Square Goodness of Fit test in Excel: Normally Distributed

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

See attached data file.

Need help performing a Chi-Square Goodness of Fit test to determine whether or not the prices of all 90 cars in the attachment are normally distributed.

Please provide a short write-up in Word that interprets your output and a file that provides the statistical output or calculations in Excel

Please feel free to contact me if you have any questions, can not access the file or a recommendations for the credits.

https://brainmass.com/statistics/chi-squared-test/chi-square-goodness-fit-test-excel-normally-distributed-358791

#### Solution Preview

Procedure
Step1: Compute mean and standard deviation of the given prices.
Step2: Transform the data to a frequency distribution and find the observed frequencies Oi
Step 3: Standardize the upper boundaries of the frequency table and obtain the theoretical frequencies using standard normal tables.
Step 4: Calculate the table for chi-square
Step 5: Conduct chi-square test