Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How many veggie food boxes did we sell on 04/14/2015 via marketing channel Newsletters? Solve with 1 formula and show the formula you used. Please
How many veggie food boxes did we sell on 04/14/2015 via marketing channel Newsletters? Solve with 1 formula and show the formula you used.
Please Tell me the steps on how this would be solved using Excel. Note that this is not the full excel data but just a small sample.
date_sign_up | customer_id | product_name | marketing_channel | City |
4/17/2015 13:11 | 71041 | Classic - 3 meals per week for 2 people | Search Engine Marketing | San Diego |
4/14/2015 11:32 | 103289 | Classic - 3 meals per week for 2 people | Newsletters (internal) | Los Angeles |
4/14/2015 9:53 | 107746 | Classic - 3 meals per week for 2 people | Newsletters (internal) | Los Angeles |
4/14/2015 16:08 | 157441 | Classic - 3 meals per week for 4 people | Newsletters (internal) | San Francisco |
4/18/2015 8:04 | 158646 | Classic - 3 meals per week for 2 people | Newsletters (internal) | San Diego |
4/18/2015 15:41 | 178843 | 3 Meals (vegetarian) for 2 people | TV / Radio Advertising | Miami |
4/15/2015 9:45 | 179297 | Classic - 3 meals per week for 2 people | Newsletters (internal) | Philadelphia |
4/15/2015 8:21 | 182439 | 3 Meals (vegetarian) for 2 people | Newsletters (internal) | San Francisco |
4/17/2015 6:57 | 186180 | Classic - 3 meals per week for 2 people | Partnership Marketing | San Diego |
4/19/2015 20:39 | 190396 | Classic - 3 meals per week for 2 people | TV / Radio Advertising | Miami |
4/14/2015 10:26 | 194229 | Classic - 3 meals per week for 2 people | Search Engine Marketing | Los Angeles |
4/13/2015 20:17 | 194353 | Classic - 3 meals per week for 2 people | Search Engine Marketing | Washington |
4/15/2015 14:43 | 200286 | Classic - 3 meals per week for 2 people | Search Engine Marketing | Philadelphia |
4/16/2015 7:35 | 201307 | Classic - 3 meals per week for 2 people | TV / Radio Advertising | 1San Diego |
4/15/2015 6:54 | 203319 | Classic - 3 meals per week for 2 people | Newsletters (internal) | San Francisco |
4/14/2015 8:35 | 205233 | Classic - 3 meals per week for 2 people | TV / Radio Advertising | Los Angeles |
4/13/2015 12:08 | 205322 | Classic - 3 meals per week for 2 people | Newsletters (internal) | Chicago |
4/16/2015 5:04 | 205611 | Classic - 3 meals per week for 2 people | TV / Radio Advertising | San Diego |
4/15/2015 12:17 | 208066 | 3 Meals (vegetarian) for 4 people | Newsletters (internal) | Philadelphia |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started