The answers are correct. I forget how do do this. Is there a quick way to solve

Question

The answers are correct. I forget how do do this. Is there a quick way to solve this problem using Data-analysis in excel?

An agent for a real estate company wanted to predict the monthly rent for apartments based on the size of the apartment. The data for a sample of 25 apartments is available below. Perform attest for the slope to determine if a significant linear relationship between the size and the rent exists. a. At the 0.05 level of significance, is there evidence of a linear relationship between the size of the apartment and the monthly rent? b. Construct a 95% confidence interval estimate of the population slope, B1, BEE Click the icon to view the data. a. Determine the hypotheses for the test. Choose the correct answer below. O A. HD: 20 Hot Po 0 C. Ho A1 s 0 Find the test statistic. TAT 7.96 (Round to two decimal places as needed.) What is the p-walue? p-value 0.000 (Round to three decimal places as needed.) Reach a decision. Reject Ho. There is sufficient evidence to conclude that there is a linear relationship between the size of the apartment and the monthly rent. b, The 95% confidence interval is 0.8060 sp, s 1.3708 (Round to four decimal places as needed.)

Explanation / Answer

you can select data --data analysis ---regression

in that put rent array in Y and square feet in X array

select level of significance =0.05

and ypu wil get output of slope with all the paramters you are looking for

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.