A Dual Axis line chart where we can see month by month the trend of the transactions’ Average Discount and the trend of the transactions’ Total Margin. Do not synchronize the axes, so we can compare whether the two trends have moved together chronologically, but make sure we can identify what axis corresponds to each line.
A Scatter Plot comparing the Number of Orders (Y) and the transactions’ Average Discount (X) per either Store Type or Product Category or Region whichever has a better correlation. Add a trend line.
Hint: you can see the R-Square by hovering over the trend line. Do not worry about the significance of the p-value. Only present the scatter plot grouped by either store type, category, or region, whichever has the highest R-Square.
[order_button_a]
A Stacked Columns Chart of the Number of Transactions per Day of the Week with product Categories stacked on each day’s bar.
The final deliverable of this question contains a story with three story points, one for each chart. Make it professional and inclusive; some members of your audience are colorblind.
Remember that the file should be saved as .twbx.The first file is for question 1 ( 20230720 AT2 Dataset-1.xlsx)
Unanswered test workbook: 20230720 AT2 Dataset-2.xlsx
Pareto Chart
Due to inflation, our company needs to make a revision of costs. Of particular interest will be the set of products that account for at least 80% of all costs. Please, provide a pivot table and associated Pareto Chart where we can see the Total Cost in dollars per Product and the Cumulative Percentage that each product contributes to the total cost. Remember to order the columns from highest to lowest contribution to the cost. Present a professional chart.
[order_button_b]