4- The file Grades.txt contains the grades for the Assignments (column 1), Midterm exam (column 2) and Final Exam (column 3) for 10 students. Read the grades in an ndarray and answer the following questions: a. What is the maximum grade in the final exam? b. How many students achieved a total score of 85% and more? c. What is the mean and standard deviation for each assessment tool (i.e. Assignments, Midterm and Final Exam) d. Which assessment tool has the highest standard deviation e. How many students scored the maximum score in the Assignments (the maximum score is 20)

4- The file Grades.txt contains the grades for the Assignments (column 1), Midterm exam (column 2) and Final Exam (column 3) for 10 students. Read the grades in an ndarray and answer the following questions: a. What is the maximum grade in the final exam? b. How many students achieved a total score of 85% and more? c. What is the mean and standard deviation for each assessment tool (i.e. Assignments, Midterm and Final Exam) d. Which assessment tool has the highest standard deviation e. How many students scored the maximum score in the Assignments (the maximum score is 20)

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter8: Sql Functions And Procedures

Section: Chapter Questions

Problem 1CAT

See similar textbooks

Similar questions

The file ClassificationData.xlsx (Screenshot attached below) contains the following information about the top 25 MBA programs: percentage of applicants accepted, percentage of accepted applicants who enroll, mean GMAT score of enrollees, mean undergraduate GPA of enrollees, annual cost of school (for state schools, this is the cost for out-of-state students), percentage of students who are minorities, percentage of students who are non-U.S. residents, and mean starting salary of graduates (in thousands of dollars).Use these data to divide the top 25 schools into 4 clusters, usingfor example the K-Means clustering algorithm, and interpret your clusters. The method is explained in our textbook: Section 8.8 in the Fourth and Fifth Edition or Section 14.3 in the Sixth Edition. More precisely, use Evolutionary Solver to find 4 schools to be used as cluster centers and to assign all other schools to one of these cluster centers. Each school is then assigned to the nearest cluster center,…
Correct and detailed answer will be Upvoted else downvoted. Thank you
1. List all vehicles and their average number of rental days per year. The results should be displayed as Year, RegNo, make, model, average number of days. 2. Count the number of cars rented in each quarter of each year. your output should show rental year, wuarter, number of cars rented. Quarter 1 contains months Jan, Feb, March; quarter 2 - April, May, June, etc. Note, year 2022 has records for quarter 1 only. Using the SQL syntax Here is the physical model of this database.
complete the data system for citywide taxi company. now, the information for each taxi is expanded to include: taxi id (such as ctc0001), the driver’s name, the maker of the car (such as ford), the model of the car (such as escape), the color of the car (such as black), the license number (such as hxt 4578), the number of passages the car served in the entire shift (integer type, this field will be left empty for this project). your c++ program will (with array of class object): define a class for the car with all members of variable mentioned above as private; write all necessary class member functions to access those member variables (write or read); read up to 50 records of data from the keyboard (provide a method to end the input before reaching 50 records); (1 points) save all records inputted from step 3 to a disk file called ctc.dat. In cpp
complete the data system for citywide taxi company. now, the information for each taxi is expanded to include: taxi id (such as ctc0001), the driver’s name, the maker of the car (such as ford), the model of the car (such as escape), the color of the car (such as black), the license number (such as hxt 4578), the number of passages the car served in the entire shift (integer type, this field will be left empty for this project). your c++ program will (with array of class object): define a class for the car with all members of variable mentioned above as private; write all necessary class member functions to access those member variables (write or read); ) read up to 50 records of data from the keyboard (provide a method to end the input before reaching 50 records); save all records inputted from step 3 to a disk file called ctc.dat.
Create a table of your courses for this semester with fictitious grades for Test 1, Test 2, and Test 3 with appropriate weighting. The next column should determine the grade using the 'if' function, with plus and minus. The grade cell should show a discrete color scheme with below C- in red; above B in green and, yellow for the rest. This should be done using conditional formatting of cells.
INSERT INTO Athletics VALUES((100, 'Samuel', 'David', '1967-11-17', '23',1967-11-20); INSERT INTO Athletics VALUES((110, 'Mario', 'Cassius', '1967-11-13', '22',1967-11-20 ); INSERT INTO Athletics VALUES((104, 'Mario', Ace', '1967-12-31', '26',1967-11-20 ); INSERT INTO Athletics VALUES((123, 'Cristisno', 'Ronny', '1965-11-13', '28',1967-11-20 ); INSERT INTO Athletics VALUES((110, 'Harx', 'Wale', '1964-11-12', '20',1967-11-20 ); QUESTION Create a stored procedure named sp_InsertAthleteDetails, which enters details into the Athletics table by using 4 parameters for the first four columns in the Athletics table. Set No Count on.
• 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”.
Tables: 1. Brands (sample csv enclosed) a. Brand ID b. Brand Name c. Holding Company ID d. Holding Company Name 2. Store Order Items (sample csv enclosed) a. Order ID b. User ID c. Product ID d. Brand ID e. Unit Price f. Quantity g. Date (of sale) h. Store ID (of sale) 2. For each Product (ID), determine the “store of sale” that made the first sale of the product in 2019. Written in Sql
Product a report showing the distinct first and last names of customers from the state of New York (NY) who purchased shoes manufactured by companies in the city of New York. Sort the result by the last name.
The following is a table of applicants to be considered for admission into 07BSAM: POINTS MATH SYMBOL 123 450 NAMES STUDENT NUMBER ENG SYMBOL To qualify for admission, an applicant should have at least 25 points, minimum of B symbol in Mathematics and a minimum of E symbol in English. If an applicant has a C symbol in Mathematics, then the applicant must pass an entrance test to be considered for admission. Hints: There are three modes of study: The Full-time mode, the Part-time mode and the Distance mode. Applicants can choose which mode they want provided there is space in that mode. Each of the Full- time and the Part-time modes cannot accommodate more 30 admitted students. After these two modes are full, every other qualified applicant is admitted in the Distance mode. The admission exercise is first come first served. Write a pseudocode that identifies the applicants that qualify for admission and outputs their names, student numbers and modes of study. Use a FOR-LOOP /…
a) List the names (Fame and Lame) and SSN of all male employees (Sex='M). b) List the last name and SSN of employees who work on project 'City Tower', sorted by alphabetical order of last na c) Retrieve the average salary of all female employees (Sex='F'). d) List department names and the number of employees who work for each department. Sort by department name. e) Retrieve the names of employees who make at least $10,000 more than thé employee who is pald the least in