F49. 1. Count the number of Products where Price is lessthan 500.2. If the Total Amount is above 1000 display "Overthe Budget!", otherwise "Within the Budget!"3.Get the average Price of the Products with aQuantity equivalent to two (2).4. Total Price of the Products that end with the letter665.⁹⁹.2 Respondent31425364758678991011121314A151617101112131415BLEGEND:Age442234245565422125415460232830181920 HypoglycemiaNormal Blood Sug2122HyperglycemiaDiabetes23CBlood Glucose SurveyGlucose Level707514580160185100909512513518099115132DStatusNormal Blood SugarNormal Blood SugarBelow 70 mg/dLBetween 70mg/dt-140 mg/dlBetween 140mg/dL-180 mg/dLAbove 180 mg/dl.The following survey is conducted to identify theglucose level (mg/dL) from the different ages. Thefollowing should be identified through the use of excelfunctions:3.2. Look for the Glucose Level of Respondent 6.3. Count the number of Respondents with theGlucose Level above 100.4. The total number of Respondents whose Age isabove 30 years old.4.1.2.3.1. The equivalent Status of the following Glucose 4.Level. (Please do check the Legend Below)

Start. Initialize the variables. Read the inputs. Perform the operations. Print the output. Exit.

Answered: F49. | bartleby

Engineering

Computer Science

F49.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter1: Getting Started With Excel

Section: Chapter Questions

Problem 17RA

See similar textbooks

Related questions

Q: What is the read position of a file? What is the beginning of the first read in a file?

A: A file is the common storage unit in a computer and all programs and data are written into a file…

Q: What are the disadvantages of Big Data innovations for the general public?

A: Big Data Big data proposes too titanic or complex data sets to oversee data dealing with the…

Q: Give some instances of how information system principles operate.

A: Information System principles: User involvement, user control, interface design, information…

Q: After writing and testing each module individually, it is important to combine and test them…

A: The which means of Integration testing is sort of straightforward- Integrate/combine the unit tested…

Q: Why is it necessary in computer science to cleanse our data?

A: Analysis of the issue: The foundations of machine learning's data cleaning are the basis for the…

Q: You are notified through email from your company's mail server that your password has been changed,…

A: The answer is given in the below step

Q: Paper ID Title 27 loT Real-Time Car Traffic Flow Counter for Smart Traffic Light System Raspberry…

A: The answer is given below.

Q: Why maintain a Master file with mostly permanent information?

A: Given: What is the purpose of a master file containing largely permanent data?

Q: What is a distributed denial-of-service assault, even if one individual cannot orchestrate one?

A: Definition Multiple computers assault a single target in a DDoS attack. DDoS attackers typically…

Q: What is the exact difference between Repository and Data Dictionary?

A: Simply said, a repository is a centralised location for the upkeep and storage of data. A Data…

Q: vDefine distributed systems and their constituent parts. Provide an illustration of the significant…

A: illustration Definition: 1: An example that provides as a starting point. a: a drawing or diagram…

Q: Include at least five advantages of using cascading style sheets in your work.

A: Cascading Style Sheets' Advantages easier to update and manage. more uniformity in the design.…

Q: solutions all Input 35H into the accumulator, followed by output to the B register. Exercise 2:…

A: Given: It's time to get down to the assembly language programming of- Insert 35H into the…

Q: What do you specifically mean by "Data Purging"?

A: The answer to the question is given below:

Q: How can you distinguish between primary and secondary memory

A: Please find the answer below :

Q: What does "Big Data" entail? In what ways are big data and conventional data distinct?

A: Big Data Big data is vast data that can increase rapidly over time. Since the 1990s, this technology…

Q: How can a systems analyst guarantee that the basis for system design is solid?

A: A system analyst is responsible for determining the system requirements and performing an in-depth…

Q: Describe how you regularly use databases or programmes that utilise databases in your daily life.…

A: answer is

Q: Where can I locate a list of the dictionary's entries?

A: The data dictionary's what? Data dictionary may be defined as follows.

Q: In other words, what exactly is "Big Data"? What are the greatest benefits of Big Data for…

