Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
From the above Datasets, may I know what kind of Excel Formulas should I use to get the above answers? Provide your answers in the
From the above Datasets, may I know what kind of Excel Formulas should I use to get the above answers? Provide your answers in the yellow highlighted fields of each answer tab.
As clear as possible, please show your workings for your attempts at answering the questions. E.g. usage of formulas, pivot tables
. B 1 Dataset variables Definition 2 grass_region country/ market 3 purchased_on the date which the order was made 4 shopid unique identifier of a shop 5 revenue total revenue of an order the channel which the order was shipped channel_id through 6 each channel has a unique channelid 7 weight weight of the parcel of the order 8 cost_tw_order_paid cost component 9 commission_fee_usd cost component 10 shipping_cost_usd cost component 11 cost_total total cost of an order 12 p_and_ total profit/loss of an order = revenue - cost 13 orderid unique identifier of an order 14 ordersn unique identifier of an order 15 16 A 1 grass_region 2 SG 3 SG 4 SG 5 SG 6 SG 7 SG 8 SG 9 SG 10 SG 11 SG 12 SG 13 SG 14 SG 15 SG 16 SG 17 SG 18 SG 19 SG 20 SG 21 SG 22 SG 23 SG 24 SG B D E F. purchased_on shopid channel id orderid ordersn 19/9/2019 32351807 18015 1832641261 19091922357KIZD 19/9/2019 32351807 18015 1830435004 19091911537D8SV 19/9/2019 32351807 18016 1830598623 19091912387J8JY 19/9/2019 32351807 18016 1830135219 19091910227441K 19/9/2019 32351807 18016 1830405866 19091911457CCBA 19/9/2019 32351807 18015 1832573763 19091922167HGA3 19/9/2019 32351807 18016 1830763614 19091913227Q9PX 19/9/2019 32351807 18016 1829684050 19091906437MVOJ 19/9/2019 32351807 18015 1830376999 19091911367BG57 19/9/2019 32351807 18015 1832651264 19091922387KVOO 19/9/2019 32351807 18016 1832821050 19091923327S1ST 19/9/2019 32351807 18016 1829927594 19091909107V9UA 19/9/2019 32351807 18016 1829469246 19091901287EA7X 19/9/2019 32351807 18016 1830304550 1909191114799D6 19/9/2019 32351807 18015 1832034193 1909191933711CH 19/9/2019 32351807 18016 1830890409 19091913547U5H9 19/9/2019 32351807 18016 1831758267 19091918027Q4FU 19/9/2019 32351807 18016 1832582226 19091922187HRJJ 19/9/2019 32351807 18016 1829995593 19091909367XC89 19/9/2019 32351807 18016 1831616260 19091917177JST4 19/9/2019 32351807 18015 1829896158 19091908567UB4X 19/9/2019 32351807 18016 1829273137 190919000478AQH 19/9/2019 32351807 18016 1829285580 190919000878PVC G H | M revenue weight cost_tw_order_paid commission_fee_usd shipping_cost_usd cost_total p_and_ 79.79294318 6.5 54.30479253 2.51401437 16.64 73.4588069 6.334136282 34.06525488 1.7 19.44009592 1.044504537 8 28.48460046 5.580654425 28.6626452 0.7 17.84664543 0.871621028 4.94 23.65826646 5.004378743 19.91762101 0.2 12.11022369 0.590685325 3.76 16.46090901 3.456711996 37.53733203 2.9 22.27643778 1.159760211 10.9 34.33619799 3.201134041 56.52570418 6.1 34.92843463 1.772055974 16.64 53.34049061 3.185213569 18.93794779 0.2 11.47284349 0.561871406 3.76 15.7947149 3.143232887 20.88288727 0.6 12.74760388 0.626702722 4.7 18.0743066 2.808580667 47.24762249 4.6 30.02060714 1.469509832 13.76 45.25011697 1.99750552 16.3591021 0.8 8.891453707 0.482633131 6.08 15.45408684 0.905015263 9.400540837 0.2 4.748482446 0.259325264 3.76 8.76780771 0.632733127 9.35011648 0.2 4.716613436 0.252121785 3.76 8.728735221 0.621381259 44.11410888 0.3 38.14720461 1.368661118 4 43.51586573 0.598243148 8.651378962 0.1 4.30231631 0.230511346 3.53 8.062827656 0.588551306 21.58882827 1.8 12.36517576 0.648313161 8 21.01348893 0.575339342 15.9701142 0.9 9.528833901 0.468226172 5.41 15.40706007 0.563054131 22.56129801 0.8 16.50814703 0.677127079 5.17 22.3552741 0.206023904 8.118321474 0.2 3.983626213 0.216104387 3.76 7.9597306 0.158590874 9.162826011 0.2 5.067172543 0.244918305 3.76 9.072090848 0.090735164 7.902217087 0.2 3.856150174 0.208900907 3.76 7.825051081 0.077166006 27.31559452 2.6 16.66749207 0.82840015 9.92 27.41589222 -0.1002977 11.15818985 0.6 6.37380194 0.309749621 4.7 11.38355156 -0.22536171 8.118321474 0.4 3.983626213 0.216104387 4.23 8.4297306 -0.311409126 A B Total revenue of SG orders in September 1 2 3 4 4 5 Weight Shipping Cost 6 7 8 19103001151H6GH 19091913243QMMU . B 1 Dataset variables Definition 2 grass_region country/ market 3 purchased_on the date which the order was made 4 shopid unique identifier of a shop 5 revenue total revenue of an order the channel which the order was shipped channel_id through 6 each channel has a unique channelid 7 weight weight of the parcel of the order 8 cost_tw_order_paid cost component 9 commission_fee_usd cost component 10 shipping_cost_usd cost component 11 cost_total total cost of an order 12 p_and_ total profit/loss of an order = revenue - cost 13 orderid unique identifier of an order 14 ordersn unique identifier of an order 15 16 A 1 grass_region 2 SG 3 SG 4 SG 5 SG 6 SG 7 SG 8 SG 9 SG 10 SG 11 SG 12 SG 13 SG 14 SG 15 SG 16 SG 17 SG 18 SG 19 SG 20 SG 21 SG 22 SG 23 SG 24 SG B D E F. purchased_on shopid channel id orderid ordersn 19/9/2019 32351807 18015 1832641261 19091922357KIZD 19/9/2019 32351807 18015 1830435004 19091911537D8SV 19/9/2019 32351807 18016 1830598623 19091912387J8JY 19/9/2019 32351807 18016 1830135219 19091910227441K 19/9/2019 32351807 18016 1830405866 19091911457CCBA 19/9/2019 32351807 18015 1832573763 19091922167HGA3 19/9/2019 32351807 18016 1830763614 19091913227Q9PX 19/9/2019 32351807 18016 1829684050 19091906437MVOJ 19/9/2019 32351807 18015 1830376999 19091911367BG57 19/9/2019 32351807 18015 1832651264 19091922387KVOO 19/9/2019 32351807 18016 1832821050 19091923327S1ST 19/9/2019 32351807 18016 1829927594 19091909107V9UA 19/9/2019 32351807 18016 1829469246 19091901287EA7X 19/9/2019 32351807 18016 1830304550 1909191114799D6 19/9/2019 32351807 18015 1832034193 1909191933711CH 19/9/2019 32351807 18016 1830890409 19091913547U5H9 19/9/2019 32351807 18016 1831758267 19091918027Q4FU 19/9/2019 32351807 18016 1832582226 19091922187HRJJ 19/9/2019 32351807 18016 1829995593 19091909367XC89 19/9/2019 32351807 18016 1831616260 19091917177JST4 19/9/2019 32351807 18015 1829896158 19091908567UB4X 19/9/2019 32351807 18016 1829273137 190919000478AQH 19/9/2019 32351807 18016 1829285580 190919000878PVC G H | M revenue weight cost_tw_order_paid commission_fee_usd shipping_cost_usd cost_total p_and_ 79.79294318 6.5 54.30479253 2.51401437 16.64 73.4588069 6.334136282 34.06525488 1.7 19.44009592 1.044504537 8 28.48460046 5.580654425 28.6626452 0.7 17.84664543 0.871621028 4.94 23.65826646 5.004378743 19.91762101 0.2 12.11022369 0.590685325 3.76 16.46090901 3.456711996 37.53733203 2.9 22.27643778 1.159760211 10.9 34.33619799 3.201134041 56.52570418 6.1 34.92843463 1.772055974 16.64 53.34049061 3.185213569 18.93794779 0.2 11.47284349 0.561871406 3.76 15.7947149 3.143232887 20.88288727 0.6 12.74760388 0.626702722 4.7 18.0743066 2.808580667 47.24762249 4.6 30.02060714 1.469509832 13.76 45.25011697 1.99750552 16.3591021 0.8 8.891453707 0.482633131 6.08 15.45408684 0.905015263 9.400540837 0.2 4.748482446 0.259325264 3.76 8.76780771 0.632733127 9.35011648 0.2 4.716613436 0.252121785 3.76 8.728735221 0.621381259 44.11410888 0.3 38.14720461 1.368661118 4 43.51586573 0.598243148 8.651378962 0.1 4.30231631 0.230511346 3.53 8.062827656 0.588551306 21.58882827 1.8 12.36517576 0.648313161 8 21.01348893 0.575339342 15.9701142 0.9 9.528833901 0.468226172 5.41 15.40706007 0.563054131 22.56129801 0.8 16.50814703 0.677127079 5.17 22.3552741 0.206023904 8.118321474 0.2 3.983626213 0.216104387 3.76 7.9597306 0.158590874 9.162826011 0.2 5.067172543 0.244918305 3.76 9.072090848 0.090735164 7.902217087 0.2 3.856150174 0.208900907 3.76 7.825051081 0.077166006 27.31559452 2.6 16.66749207 0.82840015 9.92 27.41589222 -0.1002977 11.15818985 0.6 6.37380194 0.309749621 4.7 11.38355156 -0.22536171 8.118321474 0.4 3.983626213 0.216104387 4.23 8.4297306 -0.311409126 A B Total revenue of SG orders in September 1 2 3 4 4 5 Weight Shipping Cost 6 7 8 19103001151H6GH 19091913243QMMUStep by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started