Math Problem Statement

tell me how to solve this using excel: A real estate agent in the coastal area of Georgia wants to compare the variation in the selling price of homes on the oceanfront with those one to three blocks from the ocean. A sample of 21 oceanfront homes sold within the last year revealed the standard deviation of the selling prices was $45,600. A sample of 18 homes, also sold within the last year, that were one to three blocks from the ocean revealed that the standard deviation was $21,330. At the 0.01 significance level, can we conclude that there is more variation in the selling prices of the oceanfront homes?

What is the decision rule? Use the 0.01 significance level.

Note: Round your answer to 2 decimal places.

What is the value of F?

Note: Round your answer to 2 decimal places.

At the 0.01 significance level, can we conclude that there is more variation in the selling prices of the oceanfront homes?

Solution

Ask a new question for Free

By Image

Drop file here or Click Here to upload

Math Problem Analysis

Mathematical Concepts

Statistics
Hypothesis Testing
F-test
Variation

Formulas

F = s1^2 / s2^2
Critical F-value = F.INV.RT(α, df1, df2)

Theorems

F-test for Equality of Variances

Suitable Grade Level

Undergraduate