The solution file of the classification question is available here https://drive.google.com/file/d/0B6PHuk6I5SxbcHhkUzI1Z05XVVU/view?usp=sharing.
You know pivot table, filter, vlookup, if and many more functions in calc. Try to find following from the data given in the above file.
1. How many High valued customers are of age less than 30 years?
2. How many Regular Customers have Annual Income more than Rs. 25 lakhs?
3. How many Regular Customers have Age less than 30 years and Annual Income more than equal to Rs. 8 lakhs?
Share your solution and/or approach as comment to this post.
You know pivot table, filter, vlookup, if and many more functions in calc. Try to find following from the data given in the above file.
1. How many High valued customers are of age less than 30 years?
2. How many Regular Customers have Annual Income more than Rs. 25 lakhs?
3. How many Regular Customers have Age less than 30 years and Annual Income more than equal to Rs. 8 lakhs?
Share your solution and/or approach as comment to this post.
No comments:
Post a Comment