A. A new credit card company is investigating various market segments to determine whether it is profitable to direct its advertising specifically at each one. One of the market segments is composed of Asian migrants. The latest census indicates that there are 2.01 million Asian migrants in Australia. A survey of 475 Asian migrants asked each how they usually pay for products that they purchase. The responses are:

1 Cash

2 Cheque

3 Visa

4 MasterCard

5 Other credit card.

The responses are recorded and stored in file 3ACARD.xlsx. Estimate with 95% confidence the number of Asian migrants in Australia who usually pay by credit card.

B. An insurance company boasts that 90% of its customers who make claims are satisfied with the service. To check the accuracy of this declaration, the company conducts an annual Claimant Satisfaction Survey in which customers are asked whether they were satisfied with the quality of the service (1 = Satisfied and 2 = Unsatisfied). Their responses are recorded and stored in file 3BSERVICE.xlsx. Can we infer at the 5% level of significance (a= 0.05) that the satisfaction rate is less than 90%?

Here is the link for data .

https://1drv.ms/x/s!AqswQjmPQpq6jxfGU3Rn0TzoEdKf?e=zj9sFF

https://1drv.ms/x/s!AqswQjmPQpq6jxhc5a2PQZPMlAlW?e=bZ19AW

please provide link for solved data file. Thank you.