Choose all the answers that apply to Excel array functions

1. Choose all the answers that apply to Excel array functions.

a) Use parentheses ()

b) =FREQUENCY() is an array function

c) Use other computer keys besides Enter to create function

d) Inputs are separated by semicolon

e) =COUNT() is an array function

f) Display curly braces {}

2. Choose all probability distributions which are theoretically related to the normal probability distribution.

a) Chi Square

b) Morphet’s Q

c) Z

d) G

e) F

f) Student’s t

3. The 68-95-99.7 rule states that in a normal distribution:

a) 95% of all values are within 2 standard deviations from the mean

b) The probability of a random value to be 2 standard deviations above the mean or 2 standard deviations below the mean is 95%

c) The probability of a random value to be within 2 standard deviations above the mean is 95%

d) The probability of a random value to be between 1 and 2 standard deviations above the mean is 95%

4. For a normal distribution with a mean of 124 and a standard deviation of 28, what is the Z value (distance from the mean) for a random value to be 248? (Use 2 decimal digits, show work).