Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
Using Rstudio while using the completejoumey 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 completejoumey library and rather than use the sample transaction data (transactions_sample) we will be using the entire transaction data set provided by pet_transactions(i) and the entire promotions dota set provided by get_promotionsi). Lab Question I Using the 'transactions' and 'demographies" data, how many of the trantactions do we not have demographic Lab Question 2. Wsing the "Iransactions" and 'demographics' data, compure the total 'sales_value' by age' categary. Which age group denerates the most sales? 4554 3544 65+ 25-34 Lab Cuestion 3: identify all houscholds that haro total sales ('saies_value ' of $1000 or more. For these households that we do heve demograptics cn, which 'income' range produces the mest households that spend $1000 ar more? 6074K 125140x 75-99 3549k. 'Lab Question 4: Using the 'promotions' and 'tramsactions' data, compute the total sales for exch product dinplayed in the front of the store ('display Jocation w 1'2. Which 'product_id' had the largost total sales. product ID 5569230 with 54,170,653.06in total sales product ID 5569471 with $5,980,343 in total sales product ID a34117 with 5712,442 in total sales product 10 8090537 with 5853,679 in total sales Lab Question 5: Using the "coupons' and 'products' data, which "product_category" is rolated to the coupon where "campaign_id' is equal to 18 and 'coupon_upe' is equal to 100000902387 AUTOMOTIVE PRODUOTS 5WOKED MEATS HAR CARE PRODUCTS FRZN MEATMAEAT DINENEA Lab Question 6: identify all different products that contain "pizza" in their 'product_type' description. Which of these groducts produces the greatest amount of total sales icompute total salus by product in and product typen? Group of answer choices Product 10: 1034 1942; Product type QSA FD: COLD PR2ZA Product io: 9624291; Product type: PREP FO: Pizza (COL.D) Product ID: 944139, Product type: PIZZAIRAOIIONAL. Product 10: 1104475, Product type: PAZzNSINGLE SERVEMICROWAVE Using Rstudio while using the completejoumey library and rather than use the sample transaction data (transactions_sample) we will be using the entire transaction data set provided by pet_transactions(i) and the entire promotions dota set provided by get_promotionsi). Lab Question I Using the 'transactions' and 'demographies" data, how many of the trantactions do we not have demographic Lab Question 2. Wsing the "Iransactions" and 'demographics' data, compure the total 'sales_value' by age' categary. Which age group denerates the most sales? 4554 3544 65+ 25-34 Lab Cuestion 3: identify all houscholds that haro total sales ('saies_value ' of $1000 or more. For these households that we do heve demograptics cn, which 'income' range produces the mest households that spend $1000 ar more? 6074K 125140x 75-99 3549k. 'Lab Question 4: Using the 'promotions' and 'tramsactions' data, compute the total sales for exch product dinplayed in the front of the store ('display Jocation w 1'2. Which 'product_id' had the largost total sales. product ID 5569230 with 54,170,653.06in total sales product ID 5569471 with $5,980,343 in total sales product ID a34117 with 5712,442 in total sales product 10 8090537 with 5853,679 in total sales Lab Question 5: Using the "coupons' and 'products' data, which "product_category" is rolated to the coupon where "campaign_id' is equal to 18 and 'coupon_upe' is equal to 100000902387 AUTOMOTIVE PRODUOTS 5WOKED MEATS HAR CARE PRODUCTS FRZN MEATMAEAT DINENEA Lab Question 6: identify all different products that contain "pizza" in their 'product_type' description. Which of these groducts produces the greatest amount of total sales icompute total salus by product in and product typen? Group of answer choices Product 10: 1034 1942; Product type QSA FD: COLD PR2ZA Product io: 9624291; Product type: PREP FO: Pizza (COL.D) Product ID: 944139, Product type: PIZZAIRAOIIONAL. Product 10: 1104475, Product type: PAZzNSINGLE SERVEMICROWAVE
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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