Working on a case study and the final portion is 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 or some other method? I don't know much about stat so I don't know about all of the different options I can use. 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 or some other method? I don't know much about stat so I don't know about all of the different options I can use. Thank you!