In an additional column in tab Data, mark all boxes sold in New York via Marketing channel Newsletters (internal) with a 1 , all other box city combinations with a 0 Solve with 1 formula 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

The Answer is in the image, click to view ...

Question: In an additional column in tab Data, mark all boxes sold in New York via Marketing channel Newsletters (internal) with a 1, all other box

In an additional column in tab Data, mark all boxes sold in "New York" via Marketing channel "Newsletters (internal)" with a "1", all other box city combinations with a "0"; Solve with 1 formula

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

1. Which customer ID bought most food boxes, and what city were they from? ID: 220418. Philadelphia 2. How many customers purchased more than 1 product? Solve with 1 formula and show the formula you...

C32 fix H G Total Meals_per_Week 6 6 6 12 6 6 6 6 6 6 6 B 1 Date_Sign_Up Cusomter_ID Product_Name 2 4/17/2015 13:11 71041 Classic - 3 meals per week for 2 people 3 4/14/2015 11:32 103289 Classic - 3...

Prepare an additional column in tab Data, in which you convert format "Date Time" from column A into format "Date" with a formula and prepare an overview how many classic food boxes and how many...

Add an additional column in the Data tab, in which you convert Column A from DateTime to Date format with a formula. Prepare a table chart showing how many classic food boxes and how many veggie food...

please I need this completed asap. If you need the username and password to log-in let me know \fInstructions City of Bingham Computerized Cumulative Problem For use with McGraw-Hill/Irwin Accounting...

I need Chapter 5 and Chapter 6 solutions to the "City of Bingham" continuous accounting problem from the 16e "Accounting for governmental & nonprofit entities" book. Instructions are posted...

At the year end, an analysis by the city?s finance department determined the following constraints on resources in the general fund. Prepare the appropriate journal entry in the general fund to...

Hey i need help with this, use the 2 repports that i have attatched to answer, will give tip if done fast UNITED STATES SECURITIES AND EXCHANGE COMMISSION Washington, D.C. 20549 Form 10-K ANNUAL...

I NEED SOLUTIONS FOR CHAPTER 4.. REQUEST ANY ADDITIONAL INFORMATION IF ITS NECESSARY. Instructions City of Smithville Full Version Computerized Cumulative Problem For use with McGraw-Hill/Irwin...

Need help journal entries City of Smithville Full Version 16E General Fund journal entries chapter 4 Street Improvement Capital Projects fund Chapter 5 Street Improvement Bond Debt Service Fund...

Clinton Company has provided information on intangible assets as follows. A patent was purchased from Reagan Company for $2,000,000 on January 1, 2007. Clinton estimated the remaining useful life of...

Which of the following statement(s) is/are true with regard to positional information in Drosophila? A. Morphogens are a type of molecule that conveys positional information. B. Morphogenetic...

Which of the following is NOT one of the things I said I beg you to do when you sign up for a 4 0 1 ( K ) at work? Group of answer choices On day one, take out as much as the employer matches. Sign...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...