Download working excel from here :

Problem Statement 1:

Solution:

Step 1: Identify

Step 2: Compute (Manually):

Step 3: Interpret

Step 4: Assess

Solve using:

Solve using R Program:

Solve using Python