Crack the case, someone is familiar with law, statistic and excel.

Read the case and the other material, then Crack the case in detail by answering questions attached below. (Expecially in question 3, I want it be a long paragraph, but keep it simply as possible. You make use the material given as reference, or cited other material or source)