For further clarification, I have a worksheet that contains fields about various marketing-related KPIs. I'd like to create 3 ideal sets that would maximize the number of good marketing prospects and minimize our spending. I have to filter between some different column values i.e. Age_group (20-25, 25-35, etc), Region (Midwest, South, North, etc), etc.
All of the data is located on another sheet on the same workbook which contains several filters/values for various columns like the two columns I mentioned above. Once I've created a specific set i.e. 20-25 for Age_group, Midwest for Region, I'm supposed to write in adjacent cells which the expected number of good prospects and spending would be. For instance, if I use the ideal set mentioned in the previous sentence, I could get a value of "300" good prospects and "$1450" for expected cost. If I were to change the Age_group from 20-25 to 25-35 and keep the Region the same, my values may change to "105" good prospects and "$1900" expected cost.
Would I calculate this using multiple regression, Excel Solver, or some other method? I'm not sure from what angle to approach this. Thank you!
All of the data is located on another sheet on the same workbook which contains several filters/values for various columns like the two columns I mentioned above. Once I've created a specific set i.e. 20-25 for Age_group, Midwest for Region, I'm supposed to write in adjacent cells which the expected number of good prospects and spending would be. For instance, if I use the ideal set mentioned in the previous sentence, I could get a value of "300" good prospects and "$1450" for expected cost. If I were to change the Age_group from 20-25 to 25-35 and keep the Region the same, my values may change to "105" good prospects and "$1900" expected cost.
Would I calculate this using multiple regression, Excel Solver, or some other method? I'm not sure from what angle to approach this. Thank you!