Consider Data on Sales Transactions and answer the following questions :
1- Give the right data type for each attribute.
2- Find a variable which could be visualized using a Pie chart and draw the pie chart using Excel. Interpret the chart.
3- Find a variable which could be visualized using a Culumn chart and draw the culumn chart using Excel. Interpret the chart.
4- From sales transactions provide data which could be visualized using 100% stacked culumn chart.
5-Find a variable which could be visualized using a Histogram (Use XLMiner and include screen shots in your report to show the steps ) . Interpret the histogram and justify the bins choice.
6- Implement a pareto analysis on appropriate data.
7- Using appropriate graphs, show which payment type is preferred in each region?
8- Which source has a better median amount.
Hint: the use of excel functions in the first chapter are recommended.
