Question: The data in the table below are the results of a random sample of recent home sales in your neighborhood that your boss has asked

The data in the table below are the results of a random sample of recent home sales in your neighborhood that your boss has asked you to use to estimate the relationship between the selling price of the house and the number of square feet in it.

a. First plot the data, with number of square feet on the "X" axis and the price of the house on the "Y" axis. Explain why housing price is the dependent variable and square feet is the independent variable.
b. What is the estimated regression line? What does the coefficient of square feet represent?
c. Is the sample size large enough for the estimated coefficient of square feet to be statistically significant at the 5% level?
d. What is the coefficient of determination (R2)?
e. Perform an F-test, again at the 5%level.

Observation Number Sale Price (in thousands) Square Feet (in hundreds) 280 328 281 293 263 291 320 256 311 352 288 356 293 272 308 20.3 30 21.5 25.4 14.5 22.3 31 37.2 27.1 30.2 21.2 37.2 23 26.7 10 13 14 26.5

Step by Step Solution

★★★★★

3.50 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a 1 280 203 2 328 30 3 281 215 4 293 254 5 263 145 6 291 223 7 320 31 8 256 372 9 311 271 10 352 302 ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

68-B-F-F-M (205).xlsx

300 KBs Excel File

Students Have Also Explored These Related Finance Questions!

The contingency table shows the results of a random sample of students by the location of school and the number of those students achieving basic skill levels in three subjects. At = 0.01, test the...

The contingency table shows the results of a random sample of students by type of school and their attitudes on safety steps taken by the school staff. At = 0.01, can you conclude that attitudes...

The contingency table shows the results of a random sample of former smokers by the number of times they tried to quit smoking before they were habit-free and gender. At = 0.05, can you conclude...

0 Question 23 B 0/1 pt '0 3 8 99 (9 Details 14% of all college students volunteer their time. Is the percentage of college students who are volunteers larger for students receiving financial aid? Of...

EXCEL ASSIGNMENT P.S ( I need all these answers in excel with formula) Use the Excel data file Xr04-94: Increasing tuition has resulted in some students being saddled with large debts upon...

reenriver.edu/courses/2507123/assignments/336 Chapter 11: Goodness of Fit Score: 0/14 Answered: 0/6 Question 1 A restaurant owner has given out 147 free coupons to special customers that will all be...

Recent data on the various types of properties purchased in the major cities and suburbs show upward price trends. Historically, 20% of purchases were for condos, 32% were for townhouses, 38%6 for...

The text McClave et al. (2000) discusses the following problem that relates the value of a home to its upkeep expenditure. Quality Home Improvement Center (QHIC) operates five stores in a large...

Data were collected from a random sample of 220 home sales from a community in 2003. Let Price denote the selling price (in $1,000), BDR denote the number of bedrooms, Bath denote the number of...

Two cards have straight edges. Suppose that the top edge of one card crosses the bottom edge of another card at a small angle, as in Figure Q39.18a. A person slides the cards together at a moderately...

X-ray radiation of energy 1.29x10-1J is diffracted from (333) plane of a sample has tetragonal crystal structure with lattice constants a = 2 and c = 3 . Calculate the Bragg angle for the first...

How much must be deposited today into the following account in order to have $ 35 comma 000 in 6years for a down payment on a house? Assume no additional deposits are made. An account with monthly...

When the values of stocks and bonds fluctuate, they have an impact on the bal- ance sheet of insurance companies. Why is that impact more likely to be a prob- lem for life insurance companies than...

Indicate whether each account is an asset, a liability, or a stockholders equity account, and whether it would have a normal debit or credit balance. (a) Accounts Receivable. (b) Accounts Payable....

For the following transactions, indicate the account debited and the account credited. (a) Supplies are purchased on account. (b) Cash is received on signing a note payable. (c) Employees are paid...

For each account listed here, indicate whether it generally will have debit entries only, credit entries only, or both debit and credit entries. (a) Cash. (b) Accounts Receivable. (c) Dividends. (d)...

You invested $ 1 , 3 5 0 , 0 0 0 with a market - neutral hedge fund manager. The fee structure is 2 / 2 0 , and the fund has a high - water mark provision. Suppose the first year the fund manager...

2. Consider the following investment strategy involving put options on a stock with the same expiration date. (1) Buy one 25-st rike put (2) Sell two 30-strike puts (3) Buy one 35-strike put...

Please answer using excel and show all formulas you use, and the menu of your solver solution (or any other important menu) Thank you! Oriental Airlines is considering a capital expansion in which it...