Auditors at the Numeros Verdes Partners, P.S.C., took a sample of 200 accounts payable bills, as shown

Question:

Auditors at the Numeros Verdes Partners, P.S.C., took a sample of 200 accounts payable bills, as shown in the table found in the worksheet Prob04-03 in the Excel workbook Ch04Data.xlsx on the Student Companion Site. Find the proportion of the accounts payable in the sample that are classified as overdue by using the Excel COUNTIF function.

 


















COUNTIF FUNCTION







































Answers the question: Is the bill overdue?





































FALSETRUEFALSEFALSETRUEFALSEFALSETRUETRUEFALSEFALSEFALSEFALSETRUEFALSEFALSETRUEFALSETRUEFALSE
FALSEFALSEFALSETRUEFALSEFALSEFALSEFALSEFALSETRUETRUEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSETRUE
FALSEFALSEFALSEFALSETRUETRUEFALSEFALSETRUEFALSEFALSEFALSEFALSETRUEFALSEFALSEFALSEFALSEFALSEFALSE
TRUEFALSETRUETRUEFALSEFALSETRUEFALSEFALSEFALSEFALSETRUEFALSETRUEFALSETRUEFALSEFALSEFALSEFALSE
FALSEFALSEFALSEFALSEFALSETRUEFALSEFALSEFALSETRUETRUEFALSETRUEFALSEFALSETRUEFALSEFALSETRUEFALSE
FALSEFALSEFALSETRUETRUEFALSEFALSEFALSEFALSEFALSEFALSEFALSETRUEFALSETRUEFALSETRUEFALSEFALSEFALSE
TRUEFALSEFALSEFALSEFALSETRUEFALSEFALSEFALSETRUEFALSEFALSEFALSETRUEFALSEFALSEFALSEFALSEFALSEFALSE
FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSETRUETRUEFALSEFALSEFALSEFALSEFALSEFALSEFALSETRUEFALSE
TRUEFALSEFALSEFALSETRUEFALSEFALSETRUEFALSEFALSETRUEFALSETRUEFALSEFALSEFALSEFALSEFALSEFALSEFALSE
FALSETRUEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSETRUEFALSEFALSETRUEFALSETRUETRUEFALSEFALSE





















GoodDefective


















50150







































Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: