send me excel file

Read, understand and solve each item carefully. Show your complete solution on the answer sheet column. Direction: Solve each problem showing all the necessary steps and computations. 1. Given are the capital shares of 12 randomly chosen member accounts of a certain cooperative. Shared Capital: 7500, 12800, 9650, 13000, 25000, 15000, 15500, 17250, 18600, 21050, 16750, 17800, 15000, 22100, 10210 Can it be claimed that the average capital share of the members is significantly different from 16,000? Use a 1% level of significance and follow the necessary steps below: (10 points) Null and Alternative Hypothesis (both in symbols and statement form) ii. Level of Significance; sample size; test statistics iii. Decision Rule iv . Computation: Paste here the solution you made using Excel V . Decision AND Conclusion: 2. A sample of 800 items produced on a new machine showed that 48 of them are defective. The factory will get rid the machine if the data indicates that the proportion of defective items is significantly more than 5%. At a significance level of 5%, is there enough evidence to get rid of the machine? The following steps should be indicated in your answer: (10 points) i. Null and Alternative Hypothesis (both in symbols and statement form) ii. Level of Significance; sample size; test statistics iii. Decision Rule iv. Computation: Paste here the solution you made using Excel; or write your manual computation. v. Decision AND Conclusion