$1.$ What is the mean and median of TransactionValue?

$2.$ By comparing the median and mean of transaction values, can you infer if $$TransactionValue$$ is

skewed or symmetric?

$3.$ What is the IQR and standard deviation of TransactionValue?

$4.$ What is the correlation between the Quantity and UnitPrice?

$5.$ Show the breakdown of the number of transactions by countries, i$.$e$.,$ how many transactions

are in the dataset for each country $($consider all records, including return transactions$).$

$6.$ Show the breakdown of the total sum of transaction values by countries, i$.$e$.,$ how much money

in total has been spent by costumers from each country. Show only countries where the total

transaction value exceeds $130,000$ British Pound.

$7.$ What are the top $5$ products $($identified by StockCode$)$ that have generated the highest revenue

for the retailer? $($i$.$e$.,$ item with the highest total sum of $$TransactionValue$).$

$8.$ What is the second most popular product $($judged by the total quantity of the orders$)$ ordered by

Portuguese customers?

$9.$ What is the average transaction value of French customers for transactions where the quantity

of items ordered is exactly $1?($Hint: You need to filter both based on the country and the

quantity$)$

Short Answer

Please briefly $(3-5$ sentences$)$ answer each of the following questions:

$1.$ In an analytics project, what is the role and importance of data exploration and data

preparation? How should data be presented?

$2.$ What insights can summary statistics provide?

$3.$ A variety of data transformations and imputation methods exist. Please describe two of these

methods.

Requirements

All due dates are included in the Assignment Schedule.

General Submission Instructions

All work must be your own. Copying other people$$s work or from the Internet is a form of plagiarism and

will be prosecuted as such.

Your submission should include the final results $($i$.$e$.,$ answers to the questions$)$ as well as the R or Excel

files. If you choose to use R$,$ you can submit a single PDF file that includes the answers to the questions

as well as the screenshots of the R codes and the output. Alternatively, you can submit a PDF file that

contains the answers and submit an R script file separately.