1. With the above raw dataset, create the code to provide the following output: Sales Figures Total Unit Sales for Stand 1 was 92 Total Unit Sales for Stand 2 was 85 Total Unit Sales for Stand 3 was 72 Total Unit Sales for Stand 4 was 63 Total Unit Sales for Stand 5 was 60 Total Unit Sales for Stand 6 was 55 Total Unit Sales for Stand 7 was 50 Total Unit Sales for Stand 8 was 49 Total Unit Sales for Stand 9 was 45 Total Unit Sales for Stand 10 was 31 2. Now create the code that will provide the following output: Sales Figures Total Unit Sales for Stand 1 was 31 Total Unit Sales for Stand 2 was 45 Total Unit Sales for Stand 3 was 49 Total Unit Sales for Stand 4 was 50 Total Unit Sales for Stand 5 was 55 Total Unit Sales for Stand 6 was 60 Total Unit Sales for Stand 7 was 63 Total Unit Sales for Stand 8 was 72 Total Unit Sales for Stand 9 was 85 Total Unit Sales for Stand 10 was 92 3. Now create a new cell that can search through the entire unsorted raw data set from the beginning to the end until it finds the sales value of "92". Once it finds this sales value, you will print out the bubble tea stand number as the position in the data set (i.e. you will print out the 1* or 2nd or 3d. or 10th hot dog stand with the sales value of "92"). Note: Your program should be robust enough to search for any duplicate level of sales as well.
1. With the above raw dataset, create the code to provide the following output: Sales Figures Total Unit Sales for Stand 1 was 92 Total Unit Sales for Stand 2 was 85 Total Unit Sales for Stand 3 was 72 Total Unit Sales for Stand 4 was 63 Total Unit Sales for Stand 5 was 60 Total Unit Sales for Stand 6 was 55 Total Unit Sales for Stand 7 was 50 Total Unit Sales for Stand 8 was 49 Total Unit Sales for Stand 9 was 45 Total Unit Sales for Stand 10 was 31 2. Now create the code that will provide the following output: Sales Figures Total Unit Sales for Stand 1 was 31 Total Unit Sales for Stand 2 was 45 Total Unit Sales for Stand 3 was 49 Total Unit Sales for Stand 4 was 50 Total Unit Sales for Stand 5 was 55 Total Unit Sales for Stand 6 was 60 Total Unit Sales for Stand 7 was 63 Total Unit Sales for Stand 8 was 72 Total Unit Sales for Stand 9 was 85 Total Unit Sales for Stand 10 was 92 3. Now create a new cell that can search through the entire unsorted raw data set from the beginning to the end until it finds the sales value of "92". Once it finds this sales value, you will print out the bubble tea stand number as the position in the data set (i.e. you will print out the 1* or 2nd or 3d. or 10th hot dog stand with the sales value of "92"). Note: Your program should be robust enough to search for any duplicate level of sales as well.
Chapter8: Working With Advanced Functions
Section: Chapter Questions
Problem 4.4CP
Related questions
Question
100%
PLEASE DO THIS IN PYTHON 3
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L