98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » T test, non-numeric data error message
T test, non-numeric data error message
Resolved · Low Priority · Version 2016
Tue 4 Aug 2020, 11:21Delegate Alan said...
Alan has attended:
Excel Intermediate course
T test, non-numeric data error message
I am trying to do a t test on excel and when I put all the necessary cell numbers in the ranges, the calculation will not execute due to 'input range contains non-numeric data'. All the cells have numbers in them and I even changed the format of all the cells to Number. None of the cells I have chosen have text in them. Is there anything else I can try to get the t test to run? Thanks, Alan
Tue 4 Aug 2020, 13:08Trainer Jens said...
RE: T test, non-numeric data error message
Hi Alan,
Thank you for the forum question.
If you type in formatting Excel can see it as text not a number. There can be a number of reason for Excel will see it as text. What I would do is to add a column and type =isnumber(A2) if my column with the numbers starts from A2 otherwise change the cell reference. Copy it down and if the function return false it is text and if it returns true it is a number. this way you can find the numbers which are text.
A more simple solution is to change the column width to double size. If the numbers left align it is text if they right align it is numbers.
If you copy the column with numbers and past them in a new file I am happy to have a look at it.
You can send the file to:
info@stl-training.co.uk
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Viewing Many WorksheetsIf there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds. |
