1. Write a Python program that allows the user to calculate summary statistics for a maximum of six deliverables of a course. The summary statistics that will be calculated for these deliverables are average, median, highest, lowest, and sample standard deviation. Your program must meet the following requirements:   a) Read in the data from a CSV file provided on Canvas. Hint: The file includes row and column headers. Use the example code from class 3/7 to read in a CSV file with headers.   b) Minimum requirements are to always ask for 3 assignments – for this, you skip this step. For bonus credit, prompt the user to input the number of assignments to calculate statistics for.  In this case you would need to prompt the user for the total number of deliverables for which summary statistics will be calculated. You must verify that the user enters a value that can represent a valid integer number in the range [1, 6]. If the user enters a value that does not represent a number, the user enters a valid value but the value is outside of the allowed range, or the user enters a non-integer value, your program must display an error message. Your program must continue to display the prompt asking for the number of assignments until a valid value is provided. Note: you must use a repetition programming structure with a single prompt to fulfill this requirement.   c) The value for the total number of deliverables must be used by a repetition programming structure to control the calculation and the printing of the summary statistics for the deliverables. (This is 3 items for the minimum requirements, or the user input value of 1 to 6 for the bonus.) The user must first be prompted for the label that will identify the specific deliverable to be processed. You code must check that labels are provided in the CSV file header row. Note that the user should be allowed to enter labels for deliverables in any order. If the user enters an incorrect value, your program must display an error message and then re-prompt the user to enter the value. Note: you must use a repetition programming structure with a single input box function statement to fulfill this requirement.   d) Once the user provides valid labels for the deliverables, your program will print a table with the summary statistics for each deliverable specified in the order they were specified.  Have one decimal place of precision for calculated statistics.  Figure 7 depicts an example of how this table looks. You must include row and column labels along with the calculated statistics.

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
icon
Related questions
Topic Video
Question

1. Write a Python program that allows the user to calculate summary statistics for a maximum of six deliverables of a course. The summary statistics that will be calculated for these deliverables are average, median, highest, lowest, and sample standard deviation.

Your program must meet the following requirements:

 

a) Read in the data from a CSV file provided on Canvas. Hint: The file includes row and column headers. Use the example code from class 3/7 to read in a CSV file with headers.

 

b) Minimum requirements are to always ask for 3 assignments – for this, you skip this step. For bonus credit, prompt the user to input the number of assignments to calculate statistics for.  In this case you would need to prompt the user for the total number of deliverables for which summary statistics will be calculated. You must verify that the user enters a value that can represent a valid integer number in the range [1, 6]. If the user enters a value that does not represent a number, the user enters a valid value but the value is outside of the allowed range, or the user enters a non-integer value, your program must display an error message. Your program must continue to display the prompt asking for the number of assignments until a valid value is provided. Note: you must use a repetition programming structure with a single prompt to fulfill this requirement.

 

c) The value for the total number of deliverables must be used by a repetition programming structure to control the calculation and the printing of the summary statistics for the deliverables. (This is 3 items for the minimum requirements, or the user input value of 1 to 6 for the bonus.) The user must first be prompted for the label that will identify the specific deliverable to be processed. You code must check that labels are provided in the CSV file header row. Note that the user should be allowed to enter labels for deliverables in any order. If the user enters an incorrect value, your program must display an error message and then re-prompt the user to enter the value. Note: you must use a repetition programming structure with a single input box function statement to fulfill this requirement.

 

d) Once the user provides valid labels for the deliverables, your program will print a table with the summary statistics for each deliverable specified in the order they were specified.  Have one decimal place of precision for calculated statistics.  Figure 7 depicts an example of how this table looks. You must include row and column labels along with the calculated statistics.

AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

Knowledge Booster
Instruction Format
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education