1.

a.Suppose you will go to graduate school for 3 years beginning in year 5. Tuition is $34,657 per year, due at the end of each school year. What is the Macaulay duration (in years) of your grad school tuitions? Assume a flat yield curve of 0.05.

b.Suppose in the question above, the tuition obligations have a Macaulay duration of 4.54 in years, and that you wish to immunize against the tuition payments by buying a single issue of a zero coupon bond. What maturity zero coupon bond should you buy?

c.Suppose in question a, the tuition obligations have a Macaulay duration of 6.86 in years and a present value of 44,225. In order to immunize against the tuition payments by investing in some combination of two bonds with duration 3.48 and 9.91, what is the dollar amount that you should invest in the bond with duration 9.91?

You have chosen biology as your college major because you would like to be a medical doctor. However, you find that the probability of being accepted to medical school is about 16 percent. If you are accepted to medical school, then your starting salary when you graduate will be $316,000 per year. However, if you are not accepted, then you would choose to work in a zoo, where you will earn $44,000 per year. Without considering the additional years, you would spend in school if you study medicine or the time value of money.

What is your expected starting salary? (Round answer to 2 decimal places, e.g. 15.25.) Expected starting salary $ LINK TO TEXT What is the standard deviation of that starting salary? (Round answer to 2 decimal places, e.g. 15.25.)

Standard deviation $

Rolling a Die If a die is rolled one time, find these probabilities: a. Getting a 7 b. Getting an odd number c. Getting a number less than 7 d. Getting a prime number (2, 3, or 5)

4.Rolling a Die If a die is rolled one time, find these probabilities: a. Getting a number greater than 0. b. Getting a number greater than or equal to 3 c. Getting a number greater than 2 and an even number d. Getting a number less than 1

6.Riding to School The probability that John will drive to school is 0.37, the probability that he will ride with friends is 0.23, and the probability that his parents will take him is 0.4. He is not allowed to have passengers in the car when he is driving. What is the probability that John will have company on the way to school?

Adequate Preparation for Retirement. In 2018, RAND Corporation researchers found that 71% of all individuals ages 66 to 69 are adequately prepared financially for retirement. Many financial planners have expressed concern that a smaller percentage of those in this age group who did not complete high school are adequately prepared financially for retirement.

a. Develop appropriate hypotheses such that rejection of H0 will support the con-clusion that the proportion of those who are adequately prepared financially for retirement is smaller for people in the 66–69 age group who did not complete high school than it is for the population of the 66–69 year old.
b. In a random sample of 300 people from the 66–69 age group who did not complete high school, 165 were not prepared financially for retirement. What is the p-value for your hypothesis test?
c. At a 5 .01, what is your conclusion?

6.73 Attitudes toward school. The Survey of Study Habits and Attitudes (SSHA) is a psychological test that measures the motivation, attitude toward school, and study habits of students. Scores range from 0 to 200. The mean score for U.S. college students is about 95, and the standard deviation is about 20. A teacher who suspects that older students have better attitudes toward school gives the SSHA to 25 students who are at least 30 years of age. Their mean score is ¯x = 103.3.

1. Assuming that σ = 30 for the population of older students, carry out a test of

   H₀: μ = 95

   H_a: μ > 95

   Report the P-value of your test, and state your conclusion clearly.

2. Your test in part (a) required two important assumptions in addition to the assumption that the value of σ is known. What are they? Which of these assumptions is most important to the validity of your conclusion in part (a)?

. A teaching assistant for Statistics course as a university collected data from students in her class to investigate whether study time per week (average number of hours) differed between students who planned to go to graduate school and those who did not. The data were as follows:

Graduate school: 15, 7, 15, 10, 5, 5, 2, 3, 12, 16, 15, 37, 8, 14, 10, 18, 3, 25, 15, 5, 5

No graduate school: 6, 8, 15, 6, 5, 14, 10, 10, 12, 5.

State the null and alternative hypotheses using statistical notations. Use R command t.test to test whether study time differed between two groups. Include your R output and identify the test statistic and p-value. Draw the conclusion.

Theory Questions 1.

The Kyrgios Database Group has about 120 employees. Each employee has an ID, a firstname and a surname. Each employee belongs to a department. The organisation has around 6 departments. Each department has a department code and a departmentname. • Create an ERD solution based on the above narrative. ERD Diagram

Question 2.

The Tomic Primary School wishes to democratically choose which animal will become the school mascot. The list of alternatives includes Kangaroo, Koala, Tiger, Elephant, Parrot, Penguin… Each student may vote for one or more of the animals to be the mascot. Each student has a student Id and name. Each of the animals has been assigned a numeric id and name (e.g. 7 Tiger). The school want to be able to store all of the votes made by students in a database. • Create an ERD solution based on the above narrative. ERD Diagram

Required Lump-Sum Payment

To complete your last year in business school and then go through law school, you will need $20,000 per year for 4 years, starting next year (that is, you will need to withdraw the first $20,000 one year from today). Your uncle offers to put you through school, and he will deposit in a bank paying 8.4% interest a sum of money that is sufficient to provide the 4 payments of $20,000 each. His deposit will be made today.

1. How large must the deposit be? Round your answer to the nearest cent.
   
   
2. How much will be in the account immediately after you make the first withdrawal? Round your answer to the nearest cent.
   
   
   How much will be in the account immediately after you make the last withdrawal? Round your answer to the nearest cent. Enter "0" if required

Islamic parent: “My child’s school has many Christian-based activities and has never even recognized that some of the students are not Christian.”

Single parent: “I feel that all my son’s behavior at school is blamed on the fact that I’m a single parent, and that many judgments about our family are made based on no other evidence than our ‘single parent family’ status.”

Vietnamese parent: (translated from Vietnamese) “My children speak and read better English than I do. It is so hard when lots of letters and information come home from school in English. I also feel that my children are losing respect for their parents and the elders in this country.”

Required Lump-Sum Payment

To complete your last year in business school and then go through law school, you will need $20,000 per year for 4 years, starting next year (that is, you will need to withdraw the first $20,000 one year from today). Your uncle offers to put you through school, and he will deposit in a bank paying 8.61% interest a sum of money that is sufficient to provide the 4 payments of $20,000 each. His deposit will be made today.

1. How large must the deposit be? Round your answer to the nearest cent.
   $  
   
2. How much will be in the account immediately after you make the first withdrawal? Round your answer to the nearest cent.
   $  
   
   How much will be in the account immediately after you make the last withdrawal? Round your answer to the nearest cent. Enter "0" if required
   $