I need help with the below question - data sets are below

Interior SF Exterior SF Price

1,597 667 $574,532

1,354 541 $548,347

1,623 673 $547,645

1,274 398 $562,410

1,789 676 $700,472

1,544 847 $820,238

1,311 549 $613,707

1,176 482 $573,027

1,512 609 $683,590

1,210 643 $649,883

1,967 664 $831,774

1,519 561 $582,545

1,376 726 $698,385

1,515 756 $479,770

1,379 456 $560,912

1,541 612 $589,246

1,199 457 $418,522

1,755 640 $744,768

1,432 561 $661,616

1,854 722 $798,405

1,619 561 $645,936

1,175 512 $624,756

1,590 639 $639,427

1,296 673 $426,297

1,272 456 $501,829

1,413 640 $650,628

1,392 577 $544,671

1,441 709 $535,145

1,554 630 $548,814

1,409 519 $541,797

1,377 457 $597,983

1,512 588 $549,184

1,591 673 $736,916

1,404 460 $384,603

1,496 755 $607,290

1,710 630 $533,153

1,670 707 $657,136

1,477 573 $538,882

1,623 537 $636,610

1,523 564 $643,092

1,618 537 $447,717

1,502 734 $745,808

1,883 610 $642,318

1,645 606 $653,855

1,860 755 $653,005

1,640 683 $579,304

976 512 $594,487

1,373 500 $572,955

1,422 492 $419,730

1,609 470 $506,876

A real estate agent wants to know whether both the internal square footage ofa house and the external square footage of the house tie. the square footage of the land which does not contain the house itself) independently increase the sales price of the house. Data are collected froma random sample ofrecentlyesold homes. and the sale price internal square footage. and external square footage are recorded. The data are contained in aworksheet named \"Houses" in the "Final Examination 2021 xlsx" le. Based on these data' 1. What is predicted sales price of a house which has 1.500 square feet ofinterior space and 500 square feet of exterior space (accurate to the nearest dollar)? he proport n a he variation n sa 5 price that pre cted in the popula on when tmth var bies are nthe mod 3. What is the value of the coefcient of partial determination for interior square footage (accurate to two places to the right ofthe decimal point). and what is the interpretation ofthis value? 4. In the context of the agent's objective. what is the interpretation ofthe intercept? 5. In the context of the agent's objective. what is the interpretation ofthe slope coefficient associated with interior square footage? 6. Can you be 95% confident that, after controlling for external square footage higher internal square footage is associated With higher sales prices in the population?Jusryour answer 7. In the context of the agent's objective. what can you infer from the pvalue associated with the Global F