Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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_2

Step: 3

blur-text-image_3

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

Microsoft Visual Basic 2017 For Windows Web And Database Applications

Authors: Corinne Hoisington

1st Edition

1337102113, 978-1337102117

More Books

Students also viewed these Databases questions