Neco 2017 Data Processing Question 37

A spreadsheet records monthly sales of three products (A, B, C) for six months. Unit prices are \(\text{₦}200\) for A, \(\text{₦}150\) for B and \(\text{₦}250\) for C. The units sold are:\n\n| Month | A | B | C |\n|-------|---|---|---|\n| Jan | 120 | 80 | 140 |\n| Feb | 130 | 90 | 160 |\n| Mar | 110 | 85 | 155 |\n| Apr | 140 | 95 | 170 |\n| May | 150 | 100 | 145 |\n| Jun | 160 | 105 | 180 |\n\n(a) Write a spreadsheet formula that computes the average monthly revenue **only for months where product C sales exceed 150 units**.\n(b) Using the data, calculate the percentage increase of this conditional average compared to the overall average monthly revenue (all six months). Round the percentage to one decimal place.