A: The definition of Big Data is data that contains more variety, increases in quantity, and arrives at…

Q: Why is the Waterfall methodology superior to Agile when developing a system for university course…

A: Waterfall Model: A serial model example is the waterfall model. In this approach, the computer code…

Q: Describe the basic premise of test-driven development, the goals of this approach, and when this…

A: According to the company's policy, we are allowed to answer only one question at a time. Kindly…

Q: What capabilities does a desktop operating system possess?

A: Desktop Operating System: The environment through which a user manages a personal computer is called…

Q: Explain in three pages the differences between variables and properties.

A: Given: Variables Properties Variables: A variable is a term used to identify a location in memory…

Q: Expert systems are retrieval systems able to simulate human cognitive powers. Write a short comment…

A: The correct answer for the above mentioned question is given in the following steps for your…

Q: 10 11 12 13 14 15 16 17 18 19 20 21 2872858 23 24 26 P 1 KB 2 KB 4 KB 8 KB VPN bits Number of VPO…

A: 1KB : - Page size = 1KB = 2^10 Bytes hence 10 bits are used as offset bits. So, VPO = PPO = 10 bits…

Q: What opportunities exist for guaranteeing data security at the level of the field

A: Please find the answer below :

Q: What is the npm package exactly? Explain what you mean using your own words

A: Answer :

Q: What precisely is a meeting? What are the many types of gatherings? Describe the assembly's numerous…

A: Meeting :- A meeting is when two or more people come together to discuss one or more topics, often…

Q: Why, despite its simplicity and beauty, is a file so powerful?

A: Given: Because it enables one to write extremely big and very tiny integers fast and compactly, the…

Q: To comprehend RAID 5, we must first comprehend what it is. In what circumstances should RAID 5 be…

A: Definition: What is RAID 5 and how does it operate in light of this? What conditions would make it…

Q: Is it vital to have a Master file since it contains so much long-term information?

A: Long-term data: Long-term data storage refers to the permanent and long-lasting preservation of…

Q: Assume the Circularly Linked List as follows, please write a code to insert the new data node into…

A: In this question we need to write a program to insert an element in a circular linked list.

Q: Exist several types of information systems? If so, who utilises them and why?

A: Primary varieties of information systems include: Information system for management decision-making…

Q: How is a mainframe operating system different from a PC operating system?

A: Mainframe computer: It is used in huge businesses that process massive amounts of data that cannot…

Q: Many businesses now use big data. Describe how and why it is used inside the organization.

A: Big Data Big data suggests too colossal or complex data sets to manage data taking care of the…

Q: What does "Big Data" entail? In what ways are big data and conventional data distinct?

A: The characteristics of big data can be summed up as follows: Massive data: Big data is a large…

Q: How can Big Data provide a competitive advantage?

A: Introduction: Big Data Big data is a vast collection of information that has increased rapidly over…

Q: List several technological advances in computing that made computers now smaller, powerful while…

A: There are several technological advancements in computing that made the computer smaller, powerful…

Q: In other words, what exactly is "Big Data"? What are the greatest benefits of Big Data for…

A: Introduction In this question, we are asked, what exactly is "Big Data" and What are the greatest…

Q: What makes the notion of a file so captivating, despite the fact that it is simple and aesthetically…

A: Introduction: You need a file format in order to store data on your computer. It explains the use of…

Q: What is the function of a Master file containing mostly permanent information?

A: What is the purpose of a master file mainly containing permanent data? Solution: A master file is a…

Q: Assume that your company's mail server has given you a message informing you that your password has…

A: Definition: Phishing attacks are a type of virus that target passwords. The attacker receives…

Q: What is the difference between logical and physical file descriptions?

A: 1)Physical File vs 2) Logical File 1) It occupies the portion of memory. It contains the original…

Q: 01.

A: Here, Given regular language is L= { 0,000,00000........} Odd number of zeros

Q: ecome so commonplace in data and processing model

A: Introduction: Data flow diagrams (DFDs) are a graphical technique for summarising data movement…

Q: What can you do to maintain your informant's confidence?

A: A person who gives crucial information on a person or group to an agency is known as an informer or…

