Problem Statement: Write a well-commented VBA program to process a set of data in preparation for a subsequent frequency analysis. Raw data will be provided in 50 batches of 15 observations (750 total observations), in a two-column text file (750 rows by 2 columns). The first (left) column represents the batch number or test run, and the second (right) column represents the observation. The program must read the data, convert the 750 x 2 format to a 50 x 15 matrix format, and determine (and record into the spreadsheet) the maximum observed value in each batch. Additional Requirements/Details: Your program should: o o Read the file HW02data.txt into a 2-d array, preserving the left-right column relationship. (Column 1 is the batch number, column 2 is the data value.) Turn the 750 x 2 array into a new 50x 15 array, with each row representing the 15 observations in a batch. Again, for credit, we only need you to put the correct 50x 15 array into memory, but you will probably want to put it out into the worksheet in order to check that your program is working properly. Determine the maximum observed value in each batch, and writes the summary data to the Excel worksheet, with batch numbers in the first column and maxima in the second column. Problem Statement: Write a well-commented VBA program to process a set of data in preparation for a subsequent frequency analysis. Raw data will be provided in 50 batches of 15 observations (750 total observations), in a two-column text file (750 rows by 2 columns). The first (left) column represents the batch number or test run, and the second (right) column represents the observation. The program must read the data, convert the 750 x 2 format to a 50 x 15 matrix format, and determine (and record into the spreadsheet) the maximum observed value in each batch. Additional Requirements/Details: Your program should: o o Read the file HW02data.txt into a 2-d array, preserving the left-right column relationship. (Column 1 is the batch number, column 2 is the data value.) Turn the 750 x 2 array into a new 50x 15 array, with each row representing the 15 observations in a batch. Again, for credit, we only need you to put the correct 50x 15 array into memory, but you will probably want to put it out into the worksheet in order to check that your program is working properly. Determine the maximum observed value in each batch, and writes the summary data to the Excel worksheet, with batch numbers in the first column and maxima in the second column