How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard, Software Specialist
Category: Software
Satisfied Customers: 30280
Experience:  Over 15 year experience in Computers, Mobile devices and Networks
Type Your Software Question Here...
Richard is online now
A new question is answered every 9 seconds

Does MS Excel has the ability to automate statistical tasks

Customer Question

Does MS Excel has the ability to automate statistical tasks like T-stats and Confidence intervals?
Submitted: 1 month ago.
Category: Software
Expert:  George Sibiya replied 1 month ago.


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".



Customer: replied 1 month ago.
By automate I mean, That it calculates through basic data I enter initially!
Expert:  George Sibiya replied 1 month ago.

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?

Expert:  Richard replied 1 month ago.

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.