View the step-by-step solution to:

# Team Payroll Wins ALAnaheim 79.03 ALBaltimore 73.88 ALBoston 99.95 ALChicago 51.01 ALCleveland 48.58 ALDetroit 49.17 ALKansas City 40.52 ALMinnesota...

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?

Team Payroll Wins ALAnaheim 79.03 77 ALBaltimore 73.88 71 ALBoston 99.95 95 ALChicago 51.01 86 ALClevelan 48.58 68 ALDetroit 49.17 43 ALKansas C 40.52 83 ALMinnesot 55.51 90 ALNew York 152.75 101 ALOakland 50.26 96 ALSeattle 86.96 93 ALTALpa B 19.63 63 ALTexas 103.49 71 ALToronto 51.27 86 NLArizona 80.6 84 NLAtlanta 106.2 101 NLChicago 79.9 88 NLCincinna 59.4 69 NLColorado 67.2 74 NLFlorida 49.1 91 NLHouston 71.0 87 NLLos Ange 105.9 85 NLMilwauke 40.6 68 NLMontreal 51.9 83 NLNew York 117.2 66 NLPhiladelp 70.8 86 NLPittsburg 54.8 75 NLSan Dieg 47.9 64 NLSan Fran 82.9 100 NLSt. Louis 83.5 85
Opinion 2 3 2 1 2 1 1 1 1 3 1 2 2 2 2 1 1 1 1 1 1 1 1 1 1 1 1 3 1 1 1 2 1 1 2 1 1 1 2 3 2 1 1 1 2 2 1 3 1 1 2 1 2 2 1 2 2 1 1 1 1 1 1 1 2 1 1 3 3 1 1 3 2 3 1 2 1 2 3 1 2 1 3 3 1 2 3 1 1 1 3 1 3 1 2 2 1 1 1 1 1 1 1 3 1 1 1 2 1 3 2 1 2 1 1 1 2 1 1 1 2 3 1 1 1 3 2 2 1 1 1 1 1 2 2 1 1 1 1 1 1 1 1 3 1 1 1 1 1 1 1 3 2 1 1 1 3 1 1 2 1 1 2 2 3 1 2 1 2 1 2 2 2 1 3 1 2 1 1 2 1 1 1 1 2 3 1 1 2 1 1 1 2 1 2 1 1 2 1 3 1 2 2 1 2 1 2 1 1 1 1 1 2 1 2 2 2 1 1 2 1 1 3 1 1 1 1 1 1 2 2 1 2 1 1 1 1 3 1 3 1 2 1 1 1 1 3 1 1 3 2 1 1 2 1 1 1 1 1 2 1 1 1 1 1 3 2 1 1 3 2 1 1 1 1 1 1 1 3 1 2 1 1 1 3 1 1 2 1 2 1 1 2 2 2 2 1 1 1 1 3 1 1 1 1 1 1 2 2 1 1 1 1 1 2 1 1 2 2 2 2 1 2 1 1 1 1 1 1 1 2 1 1 1 1 2 1 1 2 2 1 2 1 1 2 1 2 3 1 1 1 1 1 1 1 1 3 1 2 1 2 1 1 1 1 2 1 2 1 3 1 1 1 1 1 1 1 3 1 1 1 2 2 1 2 1 1 1 1 1 1 2 1 3 1 1 1 2 2 1 3 1 3 1 1 1 1 1 2 3 3 1 1 2 1 1 1 1 1 1 1 1 3 3 1 1 1 2 1 1 1 1 1 2 1 1 2 1 3 1 2 1 1 1 2 2 1 2 1 1 1 1 1 1 1 2 1 1 1 1 3 1 1 1 1 1 1 2 3 1 1 2 1 1 2 1 1 1 1 1 1 2 1 2 1 2 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 2 1 1 1 1 1 3 1 1 1 1 1 1 1 1 1 1 1 1 3 2 2 2 1 1 1 2 1 1 3 1 3 1 1 2 2 2 2 1 1 1 1 1 1 1 1 2 2 3 1 2 1 1 1 2 1 3 3 2 1 1 1 1 1 3 1 2 1 1 1 1 1 1 2 2 1 1 3 3 1 2 1 3 1 1 1 1 3 3 1 1 2 3 1 2 1 1 3 1 1 1 1 1 1 1 1 3 1 1 1 1 1 2 1 3 1 1 1 1 1 1 1 2 2 1 1 1 2 1 1 1 1 1 1 1 1 3 1 1 2 1 3 1 1 1 3 3 3 1 1 1 2 1 1 1 1 1 2 3 1 1 1 3 2 1 1 1 3 1 3 1 1 2 1 1 1 1 1 1 1 1 1 2 1 3 2 1 3 3 2 1 1 1 1 3 3 1 1 1 3 1 2 1 1 1 1 2 2 1 1 3 2 1 1 1 2 1 2 1 1 1 2 1 1 2 1 1 1 1 1 2 1 2 1 1 2 1 2 1 2 2 1 1 2 1 1 2 2 3 1 1 1 1 1 3 2 1 3 1 3 1 2 2 1 2 1 3 2 1 2 1 1 1 1 1 2 1 1 1 2 3 2 2 1 1 1 1 1 1 1 1 2 1 1 2 1 1 1 1 2 1 1 1 3 1 3 1 2 1 3 3 1 1 1 1 1 1 1 3 1 1 1 1 2 3 2 1 3 1 2 1 1 2 1 1 1 1 1 3 1 1 1 1 2 1 1 1 1 1 1 1 2 2 2 2 1 1 3 1 1 2 1 3 1 1 1 1 1 2 1 1 1 3 2 1 2 1 1 1 3 1 1 3 2 2 3 1 1 1 1 3 3 1 3 1 1 2 2 3 2 3 1 2 1 1 1 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 1 2 2 1 1 1 1 1 1 3 1 3 3 2 1 1 2 1 3 1 1 1 2 1 3 1 2 1 2 1 3 3 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3 1 2 1 1 1 1 1 1 1 1 1 1 1 1 2 3 1 1 1
Show entire document

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents