Question

In: Math

Econ 2310 Business Statistics: Problem Set #1 Instructions: You may use Excel and/or a calculator to...

Econ 2310

Business Statistics: Problem Set #1

Instructions: You may use Excel and/or a calculator to complete this assignment. Please show work or reference what Excel commands you used to solve the problems.

  1. You are given the following two series on income and credit scores.

Income

FICO

39

625

27

600

57

710

31

595

34

610

50

840

38

726

62

710

43

635

49

560

  1. Find the covariance and the correlation coefficient. (B) Do credit scores increase, decrease, stay the same, with Income? (C) Create a scatter plot with Income and credit score. What do you see?
  1. Suppose you flip a fair coin four time. (A) What is the probability you will get all four heads? (B) All four tails? (C) Either all four heads or four tails? (D) Anything but four heads or four tails?

  1. Crime and Punishment: In a study of pleas and prison sentences, it is found that 45% of the subjects studied were sent to prison. Among those sent to prison, 40% chose to plead guilty. Among those not sent to prison, 55% chose to plead guilty.    
  1. If one of the study subjects is randomly selected, find the probability of getting someone who was not sent to prison.
  2. If a study subject is randomly selected and it is then found that the subject entered a guilty plea, find the probability that this person was not sent to prison.

  1. In the BS Lottery (which stands for “Business Statistics”, of course), players choose 5 numbers out of 30. They win if they choose the same 5 numbers as our machine, which selects the numbers randomly. (A) How many permutations are possible? (B) How many combinations are possible?

  1. Below is a table of X and its frequency. What is the mean of X? What is the standard deviation of X? What is the variance of X?

X

Frequency

2

20%

5

10%

8

15%

10

30%

12

25%

Solutions

Expert Solution

A. Find the covariance and the correlation coefficient.

X Y* X*Y X^2 Y^2
39 625 24375 1521 390625
27 600 16200 729 360000
57 710 40470 3249 504100
31 595 18445 961 354025
34 610 20740 1156 372100
50 840 42000 2500 705600
38 726 27588 1444 527076
62 710 44020 3844 504100
43 635 27305 1849 403225
49 560 27440 2401 313600
Sum = 430 6611 288583 19654 4434451

Credit Score increases with income.


Related Solutions

Instructions to solve the problem: You are required to use a financial calculator or spreadsheet (Excel)...
Instructions to solve the problem: You are required to use a financial calculator or spreadsheet (Excel) to solve the problem related to the cost of capital. You are required to show the following 3 steps for the problem. (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Submit all answers as percentages and round to two decimal places. Problem: Cosa Nostra...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the provided...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the provided capital budgeting problem (sample questions and solutions are provided for guidance). Problem: Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years....
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Kingston Corp. is considering a new machine that requires an initial investment of $520,000 installed, and has a useful life of 8 years. The expected annual after-tax cash flows for the machine are $76,000 during the first 3 years, $87,000 during years 4 through 6 and $92,000 during the last two years. (i)...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed, and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years. (i)...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems (provided on page 4) related to risk and return characteristics and stock/bond valuation. You are required to show the following three steps for each problem (sample problems and solutions are provided for guidance): (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. A company’s stock...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve related to...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve related to the risk and return, stocks and bonds valuation. You are required to show the following 3 steps for each problem (sample questions and solutions are provided for guidance): (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. PROBLEM: Consider a 10 year bond with face...
Econ 103: Bonus Problem Set Due May 8th, 2018 Equivalent to 12% on a midterm, but...
Econ 103: Bonus Problem Set Due May 8th, 2018 Equivalent to 12% on a midterm, but does not affect the curve so this is truly optional. Trump has consistently pursued policies aimed at stimulating the economy. On the regulatory side, his administration has worked to reduce regulation on corpo- rations and banks. On the fiscal side, the president supported and signed the tax cut act of 2017 reducing personal and corporate income taxes (among other things). And on the monetary...
Econ 103: Bonus Problem Set Due May 8th, 2018 Equivalent to 12% on a midterm, but...
Econ 103: Bonus Problem Set Due May 8th, 2018 Equivalent to 12% on a midterm, but does not affect the curve so this is truly optional. Trump has consistently pursued policies aimed at stimulating the economy. On the regulatory side, his administration has worked to reduce regulation on corpo- rations and banks. On the fiscal side, the president supported and signed the tax cut act of 2017 reducing personal and corporate income taxes (among other things). And on the monetary...
eBook Problem 7-31 Use a financial calculator or a program such as Excel to answer the...
eBook Problem 7-31 Use a financial calculator or a program such as Excel to answer the questions. Round your answers to the nearest whole number. You purchase a stock for $9,000 and collect $300 at the end of each year in dividends. You sell the stock for $10,500 after five years. What was the annual return on your $9,000 investment?   % You purchase a building for $850,000, collect annual rent (after expenses) of $110,000, and sell the building for $950,000...
Part 1: Random Data, Statistics, and the Empirical Rule **Data Set Below** Methods: Use Excel (or...
Part 1: Random Data, Statistics, and the Empirical Rule **Data Set Below** Methods: Use Excel (or similar software) to create the tables and graph. Then copy the items and paste them into a Word document. The tables should be formatted vertically, have borders, and be given the labels and titles stated in the assignment. The proper symbols should be used. Do not submit this assignment as an Excel file. The completed assignment should be a Word (or .pdf) document. The...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT