Administration and Executive AssistantTier 830 minadvanced

T.TEST Tails

Test whether two machines differ at all, using a two-tailed test, not a one-tailed one.

What you will learn

• Use T.TEST to compare the means of two samples
• Explain the difference between a one-tailed and a two-tailed hypothesis
• Recognise that a two-tailed p-value is always exactly double the one-tailed p-value for the same data

Excel skills

T.TEST · Inferential Statistics

The task

Two machines' output measurements are listed. Test whether there is a difference between them at all - in either direction - and report the p-value in Summary!B3.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free