statistics questions

Overview

the answers are shown but i am not sure how to solve it. would you mind showing the solutions on excel .