SHOW IN EXCEL WITH STEPS AND SCREENSHOTS PLEASE

Auditors at the Valles Verdes Partners, P.S.C. took a sample of 150 accounts payable bills, as shown in the table found in the Excel worksheet Prob. 6-2 in the Excel workbook C06Data.

Valles Verdes Partners Overdue Paid Paid OverdueOverduePaid Paid OverdueOverduePaid OverdueOverduePaid OverduePaid Overdue OverdueOverdueOverdueOverdueOverdueOverduePaid OverdueOverdueOverdueOverdueOverdueOverdueOverdue Overdue OverduePaid Paid OverdueOverduePaid OverdueOverduePaid OverdueOverdueOverdueOverdueOverdue Paid OverdueOverdueOverduePaid OverdueOverdueOverduePaid Paid OverduePaid OverdueOverdueOverdue Overdue OverdueOverduePaid OverdueOverdueOverduePaid OverdueOverdueOverduePaid OverdueOverduePaid Paid OverdueOverduePaid OverdueOverdueOverdueOverdueOverdueOverduePaid OverduePaid OverdueOverdue Overdue OverdueOverdueOverdueOverdueOverdueOverduePaid OverduePaid OverdueOverdueOverdueOverdueOverdue Paid OverduePaid OverdueOverdueOverdueOverduePaid OverdueOverdueOverdueOverdueOverdueOverduePaid Overdue Paid OverdueOverdueOverduePaid OverdueOverdueOverdueOverdueOverdueOverdueOverdueOverdueOverdue Overdue OverdueOverduePaid OverdueOverduePaid OverduePaid OverdueOverdueOverduePaid OverdueOverdue

a. Find the proportion of the accounts payable in the sample that are classified as overdue by using the Excel COUNTIF function. b. If an auditor takes a random sample of only 15 accounts from this population, assuming that they follow a binomial distribution, what is the probability that: (i) exactly 6 bills will be overdue? (ii) 3 or fewer bills will be overdue? (iii) 7 or more bills will be overdue? Use the binomial probability distribution formula and verify your result using Excel Binomial spreadsheet template.