1. In this question, we will continue to use the data we used in assignment 2. The dataset includes 184 US cities. 21 variables in the dataset, contain information ranging from city sustainability policy actions to population health status, along with local demographic information. The explanation for each variable is on sheet 2.

In the assignment 2, you picked one research question from three below and answered a few questions regarding the properties of dependent variable and independent variable in the question you picked.

Does the city with higher level biking usage have less people diagnosed with physical health problems?

Review your answer in assignment 2 first and answer the following question:(5 points)

For those who picked question I or II, based on the question you selected, please conduct simple regression analysis by Excel and report the results:

  1. Report the value of intercept and regression coefficient
  2. State the regression line equation
  3. Based on the equation, state how the dependent variable is going to be changed if there is one unit change in the independent variable
  4. According to the statistical results, is the relationship significant?
  5. Interpret R2
  6. Think about one additional independent variable from the dataset as the control variable, use one sentence or two to justify why you think the additional variable could jointly explain the dependent variable.
  7. Then, conduct multiple regression analysis and report the findings (regression line equation, state how the dependent variable is going to be changed if there is one unit change in the independent variable, holding constant the impact of another independent variable; are the relationships significant? Interpret R2 and F test)