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.

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter8: Working With Advanced Functions
Section: Chapter Questions
Problem 4.4CP
icon
Related questions
Question
100%

PLEASE DO THIS IN PYTHON 3

sales = [45, 49, 55, 63, 31, 92, 60, 85, 72, 50]
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
1s* or 2nd or 3rd. 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.
Transcribed Image Text:sales = [45, 49, 55, 63, 31, 92, 60, 85, 72, 50] 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 1s* or 2nd or 3rd. 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.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Function Arguments
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L