# Statistics/Excel - 9328

Request Posted by ## kevin2412

Rating : No Rating
Earned: \$0
Request Detail
Price: \$1
• From: Mathematics,
• Due on: Mon 30 Apr, 2012 (12:53pm)
• Asked on: Mon 30 Apr, 2012
• Due date has passed, but you can still Post Solution.
Description
• Page 317 - Data Set Exercises
#57 - Real Estate Data - A thru D

Refer to the Real Estate data, which report information on homes sold in Phoenix, Arizona, last year.

A recent article in The Arizona Republic indicated that the mean selling price of the homes in the area is more than \$220,000. Can we conclude that the mean selling price in the Denver area is more than \$220,000? Use the .01 significance level. What is the p-value?

The same article reported the mean size was more than 2,100 square feet. Can we conclude that the mean size of homes sold in the Denver area is more than 2,100 square feet? Use the .01 significance level. What is the p-value?

Determine the proportion of homes that have an attached garage. At the .05 significance level can we conclude that more than 60 percent of the homes sold in the Denver area had an attached garage? What is the p-value?

Determine the proportion of homes that have a pool. At the .05 significance level, can we conclude that less than 40 percent of the homes sold in the Denver area had a pool? What is the p-value?

#60 - Wage Data - A thur D

Refer to the Wage data, which report information on the annual wages for a sample of 100 workers. Also included are variables relating to the industry, years of education, and gender for each worker.

Conduct a test of hypothesis to determine if the mean annual wage is greater than \$30,000. Use the .05 significance level. Determine the p-value and interpret the result.

Conduct a test of hypothesis to determine if the mean years of experience is different from 20. Use the .05 significance level. Determine the p-value and interpret the result.

Conduct a test of hypothesis to determine if the mean age is less than 40. Use the .05 significance level. Determine the p-value and interpret the result.

Conduct a test of hypothesis to determine if the proportion of union workers is greater than 15 percent. Use the .05 significance level and report the p-value.
Attachments  ### Computer Science ### Mathematics ### Applied Science ### Humanities Tutor 