Question

Please use excel if possible

Companies that had recently developed new products were asked to rate which activities are most difficult to accomplish with new products. Options included such activities as assessing market potential, market testing, finalizing the design, developing a business plan, and the like. Researchers want to conduct a similar study to compare the results between two industries: the computer hardware industry and the banking industry. They take a random sample of 56 computer firms and 91 banks. They ask whether market testing is the most difficult activity to accomplish in developing a new product. Some 48% of the sampled computer companies and 56% of the sampled banks respond that it is the most difficult activity. Use a level of significance of 0.20 to test whether there is a significant difference in the responses to the question from these two industries.

Answer 1