Author Question: The _____________ button provides an automatic means of checking for mathematical errors within ... (Read 59 times)

tfester · **on:** Jun 24, 2018

The _____________ button provides an automatic means of checking for mathematical errors within formulas of a worksheet.
a. Error Checking b. Trace Precedents
c. Watch Window d. Math & Trig

Question 2

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. What percent of the time does he exceed 13,000 steps?
a. 2.28
b. 5.0
c. 95
d. 97.72

meltdown117 · **Reply #1 on:** Jun 24, 2018

Answer to Question 1

a
RATIONALE: The Error Checking button provides an automatic means of checking for mathematical errors within formulas of a worksheet.

Answer to Question 2

a
RATIONALE: We are asked to calculate P(X > 13,000) given a normal distribution with a mean of 10.000 and a standard deviation of 1,500 steps. This probability can be calculated using the Excel function 1 NORM.DIST(13000, 10000, 1500, TRUE) = 0.0228.