Question

How would we convert this in Excel, income>=50k, convert to 1; If income<50k, convert to 0.

How would we convert this in Excel, income>=50k, convert to 1; If income<50k, convert to 0.

Homework Answers

Answer #1

Suppose we have the excel sheet with Column : Income with lots of Entries.

Use: =if(Logical_test,[value_if_True],[value_if_false])

here

Logical test: in your case it is income>=50000

value_if_True: if this condition True we need 1

value_if_false: if condition fails we need 0

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
How to convert a Regular Expression to left-linear grammar (0+1)*00(0+1)*
How to convert a Regular Expression to left-linear grammar (0+1)*00(0+1)*
A)How do you convert 1/3 into binary with detailed steps ? B) Also how do you...
A)How do you convert 1/3 into binary with detailed steps ? B) Also how do you convert from repeating binary into decimal. (0.0110011001100110....0110) in base 2 . Assume 0110 patters go to forever. how can we convert it into decimal.
Open the Excel program In our last computer assignment we learned how to find the standard...
Open the Excel program In our last computer assignment we learned how to find the standard normal distribution up to the given score value a, that is we found P(Z < a). We used Excel instead of the standard normal distribution table and evaluated P(Z<-1.72) with the command =NORMDIST(1.72,B1,B2,TRUE) and we obtained 0.042716 approximately. Here Z is standard normal distribution. In this exercise we will learn how to go backwards, that is from the probability P(Z < a) to the...
What is the differences between groups and teams? How do we convert a group to a...
What is the differences between groups and teams? How do we convert a group to a team? What benefits might come from this conversion in a business environment?
1. Show how you would do the following sum in binary (make sure to convert to...
1. Show how you would do the following sum in binary (make sure to convert to binary first and give the result in both binary and base 10): 63+125 2. How many binary sequences are there of length n? 3. What is two’s complement and why is it used?
I don t understand NMR proton how we can use to find molecule? how convert ppm...
I don t understand NMR proton how we can use to find molecule? how convert ppm to hz and hz to ppm?
If fructose costs $1/kg, and we can convert 50% of it to HMF at a cost...
If fructose costs $1/kg, and we can convert 50% of it to HMF at a cost of $5/kg HMF, calculate the potential operating profit if HMF wholesales for $100/kg, and we produce 100,000 kg HMF/yr.
3. Show how you would convert I. 3-methylpentanol to isoleucine II. 1-methylcyclo- hexene to 1-bromo-2-methylcyclohexane III....
3. Show how you would convert I. 3-methylpentanol to isoleucine II. 1-methylcyclo- hexene to 1-bromo-2-methylcyclohexane III. 2-methyl-1-butene to 1-fluoro-2-methylbutane
How do you load an image into our Excel Worksheets, and what process do we use...
How do you load an image into our Excel Worksheets, and what process do we use to format the image in Excel?
How would I write in excel a formula for started at 60 % and increase their...
How would I write in excel a formula for started at 60 % and increase their capacity factor by 16 % a year till they reached a 100% capacity factor. (This meant that the capacity factor for year 2, CF2, would be = CF1*(1+growth_rate), and stop once it hit 100%