Question

Data for a sample of 25 apartments in a particular neighborhood are provided in the worksheet apartments in the excel workbook apartments.xlsx. using the estimated regression equation found by using size as the predictor variable, find a point estimate for the average monthly rent for apartments having 1,000 square feet of space. place your answer, rounded to the nearest whole dollar, in the blank. when entering your answer do not use any labels or symbols. simply provide the numerical value. for example, 123 would be a legitimate entry. apartments.xlsx

Answer 1

As the data is not provided above I am assuming that it is the question of quiz 5 | Errors And Residuals | Correlation And Dependence and assume the data provided in it so taking the data as linear regression we know that the linear equation is of the form y=mx+b where y is dependent variable x is independent variable m is slope of line and b is its intercept if the data from the excel sheet is plotted on graph and a line for linear regression is found out if you want to know how the stat tools on net have feature to plot data in linear regression model.  
You can find out the equation comes out for data is  
rent=177.12+1.065(size) 
now given that size is 1000 feet so  
rent=177.12+1.065*1000 
rent=1242 (rounded off