Neco 2018 Data Processing Question 30

A spreadsheet contains the following data (Month, Units Sold, Unit Price in \(\text{₦}\)):\n\begin{tabular}{lrr} Month & Units Sold & Unit Price\\\hline Jan & 120 & 50\\ Feb & 150 & 48\\ Mar & 130 & 49\\ Apr & 160 & 47\\ May & 170 & 46\\ Jun & 180 & 45\\ \end{tabular}\nColumn D computes Revenue as \(\text{Units Sold}\times\text{Unit Price}\).\nUsing the revenues for April, May and June, apply a simple linear regression (least‑squares) to predict the revenue for July (the next month). Then determine the percentage increase of this projected July revenue over June's actual revenue. Give the projected revenue (rounded to two decimal places) and the percentage increase (rounded to two decimal places).