Students: Johnson, Williams, Matt, Jones, Eric, Lili, John and Jason, whose grades are listed below.Each column is the grades each student received. There are 8 students with 10 grades each.Johnson: 79, 92, 85, 0, 100, 64, 72, 99, 90, 86Williams: 80, 75 93, 94, 0, 90, 89, 88, 87, 86Matt: 82, 67, 72, 74, 89, 0, 70, 89, 100, 76Jones: 85, 84, 82.5, 82, 84, 80, 80.5, 90, 96, 85Eric: 90, 91, 87, 85.5, 86.5, 0, 90, 90, 91, 92Lili: 60, 75, 81, 70, 80, 81, 94, 67.5, 99, 98John: 79,0, 74, 96, 88.5, 88, 0, 100, 86, 83Jason: 89, 90, 90, 85, 85, 90, 91, 88, 100, 79Write user-defined functions or build-in functions (e.g., sum, mean, max, min, etc.) to calculate:The Average Grade of each student; this average should be a vector.The average of the class; this average is a scalar vector.The highest grade among the Average Grade of Each StudentThe lowest grade among the Average Grade of Each StudentShow a table with each student's name, average grade and letter score using A, B, C, D, F in theCommand Window.Output above table in a *.txt fileMake a 2D plot of the grade curve of Average Grade of Each Student. Use a Title, labels, legendof figure, etc.Express above average grade curve with an estimated 5th order polynomial function and showthis function on Command Window.

In this question we have to write a python code to calculate avergae grade of each student and plot…

Students: Johnson, Williams, Matt, Jones, Eric, Lili, John and Jason, whose grades are listed below. Each column is the grades each student received. There are 8 students with 10 grades each. Johnson: 79, 92, 85, 0, 100, 64, 72, 99, 90, 86 Williams: 80, 75 93, 94, 0, 90, 89, 88, 87, 86 Matt: 82, 67, 72, 74, 89, 0, 70, 89, 100, 76 Jones: 85, 84, 82.5, 82, 84, 80, 80.5, 90, 96, 85 Eric: 90, 91, 87, 85.5, 86.5, 0, 90, 90, 91, 92 Lili: 60, 75, 81, 70, 80, 81, 94, 67.5, 99, 98 John: 79, 0, 74, 96, 88.5, 88, 0, 100, 86, 83 Jason: 89, 90, 90, 85, 85, 90, 91, 88, 100, 79

Students: Johnson, Williams, Matt, Jones, Eric, Lili, John and Jason, whose grades are listed below. Each column is the grades each student received. There are 8 students with 10 grades each. Johnson: 79, 92, 85, 0, 100, 64, 72, 99, 90, 86 Williams: 80, 75 93, 94, 0, 90, 89, 88, 87, 86 Matt: 82, 67, 72, 74, 89, 0, 70, 89, 100, 76 Jones: 85, 84, 82.5, 82, 84, 80, 80.5, 90, 96, 85 Eric: 90, 91, 87, 85.5, 86.5, 0, 90, 90, 91, 92 Lili: 60, 75, 81, 70, 80, 81, 94, 67.5, 99, 98 John: 79, 0, 74, 96, 88.5, 88, 0, 100, 86, 83 Jason: 89, 90, 90, 85, 85, 90, 91, 88, 100, 79

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: List the first name and last name of all authors. Concatenate the first and last names so that the…

A: Concat() function : This function in SQL joins string into one, maximum string which it can take as…

Q: Show students’ first name, last name, the grades of the students, and the credits of the course for…

A: Select St.FristName, St.LastName, Et.Grade, C.CourseIDfrom Student St INNER JOIN Enrollment Et ON…

