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.
Please find attached the required drawing that illustrates the given situation
With a driving speed of 0.003 miles per second, which is approximately 4.83 meters per second, we have the drawing of the graph that represent the given situation which is create with Microsoft Excel and attached alongside here
The total time for the travel is approximately 2,244 second with a total distance of approximately 6.732 miles, using angles, 60° for a steep slope and 30° for a gentle slope