Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

really confused please help I have included the data table that is needed to help solve the problems A B D E 1 Real Estate

image text in transcribedimage text in transcribed

really confused please help I have included the data table that is needed to help solve the problems

image text in transcribedimage text in transcribed
A B D E 1 Real Estate Sales Price 2 Sales Price Home Size Rating 4 Y X1 X2 5 180 23 5 6 98.1 11 2 173.1 20 9 8 136.5 17 9 141 15 10 165.9 21 11 N V O V A OO W C 193.5 24 12 127.8 13 13 163.5 19 14 172.5 25 15 16 17 18 19 20 21 22 23 24 25 26 Sheet1 10THE REAL ESTATE SALES PRICE CASE A real estate agency collects the data concerning y = sales price of a house (in thousands of dollars) x1 = home size (in hundreds of square feet) x2 = rating (an overall "niceness rating" for the house expressed on a scale from 1 [worst] to 10 [best], and provided by the real estate agency) Scatter plots of y versus x1 and y versus x2 are as follows: Price Price Size, X1 Rating, X2 Click here for the data. 1. What is b1 and b2 2. Calculate a point estimate of the mean sales price of all houses having 2,000 square feet and a rating of 8: , and a point prediction of the sales price of a single house having 2,000 square feet and a rating of 8: 3. What is the total variation , unexplained variation ], and explained variation 4. What is the adjusted R2. 5. Use the F(model) statistic and the appropriate critical value to test the significance of the linear regression model under consideration by setting a equal to .05. (1) What are the F(model) statistic and the F critical value (2) Reject or do not reject HO (Click to select) (3) Is the model significant? (Click to select) ) 6. Find the p-value related to F(model) on the output . Using the p-value, test the significance of the linear regression model by setting a = .001. Reject or do not reject HO (Click to select)) 875 7. Using the t statistic and appropriate critical values, test the significance of B1 by setting a equal to .01. 516 (1) What are the t value and the positve t critical value (2) Reject or do not reject HO (Click to select) (3) Is B1 significant? (Click to select) 8. Using the t statistic and appropriate critical values, test the significance of B2 by setting a equal to .01. (1) What are the t value and the positive t critical value (2) Reject or do not reject HO (Click to select) (3) Is B2 significant? (Click to select) 9. Calculate the 99 percent confidence interval for B1? Lowerl limit ], Upper limit MAY 20 67 10 ... W tv MacBook Pro Save to: De & W # 4

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Mathematical Statistics And Its Applications

Authors: Richard J. Larsen, Morris L. Marx

5th Edition

321693949, 978-0321694027, 321694023, 978-0321693945

More Books

Students also viewed these Economics questions

Question

Discuss the significance of field of experience in communication.

Answered: 1 week ago