Question

In: Operations Management

How many customers purchased more than 1 product? (Hint: Customer ID stays the same per customer...

How many customers purchased more than 1 product? (Hint: Customer ID stays the same per customer when he/she buys several food boxes)

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

Solutions

Expert Solution

Answer: Hi following is the step to know that

select the table and insert a pivot table:

Place Customer ID in row and product name in column, then place the product name in value field and set it to the count

Now select the table and paste it in another sheet as a table only (not the pivot table)

Then remove the Grand total column and create a count of product column which will have the count function to count the number of entries under various product column against each of the customer Id.

This will tell us how many differnet type of product each customer has ordered in the data set.


Related Solutions

A bank manager claims that the median number of customer per day is no more than...
A bank manager claims that the median number of customer per day is no more than 440. A teller doubts the accuracy of this claim. The number of bank customers per day for 16 randomly selected days are listed below 410, 416, 416, 420, 430, 433, 437, 440, 450, 455, 455, 460, 463, 465, 465, 470 At the 0.05 significance level, test the bank manager's claim. The test statistic x is______ The x-critical value is________
Wegmans food stores conducted a study to see how many customers will return to the same...
Wegmans food stores conducted a study to see how many customers will return to the same store in the future. The study showed that 40% of the customers visiting a specific store will return in the future to the same store. Suppose seven customers are selected at random, what is the probability that: (a) Exactly four customers will return? (b) All seven customers will return? (c) At least six customers will return? (d) At least one customer will return? (e)...
How much more is a perpetuity of $1000 worth than an annuity of the same amount...
How much more is a perpetuity of $1000 worth than an annuity of the same amount for 18 years? Assume an interest rate of 8% and cash flows at the end of each period.
How much more is a perpetuity of $1600 worth than an annuity of the same amount...
How much more is a perpetuity of $1600 worth than an annuity of the same amount for 24 years? Assume an annual interest rate of 13% and cash flows at the end of each period. Given annual compounding.
Panera Bread operates more than 1,900 bakery-cafés in more than 45 states and Canada. How many...
Panera Bread operates more than 1,900 bakery-cafés in more than 45 states and Canada. How many of the four tests of the competitive power of a resource does the store network pass? Using your general knowledge of this industry, perform a SWOT analysis. Explain your answers.
Please find how many numbers more than 1,000 and less than 1,000,000 are not multiple of...
Please find how many numbers more than 1,000 and less than 1,000,000 are not multiple of 2, 3, or 5.
How many passwords are possible? Passwords must: be more than 8 characters long but no more...
How many passwords are possible? Passwords must: be more than 8 characters long but no more than 30 Use lower case, upper case, a number, and a special character [like ~ ! @ # $ % ^ & * ( ) _ + = ? > < . , / ] A mathematical expression is fine. What kind of PMF will be used?
A machine purchased 1 year ago for $1055,000 costs more to operate than anticipated. When purchased,...
A machine purchased 1 year ago for $1055,000 costs more to operate than anticipated. When purchased, the machine was expected to be used for 10 years with annual maintenance costs of $32,000 and a $10,000 salvage value. However, last year, it cost the company $38,000 to maintain it, and these costs are expected to escalate to $40,000 this year and increase by $2,000 each year thereafter. The market value is now estimated to be $105,000 − $15,000k, where k is...
A machine purchased 1 year ago for $1055,000 costs more to operate than anticipated. When purchased,...
A machine purchased 1 year ago for $1055,000 costs more to operate than anticipated. When purchased, the machine was expected to be used for 10 years with annual maintenance costs of $32,000 and a $10,000 salvage value. However, last year, it cost the company $38,000 to maintain it, and these costs are expected to escalate to $40,000 this year and increase by $2,000 each year thereafter. The market value is now estimated to be $105,000 − $15,000k, where k is...
How much more is a perpetuity of 1000 worth than an annuity of the same amount for 19 years?
How much more is a perpetuity of 1000 worth than an annuity of the same amount for 19 years? Assume an interest rate of 8% and cash flows at the end of each year.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT