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
Richard, Software Specialist
Category: Software
Satisfied Customers: 38368
Experience:  Over 15 year experience in Computers, Mobile devices and Networks
32989067
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 year ago.
Category: Software
Expert:  George Sibiya replied 1 year ago.

Hi,

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

http://www.excel-easy.com/examples/t-test.html

and

https://support.office.com/en-ie/article/CONFIDENCE-T-function-e8eca395-6c3a-4ba9-9003-79ccc61d3c53?ui=en-US&rs=en-IE&ad=IE

If you already know these please explain a bit what you mean by "automate".

Regards,

G

Customer: replied 1 year ago.
By automate I mean, That it calculates through basic data I enter initially!
Expert:  George Sibiya replied 1 year 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 year 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

=A1+B1-C1

So it is a matter of noting the rules needed for the calculations and entering these into Excel.