Homework Assignment 6
分析数据库代写 What form of payment is the most common? Does this payment type more prominent for different product types? Or is the payment type same
This project gives you an opportunity to learn how to use Excel’s PivotTable feature to analyze a database or data list. Use the data file for Online Management Training Inc. The data file provided in the blackboard under Homework Assignment 6. This is a list of the sales transactions at Online Management Training for one day. Use Excel’s PivotTable to help you answer the following questions: 分析数据库代写
- Where are the average purchases higher? The answer might tell marketing managers of the company on where to focus marketing and sales resources or pitch different messages to different regions.
- What form of payment is the most common? Does this payment type more prominent for different product types? Or is the payment type same across the product type? Describe your findings? Your finding will be used by the company to emphasize in advertising the most preferred means of payment. 分析数据库代写
- Are there any times of day when purchases are most common? Do people buy more products while at work (likely during the day) or at home (likely in the evening)? Does this pattern of buying same across the product types or is it different?
- What’s the relationship between region, type of product purchased, and sales price? Use the combination there 3 different attributes to draw your own 分析数据库代写 conclusion.
Find the attached screen shot to see my results. For question 4 I have used one type of combination, but you don’t have to follow that same combination.
Following are the deliverables for this project
- Submit the excel sheet along with the data provided to you in one sheet and all the pivot tables in another sheet
- Name your excel sheet prefixing with your netid
- In the sheet where you have your pivot tables write your conclusions for each question under each questions pivot table. Write a short paragraph with a maximum of 2-3 sentences to give your conclusion