I have attached the question to answer with the data. Please use Excel. Thanks, Your assignment for

Posted Date: