### Find standard deviations

Assignment Help Basic Computer Science
##### Reference no: EM1379484

Credit scorecards are used by banks and financial institutions to determine whether applicants will receive loans. The scorecard is the product of a statistical technique that converts questions about income, residence, and other variables into a score. The higher the score, the higher the probability is that the applicant will repay.

A small bank that heretofore did not use a scorecard wanted to determine whether a score-card would be advantageous. The bank manager took a random sample of 300 loans that were granted and scored each on a scorecard borrowed from a similar bank. This scorecard is based on the responses supplied by the applicants to questions such as age, marital status, and household income. The scores of those who repaid and the scores of those who defaulted were recorded.

a. Use EXCEL to calculate the lower confidence limit (LCL) and upper confidence limit (UCL) at 95% confidence for the mean score of those who repaid.

b. Use EXCEL to calculate the lower confidence limit (LCL) and upper confidence limit (UCL) at 95% confidence for the mean score of those who defaulted.

Notes:

1. Use AVERAGE function to find means.  For example, you may use the following statement to find mean for part (a)

= AVERAGE (A2:A221)

2. Use STDEV function to find standard deviations. You may use the following statement to find standard deviation for part (a)

= STDEV (A2:A221)

3. Use NORMSINV function to find ZA:

= NORMSINV (1-A)

You will need these to find confidence limits.

4.  Computer projects are individual efforts, and not team projects.

#### Questions Cloud

 What channels did companies use to communicate : What channels did companies use to communicate prior to the electronic age? Do you think that communication in businesses was more effective prior to the electronic age Identify the ethical as well as legal issues : Identify the ethical as well as legal issues of which Albert needs to be aware. Deliberate the advantages and disadvantages of each decision that Albert could make and has made. You must select between two sales recruits : You must select between two sales recruits. One has scored very high in terms of the excellence of his interview however not very well on the series of psychological tests to predict qualities the firm thinks are necessary for success. Presume that technophiles are willing to pay : Presume that technophiles are willing to pay \$400 now for the latest iPhone however only \$300 if they have to wait a year. Normal people are eager to pay \$250 and their desire to purchase doesn't vary with time. Find standard deviations : A small bank that heretofore did not use a scorecard wanted to determine whether a score-card would be advantageous.  find standard deviations. Values in an organization influence ethical behaviour : Given that individual alterations in values in an organization influence ethical behaviour, explain how organizations can use this knowledge to increase ethical behaviour. What does it mean to be a member of an oppressed : What does it mean to be a member of an oppressed or subordinate group? How does mass media subsidise to the perpetuation of stereotypes and prejudice in the United States? How does racial as well as ethnic groups define prejudice : How does Racial as well as Ethnic Groups define prejudice? Do you agree with this definition? Why or why not? Racial profiling is frequently in the news as well as is a prime example of stereotyping in action What are benefits in addition to frustrations with working : What are benefits in addition to frustrations with working with virtual teams?

### Write a Review

#### Explain why companies get better results-information system

Using three components of information systems and complementary assets concepts, explain why some companies achieve better results with information systems than others.

#### Describe how cpu can achieve i-o with teletype by registers

Consider a computer system that contains an I/O module controlling a simple keyboard/ printer Teletype. Describe how de CPU, using the first four registers listed in this problem, can achieve I/O with the Teletype.

#### Conduct observation used in business or organization

Conduct the observation to someone involved in procedure which is used in a business or organization. This person could be someone at university, in small business in your neighborhood.

#### Describe how single-user system scheme works

Give a real-life example of a single-user system scheme, fixed partitions, dynamic partitions, and relocatable dynamic partitions. Describe how process works.

#### Explaining reliable information systems staff member

How many information systems staff member do you think Reliable can reasonably afford to employ? what mix of skills would they need?

#### Classify memory in hierarchy

Classify a memory in hierarchy according to the two most common attributes like accessing method and speed.

#### Explaining security risks for computing infrastructure

In your new position at XYZ Corporation, you have been asked to lead risk assessment team. As part of project to assess security risks for computing infrastructure.

#### What is effect of control hazards on cpi for pipeline

What is the effect of control hazards on the CPI for this pipeline? Consider the two cases of "predict branch not taken" and "predict branch taken".

#### Compute the cost of sorting the relation in seconds

Suppose a flash storage device is used instead of disk, and it has a seek time of 1 microsecond and a transfer rate of 40 MB per second. Recompute the cost of sorting the relation in seconds with.

#### First instruction executed if we start machine with counter

Suppose the memory cells at addresses 00 through 02 contain the following bit patterns. What would be the first instruction executed if we start the machine with its program counter containing 00?

#### Circuit diagram-truth table for half subtractor-full adder

Illustrate the circuit diagram of the following circuit and create truth table for half subtractor and full adder. Full subtractor and Half adder.

#### What bit pattern will be in memory cell

What bit patterns will be in registers 0, 1, and 2 when the machine halts? What bit pattern will be in the memory cell at address 30 when the machine halts?