Task summary: Dear Freelancer,
please complete the Project using Special software Excel and write a Report.
The reports needs to present and discuss the graphs that were done in XLS and needs to have around 900-1000 words.
📋 MAIN DETAILS: See the scenario attached. Write a managerial report. Use the tabular and graphical methods to help management develop a customer profile and to evaluate the promotional campaign.
At a minimum, your report should include the following techniques (include more techniques that would aid in the report creation besides the below ones)
1. Percent frequency distributions created in Excel using PivotTables for each of the key variables: number of items purchased, net sales, method of payment, gender, marital status, and age.
2. A sorted column chart showing the number of customer purchases attributable to the method of payment.
3. A crosstabulation of type of customer (regular or promotional) versus net sales.
4. A scatter chart with a trendline to explore the relationship between net sales and customer age.
5. A chart to examine whether the relationship between net sales and age depends on the marital status of the customer.
6. A clustered bar chart to examine the method of payment by customer type (regular or promotional).
📎 ATTACHED: -worksheet-instructions-rubric-bad grade sample (a low grade for his first project 1)
Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount