Which of the following functions computes a value such that 2.5% of the area under the standard normal distribution lies in the upper tail defined by this value? ○ 0 ° ○ a.-normsinv(0.975) b.-norm·s. inv(0.05) c.-norm. s-inv(0.95) d.-normsinv(0.025)

a) NORM.S.INV(0.975)

Step-by-step explanation:

1) Some definitions

The standard normal distribution is a particular case of the normal distribution. The parameters for this distribution are: the mean is zero and the standard deviation of one. The random variable for this distribution is called Z score or Z value.

NORM.S.INV Excel function "is used to find out or to calculate the inverse normal cumulative distribution for a given probability value"

The function returns the inverse of the standard normal cumulative distribution(a z value). Since uses the normal standard distribution by default the mean is zero and the standard deviation is one.

2) Solution for the problem

Based on this definition and analyzing the question :"Which of the following functions computes a value such that 2.5% of the area under the standard normal distribution lies in the upper tail defined by this value?".

We are looking for a Z value that accumulates 0.975 or 0.975% of the area on the left and by properties since the total area below the curve of any probability distribution is 1, then the area to the right of this value would be 0.025 or 2.5%.

So for this case the correct function to use is: NORM.S.INV(0.975)

And the result after use this function is 1.96. And we can check the answer if we look the picture attached.

the most boring ever written

step-by-step explanation:

i am writing something. yes, i plan to make it the most boring thing ever written. i go to the store. a car is parked. many cars are parked or moving. some are blue. some are tan. they have windows. in the store, there are items for sale. these include such things as soap, detergent, magazines, and lettuce. you can enhance your life with these products. soap can be used for bathing, be it in a bathtub or in a shower. apply the soap to your body and rinse. detergent is used to wash clothes. place your dirty clothes into a washing machine and add some detergent as directed on the box. select the appropriate settings on your washing machine and you should be ready to begin. magazines are stapled reading material made with glossy paper, and they cover a wide variety of topics, ranging from news and politics to business and stock market information. some magazines are concerned with more recreational topics, like sports card collecting or different kinds of hairstyles. lettuce is a vegetable.

what graph

step-by-step explanation: