Q-1 OVERVIEWBody mass index (BMI) is a value derived from the mass (weight) and height of a person. The BMIis defined as the body mass divided by the square of the body height, and is expressed in units of kg/m2,resulting from mass in kilograms and height in meters. The BMI may be determined using a table or chartwhich displays BMI as a function of mass and height using contour lines or colors for different BMIcategories, and which may use other units of measurement (converted to metric units for thecalculation). The BMI is a convenient way for classifying persons in to 4 categories based the BMI valueas shown the following table:BMI valueCategoryLess than 18.5Underweight18.5 to less than 25Normal25 to less than 30Overweight30 or higherObeseA national study in some country to analyze the BMI of the people in the country is considered. In thisstudy, a set of cities is selected in the study and randomly specific number of persons are selected tocheck the BMI category of each one.Implement a java project to help in the study analysis with the following steps:Read from the user the number of cities (minimum 6 cities.)For each city: city name and the number of persons (minimum 10 persons) are entered.For each person in a city: mass and height should be entered, BMI and BMI category have to becomputed and printed.For each city, the number of persons and percent ratio in each BMI category should be computedand printed.Finally, the program should print a summary report with the following details:Number of cities.Total number of persons and percent ratio of persons in each BMI category in all cities.The name of the best city which has the maximum percent of persons in normal weightBMI category and these people's percent ratio.The name of the worst city which has the maximum percent of persons in obese BMIcategory and these people's percent ratio.The name of the city which has the minimum percent of persons in underweight BMIcategory and these people's percent ratio.

To Desing this system we can define the classes City and Person as given in below: Note:I have…

Answered: Body mass index (BMI) is a value…

Body mass index (BMI) is a value derived from the mass (weight) and height of a person fined as the body mass divided by the square of the body height, and is expressed in units

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter6: Managing Multiple Worksheets And Workbooks

Section: Chapter Questions

Problem 4.4CP

See similar textbooks

Similar questions

