Submit 1. Create a list named grades. a) Add the following grades: 92, 51, 83, 37, 72 b) Compute the average of these grades using the len method. c) Print the average with a precision of two decimal places. d) Compute the location of the median grade using the len method. e) Print the median grade using index syntax. f) Remove all failing grades (lower then 60) from the list. g) Print the updated list of grades. h) Print the updated average. Average the sum of all elements divided by the number of elements Median = the middle element in a ist of elements Output Example [92, 51, 83, 37, 72] Average: 67.00 Median: 83 [92, 83, 72] 33

Submit 1. Create a list named grades. a) Add the following grades: 92, 51, 83, 37, 72 b) Compute the average of these grades using the len method. c) Print the average with a precision of two decimal places. d) Compute the location of the median grade using the len method. e) Print the median grade using index syntax. f) Remove all failing grades (lower then 60) from the list. g) Print the updated list of grades. h) Print the updated average. Average the sum of all elements divided by the number of elements Median = the middle element in a ist of elements Output Example [92, 51, 83, 37, 72] Average: 67.00 Median: 83 [92, 83, 72] 33

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Which cards do not have a price recorded. Display all fields in the same column order as defined in…

A: Answer: We have to print table based on data given . here we will use SQL query to print data. we…

Q: 12. Report the names of the professors who supervise more than one student. 13. Report the names…

A: In order to find professors who supervise more than one student, we will need a COUNT() function on…

Q: which description defines data type? a) It is a named set of values. b) It is an unnamed tuple of…

A: Programming relies heavily on data types, which act as guidelines for the types of values that can…

Q: List names of all customers who live in a given zip code

A: Approach Start Create procedure Select a statement from the cursor End Display the procedure with…

Q: CREATE TABLE EMPLOYEE( ENUM DECIMAL(12) NOT NULL,/* Employee number */ FNAME VARCHAR(50) NOT NULL,/*…

A: the answer is:

Q: Create a table using a two-dimensional list that stores a Fahrenheit temperature and the equivalent…

A: Note: Programming language is missing in the question. So we will answer this program in Python…

Q: The population of the five most populous Australian cities at the last three census is recorded in…

A: Since no programming language is mentioned, I am using Matlab. Code:…

Q: Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on…

A: SQL query to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF…

Q: 1) Make a list of customers: first name, last name, city 2) Make a list of customers who live in…

A: Structured Query Language (SQL) is a computer language used to manage and modify relational…

Q: Given the following JSON format: {"list": [ {"name": "David Brown", "address": "101 Main Street,…

Q: Microsoft Excel Formula assignment: The objective of this assignment is to create 20 [5x5] tables…

A: The steps to find out the solution to the problem is in next step.

Q: List all the course information and the students who took the courses. If the course has no student,…

A: The question has been answered in step2

Q: Create a formula that provides the start date of a project as follows: In cell H4, begin to enter a…

A: Question given: A excel table is given. This table stores project details. Create a formula using…

Q: The Department summary table should look up the department abbreviation and return all of the data…

A: Use the VLOOKUP function to search the staff table data and return the department name based on the…

Q: The Movie table has the following columns: ID - positive integer Title - variable-length string…

A: In the dynamic landscape of relational databases, the ability to modify existing tables is crucial…

Q: For this portion of the lab design the solution in the following manner: Create a table using a…

A: Program Explanation: Define the function for conversion. Inside the function create the table for…

Q: def ) -> """ Return a float corresponding to the amount of time required to travel from the source…

A: In this question we have to write a python code for calculate trip time method Let's code and hope…

Q: The Horse table has the following columns: ID - integer, primary key RegisteredName -…

A: Table Description:The table Horse has the following columns:ID: An integer column serving as the…

Q: • List the staff names whose last name ends with a “d”. • List the staff names whose last name does…

A: Below is the complete solution with explanation in detail for the given questions about SQL…

Q: I The column value descriptor (CVD) contains a description of a column value. During field-encoding,…

Q: Using the data file below design a hierarchical struct to organize the data. Then declare an array…

A: To organize the reservation data provided in the file, we can use a hierarchical struct that…

Q: C. d. ne: ID: A 7. A summer camp offers a morning session and an afternoon session. The list…

A: Correct answer is option a

Question

03 Lists_I_Homework.pdf
1 page
Search
Read
Chapter 3: Introducing Lists
Submit
1. Create a list named grades.
a) Add the following grades: 92, 51, 83, 37, 72
b) Compute the average of these grades using the len method.
c) Print the average with a precision of two decimal places.
d) Compute the location of the median grade using the len method.
e) Print the median grade using index syntax.
f) Remove all failing grades (lower then 60) from the list.
g) Print the updated list of grades.
h) Print the updated average.
the sum of all elements divided by the number of elements
the middle element in a list of elements
Average
Median
Output Example
[92, 51, 83, 37, 72]
Average: 67.00
Median: 83
[92, 83, 72]
Average: 82.33

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!

SEE SOLUTION Check out a sample Q&A here

Step 1 - Algorithm

VIEW

Step 2 - Code in Python

VIEW

Step 3 - Code Screenshot

VIEW

Step 4 - Output

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 2 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

Question 5 Assume you are given a dictionary student_dict with Mary taking ACT101, FIN202, MIS310 and MIS340, Steve is enrolled in FIN202, MKT300 and MIS310, and Paul is registered for ACT101 and MKT300. With Ist initially set to an empty list, which of the following would complete the code that will correctly produce the list of students taking MIS courses. for key in student_dict: for val in student_dict [key]: if 'MIS' in 1st.append( and O val; val; 1st; key O val; val; 1st; val O val; key; 1st; val O val; key; 1st; key Question 6 0.5 pts not in 0.5 pts Given the customer reviews shown below, which one of the following would correctly display the first company's name XYZ, Inc.? + 100% O KH
The Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020. -- Your SELECT statement goes hereSELECT *FROM HorseWHERE (Height >= '15.0' AND Height <= '16.0') OR BirthDate >= '2020-01-01';
Using the data file below design a hierarchical struct to organize the data. Then declare an array of structs for the reservations. The data file contains ten reservations. There are 8 columns of data: party name, size, date and time for the reservation, phone number, email address, credit card number and expiration date for the credit card. The data can be read from the file below so you will not need to type it in repeatedly. Once you have populated the array with data perform the following tasks: Write a function that will print out to the screen the information for one reservation.In the main program write code that prompts the user to enter a date in the form MM DD YYYYCall the function to print out all reservations on that date. You can make a loop that calls the print function repeatedly or you can put that code inside the print function.TEST CASES: April 30, 2023 and May 12, 2023. In this example you need to carefully consider what data types to use. For example, the credit…
he Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020.
For this week's assignment you will allow the user to add employee, view all employees, search employee by ssn, and edit employee information. Below this is what its supposed to look like when completed. I have also included what I started to do but I can't figure out how to add the search by SSN option or the edit employee option. If you can give me a step by step on how to do this in python I would greatly appreciate it.
individual characters using their 0-based index. Hint: You will need to do this for checking all the rules. However, when you access a character .