An agent for a residential real estate company in a suburb located outside a major city has the business objective of developing more accurate estimates of the monthly rental cost for apartments. Toward the goal, the agent would like to use the size of an apartment, as defined by square footage to predict the monthly rental cost. The agent selects a sample of 8 one-bedroom apartments and the data are shown.

Monthly Rent ($)	Size (Square Feet)
975	850
1600	1300
825	950
1550	1250
2000	2000
950	650
1750	1300
1250	950

How can I find the following in excel and what is the formula to do so? :

1. Use the least-squares method to determine the regression coefficients b0 and b1? Answer is b0 = 293.5. b1 = 0.9

2. Predict the mean monthly rent for an apartment that has 1,000 square feet?

Answer is $1,218.04

3. Two people are considering signing a lease for an apartment in this neighborhood. They are trying to decide between two apartments, one with 1,000 square feet for a monthly rent of $1,275 and the other with 1,200 square feet for a monthly rent of $1,425. Based on (a) through (d), which apartment is a better deal? Answer is: Based on (a) through (d), the apartment with 1,200 square feet is the better deal.