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
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 = ...
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.