(Use Excel)The Following Are the Prices (In $1,000s)of 20 Houses

question 8

Essay

(Use Excel)The following are the prices (in $1,000s)of 20 houses sold recently in Vancouver,Washington.A real estate agent believes that the standard deviation of house prices is less than 70 units,where each unit equals $1,000.Assume house prices are normally distributed. a.State the null and the alternative hypotheses for the test.
B)Calculate the value of the test statistic.
C)Use Excel's function (either CHISQ.DIST.RT or CHISQ.DIST)to calculate the p-value.
D)At α = 0.10 what is the conclusion? Is the agent's claim supported by the data?

---

Definitions:

Aggravated Identity Theft

A crime involving the unauthorized use of another individual’s personal information to commit fraud, especially under circumstances that exacerbate the crime's severity.

EU Data Protection Directive

A decree issued by the European Union (EU) that prevents European companies from sharing ESI with countries that do not provide the same level of protection for the ESI as the EU.

Consideration

The value (such as cash, goods, or services) exchanged between parties in a contract, making the agreement legally binding and enforceable.

Bargained-For-Exchange

A fundamental principle in contract law requiring that each party to a contract must exchange something of value for the agreement to be binding.