Based on the image attached,a. Complete problem analysis (Input, process, and Output) in a table.b. Pseudocode*Help me with a detailed solution. Thank you in advance. for theST01302 Coffee Shopcustomer places an order, aprovideclerk asks for the customer's zipDesigntocustomer marketaprogramsomeresearch data. When acodeandage.The clerk entersthat datawellthe number of items theasasorders. The programa 0 forinvalid zip code (morethan 110), thecustomeroperates continuously untiltheclerkenterszip code at the end of the day. When the clerk entersinvalid ageanthan5 digits) or(defined as lessthan 10 oranmorethe clerk continuously. Whenmore than 12 items, the program reprompts the clerk twoprogram repromptstheclerkentersfewerthan1ormore times. If the clerkentersa high value on the third attempt, the program accepts the high value, but ifthe clerk enters a negative value on the third attempt, an error message is displayedand the order is not counted. At the end of the program, display acount of thethe coffee shopnumber of items ordered by customers from the same zip codefrom other zip codes.as(54984), andcountAlso display the averagecustomeraageas well ascounts of the number of items ordered by customers under 30 and bycustomers 30 and older.

Answered: Image /qna-images/answer/7dc7cda9-e30a-4bbc-bef1-603df240dcad.jpg

program for the research data. When a Coffee Shop provide clerk asks for the customer's zip Design ST01302 to customer market a some customer places an order, a code and age. The clerk enters that data well as the number of items the as customer orders. The program operates continuously until the clerk enters 0 for a zip code at the end of the day. When the clerk than 5 digits) or invalid zip code (more than 110), the enters an invalid age (defined as less than clerk continuously. an 10 or more program reprompts the more than 12 items, the program reprompts the clerk two When the clerk enters fewer than 1 or more times. If the clerk enters a high value the third attempt, the program accepts the high value, but if on the clerk enters a negative value on the third attempt, an message is displayed error and the order is not counted. At the end of the program, display a count of the number of items ordered by customers from the same zip code as the coffee shop (54984), and count from other zip codes. Also display the average customer age a as well counts of the number of items ordered by customers under 30 and by as customers 30 and older.

program for the research data. When a Coffee Shop provide clerk asks for the customer's zip Design ST01302 to customer market a some customer places an order, a code and age. The clerk enters that data well as the number of items the as customer orders. The program operates continuously until the clerk enters 0 for a zip code at the end of the day. When the clerk than 5 digits) or invalid zip code (more than 110), the enters an invalid age (defined as less than clerk continuously. an 10 or more program reprompts the more than 12 items, the program reprompts the clerk two When the clerk enters fewer than 1 or more times. If the clerk enters a high value the third attempt, the program accepts the high value, but if on the clerk enters a negative value on the third attempt, an message is displayed error and the order is not counted. At the end of the program, display a count of the number of items ordered by customers from the same zip code as the coffee shop (54984), and count from other zip codes. Also display the average customer age a as well counts of the number of items ordered by customers under 30 and by as customers 30 and older.

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter5: Working With Multiple Worksheets And Workbooks

Section: Chapter Questions

Problem 4AYK

See similar textbooks

Similar questions

