Hi! For utilizing the VLOOKUP function, you require the value to search for, the table’s range, and the specific column that has the return value. In your scenario, you provided both the range and the column; however, it’s unclear what value you wish to look up. For this explanation, let’s assume you want to search for the value in cell D5. Feel free to modify it according to your needs.
In syntax form, it will be:
=VLOOKUP(D5,G4:H7,2)
Step 1: Use the provided formula to create an Indicator Variable for cities with metro areas. Step 2: Apply a filter to isolate data specific to metro cities, selecting only those marked with Metro Indicator 1. Step 3: Transfer the filtered data to a new worksheet. Step 4: Navigate to Data - Data Analysis - Regression. Step 5: Input the specified Y-variable and X-variable ranges as indicated. Choose the output range and ensure residuals are checked, which will produce the Output Summary and the Predicted Values alongside Residuals. Please see the accompanying attachment.
