Create an Excel spreadsheet that will take a file of numbers (up to 20,000) and calculate the mean, median, mode, minimum, maximum and Standard Deviation of the numbers. Results should be displayed on the same page (layout to your discretion). Finally, the numbers should be sorted in ascending order and placed in an external text file. You may use the data file data.txt in the directory. This part is Complete.

I need help in how to Automate this process using VBA (macros) . do it using the excelfile.

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.