Question

1 Approved Answer

Posted on Sep 25, 2024

READ THE INSTRUCTIONS READ THE INSTRUCTIONS READ THE INSTRUCTIONS READ THE INSTRUCTIONS READ THE INSTRUCTIONS READ THE INSTRUCTIONS READ THE INSTRUCTIONS DONOT COPY AND PASTE

******************************READ THE INSTRUCTIONS

******************************DONOT COPY AND PASTE A WRONG ANSWER

******************************READ THE QUESTION AND UNDERSTAND BEFORE ANSWERING

*************************I DID THIS BECAUSE MOST EXPERTS DON'T READ THE QUESTION AND JUST COPY AND PASTE WRONG ANSWERS

THIS IS A DATA ANALYSIS TASK

Using Python to develop a simple data analysis system

The students are required to use Python to develop a simple data analysis system according to the following guidelines: The system should read a CSV (Comma-Separated Values) file which stores the data for four variables: students ID (id), name (name), number of hours of study (hours) and students final score (score). The first raw of the file contains the variable names. When the system starts, it should show a welcome screen, then it shows the menu of options. The menu of options should include the following tasks: 1. Read Data: the system should ask for a file name, then it reads this file and stores its content to variables (4 list variables). The system should print a message showing that reading data was successful. 2. List Data: To show the content of the data file to the user (in a nice and readable way). 3. Compute and Show Grades: the system should compute and print students ID, name and grade for each student according to the following rule: A: for 100>=score >=90 B: for 90> score>=75 C: for 75> score>=60 D: for 60> score>=50 F: for 50> 4. Search by Name: the system should ask for students name or part of the name, then it prints the data for all students with names containing the given name/part. 5. Descriptive Statistics: To calculate and show the mean, variance and standard deviation of the two variables: hours and score. 6. Regression Analysis: To calculate the simple regression parameters b0 and b1 of the regression equation (score = b0 + b1*hours), and print the regression equation

7. Prediction: The regression equation can be used to predict the score of a student for a specific number of hours of study. The system should ask for hours and print the predicted score. 8. Exit: to print a good-bye message and exit the system. The system should keep showing the menu to the user until he/she selects the Exit option. The code should include enough documentation (using comments # ), to explain the purpose of the variables, function and hard-to-understand parts of the code.

Useful Tips Write a separate function for each of the required tasks. Test every function after you finish it and make sure it works properly. For example, you should test the function that reads the data file after you write it, you can do that by printing the content of the file after you read it. Make sure that your project it well-documented by adding comments

Sample data file This is the first 10 records of the CSV data file with four variables: students ID (id), name (name), number of hours of study (hours) and students score (score). id,name,hours,score 1,Ahmed Aly,6,95 2,Yasser Mohamed,10,90 3,Faten Youssef,8,97 4,Manar Khalid,7,99 5,Jana Mohamed,5,80 6,Salma Salah,4,70 7,Aziz Atef,9,92 8,Malak Waheed,6,90 9,Noha Ahmed,2,60 10,Mayar Omar,3,50

image text in transcribed

DO NOT COPY THE WRONG ANSWER THAT WAS PROVIDED BY ANOTHER EXPERT ON THIS QUESTION

Formula Sheet You may need the following formulas: Meani The mean of a variable X is calculated by (sum of values divided by their number): Mean (x) Variance The variance of a variable X is calculated by: (x-x) n. 1 n OR 2x2 (Ex) n n-1 Standard Daviation The standard deviation is the square root of the variance Regression Parameters: The regression equation represents the relationship between a dependent variable (Y) and an independent variable (x) as: Y=bo + bX xy-nxy . Ex? - nx? bo = - b, b