$1.$ Consider a dataset on Standardized Precipitation Evaporation Index $($SPEI$)$ which measures the drought level of areas. Here, SPEI$\_1981\_2010.$csv data is given and indicate the drought level of a sample of districts in Amhara region, Ethiopia. The SPEI data is the monthly measures between $1981$ and $2010.$The main objective of this data manipulation or exploratory data analysis is to provide insightful information to respond the objectives of a research. That is:a$.$ A researcher wants to classify drought level in eight classes and wants to compare percentage of time that a given district was in each drought level in the past $30$ years.b$.$ In addition, the researcher want to estimate the mean and standard deviation of SPEI in each drought level class. c$.$ Further, the researcher wants to compare drought levels of districts in the region using mean and standard deviation. The classification of the SPEI into drought level is based on the following criteria. SPEI ValueClassExtremely wetSeverely wetModerately wetMild wetNormalMild droughtModerately droughtSeverely droughtExtremely drought Based on the interest of the research,i$.$ Summarize the data using frequency tables of SPEI class with frequency, percentage, mean and standard deviation of SPEI in each drought level. The frequency table look like $($the values in the table are not true$).$Drought levelAdet frequencyPercentMeanSt.dev.Extremely drought$92\mathrm{.}2\%-3\mathrm{.}6$ Extremely wet$143\mathrm{.}4\%2\mathrm{.}3$ Mild drought$5012\mathrm{.}3\%-\mathrm{.}8$ Mild wet$6716\mathrm{.}5\%\mathrm{.}8$ Moderate drought$368\mathrm{.}9\%-1\mathrm{.}3$ Moderately wet$245\mathrm{.}9\%1\mathrm{.}3$ Normal$17643\mathrm{.}3\%\mathrm{.}1$ Severely wet$123\mathrm{.}0\%1\mathrm{.}8$ Severely drought$184\mathrm{.}4\%-1\mathrm{.}7$ ii$.$ Write R$-$code generate an appropriate output and give full description for each function in your code. iii. Write discussion about your results.iv$.$ Visualize your data using different graphical methods like time series plots $($line$,$ smooth plot $($lm$,$ loess,..$)$v$.$ Draw some bar plot, simple or multiple bar plots.vi$.$ Visualize presence of seasonality in SPEI across districts.