Question: Develop an excel spreadsheet that charts the theoretical cost (Best, Average, Worst) for each of the four sort routines you have the code for. The
Develop an excel spreadsheet that charts the theoretical cost (Best, Average, Worst) for each of the four sort routines you have the code for. The spreadsheet MUST have a sheet for each and the sheets MUST be in this order: Bubble Sort, Insertion Sort, Quick Sort, and Merge Sort. For each sort routine you MUST also include a chart (see below).
The chart colors MUST be red for worst case, green for best case, blue for average case.
Part 2:
Add to the spreadsheet the actual run-times for each sort routine using the same values of N as used in part 1. You will most likely have to adjust your loop to get run-times similar to the theoretical values (which is OK as all we want to know is how does the actual code compare with the theory).
Part 3:
Add a fifth sheet comparing the run-times of the 4 sort routines. The chart colors here MUST be red for Bubble Sort, green Insertion Sort, blue for Quick Sort, and black for Merge Sort.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
