When Using Excel to Calculate a P-Value for an Upper-Tail

question 1

Multiple Choice

When using Excel to calculate a p-value for an upper-tail hypothesis test, the following must be used

• A)RAND
• B)1 - NORM.S.DIST
• C)NORM.S.DIST
• D)Not enough information is given to answer this question.

---

Definitions:

Somatic Nervous

The part of the peripheral nervous system that handles voluntary control of body movements through the control of skeletal muscles and also mediates sensory information from the external environment.

Physical Reactions

Bodily responses to stimuli, which can include reactions like sweating, shaking, or increased heart rate.

Sensory Stimulus

Any object or event that is input to the senses, leading to a response or recognition from the body or brain.

Reflex

An automatic, involuntary response to a stimulus without the involvement of conscious thought.