Consider the following sales data (in units) for three products over four months:\n\n| Month | Product A | Product B | Product C |\n| Jan | 120 | 80 | 200 |\n| Feb | 150 | 95 | 210 |\n| Mar | 130 | 110 | 190 |\n| Apr | 160 | 105 | 220 |\n\n1. Compute the total sales for each product over the four months.\n2. Compute the overall average sales per entry (i.e., total of all 12 numbers divided by 12).\n3. Identify which months have a combined total sales exceeding $150\%$ of that overall average.\n4. Write an Excel formula that, given a month's total sales in cell E2, returns "Yes" if it exceeds the $150\%$ threshold and "No" otherwise.

Question

Consider the following sales data (in units) for three products over four months:\n\n| Month | Product A | Product B | Product C |\n| Jan   | 120       | 80        | 200       |\n| Feb   | 150       | 95        | 210       |\n| Mar   | 130       | 110       | 190       |\n| Apr   | 160       | 105       | 220       |\n\n1. Compute the total sales for each product over the four months.\n2. Compute the overall average sales per entry (i.e., total of all 12 numbers divided by 12).\n3. Identify which months have a combined total sales exceeding $150\%$ of that overall average.\n4. Write an Excel formula that, given a month's total sales in cell E2, returns "Yes" if it exceeds the $150\%$ threshold and "No" otherwise.

Accepted Answer

Product totals - A: 560, B: 390, C: 820; Overall average = 147.5; Months exceeding 150% threshold: Jan, Feb, Mar, Apr; Excel formula: =IF(E2>1.5*AVERAGE($E$2:$E$5),"Yes","No")

Neco 2023 Data Processing Question 13

Answer Options

About This Question

Master the Exam!