Question
Using Rstudio while using the completejourney library and rather than use the sample transaction data (transactions_sample) we will be using the entire transaction data set
Using Rstudio while using the completejourney library and rather than use the sample transaction data (transactions_sample) we will be using the entire transaction data set provided by get_transactions() and the entire promotions data set provided by get_promotions(). . Lab Question 1: Using the `transactions` and `demographics` data, how many of the transactions do we not have demographic information on? ( 1,469,307 total transactions) 551,289 740,475 640,457 828,850 . Lab Question 2: Using the `transactions` and `demographics` data, compute the total `sales_value` by `age` category. Which age group generates the most sales? 45-54 35-44 65+ 25-34 . Lab Question 3: Identify all households that have total sales (`sales_value`) of $1000 or more. For these households that we do have demographics on, which `income` range produces the most households that spend $1000 or more? 50-74K 125-149K 75-99K 35-49K . Lab Question 4: Using the `promotions` and `transactions` data, compute the total sales for each product displayed in the front of the store (`display_location = 1`). Which `product_id` had the largest total sales. product ID 5569230 with $4,170,653.06 in total sales product ID 5569471 with $5,980,343 in total sales product ID 834117 with $712,442 in total sales product ID 8090537 with $853,679 in total sales . Lab Question 5: Using the `coupons` and `products` data, which `product_category` is related to the coupon where `campaign_id` is equal to 18 and `coupon_upc` is equal to 10000089238? AUTOMOTIVE PRODUCTS SMOKED MEATS HAIR CARE PRODUCTS FRZN MEAT/MEAT DINNER . Lab Question 6: Identify all different products that contain "pizza" in their `product_type` description. Which of these products produces the greatest amount of total sales (compute total sales by product ID and product type)? Group of answer choices Product ID: 10341942; Product type: QSR FD: COLD PIZZA Product ID: 9524291; Product type: PREP FD: PIZZA (COLD) Product ID: 944139; Product type: PIZZA/TRADITIONAL Product ID: 1104475; Product type: PIZZA/SINGLE SERVE/MICROWAVE . Lab Question 7: Identify all products that are categorized as "pizza" (via `product_category`) but are considered a "snack" or "appetizer" (via `product_type`). Which of these products (`product_id`) have the most number of sales (measured by `quantity`)? Product ID 1103105 with total quantity of 276 Product ID 890695 with total quantity of 718 Product ID 845193 with total quantity of 847 Product ID 907631 with total quantity of 632 . Lab Question 8: Identify all products that contain "peanut butter" in their `product_type`. For these products, compute the total `sales_value` by month based on the `transaction_timestamp`. Which month produces the largest total sales value for these products? November with $885.50 in total sales December with $1,013.90 in total sales August with $895.20 in total sales September with $903.17 in total sales . Lab Question 9: Using the `coupon_redemptions` data, filter for the coupon associated with `campaign_id` 18 and `coupon_upc` "10000085475". How many households redeemed this coupon? 63 51 17 101 . Lab Question 10: Following the lab's question 10 instructions which `product_type` resulted in the greatest sales when associated with the stated coupon? ASPARAGUS ORGANIC APPLES CELERY VARIETY LETTUCE
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