Share
Explore BrainMass

Compare insurance amounts and customer satisfaction among BankTen customers to the national average.

See attached data file.

Before you write your report for Cindy, use the Customer Data template in Materials below to work with the data, as follows:

Estimate the total market size of the insurance business for the target population (i.e., estimate the total dollar volume of the insurance business done by the entire population of the bank's target customers).

Estimate the number of customers that may be willing to do insurance business with BankTen.

Compare the amount spent on insurance and customer satisfaction rates among BankTen customers with the national average.

Describe whether it is possible to estimate annual insurance expenses based on the annual income of customers?how reliable would such an estimate be?

From: Cindy Parker, VP of Corporate Strategy
To: You, Analyst
Subject: Insurance Data

I have one more big project I'd like you to work on. As BankTen moves toward becoming an integrated services provider, we are investigating the feasibility of starting an insurance business (excluding health insurance) for a segment of our customers. There are about 80,000 bank customers in the target population. Ideally, we would have contacted every customer to directly assess the potential amount of insurance business from each customer. However, the process of contacting and interviewing customers is extremely expensive, and we only had enough money in the budget to interview 100 customers. With the help of branch mangers and information technology staff, we successfully obtained responses from 100 randomly selected customers from the target population.

I have provided you with an Excel file, Customer Data 5b, that contains information on the total dollars each customer spends on insurance and an indication of whether each is happy with the current insurance provider(s). In addition, we have been able to get an estimate of the annual income of these customers from the bank's own database. I'd like you to analyze the data and make a short report to the management that shows the estimated total market size of the insurance business for the target population (i.e., the total dollar volume of the insurance business done by the entire population of the bank's target customers), as well as the estimated number of customers who may be willing to do insurance business with BankTen.

In addition, a recent national study done by the American Banking Association showed that a typical customer in our target population spends about $5,000 per year and about 25 percent of the customers are dissatisfied with their insurance providers. You should compare the BankTen customer population to find out if it is different from the national population as a whole.

Finally, is it possible for us to estimate annual insurance expenses based on annual income of customers? How reliable would such an estimate be?

Thanks,

Cindy

Compare the amount spent on insurance and customer satisfaction rates among BankTen customers with the national average.

This is actually 2 different questions. The first question asks you to compare insurance rates from the data file (Bank Tem) to the 'population' insurance rates (in the email). This requires a hypothesis test comparing means. The second question asks about comparing satisfaction rates from the data file (Bank Ten) and the population (in the email). This requires a hypothesis test of proportions.

Attachments

Solution Summary

In a 607 word detailed response, the questions are answered including statistical calculations.

$2.19