# A question about Null Hypothesis for 1 Sample T-test

#### hazwan2283

##### Involved In Discussions
Hi to all the respected experts in Elsmar, my name is Hazwan.
I have a question regarding 1 sample T-test.
When we want to do a 1 sample T-test, we need to identify first what is the null and alternative hypotheses.

Let say my first null hypothesis is Mean for the dataset is higher than or equal to 10.
My alternative hypothesis is Mean for the dataset is lower than 10.

Second way of looking into this is..i can also say null hypothesis is Mean for dataset is lower than or equal to 10.
Alternative hypothesis will then be Mean for dataset higher than 10.

My question is, regardless of which null/alternative i choose from above...higher than or lower than...i will get the same result correct?.
The reason why i'm asking this is because i'm using Excel to do this test and i cannot see anywhere in Excel where we can specify whether greater than or lower than.
While i can see from Youtube Minitab videos, in Minitab they can specify whether its greater than or lower than.

I am now wondering why is it important to indicate in Minitab whether greater than or lower than at all?.

#### Miner

##### Forum Moderator
How are you doing a 1-sample t-test in Excel? As you can see below, it is not even an option in Excel.

#### Miner

##### Forum Moderator
To answer your question about Minitab, I created a standard normal distribution (mean = 0, stdev = 1) and ran a 1-sample t-test for the following:
1. Ho: mean = 0.5, Ha: mean < 0.5
2. Ho: mean = 0.5, Ha: mean > 0.5
See the results below. One is significant and the other is not.

#### hazwan2283

##### Involved In Discussions
To answer your question about Minitab, I created a standard normal distribution (mean = 0, stdev = 1) and ran a 1-sample t-test for the following:
1. Ho: mean = 0.5, Ha: mean < 0.5
2. Ho: mean = 0.5, Ha: mean > 0.5
See the results below. One is significant and the other is not.
Hi Miner, i'm using attached excel file to do the One-to-Standard T-test. i have a feeling that excel is not completely correct...isn't it?.

#### Attachments

• One to Standard Comparison.xlsx
10.8 KB · Views: 70

#### hazwan2283

##### Involved In Discussions
Hi @Miner , i realized now that the t-statistic always a single formula. But the p-value formula differs depending on the alternative hypothesis whether single tail or double tail. I'm now in the midst of doing an excel template for my company for one-sample T-test, two sample T-test, one sample F-test, one proportion test. Since the p-value has multiple formulas..i will be dead by the time i research the formulas..

We are in a super tied budget so not possible to buy any softwares or anything...

#### Miner

##### Forum Moderator
Hi Miner, i'm using attached excel file to do the One-to-Standard T-test. i have a feeling that excel is not completely correct...isn't it?.
I verified that you are calculating everything correctly for a 2-tailed 1-sample t-test.

#### hazwan2283

##### Involved In Discussions
I verified that you are calculating everything correctly for a 2-tailed 1-sample t-test.
Yes, to my suprise i managed to add formula to the 1-tailed as well (left and right) to cover all 3 possible alternate hypotheses. Thank you Miner

Question on Finding - BSI Stage 2 ISO 13485:2016 Certification - PMS ISO 13485:2016 - Medical Device Quality Management Systems 5
Quick question about 9001 Quality Objectives Manufacturing and Related Processes 9
PROCESS OWNERSHIP (QUICK QUESTION) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 16
Private Label Manufacturer Question Canada Medical Device Regulations 2
Question on finding • Failure to follow Work Instructions ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 26
AS9102B Form 1, line 19 question. Is a printed name and signature both required or is only a signature sufficient? AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 7
Question on registration of class 1 medical device in Turkey Other Medical Device Regulations World-Wide 0
General FMEA Question FMEA and Control Plans 2
What do you think of Chat GPTs answer to this Risk Acceptability question? ISO 14971 - Medical Device Risk Management 5
ISO 13485 Supplier Question ISO 13485:2016 - Medical Device Quality Management Systems 13
Question regarding new VDA_AIAG fmea approach for process FMEA FMEA and Control Plans 0
FDA Submission Question US Medical Device Regulations 3
Cleanroom Question Manufacturing and Related Processes 10
Aircraft GAPP Software Testing Compliance Question AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 1
Quick question M3 screw plug gauge AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 0
FDA regulations medical device prescription fulfillment DME question US Medical Device Regulations 0
An interesting question about import company Other Medical Device Regulations World-Wide 5
Question about training Training - Internal, External, Online and Distance Learning 20
Labeling question about different manufacturers on a single label Manufacturing and Related Processes 4
Question regarding classification of custom made device EU Medical Device Regulations 5
Question about granite surface plates out of spec AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 9
MDR question - Meaning of Stability CE Marking (Conformité Européene) / CB Scheme 6
GD&T Question, True Position Confusion Inspection, Prints (Drawings), Testing, Sampling and Related Topics 2
Initial Importer question Other US Medical Device Regulations 2
Calibration question Manufacturing and Related Processes 4
Class Exempt Medical Device Recall Question US Food and Drug Administration (FDA) 3
Metric or Imperial; that is the question... After Work and Weekend Discussion Topics 6
Can someone help me with this CMM programming question? Manufacturing and Related Processes 2
A strange question about predicate device selected in 510(k) submission Medical Device and FDA Regulations and Standards News 8
Question regarding AQL - ISO 3951 Inspection, Prints (Drawings), Testing, Sampling and Related Topics 0
Document Control Question involving DocuSign US Food and Drug Administration (FDA) 6
Question about Customer Supplied Equipment AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
ISO 13485: 2016 Lot numbering question ISO 13485:2016 - Medical Device Quality Management Systems 4
Nadcap - Heat Treatment Proof of Verification question for Digital results AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
Question of Calibration Cycles AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 8
Software Validation Question ISO 13485:2016 - Medical Device Quality Management Systems 10
8.5.1.1 Control Plan - question audit NC IATF 16949 - Automotive Quality Systems Standard 5
Document Identification Question ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
Question regarding PCR workstation Fume Hood upon first use ISO 13485:2016 - Medical Device Quality Management Systems 0
ISO 9001 calibration question please ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
Quick question on the sequence of ISO 17025 external audits ISO 17025 related Discussions 14
ISO 13485--Question regarding performing calibrations in house. ISO 13485:2016 - Medical Device Quality Management Systems 13
Document numbering question? ISO 13485:2016 - Medical Device Quality Management Systems 7
Has the facility been inspected? question in Certificate to Foreign Government application Other US Medical Device Regulations 0
ESTAR 510(k) submission question Medical Device and FDA Regulations and Standards News 0
Question on clause 5.2.2 IEC 62304 - Medical Device Software Life Cycle Processes 2
ISO 15223 Question EU Medical Device Regulations 2
Question: Cg/Cgk formula Capability, Accuracy and Stability - Processes, Machines, etc. 4
Quick question on responsible person's experience requirements UK Medical Device Regulations 3