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:
The content of the cell is called an absolute cell reference.
Explanation:
Ms-excel can hold a value or string or number or formulas in each cell.
The end-user can input the values to a cell and do any calculation by using inbuilt formulas and do the necessary calculation and get the output in the required cell
When end-user try to copy and paste the data to another cell he or she can use paste special option where he or she can select values, by selecting values to end-user is just copying the data not formula this is called absolute reference of the cell
By using paste special end users copy the image or Unicode also.
This process is called an absolute cell reference
Answer:
Following are the correct code to this question:
short_names=['Gus','Bob','Zoe']#defining a list short_names that holds string value
print (short_names[0])#print list first element value
print (short_names[1])#print list second element value
print (short_names[2])#print list third element value
Output:
Gus
Bob
Zoe
Explanation:
- In the above python program code, a list "short_names" list is declared, that holds three variable that is "Gus, Bob, and Zoe".
- In the next step, the print method is used that prints list element value.
- In this program, we use the list, which is similar to an array, and both elements index value starting from the 0, that's why in this code we print "0,1, and 2" element value.
Answer:g
public static int addOddMinusEven(int start, int end){
int odd =0;
int even = 0;
for(int i =start; i<end; i++){
if(i%2==0){
even = even+i;
}
else{
odd = odd+i;
}
}
return odd-even;
}
}
Explanation:
Using Java programming language:
- The method addOddMinusEven() is created to accept two parameters of ints start and end
- Using a for loop statement we iterate from start to end but not including end
- Using a modulos operator we check for even and odds
- The method then returns odd-even
- See below a complete method with a call to the method addOddMinusEven()
public class num13 {
public static void main(String[] args) {
int start = 2;
int stop = 10;
System.out.println(addOddMinusEven(start,stop));
}
public static int addOddMinusEven(int start, int end){
int odd =0;
int even = 0;
for(int i =start; i<end; i++){
if(i%2==0){
even = even+i;
}
else{
odd = odd+i;
}
}
return odd-even;
}
}
Answer: CAD is mainly used for detailed engineering of 3D models or 2D drawings of physical components, but it is also used throughout the engineering process from conceptual design and layout of products, through strength and dynamic analysis of assemblies to definition of manufacturing methods of components.
Explanation:
