Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook Of Income Distribution Volume 2B

Authors: Anthony B. Atkinson, Francois Bourguignon

1st Edition

0444594299, 978-0444594297

More Books

Students also viewed these Finance questions

Question

Evaluate 3x - x for x = -2 Answer:

Answered: 1 week ago

Question

What is group replacement? Explain with an example. (2-3 lines)

Answered: 1 week ago

Question

3. Define the attributions we use to explain behavior

Answered: 1 week ago