Answer Happy

Option 2 - ANALYTICS A) Use Microsoft Excel or a text editor to create a CSV file: • Create your own spreadsheet with multiple numeric rows and multiple numeric columns, save as CSV file Or use files "dataset1.csv" (small), or "dataset2.csv" (large) from the "examples & demos" directory, under "Sinpout" -> "ZAnalytics" • Data should include both positive and negative decimal numbers, as well as zeros. • Your program should be able to read any size (rows and columns) CSV file . For full credit (see below), your data should also include null cells (cells that contain no values) . Or use file "dataset3.csv" (large & contains null cells), from the "examples & demos" directory, under "Sinpout" -> "zAnalytics" B) Write a program to compute analytics on the CSV file above . Read the CSV file above, save in a 2 dimensional array or arraylist 1. Perform analytics for each row, and print . ... Analytics include count, sum, average, median, mode, min, max, range, and standard deviation ... Median = sort array, take mid-point. If array has even number of elements, take average of 2 mid-points Mode = value that occurs most often, If all values occur only once, no mode. If multiple values occur most often, choose one. Or for more credits create an array of modes, See sample in the "examples & demos" directory, under "inpour" -> "Analytics" . 2. Perform same analytics as above for each column, and print • 3. Perform same analytics for the entire dataset, and print . 4. Re-print all analytics for column 1 again . 5. Transpose the 2 dimensional array (rows become columns, and columns become rows) . 6. Recompute all analytics steps 1-4 for the transposed array, and print . Your program should be able to read any size (rows and columns) CSV file • If you write a single class for this assignment, maximum grade will be... 70 If you write 2 classes, a user class, and a static service class... +5 • If you write 2 classes, a user class, and an instance service class... +15 • If you can produce multiple modes (if multiple values occur most often).. • If your CSV file includes null cells (cells with no values) using "dataset3.csv"... +10 Null cells should not count/sum/avg/etc. toward analytics Submit your program using "dataset2.csv", or for full credit, "dataset3.csv" (containing null cells)