Question: QUESTION 1 QUESTION 1 In Excel, we can use the binomial distribution to calculate the probability of getting three heads in three tosses of a

QUESTION 1

QUESTION 1

In Excel, we can use the binomial distribution to calculate the probability of getting three heads in three tosses of a coin as:

A.

BINOM(3,0.5,3,TRUE)

B.

BINOM(3,3,0.5, FALSE)

C.

BINOM.INV(3,3,0.5, TRUE)

D.

BINOM.DIST(3,3,0.5, FALSE)

1 points

QUESTION 2

With regard to percentiles and quartiles, which of the following statements are true:

A.

The 25th percentile is the second quartile

B.

The 50th percentile is the third quartile

C.

Both A and B

D.

Neither A nor B

1 points

QUESTION 3

A sample of 7 apples have weights 134, 238, 163, 179, 224, 207, 158 grams. Find the standard deviation.

A.

37.98

B.

35.16

C.

36.88

D.

34.90

1 points

QUESTION 4

Find Q3-Q1 for these nine values: 114, 112, 178, 192, 134, 128, 149, 165, 172, 103. Include the endpoints.

A.

68.55

B.

72.25

C.

52.75

D.

75.45

1 points

QUESTION 5

What is the probability of getting heads exactly 3 times when you toss a coin 7 times?

A.

0.34

B.

0.50

C.

0. 45

D.

0.27

1 points

QUESTION 6

The geometric mean:

A.

is calculated as the reciprocal of the average of the reciprocals

B.

is calculated in Excel by HARMEAN

C.

Both A and B

D.

Neither A nor B

1 points

QUESTION 7

Alex made an investment of $25,678 which had a return rate of 2.7% in the first year, 5.87% in the next year and 3.89% in the third year. What is the average rate of return on Alex's investment?

A.

3.95%

B.

4.05%

C.

3.75%

D.

3.50%

1 points

QUESTION 8

A set of data is described as being skewed to the right. This means:

A.

A majority of the data is on the right

B.

A majority of the data is on the left

1 points

QUESTION 9

Which of the following calculations will dampen the effect of large values?

A.

Arithmetic mean

B.

Geometric mean

C.

Harmonic mean

1 points

QUESTION 10

In Excel, we calculate the range as:

A.

=MAX(some values) - MIN(some values)

B.

=RANGE(maximum value, minimum value)

C.

Both A and B

D.

Neither A nor B

1 points

QUESTION 11

What is the first quartile and the 5th decile of this set of values: 43, 69, 28, 72, 36, 66, 88, 91, 23?

A.

66, 36

B.

72, 66

C.

72, 36

D.

36, 66

1 points

QUESTION 12

The wait time for customer service call is normally distributed with a mean of 10 minutes and standard deviation of 4 minutes. What is the probability that the wait time is greater than 15 minutes?

A.

10.56%

B.

89.43%

C.

78.82%

D.

63.28%

1 points

QUESTION 13

What is the probability of getting heads exactly 3 times when you toss a coin 7 times?

A.

0.34

B.

0.50

C.

0.45

D.

0.27

1 points

QUESTION 14

The covariance between two sets of values lies between -1 and +1.

A.

This is true

B.

This is false

1 points

QUESTION 15

Scores of 10 students are 45, 53, 56, 64, 68, 73, 78, 82, 85, 93. Only students who score above the 60th percentile pass the exam. How many students passed the exam?

A.

3

B.

2

C.

4

D.

5

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!