dont copy else downvote
Perform the given task.
You recently got a job as a library assistant. You are assigned to sort an archive of files. Files are marked by how old they are by years and you need to put the most recent files on the left.Here’s the stack of files- File 5 File 20 File 9 File 15 File 13 File 25 File 50 File 45 File 40 File 35 Which sorting algortihm would you use and why? The Head librarian handed you a file labeled as File 30. He told you, “I don’t care where other files are, just put this file in its place.” Use an algorithm to insert the file in the right place.
USING GITBASH SHELL SCRIPT Find the even multiples of any number chosen by the user in a given range – the usershould specify the multiples of which number they want to print and a minimum and maximumvalue. The multiples printed should be within the [minimum, maximum] range. For example, ifthe user choses the number 7 and would like to print all even multiples in the [15, 60] range, theprogram should print all the even multiples that are bigger than or equal to 15 (minimum), butsmaller than or equal to 60 (maximum). The program should keep a count of how many numberswere printed and should output that count, as well as the numbers. The output then, for theexample given, should be 28, 42, 56, and the count should be 3. So l wrote this code as shown by the screenshot and now l want to write the same code using functions this is the code GNU nano 5.9…
USING GITBASH SHELL SCRIPT Find the even multiples of any number chosen by the user in a given range – the usershould specify the multiples of which number they want to print and a minimum and maximumvalue. The multiples printed should be within the [minimum, maximum] range. For example, ifthe user choses the number 7 and would like to print all even multiples in the [15, 60] range, theprogram should print all the even multiples that are bigger than or equal to 15 (minimum), butsmaller than or equal to 60 (maximum). The program should keep a count of how many numberswere printed and should output that count, as well as the numbers. The output then, for theexample given, should be 28, 42, 56, and the count should be 3. So l wrote this code as shown by the screenshot and now l want to write the same code using a different alternative like functions or the for loop not the while loop this is the code GNU nano 5.9…
In The Readline Technique, on page 179, you learned how to read somefiles from the Time Series Data Library. In particular, you learned aboutthe Hopedale data set, which describes the number of colored fox fur peltsproduced from 1834 to 1842. This file contains one value per year perline.a. Write an outline in English of the algorithm you would use to readthe values from this data set to compute the average number of peltsproduced per year.b. Translate your algorithm into Python by writing a function namedhopedale_average that takes a filename as a parameter and returns theaverage number of pelts produced per year.
New Jave code must be entered inbetween grey blocks of code as seen in photo
In the Happy Valley School System, children are classified by age as follows: less than 2, ineligible2, toddler3-5, early childhood6-7, young reader8-10, elementary11 and 12, middle13, impossible14-16, high school17-18, scholargreater than 18, ineligible Given an int variable age , write a switch statement that prints out the appropriate label from the above list based on age
Task 4 Get Binary 2: For task 4 Implement the get_bin_2 function as directed in the comment above the function. If the directions are unclear, run the code, and look at the expected answer for a few inputs. For your solution, you should refer to your solution for Task 2 to get the general idea for Task 4, and you should use largest_po2_le in your solution (think about why this might be useful in terms of the binary representation). Make sure you build the string for 0 and negative numbers correctly. The same restrictions apply from Task 2. Code#include <stdio.h>#include <stdbool.h>#include <stdlib.h> // BEGIN STRINGBUILDER IMPLEMENTATION // This code is a very rudimentary stringbuilder-like implementation// To create a new stringbuilder, use the following line of code//// stringbuilder sb = new_sb();//// If you want to append a character to the stringbuilder, use the// following line of code. Replace whatever character you want to// append where the 'a' is.////…
Given integer inputs seed, how_many, and max_num, generate a list of how_many unique random integers from 0 to max_num (inclusive). 1. Complete function unique_random_ints(how_many, max_num): a. Generate a list of how_many random integers from 0 to max_num (inclusive). b. When a random number exists in the list, a new random number must be generated; use a global variable, retries, to count the number of times an existing number is generated. c. Return the list. 2. Complete __main__: a. Initialize the random module with the seed value. b. Call unique_random_ints() to get a list of random integers. c. Output the list of random integers and the value of retries, according to the output format shown in the example below. Refer to the section on the standard library to learn more about the random module and pseudo-random numbers. Ex: If the input is: 257 the output is 0 1 5 2 4 retries=1 import random def unique_random_ints(how_many, max_num):…
Java Program Make a code about clicking a row in the jTable displays a message with phrase “Are you sure you want to delete the [display name of selected product]?” and Yes and No button. If the button yes is clicked, the selected row in jTable is deleted and updates the total bill.
Given integer inputs seed, how_many, and max_num, generate a list of how_many unique random integers from 0 to max_num (inclusive). Complete function unique_random_ints(how_many, max_num): Generate a list of how_many random integers from 0 to max_num (inclusive). When a random number exists in the list, a new random number must be generated; use a global variable, retries, to count the number of times an existing number is generated. Return the list. Complete __main__: Initialize the random module with the seed value. Call unique_random_ints() to get a list of random integers. Output the list of random integers and the value of retries, according to the output format shown in the example below. Ex: If the input is: 2 5 7 the output is 0 1 5 2 4 retries=1