Please show your calculation with excel or spreadsheet

Pharmaceutical Companies all want to be leaders in innovation. South Atlantic Medical assigned 6% of their researchers the task of studying the side effects of a new headache medicine. One researcher previously claimed that women are more than 5% more likely than men to become drowsy after taking headache medicine. A group of 2000 individuals made up of 60 % men was examined. 900 of the men reported drowsiness after taking headache medicine while 680 of women reported drowsiness after taking headache medicine.

1. a. At the 0.01 level of significance, what can you say about the researcher's claim? Use the p-value approach and report your findings.

2, b. What are the limitations on your conclusion to part (a) of this question? Please make your explanation in the context of this question.

A snow ploughing company located in the Central part of Ostional believe it is spending at least as much time servicing the same size lots in Hillaby as they do in the Belp section. The company is considering charging different prices in each area. The data below is the average time in minutes the company took to service lots in Hillaby and Belp.

Hillaby Belp

37 45

36 45

35 36

37 45

34 24

38 37

66 69

41 46

29 36

1. a. At the 1% significance level, what would you conclude? Use the p-value approach.