Q: What is the difference between SSL and TLS? As far as I can determine, they are equivalent. Could…

A: SSL: Earlier Secure Sockets Layer technology, which incorporates domain name and browser,…

Q: What are the functions and operation of an operating system in a computer system?

A: Operating system is a system software which manages the computer software and hardware resources by…

Question

F49.

1. Count the number of Products where Price is less
than 500.
2. If the Total Amount is above 1000 display "Over
the Budget!", otherwise "Within the Budget!"
3.Get the average Price of the Products with a
Quantity equivalent to two (2).
4. Total Price of the Products that end with the letter
665.⁹⁹.
2 Respondent
3
1
4
2
5
3
6
4
7
5
8
6
7
8
9
9
10
11
12
13
14
A
15
16
17
10
11
12
13
14
15
B
LEGEND:
Age
44
22
34
24
55
65
42
21
25
41
54
60
23
28
30
18
19
20 Hypoglycemia
Normal Blood Sug
21
22
Hyperglycemia
Diabetes
23
C
Blood Glucose Survey
Glucose Level
70
75
145
80
160
185
100
90
95
125
135
180
99
115
132
D
Status
Normal Blood Sugar
Normal Blood Sugar
Below 70 mg/dL
Between 70mg/dt-140 mg/dl
Between 140mg/dL-180 mg/dL
Above 180 mg/dl.
The following survey is conducted to identify the
glucose level (mg/dL) from the different ages. The
following should be identified through the use of excel
functions:
3.
2. Look for the Glucose Level of Respondent 6.
3. Count the number of Respondents with the
Glucose Level above 100.
4. The total number of Respondents whose Age is
above 30 years old.
4.
1.
2.
3.
1. The equivalent Status of the following Glucose 4.
Level. (Please do check the Legend Below)

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions

