Undertaking data analytics and reporting using standard statistical techniques extracting and presenting data in microsoft excel and result comparison chart…