I need help on this following question with clear steps on how to solve it and how I can solve it on excel:

According to an estimate, more than four hundred thousand Canadians are fired from their jobs every year. A study by ABC Inc. identified the following reason for firing (shown in the first column):

ABC Inc. Recent Sample

Incompetence 38% 400

Negative attitude 32% 350

Dishonest 17% 150

Other 13% 100

a.Is the current distribution of reasons why employees were fired different from the results obtained by ABC Inc.? Test the hypothesis using a 5% level of significance.

b.Of the 400, 350, 150 and 100 employees interviewed, respectively, 350, 320, 140 and 90 had received a warning from their employer prior to the firing. At a 10% level of significance, can it be concluded that the reason for firing is related to previous warnings given by the employer?