Data preparation and exploration

The dataset Q1_Tissue.xlsx contains a transaction history describing over 3,700 purchases of facial tissue at a number of stores belonging to a grocery chain over a period of several weeks. The chain's product-line manager would like to predict the selling price of future orders from its different stores.

\fCOM_CODE Commercial code UPC Universal product code DESCRIP Description SIZE Package size CASE Number of cases NITEM Item number STORE Store number WEEK Week number MOVE Sales quantity PRICE Selling price QTY (Always 1) SALE Indicator of advertised sale PROFIT Store profit (per case) OK Confirmation code