Explore BrainMass

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.

    © BrainMass Inc. brainmass.com June 4, 2020, 12:46 am ad1c9bdddf


    Solution Preview

    Please see the attached files

    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

    For the present data Mean = $21,445.53; Standard deviation = ...

    Solution Summary

    A Chi-Square Goodness of Fit test is determined. This led to the discussion of whether or not the prices of all 90 cars are normally distributed.