PLEASE HELP SOLVE USING EXCEL:

CASE A. Century National Bank

Refer to the Century National Bank data. Is it reasonable

that the distribution of checking account balances approximates

a normal probability distribution? Determine the

mean and the standard deviation for the sample of 60 customers.

Compare the actual distribution with the theoretical

distribution. Cite some specific examples and comment on

your findings.

Divide the account balances into three groups, of

about 20 each, with the smallest third of the balances in the

first group, the middle third in the second group, and those

with the largest balances in the third group. Next, develop a

table that shows the number in each of the categories of the

account balances by branch. Does it appear that account

balances are related to the branch? Cite some examples

and comment on your findings.

\f\f