Count how many food boxes "Classic - 3 meals per week for 2 people" we sold...

Count how many food boxes "Classic - 3 meals per week for 2 people" we sold via marketing channel "TV / Radio Advertising" (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

Expert Solution

you can use the " COUNTIFS() " formula

In Criteria_range1 select enrtire product name coulumn and Criteri1 is "Classic - 3 meals per week for 2 people" , now for Criteria_range2 select entire marketing channel column and Criteria2 is "TV / Radio Advertising".

Note: this formula is character sensitive the character in criteria range and criteria need to be same.

keosha answered 1 year ago

Given the importance of food to many cultures and people, we oftentimes fail to see how...

Given the importance of food to many cultures and people, we oftentimes fail to see how various cultures can overtly or covertly divulge information about the importance of certain values just by the manner in which items are arranged in a grocery store. For this activity, each student will identify a large grocery store within 5 miles of his/her residence. Please try to identify a large grocery store chain and is a “dominant culture” store (i.e., a Latin specialty version...

Prepare a chart that shows sold food boxes per marketing channel in San Diego (Hint: You...

Prepare a chart that shows sold food boxes per marketing channel in San Diego (Hint: You might have to clean up city name "San Diego" in column E first, explain how you got all San Diego variations into a format you can work with) 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...

Marika wants to estimate how many coffees sold per week at the coffee shops and cafes in and around the University.

Marika wants to estimate how many coffees sold per week at the coffee shops and cafes in and around the University. She plans to do this by taking a sample of the coffee shops cafes and asking them how many coffees they have sold in the last week. There are 16 coffee shops and cafes (A to P). Marika went to all the coffee shops and cafes first and counted how many chairs they have. Her results are given...

Imagine we sampled 9 people. The sample mean of cigarettes per week was 5. The sample...

Imagine we sampled 9 people. The sample mean of cigarettes per week was 5. The sample standard deviation was 2. What is the 99% confidence interval for the true mean of cigarettes per week? Show work.

Many people consume eggs and toast at breakfast. Assume the typical person spends $15 per week...

Many people consume eggs and toast at breakfast. Assume the typical person spends $15 per week on eggs and toast. Currently the price of eggs is $0.75 per egg, and the price of toast is $0.50 per piece. (a) (10 points) Graph the budget constraint budget constraint. (b) Assume that some people have a utility function given by U = min[T, 2E] where T is the quantity of toast measured in slices, and E is the quantity of eggs. i....

In how many ways can we distribute 10 distinct balls into 5 distinct boxes with exactly...

In how many ways can we distribute 10 distinct balls into 5 distinct boxes with exactly 2 boxes empty?

3. It is known that the average person has 9.5 alcoholic drinks per week. Suppose we...

3. It is known that the average person has 9.5 alcoholic drinks per week. Suppose we take a sample of 25 people and find that the average amount of alcoholic drinks per week they have is 7.8 with a sample standard deviation of 9.6 drinks. We are interested in testing if the average amount of alcoholic drinks per week is actually lower than 9.5 now. a. Using the sample of 25 people, what would the 95% confidence interval be for...

how does a person’s education affect how many hours per week she or he is likely...

how does a person’s education affect how many hours per week she or he is likely to work outside the home? How have changes in the kinds of families Americans live in affected what the authors call the “work-home crunch”?

this week we covered effective leadership and motivating people, how do you think the two of...

this week we covered effective leadership and motivating people, how do you think the two of these topics correlate, is a good leader also good at motivating people? Use the text and tie in your personal experiences to illustrate your thoughts.Please give well thought out responses

We have 3 boxes. Box A contains 1 yellow ball and 2 red balls. Box B...

We have 3 boxes. Box A contains 1 yellow ball and 2 red balls. Box B conatins 2 yellow balls and 2 red balls. Box C contains 2 yellow balls and 1 red ball. First, we randomly choose between Box A and Box B. Then we randomly choose a ball from the selected box and put the ball into Box C. Lastly, we randomly choose a ball from Box C. Let E1 be the event that Box A is chosen...

Question