GENG 106: Computer Programming - Inventory of Cars Details - IT/Computer Science Assignment Help

Assignment Task:

Task:

Problem Description

An engineer keeps an inventory of cars details, but on paper. The usual operations on his ‘inventory database’ include adding new cars, updating levels of current information and producing different reports based on the current car details. As the inventory is getting larger, this manual system is becoming difficult to manage. The engineer decided to develop a computerized system to help him manage the inventory. As he is not expert in database management systems, he decided to develop his own application, based on the Python knowledge he had during his early engineering education. The cars data are printed as in the following table:-

The goal of this course project is to give you more experience on the use of functions, lists and file manipulation. You will practice them by processing a file from a real-life dataset. gather the data from the provided file “cars.txt”, and stored in lists. Further data processing is performed on these lists. The main interface of the system should be as follows: Please select a number as follows:

1. Add a new car (Phase 1).
2. Search for a car by it’s name (Phase 1).
3. Display all sport cars that has Rear-Wheel Drive, and engine size is greater than 3 (Phase 1).
4. Display Top 10 cars that makes best profit (Phase 1)
5. Delete all Minivan cars.
6. Display top 3 cars has best Highway Miles Per Gallon and smallest Engine size.
7. Calculate the slope and intercept of a linear regression and correlation between the x and y data.
8. Plot the calculated regression line through the data in part 7.
9. Exit..

•  If user selects no. 1, the program should read data of the new car which include all car details and add it the car.txt file.(Keep the old data).
•  If user selects no. 2, the program should read the car name from user, then display the data of the car with that name, or display “car is not found” if there is no car with that name.
•  If user selects no. 3, the program should display all sport car that has Rear wheel drive and it’s engine size is greater than 3.
•  If user selects no.4, the program should display data of the top 10 cars that make best profit (RetailPrice- Dealer Cost).
• If user selects no.5, the program should delete all Minivan cars.
•  If user selects no.6, the program should display data of the top 3 cars that has best Highway Miles Per Gallon and smallest Engine size.
•  If user selects no.7, the program should ask use calculate the slope ,intercept and correlation coefficient follows:-

slope=(N*sumXY - (sumX*sumY))/(N*sumXSquared - (sumX)2
)

intercept = (sumY – (slope*sumX)) / N
corr = (N*sumXY - (sumX*sumY)) /sqrt((N*sumXSq - (sumX)2

) * (N*sumYSq - (sumY)2
))

where
o X: Engine size
o Y: average mpg (we want the average mpg (the average between highway and city mileage).)
o sumX and sumY: the sum of all the X values and the sum of all the Y values
o sumXY: the sum of the product of each corresponding X,Y pair
o sumXSquared and sumYSquared: the sum of the square of every X value and the square of every Y value
o N: the number of pairs

• If user selects no. 8, the program should display a graph calculated regression line through the data in part 7
•  If user selects no.9, the system stops.

This GENG 106: IT/Computer Science Assignment has been solved by our IT/Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics.Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.