Guidelines: The overall aim of this project is to perform sales analysis. You are presented with data referring to sales’ transactions, namely 5000 transactions. For each individual sale transaction seven variables, three qualitative and four quantitative, are part of the dataset. The three qualitative variables are the region where the transaction takes place, the type of item being sold, and the sales channel. The four quantitative variables are units sold, unit price, unit cost and total profit. The latter three variables are denominated in Euro. You will use the data found in the “Final Assignment Data.xlsx” excel file, located in Moodle. Please make sure to use the data as in the worksheet named after your group. A brief desсrіption of the variables is presented below: oRegion: this qualitative variable reflects the geographical dimension of sales. Where did the sale take place? The dataset splits the world into 7 regions: Asia, Australia and Oceania, Central America and the Caribbean, Europe, Middle-East and North Africa, North America, Sub-Saharan Africa. oItem type: this variable indicates the nature of the product being exchanged Which product was sold and bought? The dataset groups products into 12 categories: baby food, beverages, cereal, clothes, comestics, fruits, household, meat, office supplies, personal care, snacks, vegetables. oSales channel: this qualitative variable shows whether the sale took place online or offline. How did the sale take place? Please note that, when performing regression analysis, you must transform this variable into a dummy variable, taking value 1 when the sale was online and value 0 when the sale was offline. oUnits sold: this variable reflects the quantity dimension of a sale. How many units of product where exchanged in that single sale transaction? It is a pure number, namely without a unit of measure. oUnit price: this variable reflects the revenue side of an individual sale. At which price was a unit of product traded for? It is measured in Euro. oUnit cost: this variable show the cost side of an individual sale. How much did it cost to produce a unit of product that was then traded? It is measured in Euro. oTotal profit: this variable shows how much profit (i.e. the difference between total revenue and total cost) accrues to the seller for the specific sale. How much did the seller make on that specific sale? It is measured in Euro.
