Question

In: Statistics and Probability

Explain the inputs (and outputs if you know them) of the following Excel functions: • Norm.S.Dist()....

  1. Explain the inputs (and outputs if you know them) of the following Excel functions:

    • Norm.S.Dist(). • Norm.Inv().
    • T.Dist().

Solutions

Expert Solution

NORM.S.DIST(z,cumulative)

The NORM.S.DIST function syntax has the following arguments:

  • Z     Required. The value for which you want the distribution.

  • Cumulative     Required. Cumulative is a logical value that determines the form of the function. If cumulative is TRUE, NORMS.DIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.

Example

=NORM.S.DIST(1.333333,TRUE)  

output

0.908788726

so basically it finds p(x<=1.333) when x follows standard normal distribution with mean 0 and variance = 1

2)

Norm.Inv()

Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

Syntax

Norm.Inv(probability,mean,standard_dev)

The NORMINV function syntax has the following arguments:

  • Probability     Required. A probability corresponding to the normal distribution.

  • Mean     Required. The arithmetic mean of the distribution.

  • Standard_dev     Required. The standard deviation of the distribution.

Remarks

  • If any argument is nonnumeric, NORMINV returns the #VALUE! error value.

  • If probability <= 0 or if probability >= 1, NORMINV returns the #NUM! error value.

  • If standard_dev ≤ 0, NORMINV returns the #NUM! error value.

  • If mean = 0 and standard_dev = 1, NORMINV uses the standard normal distribution

Data

Description

0.908789

Probability corresponding to the normal distribution

40

Arithmetic mean of the distribution

1.5

Standard deviation of the distribution

Formula

Description

Result

=NORMINV(A2,A3,A4)

Inverse of the normal cumulative distribution for the terms above

42.000002

3)

T.Dist()

Returns the Student's left-tailed t-distribution. The t-distribution is used in the hypothesis testing of small sample data sets. Use this function in place of a table of critical values for the t-distribution.

Syntax

T.DIST(x,deg_freedom, cumulative)

The T.DIST function syntax has the following arguments:

  • X     Required. The numeric value at which to evaluate the distribution

  • Deg_freedom     Required. An integer indicating the number of degrees of freedom.

  • Cumulative     Required. A logical value that determines the form of the function. If cumulative is TRUE, T.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.

Remarks

  • If any argument is nonnumeric, T.DIST returns the #VALUE! error value.

  • If deg_freedom < 1, T.DIST returns an error value. Deg_freedom needs to be at least 1.

Example

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.

Formula

Description

Result

=T.DIST(60,1,TRUE)

Student's left-tailed t-distribution for 60, returned as the cumulative distribution function, using 1 degree of freedom.

0.99469533

=T.DIST(8,3,FALSE)

Student's left-tailed t-distribution for 8, returned as the probability density function, using 3 degrees of freedom.

0.00073691


Related Solutions

Create a static method with the appropriate inputs and outputs. Call each of them in the...
Create a static method with the appropriate inputs and outputs. Call each of them in the main method. Write a method called stringToListOfWords() which takes in a String converts it into a list of words. We assumes that each word in the input string is separated by whitespace.3 2Use the equals() method. 3The split() method of String can split an input up along a provided special string called a regular expression or regex. A regex is much like a code...
Create a static method with the appropriate inputs and outputs. Call each of them in the...
Create a static method with the appropriate inputs and outputs. Call each of them in the main method. Write a method called removeAllInstances() which takes in a List and item4 . The method then proceeds to remove each item in the list that matches the given item. For example, if the method is passed the List [1, 4, 5, 6, 5, 5, 2] and the Integer 5, the method removes all 5’s from the List. The List then becomes [1,...
Create a static method with the appropriate inputs and outputs. Call each of them in the...
Create a static method with the appropriate inputs and outputs. Call each of them in the main method. Write a method called isPermutaion() which takes in two List objects which contain the same types. It returns true if the Lists are permutations of each other and false if not. Two lists are permutations if they contain the same elements, including the same number of duplicates, but they don’t have to contain the elements in the same order. For example, [1,2,...
Create a static method with the appropriate inputs and outputs. Call each of them in the...
Create a static method with the appropriate inputs and outputs. Call each of them in the main method. Write a method named allMultiples() which takes in a List of integers and an int. The method returns a new List of integers which contains all of the numbers from the input list which are multiples of the given int. For example, if the List is [1, 25, 2, 5, 30, 19, 57, 2, 25] and 5 was provided, the new list...
Chapter 2 is using the EXCEL functions FV, PV, NPV, PMT, NPER, RATE & SUM. Explain in plain English in a clear and detail way how you can use these functions. How many inputs you need for each of these outputs?
Chapter 2 is using the EXCEL functions FV, PV, NPV, PMT, NPER, RATE & SUM. Explain in plain English in a clear and detail way how you can use these functions. How many inputs you need for each of these outputs? Are all inputs required? Why not? Use the excel help in order to understand these Formulas. Do not copy and paste. This question has seven parts, identify each part with a letter from the beginning of the alphabet, as...
Consider the following inputs and outputs associated with a DCS system.
  Consider the following inputs and outputs associated with a DCS system. It is interesting to note that EXACTLY the same could be applicable to a SCADA system (although the SCADA system could use either a dedicated RTU or else a PLC). Break the following signals up (either going to, or away from the RTU-type devices) and indicate which are: i) digital inputs, ii) digital outputs, iii) analog inputs and iv) analog outputs: 18.1 ( 1 mark) START signal 18.2...
Which of the following are measures of capacity in terms of outputs and inputs produced for...
Which of the following are measures of capacity in terms of outputs and inputs produced for the corresponding production system? Select one: A. Airline – customers checked out per hour – reservation calls handled per day B. Supermarket – available seat miles per year – cartons unloaded per hour C. University – graduates per year – students admitted per year D. Automobile assembly plant – autos assembled per year –packages delivered per day In planning the long-term capacity of an...
Write a Java program for RSA encryption that has the following inputs and outputs: Given a...
Write a Java program for RSA encryption that has the following inputs and outputs: Given a message and an integer n = pq where p and q are odd primes and an integer e > 1 relatively prime to (p − 1)(q − 1), encrypt the message using the RSA cryptosystem with key (n, e).
This is a question on the inputs and outputs on Basic javascript application What is the...
This is a question on the inputs and outputs on Basic javascript application What is the displayed output of the application if the user inputs Are: 1    in the first box, 2 in the second box, 3 in the third box, and 4 in the fourth box Modify the HTML and javascript file in order to Creates an h1 and a span element ii)          Accesses all the html elements, then adds the four input values as strings and sends the...
describe the inputs, the plants, and the outputs of open-loop control systems.
describe the inputs, the plants, and the outputs of open-loop control systems.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT