Hello, I recently have a project about houses.

The given information I have for 500 samples are:

1. sale price
2. number of bedrooms
3. number of bathrooms
4. grade ( 5 is lowest, 10 is the best)
5. square footage of home
6. square footage of lots

And now, the project is asking me to

Use the least-squares procedure to fit a prediction equation for price based on the square footage of homes, and square footage of lots. Test hypotheses, construct confidence intervals for the significant relationships and interpret all your findings.

I know I should use the square footage of homes and lots to predict the price by using a confidence interval.

But the problem is that I have no idea what to do about that. Can anyone help me solve the requirement above by EXCEL?