Client Brief This document provides the client brief which should be used for the development of a single program or a collection of related programs. You have been asked to design and develop a prototype application that demonstrates how data from the given data set can be formatted, cleaned, and used to generate specific outputs $($as listed below$).$ Functional requirements The application should provide the following functionality: $$ A means to load the initial data set $($which consists of two CSV files$)$ and translate it into a suitable format: either XML$,$ JSON, or an entity relationship structure $($not CSV$)$ A means to back up the data in this format using either files or a database. This should preserve the current state of the data when the program is closed, and make it available when the program is reopened. $$ A process for cleaning and preparing the initial data set, managing inconsistencies, errors, missing values and any specific changes required by the client $($see below$).$ A graphical user interface$($s$)$ for interacting with the data that enables the user to: o Load and clean an initial data set $($from the CSV format$).$ o Load and save a prepared data set $($from its translated format$).$ o Use the prepared data set to generate output and visualisations. o Manipulate the range of values used to generate output and visualisations. It should be assumed that this program will be able to handle other sets of data generated from the same source, i$.$e$.$ data with the same column row headings but containing different values and anomalies. However, the application is not required to be generic $($work with multiple unknown data sets$).$ Given this best practice regarding code reuse, encapsulation and a well$-$defined programming interface should be applied where applicable. Data manipulation and outputs The client initially wants the application to perform the following actions on the data: $1.$ Outputs should not include any data from DAB radio stations that have the following $$NGR$$: NZ$02553847,$ SE$213515,$ NT$05399374$ and NT$2526759082.$ The $$EID$$ column contains information of the DAB multiplex block, e$.$g$.$ C$19$A$.$ Extract this out into a new column, one for each of the following DAB multiplexes: a$.$ all DAB multiplexes, which are: C$18$A$,$ C$18$F$,$ C$188$ b$.$ join each category $-$ C$18$A$,$ C$18$F$,$ C$188-$ to the $$NGR$$ that signifies the DAB stations$$ location to the following: $$Site$,$Site Height, In$-$Use Ae Ht$,$ In$-$Use ERP Total c$.$ Please note that: In$-$Use Ae Ht$,$ In$-$Use ERP Total will need the following new header after extraction: Aerial height $($m$),$ Power $($kW$)$ respectively. $3.$ The client initially needs information to generate the following and output the results using appropriate representation: a$.$ Produce the mean, mode and median for the $$In$-$Use ERP Total$$ from the extracted DAB multiplexes extracted earlier: C$18$A$,$ C$18$F$,$ C$188$ i$.$ For $$Site Height$$ more than $75$ ii$.$ For $$Date$$ from $2001$ onwards $4.$ Produce a suitable graph that displays the following information from the three DAB multiplexes that you extracted earlier: C$18$A$,$ C$18$F$,$ C$188$: $$Site$,$Freq$,$Block$,$Serv Label$1,$Serv Label$2,$Serv Label$3,$Serv label$4,$Serv Label$10$ You may need to consider how you group this data to make visualisation feasible. $5.$ Determine if there is any significant correlation between the $$Freq$,$Block$,$Serv Label$1,$Serv Label$2,$Serv Label$3,$Serv label$4,$Serv Label$10$ used by the extracted DAB stations. You will need to select an appropriate visualisation to demonstrate this.