PLEASE USE EXCEL OR MANUAL
An economist wanted to investigate the relationship between office rents (the dependent variable) and vacancy rates. Accordingly, he took a random sample of monthly office rents and the percentage of vacant office space in 30 different cities.
a) Determine the regression line.
b) Interpret the coefficients
a)
Using Excel
data -> data analysis -> regression
choose data for both x and y variable
we get
y^ = 20.640 - 0.3038 x
Get Answers For Free
Most questions answered within 1 hours.