The data file “ Case-Online Orders-Pivot Tables.xlsx” contains data on 500 customer orders. The data was collected over a period of two months from the customers placing orders online. As the orders...

Case Study: Buying Pattern of Online Customers in a Large Department Store The data file “Case-Online Orders-Pivot Tables.xlsx” contains data on 500 customer orders. The data was collected over a period of two months from the customers placing orders online. As the orders are placed, customer information is recorded in the data base. Data on several categorical and numerical values are recorded. The categorical variables shown in the data file are day of the week, time, payment type (credit, debit cards, etc.), region of the country order was placed from, order volume, sale or promotion item, free shipping offer, gender, and customer survey rating. The quantitative variables include order quantity and the dollar value of the order placed. The manager of the store wants to understand the buying pattern of the customers by summarizing the data. Suppose you are an intern for this store chain and are given the responsibility to prepare a summary of the customer data that can help understand the buying pattern of the customers and also help improve the online order process to attract more online customers to the store. You are familiar with one of the tools available in EXCEL – the Pivot Table that can be used in extracting information from such large data base. In this case, the pivot tables can help break the data down by categories so that useful insight can be obtained. For example, this tool can create a table of orders received by the geographical region, or summarize the orders by the day or time of the week. Perform the following analyses on the data to answer the questions and concerns the manager expressed in the meeting. (Note: Identify each problem clearly and for each problem analyze your results and the graph and summarize your findings.) Create a pivot table that will provide a summary of number of orders received on each day of the week. Create a bar chart and a pie chart of the pivot table created to visually see the orders received by the...