# Create a new column named Q6 and assign value based on following rule: # Q6 = 10 if dollar value >200,000 OR unit sold >800 else # Q6 = 5 if 100,000< dollar value <150,000 AND 300 < unit sold <400 else # q6=0