Q: Select every 4th person that enters a room. (enter a letter: A- Random, B- Systematic, C-…

A: There are four primary techniques for random (probability) sampling. These procedures are: Simple…

Q: please answer Exercise 4-7

A: In this question we have to answer the bash related question Let's code and answer

Q: Display the lowest and highest ages of patients treated by the doctor named "Joseph Lam'. Your…

A: CREATE TABLE patient(patientNo text PRIMARY KEY, name text, phoneNo text, age number, doctor text);…

Q: Rank Normal forms where each form is a subset of the form above it. [ Select) [Select First Normal…

A: We are going to arrange Normal forms in the database.

Q: Which code should you change to show the highest count and student with a high count?

A: Given: Which code should you change to show the highest count and student with a high count?

Q: The following table is in 1NF. Convert it to 2NF using proper notation:

A: Facilitator (FacilitatorID, LastName, FirstName, Street, City, ZipCode, (ForumNum, ForumDate,…

Q: For each invoice placed on November 15, 2021, list the invoice number along with the ID, first name,…

A: Hi there, Please find your solution below, I hope you would find my solution useful and helpful.…

Q: The expression =IF(A1 > 8, 12*A1, 7*A1) is used in a spreadsheet. Find the result if A1 is 5 Find…

A: We have expression IF(A1>8, 12*A1, 7*A1) When A1>8, then the result = 12*A1 Else A1≤8 then the…

Q: Find out what kind of books are currently accessible in the library's collection. Each category…

A: Duplicate records are removed from the result set using the DISTINCT clause. FROM TABLES, SELECT…

Q: Show students’ first name and last name, the course numbers the student took (don’t include…

A: Data is coming from 3 tables . So apply inner join on 3 tables with joining condition. student…

Q: With the following table: PRODUCTS(PRODUCT_NUMBER, DESCRIPTION,PURCHASE_DATE,CATEGORY) Write…

A: Given table is:PRODUCTS(PRODUCT_NUMBER, DESCRIPTION,PURCHASE_DATE,CATEGORY)Write the mySQL statement…

Q: Task 1: The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the…

A: An SQL prepared code that may be saved and reused repeatedly is known as a stored procedure. So, if…

Q: 3.Rose Theater Company For this assignment you will modify the Rose Theater Company assignment…

A: Logic to implement this program: define named constants for the rates define a value returning…

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: (p,g) 1 2 T F T F ? Which of the answers below contains the truth values for the third column when…

A: The truth values of the given truth table

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

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Determine what kinds of books are currently in the library's collection. Each category should only…

A: Introduction: A vast array of books has always been housed in the libraries of colleges and…

Q: Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To…

A: Sure, I can help you with that. The StayWell marketing team wants to send small gifts to all…

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

A: sql command for the question is given in step 2

Q: Determine the kind of books that are currently in stock. Each category should be represented by a…

A: One stock declaration is a piece of paper that genuinely represents an investor's possession premium…

Concept explainers

Structured English

Structured English uses a simple English language to make structured programming easier for non-professionals. The program is divided into various parts that are known as logical statements. These statements are written in a simple English language.

Question

Students: Johnson, Williams, Matt, Jones, Eric, Lili, John and Jason, whose grades are listed below.
Each column is the grades each student received. There are 8 students with 10 grades each.
Johnson: 79, 92, 85, 0, 100, 64, 72, 99, 90, 86
Williams: 80, 75 93, 94, 0, 90, 89, 88, 87, 86
Matt: 82, 67, 72, 74, 89, 0, 70, 89, 100, 76
Jones: 85, 84, 82.5, 82, 84, 80, 80.5, 90, 96, 85
Eric: 90, 91, 87, 85.5, 86.5, 0, 90, 90, 91, 92
Lili: 60, 75, 81, 70, 80, 81, 94, 67.5, 99, 98
John: 79,0, 74, 96, 88.5, 88, 0, 100, 86, 83
Jason: 89, 90, 90, 85, 85, 90, 91, 88, 100, 79
Write user-defined functions or build-in functions (e.g., sum, mean, max, min, etc.) to calculate:
The Average Grade of each student; this average should be a vector.
The average of the class; this average is a scalar vector.
The highest grade among the Average Grade of Each Student
The lowest grade among the Average Grade of Each Student
Show a table with each student's name, average grade and letter score using A, B, C, D, F in the
Command Window.
Output above table in a *.txt file
Make a 2D plot of the grade curve of Average Grade of Each Student. Use a Title, labels, legend
of figure, etc.
Express above average grade curve with an estimated 5th order polynomial function and show
this function on Command Window.

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: Overview

VIEW

Step 2: Explanation and Code

VIEW

Solution

VIEW

Step by step

Solved in 3 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

To set up a Pivot Table with years listed horizontally as shown above, the Year field should be dragged into the following Pivot Area: Group of answer choices COLUMNS ROWS VALUES FILTERS
For this portion of the lab design the solution in the following manner: Create a table using a two-dimensional list that stores a Fahrenheit temperature and the equivalent Celsius temperature. Use the following range of Fahrenheit temperatures:Starting at -10 through 100 in increments of 10. Thus, the Fahrenheit temperatures will be:-10, 0, 10, 20, 30, 40, 50…and so on.Display the contents of the list.Similarly create tables/lists for the following, starting at 0 through 100 in increments of 10:Miles to kilometersGallons to litersPounds to kilogramsInches to centimetersDisplay the contents of each listSave the program as firstname_lastname_Lab7a.py where you will replace firstname and lastname with your actual first and last name.
(1) for each Customer (e.g., customer C), display all other customers who have higher salary than this Customer (e.g., customer C). (use inner join, display each customer’s ID, name, and all higher salaries, you don’t need to display information about the customers who have higher salary.) (2) for each Customer (e.g., customer C), display all other customers who have higher salary and are younger than this Customer (e.g., customer C).
You may use the Boolean operator to search for data on two separate topics at once. To get the most relevant results, Kevin should utilize which of the following Boolean operators?
how to insert the following: Insert Into Director Values(1,'Josh','Klemm',1) Insert Into Director Values(2,'Jeff','Bezos',10) Insert Into Director Values(1,'Elon','Musk',50) Insert Into Director Values(3,'Elon','Musk',500000) Insert Into Director Values(3,'Elon','Musk',5)
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
Find out what kind of books are currently accessible in the library's collection. Each category should only have one entry.
• List the staff names whose last name ends with a “d”.• List the staff names whose last name does NOTbegins with a “B”.• List the staff names whose last name does NOT havea “e” in the 2 nd letter.• List the staff names whose last name begins with “B”and the 3 rd letter is a “e”.
Q2: Discuss when you should use tables and when using graphs.
Task 12: When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.
Task 22: KimTay Pet Supplies is considering discounting the price of all items by 10 percent. List the item ID, description, price, and discounted price for all items. Use DISCOUNTED_PRICE as the name for the computed column.
The InstantRide Driver Relationship team wants to learn how many travels each driver has done in the month of October. You need to send them the DRIVER_ID, and two calculated columns: DAY and RIDES. The DAY column is calculated using the DAY() function with the TRAVEL_START_TIME as the argument. The RIDES column is calculated by using the COUNT() function to determine the number of rides given for each day. Filter the results with the MONTH function.