Search for question
Question

2. A group of transportation planners are interested in developing a regression model that

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