Excel Problem Solver for PDF
Budget: $30 – $250 CAD
Read the assignment PDF and solve the problems. The requirements include using Excel pivot tables and providing well-justified answers.
Precisions
Regarding Problem 2 of the final assignment, particularly the computation of the ITT and the lack of information concerning campaign costs, please note the following:
Role of ITT and ToT:
In this question, the ITT (and, if applicable, the ToT) is mainly used as a statistical framework to define the populations being compared.
The key is to correctly identify the groups and then compare their average sales in a way that is consistent with the experimental design.
No ROI calculation required:
The problem statement intentionally provides no information about campaign costs. This means you are not being asked to compute a numerical ROI in this problem.
Without cost data, a true ROI cannot be calculated.
The purpose of the question is to ensure you properly apply group comparisons (ITT / ToT), not to reproduce the full example with margin or CPM.
For Problem 2, focus on a clean and well-justified comparison of averages between the correct groups, using the ITT/ToT framework. There is no need to make the analysis more complex or attempt to calculate an ROI when no cost data is provided.
Precisions
Regarding Problem 2 of the final assignment, particularly the computation of the ITT and the lack of information concerning campaign costs, please note the following:
Role of ITT and ToT:
In this question, the ITT (and, if applicable, the ToT) is mainly used as a statistical framework to define the populations being compared.
The key is to correctly identify the groups and then compare their average sales in a way that is consistent with the experimental design.
No ROI calculation required:
The problem statement intentionally provides no information about campaign costs. This means you are not being asked to compute a numerical ROI in this problem.
Without cost data, a true ROI cannot be calculated.
The purpose of the question is to ensure you properly apply group comparisons (ITT / ToT), not to reproduce the full example with margin or CPM.
For Problem 2, focus on a clean and well-justified comparison of averages between the correct groups, using the ITT/ToT framework. There is no need to make the analysis more complex or attempt to calculate an ROI when no cost data is provided.