depicts the relationship between the number of autos in a household and the number of
auto trips produced by that household on a daily basis. Based on the data contained in
Table 3, answer the questions as follows:
2.1. Develop a regression model using the Microsoft Office Excel Program. Copy the output
from Excel and paste on your paper to show your work. (10 Points)
2.2. What does the coefficient "₁" (i.e., the slope) suggest? That is, interpret "₁". (10 Points)
2.3. Is the R² from the model high or low? What does this suggest? (10 Points)
Fig: 1