P1 - Loan Payment Schedule Main Street Bank is offering an annual interest rate discount based on the client’s credit score. The discount for each credit score level is provided in the table below. The lowest credit score is 300 while the highest credit score is 850. For example, the new interest rate for a client with a credit score of 755 and a current interest rate of 4.25% would be 4.25 – 0.75 = 3.50% interest rate Credit Score Rating Interest Rate Discount 300 - 579 Very Poor 0.00 580 – 669 Fair 0.25 670 - 739 Good 0.50 740 - 799 Very Good 0.75 800 - 850 Exceptional 1.00 Use modular programming concepts Create a program that includes a WHILE loop to generate a payment schedule for loans that are paid in equal monthly payments Input the loan number and retrieve required loan account from MS_LOANS table Output is shown below Monthly interest is calculated by dividing the yearly interest rate by 12 to get a monthly interest…
In an annual charter day celebration of a university, one of the highlights of its celebration is having a concert for a cause in which national personalities were invited. The student body assigned for the conduct of the event, sold tickets for their fund raising for a cause. Tickets are sold according to the following prices. The green ticket is sold at $20, orange ticket at $30 and white ticket at $40. All students of the university are encouraged to support the said event, however the venue could only accommodate 1500 people. Write a Nassi-Shneiderman diagram that determines the total amount of money that will be generated if all tickets are all sold out and likewise print the total money collected.
In an annual charter day celebration of a university, one of the highlights of its celebration is having a concert for a cause in which national personalities were invited. The student body assigned for the conduct of the event, sold tickets for their fund raising for a cause. Tickets are sold according to the following prices. The green ticket is sold at $20, orange ticket at $30 and white ticket at $40. All students of the university are encouraged to support the said event, however the venue could only accommodate 1500 people. Write an algorithm in pseudocode, a flowchart and NS diagrams that determines the total amount of money that will be generated if all tickets are all sold out and likewise print the total money collected.
Student Companion ™ is your personal academic guide that provides the following basic information for each course while a student at the USC. Courses done, grades earned, Course outline attachments, course notes etc.This is a simple application to keep track of each course you are doing/have done and can serve as a personal test timetable for the course which has final quiz, keep track of your courses that have etc. The concept is like a personal check sheet system blended with a simple quiz timetable. This also solves a problem that often shows up when students have completed their program and need to revert back to data pertaining to their academic life from their viewpoint. Please note this does not replace a transcript, which is an official University Document. 1. Create a Class Diagram of at least six (6) major entities for your application. For entities with a large number of attributes you are allowed to limit your attributes to a max of six (6). All operations within each class…
Order Number: 5678 Customer Number: 9123 Customer Name: Thomas Customer Address: 51 Samora Machel Street City- Country: Durban, South Africa ProductNo A 123 B 234 C 345 Description A4 Paper Order Form Toner Staples Normal Form Quantity 100 200 1000 Date: 25/12/2020 Unit Price R1.00 R150.00 R5.00 1.1 Using normalization principles, depict the ONF, 1NF, 2nd NF and 3rd NF of the data above. Example: Below is an example of the table information converted to zero normal form, read chapter five in your module guide and convert the table to first, second and third normal form. The format of your answer must be as depicted below: • ORDER( order number, customer number, name, address, order date(product number, description, quantity, unit price))
KA Helge Autoparts sells new and refurbished auto parts exclusively to auto dealers. Helge purchases inventory from distributors at trade conventions. Each time Helge makes a purchase, the company records the suppliers name, address, date, specific items purchased, price paid for each, and the total amount spent. Helge later researches the inventory items to set the customer price. The company assigns an inventory number to each item purchased and records the customer price for each item. Helge buys price tags and display supplies from Alwin Incorporated, a company that sells them at all trade conventions. All inventory and supplies purchases are immediately paid for with cash or with checks from a bank account in Helge's name. All cash received from sales are also deposited to the same bank account. Several times a year Helge rents display space at dealer conventions. A deposit is always required, and the entire fee is due the day the convention starts. Helge records the deposit and…
Interpolation is the name given to the procedure that includes guessing the value of a function at a location that is beyond the range of the available data.
Programming Problem 1 – Calculating a Number As part of the discussion forum for this unit, you will be solving a programming problem from the book. This assignment will have you calculating the chapter and the number of the programming problem that you will solve for the online discussion forum. To calculate the chapter from which you solve the programming exercise: • Divide the integer number representing your student ID by 3, consider the remainder and increment it by 3. The result you obtain represents the chapter number, and it should be either 2, 3, 4, or 5. Depending on the chapter number obtained above, consider the following rules in calculating the problem number to solve: • If the chapter number is 3, divide your student ID by 34, consider the remainder and increment it by 1. The result you obtain represents the number of the programming exercise you will solve for online discussions, which should be from chapter 3. • If the chapter number is 4 (you need to go to chapter 6),…
An ISBN (International Standard Book Number) is a 10 digit number that is used to identify a book. The first nine digits of the ISBN number are used to represent the Title, Publisher and Group of the book and the last digit is used for checking whether ISBN is correct or not. To uniquely identify a book a 10-digit ISBN number is used. The rightmost digit is checksum digit. This digit is determined from the other 9 digits using condition that 10d, + 9dz + 8dg + + d4o must be a multiple of 11 (where d, denotes the i" digit from the right). The checksum digit d; can be any value from 0 to 10: the ISBN convention is to use the value X to denote 10. Write a C program using pointers that receives a 10- digit ISBN, and computes the checksum, and reports whether the ISBN number is correct or not. Example: 007462542X = 10°0 + 9*0 + 8*7 + 74 + 6*6 + 5*2 + 4*5 + 3"4 + 2*2 + 110 = 176 Since 176 leaves no remainder when divided by 11, hence it is a valid ISBN. Note: When the check digit turns out…
A social recreation club has a system to keep track of club members, committees and activities. Each club has a registration number and a title. Several members form committee. Members are male and females. Each committee has a name, a unique number and a date, which the committee has formed. The system stores the members' unique identification number, name, address, gender, birth date and club joining date. The club forms committees for different activities. A committee controls and organizes a number of activities, each of which has a unique name, a unique number and description of the event. An event has event ID and description of the event. An activity may consist of several events. Committee publishes many online advertisements about the activities. Advertisement details are ID and a title. Draw the ER diagram to represent the above scenario
The Excel function =sin(A1) will calculate the sine of the value in cell A1. The value in cell A1 must be in degrees. Group of answer choices True False
Marriage Validity You were hired by the City Hall of Kulafu as a programmer. Your task is to write a spreadsheet program that will determine whether two individuals can be married legally or not. The marriage will be legal depending on the following conditions: both individuals should be at least 18 years old the individuals should not have the same gender (same gender marriage is not legal in Kulafu) the individuals should not have a married status (in Kulafu, status are single, widow/widower, divorced and married) Write a program that will accept via keyboard the information regarding the age, gender and marital status of the two individuals. The following numeric coding system should be used: for gender: M or m represents Male and F or f represents Female. For marital status: S or s represents Single, W or w represents Widow/Widower, D or d represents Divorced and MA or ma represents Married. The word should output the word "LEGAL" if all the criteria above are met. Otherwise, the…