View the step-by-step solution to:

Hours 342 426 317 545 264 451 1049 631 512 266 492 562 298 Apartments Rent 950 1600 1200 1500 950 1700 1650 935 875 1150 1400 1650 2300 1800 1400

An agent for a residential real estate company in a large city would like to be able to predict the monthly rental cost of apartments based on the size of the apartment. Data for a sample of 25 apartments in a particular neighborhood are provided in the worksheet Apartments in the Excel workbook data.xls. At the .05 level of significance determine if the correlation between rental cost and apartment size is significant.

A. No, there is not a statistically significant linear relationship between monthly rental cost and apartment size, because the sample correlation coefficient is less than .95.
B. Yes, there is a statistically significant linear relationship between monthly rental cost and apartment size, because the p-value for this test is less than .0001.
C. Yes, there is a statistically significant linear relationship between monthly rental cost and apartment size, because the t-test value, 7.74, is greater than the critical value 1.96.
D. Yes, there is a statistically significant linear relationship between monthly rental cost and apartment size, because the sample correlation coefficient 0.85 exceeds 0.50.
Hours 342 426 317 545 264 451 1049 631 512 266 492 562 298
Apartments Page 2 Rent Size 950 850 1600 1450 1200 1085 1500 1232 950 718 1700 1485 1650 1136 935 726 875 700 1150 956 1400 1100 1650 1285 2300 1985 1800 1369 1400 1175 1450 1225 1100 1245 1700 1259 1200 1150 1150 896 1600 1361 1650 1040 1200 755 800 1000 1750 1200
Show entire document

Dear student, please... View the full answer

An agent for a residential real estate company in a large city would like to be able to
predict the monthly rental cost of apartments based on the size of the apartment. Data for
a sample of 25...

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
• -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents