This homework involves subsetting a transaction dataset (similar to the one that

This homework involves subsetting a transaction dataset (similar to the one that

This homework involves subsetting a transaction dataset (similar to the one that we used in class) into calibration time periods and holdout time periods, creating the group labels based on calibration data, and tracking business performance with the holdout data.
I provided the data and video guide for the homework down below
Please save your work and add your last name to the file name, and submit your completed Excel file here. Make sure you type your answers for Q5. Also, Please pledge your honor code in your Excel file by pasting this statement in sheet “HW4questions” and cell “A16”: “I confirm that I have typed in all the functions in this file myself, and have done my own work generating the pivot tables and the chart.”
Please follow all the steps in the video correctly and Answer the question of which variable is the most important in predicting future profits, and give the correct reason for it:
It ‘s not allowing me upload video but please click on the link i provided https://youtu.be/EXXeqEcm0qg?si=NJXfutJntsfDfqaR