Purchase Solution

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

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

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.

Solution Preview

Please see the attached files

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

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

Purchase this Solution


Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.