Answer:
a)
Explanation:
Since the worksheet contains most of the data that you need, there is a decent possibility that it also contains the data that you are missing. Therefore, you should check for data you have previously hidden. Sometimes, some data in a worksheet may become irrelevant in a given moment, and instead of deleting it since it may be useful later most people tend to make that data hidden. So checking for previously hidden data may be the best solution in this scenario.
Answer:
Step 1 : Create an Indicator Variable for metro cities using formula mentioned in formula bar.
Step 2: Filter the Data on Metro cities i.e. select only those cities with Metro Indicator 1.
Step 3: Paste this filtered data to a new sheet.
Step 4: Go to Data - Data Analysis - Regression
Step 5: Enter the range of Y-variable and X-variable as shown. Select Output range and click on residuals. It will give you Output Summary and the Predicted Values along with Residuals
Please see attachment
Answer:
B.
Explanation:
Go to the Borders and Shading option, click the Shading tab, and click the color under the Fill option.
Is this dealing with the computer because I can help you then