Saira owns a small business and she frequently makes transactions. Sometimes she makes payments and other times payments are credited in her account. One of her customer Tania purchased a product and credited payment while another payment by Saira was in progress. Now the sequence of transaction is as follows:1. Tania’s account read amount in saira’s account2. Saira’s account read amount in saira’s account3. Tania added Rs. 500/- in original amount (that was lets suppose Rs. 60,000/ 4. Saira’s account subtracted Rs. 2000/- that she debited in someone else’s account form the original amount (that was Rs. 60,000) 5. Tania’s account committed the transaction 6. Saira’s account committed the transaction Draw the above-mentioned sequence in form of a table and see if there is a problem. What this problem is called and how can we avoid such kind of problem? Propose some solutions (at least two) and then explain which one is better and why?
Suppose it is 4:00 p.m., September 29, 2008. Fitter Snacker’s CEO sends this e-mail message to the accounting manager: “I need to meet with the Board of Directors tomorrow morning. The Board members are concerned about the current sales of our energy bars. They would like to see sales data for today, 9/29, as a typical day. Please complete the attached report and have it on my desk by 9:00 a.m. tomorrow, September 30.” The blank table shown in Figure 1 is attached to the memo. Given the company’s sales order data-processing practices, why won’t the accountants be able to easily accomplish this task? Cite the practices that cause difficulty, and explain. If FS had an ERP system, why would this task be easy to complete?
From worksheet Laptop, in cell I5, find the category if : 600 < Price <=1030 then Category is “C1” 500< Price <= 600 then Category is “C2” 400< Price <=500 then Category is “C3” Price <=400 then Category is “C4” Replicate the formula to the cell range I6:I13.
SeriResort has four type of room packages, The rate for each package is shown in the following table: Type of Package Code Rate Per Day (RM) Premium 1 300 Family 2 200 Deluxe 3 150 Standard 4 100 Each guest has to pay 10% SST. The information needed to make a reservation at the resort are the guest’s name, type of package, number of days and type of booking (o – online, M – Manual). A discount of 10% will be given for online booking For each reservation, a receipt must be printed as shown below: SERI RESORT Guest Name xxxxxxxxxxxxxxx Type of Package xxxxxxxxxxxxx Number of Days xx Total Charges (RM) : xxx.xx SST 10% (RM) : xxx.xx Total Payment : xxxxx.xx Draw a flowchart to solve the given.
Which of these statements is equivalent to ∀x,y,z. American (x) ∧ Product(y) ∧ HostileCountry(z) ∧ Buy(x,y) ∧ MadeIn(y,z) → Criminal(x) ? Select one: a. Americans are criminal if they buy hostile products from countries. b. Americans are criminals if they buy any hostile products from any country. c. It is a crime for a American to buy products from a hostile nation.
Please show working for both Thanks
The following list shows the items and prices for a restaurant order. Calculate the total amount if there is 7.5% tax and the customer leaves a 15% gratuity. 1 appetizer: $8.99 2 entrees: $14.99 each 1 entree: $12.99 3 drinks: $1.99 each a. $70.96 b. $71.62 c. $75.31 d. $75.97 Please select the best answer from the choices provided A Mark this and retum No hand written and fast answer with explanation
A school has 100 lockers and 100 students. All lockers are closed on the first day of school. As the students enter, the first student, denoted as S1, opens every locker. Then the second student, S2, begins with the second locker, denoted as L2, and closes every other locker. Student S3 begins with the third locker and changes every third locker (closes it if it was open and opens it if it was closed). Student S4 begins with locker L4 and changes every fourth locker. Student S5 starts with L5 and changes every fifth locker, and so on, until student S100 changes L100. After all the students have passed through the building and changed the lockers, which lockers are open? Write a program to find your answer and display all open locker numbers separated by exactly one space. (Hint: Use an array of 100 Boolean elements, each of which indicates whether a locker is open (true) or closed (false). Initially, all lockers are closed.)
CREATE OR REPLACE PROCEDURE PROCUNO ( W_ID IN NUMBER ) W_FLAG W TAX W MSG NUMBER : = 0 ; NUMBER : = 0 ; NUMBER : = 0 ; STRING ( 20 ) : = " ; BEGIN SELECT COUNT ( * ) INTO W_FLAG FROM COMPRA WHERE COMPRA_ID - W_ID ; W_TAX : - W_X * 0.115 ; IF W_FLAG = 1 THEN SELECT SUM ( CANTIDADCOMPRADA * PRECIO ) INTO W_X FROM PRODUCTO_COMPRADO WHERE PRODUCTO COMPRADO.COMPRA_ID = W_ID ; UPDATE COMPRA SET COMPRA_X = W_X , ELSE WHERE COMPRA_ID = W_ID ; W_MSG : = ' mensajel " ; END IF ; COMPRA_TAX = W_TAX , COMPRA_TOTAL = W_X + W_TAX W_MSG : = ' mensaje2 ' ; END ;
Some rows of the STUGRADE table of a school are shown below: STU_CODE CLS_CODE GRADE YEAR 291 111 3.1 2010 938 101B 2.3 2011 931 M101 3.3 2040 291 M101 3.4 2018 190 111 2.0 2021 931 321 3.9 2003 Suppose that STU_CODE is the student code (foreign key) and CLS_CODE is the class code (foreign key). Which of the following computes the average for each year of the student with code 931? a. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931 GROUP BY YEAR b. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931. c. SELECT AVG(GRADE) FROM STUGRADE GROUP BY STU_CODE = 931 d. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931 GROUP BY AVG(GRADE)
What would the code be for a limit order to buy 2300 shares of Hewlett Packard stock (ticker symbol: HPQ) at $320.00 a share, but only if the order can be filled in the two days?
The following two SQL statements will produce the same results. SELECT P_DESCRIPT, P_QOH,P_PRICE FROM PRODUCT WHERE P_QOH >(SELECT P_QOH FROM PRODUCT WHERE P_CODE='11QER/31') AND P_PRICE>(SELECT P_PRICE FROM PRODUCT WHERE P_CODE='11QER/31'); SELECT P_DESCRIPT, P_QOH,P_PRICE FROM PRODUCT WHERE (P_QOH,P_PRICE) > (SELECT P_QOH,P_PRICE FROM PRODUCT WHERE P_CODE='11QER/31'); A) True B) False