Please answer the 6 questions using the data points above. thanks

Using Simple Linear Regression for Office Space Rental Cost Predictions The Office of Management and Budget (OMB) oversees federal property and assigns space for federal agencies using pricing rates set by an environmental scan. A branch chief for the OMB in a large metropolitan area needs to predict the monthly rental cost for office space, based on the size of the space as defined by square footage. A sample of 25 offices in a particular federal complex was selected, and the Information gathered revealed the following: Monthly Rent ($) $ 950.00 $ 1,600.00 $ 1,200.00 $ 1,500.00 $ 950.00 $ 1,700.00 7. $ 1,650.00 . $935.00 $ 875.00 $ 1,150.00 $ 1,400.00 $1,650.00 $ 2,300.00 $ 1,800.00 $ 1,400.00 $ 1,450.00 $ 1,100.00 $ 1,700.00 $ 1,200.00 $ 1,150.00 $ 1,600.00 $ 1,650.00 $ 1,200.00 $ 800.00 $1,750.00 Apartment 1 2 23 4 5 69 00 9 THERES 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Size (Square Feet) 850 1450 1085 1232 718 1485 1136 726 700 956 1100 1285 1985 1369 1175 1225 1245 1259 1150 896 1361 1040 755 1000 1200 Please answer the following questions. Support your answers with numerical values attained from the Regression Analysis. 1. Construct a Scatter Plot of the data and perform a Regression Analysis to find the regression coefficients of bo and b, of a model that explains the relationship between office space and monthly rent. Please provide the meaning of these values. (15 points) 2. Please provide the model equation and explain the objective of this model. (15 points) 3. Predict the mean monthly rent for an office that is 1,000 square feet. (15 Points) 4. Why would it not be appropriate to use the model to predict the monthly rent for offices that have 500 square feet? (15 Points) 5. The FBI is looking for office space in this federal complex. The agency is debating between two offices, 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. Using the data and data analysis techniques, which is the best use of federal dollars? (25 Points) 6. How useful is the model for predicting monthly rent? (15 Points)