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 1. Microsoft Excel spreadsheet showing detailed descriptiv

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
icon
Related questions
Question

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

1. Microsoft Excel spreadsheet showing detailed descriptive analysis.

2. Microsoft Word file with executive summary of with written analysis for Mr. Selig. (250
words minimum)

 

### Bank Account Data Overview

This table presents data from 60 different bank accounts, covering various attributes related to the accounts. The columns are defined as follows:

- **\( x_1 \)**: Account balance in $
- **\( x_2 \)**: Number of ATM transactions in the month
- **\( x_3 \)**: Number of other bank services used
- **\( x_4 \)**: Has a debit card (1 = yes, 0 = no)
- **\( x_5 \)**: Receives interest on the account (1 = yes, 0 = no)
- **\( x_6 \)**: City where banking is done

Below is the detailed data for the 60 accounts:

| \( x_1 \) | \( x_2 \) | \( x_3 \) | \( x_4 \) | \( x_5 \) | \( x_6 \) |
|-----------|-----------|-----------|-----------|-----------|-----------|
| 1,756     | 13        | 4         | 0         | 1         | 2         |
| 748       | 9         | 2         | 1         | 0         | 1         |
| 1,501     | 10        | 1         | 0         | 1         | 0         |
| 1,831     | 10        | 0         | 1         | 1         | 1         |
| 1,622     | 14        | 6         | 0         | 1         | 4         |
| 1,886     | 17        | 3         | 0         | 1         | 1         |
| 740       | 6         | 3         | 0         | 1         | 3         |
| 1,593     | 10        | 8         | 1         | 0         | 1         |
| 1,169     | 6         | 4         | 0         | 1         | 3         |
| 2,125     | 18        | 8         | 0         | 1         | 4         |
| 1,554     | 12        | 6         | 1         | 0         | 1
Transcribed Image Text:### Bank Account Data Overview This table presents data from 60 different bank accounts, covering various attributes related to the accounts. The columns are defined as follows: - **\( x_1 \)**: Account balance in $ - **\( x_2 \)**: Number of ATM transactions in the month - **\( x_3 \)**: Number of other bank services used - **\( x_4 \)**: Has a debit card (1 = yes, 0 = no) - **\( x_5 \)**: Receives interest on the account (1 = yes, 0 = no) - **\( x_6 \)**: City where banking is done Below is the detailed data for the 60 accounts: | \( x_1 \) | \( x_2 \) | \( x_3 \) | \( x_4 \) | \( x_5 \) | \( x_6 \) | |-----------|-----------|-----------|-----------|-----------|-----------| | 1,756 | 13 | 4 | 0 | 1 | 2 | | 748 | 9 | 2 | 1 | 0 | 1 | | 1,501 | 10 | 1 | 0 | 1 | 0 | | 1,831 | 10 | 0 | 1 | 1 | 1 | | 1,622 | 14 | 6 | 0 | 1 | 4 | | 1,886 | 17 | 3 | 0 | 1 | 1 | | 740 | 6 | 3 | 0 | 1 | 3 | | 1,593 | 10 | 8 | 1 | 0 | 1 | | 1,169 | 6 | 4 | 0 | 1 | 3 | | 2,125 | 18 | 8 | 0 | 1 | 4 | | 1,554 | 12 | 6 | 1 | 0 | 1
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON