COMPREHENSIVE SPREADSHEET MODELLING FINAL EXAM 2026 200 QUESTIONS AND

COMPREHENSIVE SPREADSHEET MODELLING FINAL EXAM 2026 200 QUESTIONS AND ( ANSWERS)

COMPREHENSIVE SPREADSHEET MODELLING

FINAL EXAM 2026 200

QUESTIONS AND CORRECT DETAILED

ANSWERS WITH RATIONALES (

ANSWERS)

If a z-score is zero, then the corresponding x-value must be

equal to the

a. mode.

b. mean.

c. standard deviation.

d. median. - ANSWER- mean.

In a normal distribution, which is greater, the mean or the

median?

a. Mean

b. Median

c. Neither the mean or the median (they are equal)

d. Cannot be determined with the information provided. -

ANSWER- Neither the mean or the median (they are equal)

The center of a normal curve is

a. the mean of the distribution.

b. equal to the standard deviation.

c. always a positive number.

d. always equal to zero. - ANSWER- the mean of the

distribution.

Which of the following is not a characteristic of the normal

probability distribution?

a. The mean of the distribution can be negative, zero, or

positive.

b. The standard deviation must be 1.

c. The mean, median, and the mode are equal.

d. The distribution is symmetrical. - ANSWER- The standard

deviation must be 1.

A health conscious student faithfully wears a device that tracks

his steps. Suppose that the distribution of the number of steps he

takes in a day is normally distributed with a mean of 10,000 and

a standard deviation of 1,500 steps. What percent of the days

does he exceed 13,000 steps?

a. 5%

b. 2.28%

c. 97.72%

d. 95% - ANSWER- 97.72%

The newest model of smart car is supposed to get excellent gas

mileage. A thorough study showed that gas mileage (measured

in miles per gallon) is normally distributed with a mean of 75

miles per gallon and a standard deviation of 10 miles per gallon.

What is the probability that, if driven normally, the car will get

100 miles per gallon or better?

a. 25%

b. 0.6%

c. 2.5%

d. 6% - ANSWER- b. 0.6%

A health conscious student faithfully wears a device that tracks

his steps. Suppose that the distribution of the number of steps he

takes in a day is normally distributed with a mean of 10,000 and

a standard deviation of 1,500 steps. One day he took 13,000

steps. What was his percentile on that day?

a. 95%

b.

c. 97.7%

d. 99.7% - ANSWER- 97.7%

The newest model of smart car is supposed to get excellent gas

mileage. A thorough study showed that gas mileage (measured

in miles per gallon) is normally distributed with a mean of 75

miles per gallon and a standard deviation of 10 miles per gallon.

What value represents the 50th percentile of this distribution?

a. 85

b. 75

c. 105

d. 95 - ANSWER- 75

A health conscious student faithfully wears a device that tracks

his steps. Suppose that the distribution of the number of steps he

takes is normally distributed with a mean of 10,000 and a

standard deviation of 1,500 steps. How many steps would he

have to take to make the cut for the top 5% for his distribution?

a. 7,533

b. 10,000

c. 12,467

d. 8,078 - ANSWER- 12,467

What is the mean of x, given the exponential probability

function

a. 0.05

b. 100