Question: I am struggling to understand how this function works. Any help appreciated. Age Education Usage Fitness Miles 3 112 Product TM195 TM195 TM195 TM195 2

I am struggling to understand how this function works. Any help appreciated.

I am struggling to understand how this function

Age Education Usage Fitness Miles 3 112 Product TM195 TM195 TM195 TM195 2 75 4 66 3 TM195 4 85 47 66 TM195 3 TM195 3 75 TM195 Gender 18 Male 19 Male 19 Female 19 Male 20 Male 20 Female 21 Female 21 Male 21 Male 21 Female 22 Male 22 Female 22 Female 22 Female 23 Male 23 Male MaritalStatus 14 Single 15 Single 14 Partnered 12 Single 13 Partnered 14 Partnered 14 Partnered 13 Single 15 Single 15 Partnered 14 Single 14 Partnered 16 Single 14 Single 16 Partnered 16 Partnered 3 Income Classes Income 4 Low $ 29,562.00 3 Low $ 31,836.00 3 Low $ 30,699.00 3 Low $ 32,973.00 2 Low $ 35,247.00 3 Low $ 32,973.00 3 Low $ 35,247.00 3 Low $ 32,973.00 4 Low $ 35,247.00 3 Low $ 37,521.00 3 Low $ 36,384.00 2 Low $ 35,247.00 3 Low $ 36,384.00 3 Low $ 35,247.00 $ 38,658.00 3 Low $ 40,932.00 85 141 TM195 5 2 85 TM195 TM195 TM195 3 85 3 66 TM195 4 886 75 TM195 3 75 3 1 Low 47 TM195 TM195 3 75 Assume that the manager wants to know which customer have had the maximum income. Use INDEX() function out of your Excel table to find out what product the first customer with the highest income purchased. Also, use a function you have learned in this class to find out what was the gender. Your answer here: what product the first customer with the highest income purchased? Explain how you found the answer? What was the gender of the first customer with the highest income? Explain how you found the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!