Welcome to JustAnswer and thank you for utilising our services.
Yes it should be able to. If you may have not come across the pages please see
If you already know these please explain a bit what you mean by "automate".
Ok thanks. Just to be sure I understand you correctly, say you are importing your data from a csv file or typing it manually, you would like it to calculate the t-stats automatically and display as shown in the attached figure?
Hi there and welcome
Yes, it can automate any calculations once you set the rules up for it.
What you need to do is break down the rules and enter these into Excel and once done, as you enter data, it will calculate this for you.
Example, if you wanted to add the value in A1 with B1 andd subtract C1 then you would use the formula in D1
So it is a matter of noting the rules needed for the calculations and entering these into Excel.