Question: In the dataset presented in Question 1 , In Column H , we want to make a new variable: Compared with Impala This Variable compares
In the dataset presented in Question
In Column H we want to make a new variable:
"Compared with Impala" This Variable compares the sales volumes of all cars in March with the sales volume of "Chevrolet Impala sales volume in March In case each car's sales volume in March is less than Impala's sales in March it prints "Less," and else, it prints "More." We have sorted the dataset Descending based on March sales and, Chevrolet Impala sales volume in March is now in the cell:
We type the following formula in the cell H and we drag it down so that the formula applies to the cells below.
What should replace the in the formula?
IF "Less","More"
D C
$$$$$$
$$
$$$$
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
