Your Boss in the Human Resources Department Asks You to Write

question 8

Multiple Choice

Your boss in the human resources department asks you to write a function that calculates the length of time that employees have been with the firm, using the DATEDIF function. Assume that C2 contains the hire date for a given employee and that cell $AE$2 contains the cut-off date against which to compare the hire date to determine length of service.
-For one service recognition program,you need to calculate the length of service in complete months.What is the correct formula?

• A)=DATEDIF(C2, $AE$2, "m")
• B)=DATEDIF($AE$2, C2, "month")
• C)=DATEDIF($AE$2, C2, "mth")
• D)=DATEDIF(C2, $AE$2, "mon")

---

Definitions:

Hypothesis Test

A method in statistics that employs data from a subset to assess a presumption about a parameter of the whole population.

Z Test Statistic

A statistic that measures the number of standard deviations a data point is from the mean, used in hypothesis testing for population means.

Sample Proportion

Sample proportion refers to the fraction or percentage of the sample that exhibits a particular trait or characteristic of interest.

Population Parameter

A population parameter is a numerically fixed characteristic or measure of an entire population, such as mean or variance.