The Questions are here and the Excel sheets are in the attached file.

1. Use the Baseball tab and write a memo describing your findings about the relationship between number of wins and payroll. Apply the regression analysis and include the following information:

a. Regression coefficients

b. Coefficient of determination

c. Correlation coefficient

d. Determine how well if the relationship between number of wins and payroll is significant by using testing hypothesis method.

e. Determine an estimate for the cost of an additional win.

2. Annual surveys are conducted to determine the level of confidence in the future prospects of the economy. A sample of 1,000 adults was asked the following question:

Question: Compare to last year, what do you think this year will be

1 – better?

2 – the same?

3 – worse?

Related data is found in Economy tab of project data file.

Use a suitable graphical technique to summarize these data. Describes your findings>

3. A bank manager took a random sample of 300 loans that were granted using a new scorecard. The cutoff id 65o, which means that those scoring below are predicted to default and those scoring above are predicted to repay. These cores are found in the Scorecard tab of the data file.

a. Use a graphical technique to present the scores of those who paid.

b. Use a graphical technique to present the scores of those who defaulted.

c. What have you learned about the scorecard?

1. Use the Baseball tab and write a memo describing your findings about the relationship between number of wins and payroll. Apply the regression analysis and include the following information:

a. Regression coefficients

b. Coefficient of determination

c. Correlation coefficient

d. Determine how well if the relationship between number of wins and payroll is significant by using testing hypothesis method.

e. Determine an estimate for the cost of an additional win.

2. Annual surveys are conducted to determine the level of confidence in the future prospects of the economy. A sample of 1,000 adults was asked the following question:

Question: Compare to last year, what do you think this year will be

1 – better?

2 – the same?

3 – worse?

Related data is found in Economy tab of project data file.

Use a suitable graphical technique to summarize these data. Describes your findings>

3. A bank manager took a random sample of 300 loans that were granted using a new scorecard. The cutoff id 65o, which means that those scoring below are predicted to default and those scoring above are predicted to repay. These cores are found in the Scorecard tab of the data file.

a. Use a graphical technique to present the scores of those who paid.

b. Use a graphical technique to present the scores of those who defaulted.

c. What have you learned about the scorecard?

### Recently Asked Questions

- Chemists commonly use a rule of thumb that an increase of 10 °C in temperature doubles the rate of certain types of reactions . What must the activation

- A bead is moving with a speed of 20 m/s at position A on the track shown in the figure . This track is friction-free , and there is no appreciable air

- Suppose the economy 's saving schedule shifts from S 1 to S 2 as shown in the below diagram . We can say that its :