Consider the following data.

Answer the following:

1. Write the SQL DDL statements to create the tables. Include primary and foreign keys.

Every morning the foreman flips a coin to decide which group of planters get first choice of the day's planting sites. You think the foreman doesn't like your group (we won't go into the reasons why, but your suspicions are well-founded) and that he's rigging the coin tosses against your group. You keep track for 12 days and note that 10 of the 12 coin tosses have gone against your group. Test the hypothesis (at α=.05) that the foreman is rigging the coin tosses.

An insurance company offers car policies to individuals with two different characteristics. Those with characteristic of type A will make a claim with probability p1 and those with the characteristic of type B will make a claim with probability p2, where p1 =/= p2. The fraction of the policyholders that are classed as type 1 characteristic is a and those of type 2 is 1−a, where 0 < a < 1. A policyholder is chosen at random. Let Ai denotes the event that this policyholder will make a claim in year i. Assume that A1 and A2 are conditionally independent events on the event the individual has type A characteristics. Further assume that A1 and A2 are conditionally independent events on the event the individual has type B characteristics. p1 and p2 are independant.

1. Show that P(A2 | A1) > P(A1).

2. Provide a brief (one sentence) interpretation of this result.

4. A market research company wants to assess the potential for purchasing a new product "before" and "after" an individual sees a television advertisement about that product. The ranking of potential purchases is based on a scale of 0 to 10, with a higher value indicating a higher purchase potential. The null hypothesis states that the average rating of "After" will be less than or equal to the average value of "before." A rejection of this hypothesis will show that advertising increases the average potential buying rank. Use α = 0.05 and the following data to test the hypothesis.

Here is your chance to analyze an actual co-worker conflict situation and make suggestions on how to positively resolve this issue.

The #1 people issue I have is with a younger employee who has been speaking over me in meetings with external vendors.

I approached one of my co-workers to ask if they noticed it as well and they said of course - they were actually angrier than I was.

During the next few meetings, I attempted different techniques to see if she'd notice she was talking over me but it was still happening. Eventually, I pulled her aside and told her the issue I was having with her during meetings and explained it made us look unprofessional.

It worked for a few months but she ended up going back to her old ways. From then on, whenever she spoke over me in meetings, I would stop talking immediately and let her finish her sentence.

Sometimes she got flustered and would look back to me to finish up her thoughts but I wouldn't cut in.

I hope it reflected negatively on her, and not myself or the company.

1. The employee relaying her upset used 2 conflict styles. What are they and discuss their effectiveness in this situation? .
2. What is probably the root of this employee’s discontent? As well, why do you suppose the younger employee is interrupting this employee? Your answer will need to dig below the surface statements.
3. As the manager of these two employees, how would you resolve this conflict? State the conflict resolution style you will use and the specific steps you will take.

WANT LONG PARAGRAPH FOR EACH. PLEASE DONT COPY FROM PREVIOUS QUESTION OR INTERNET. THANKS

You got a new job as a university professor and want to settle down at East Lansing. You found a nice house which is selling for $500,000. You decided to pay a down payment of 10% (no closing cost), and borrow rest of the amount from the bank. This is a fixed payment loan that lasts for 10 years with annual payments. Interest rate is 6%.

Build the amortization table in Excel and show all the numbers.

researchers at a university studied children born with an infection called roseola. the children also have the causative herpesvirus inserted into their chrome osmoses. At least one parent of each child had the virus in a chromosome of a sampled hair cell. How did the children like;y become infected? and What does the transmission of the viral DNA from generation to generation reveal about the structure of DNA and its replication?

A large boat with 91.44 m in length and 42.672 m in width is carrying 1,360,777.11 kg of coal along the river with a 2.7432m draft (the height from waterline to bottom of the boat). What is the draft and weight of the boat when the boat is empty (no coal)? What is the draft and weight of the boat if the boat hits a wave and looses 10 tons of coal? Treat the boat as a rectangular cylinder. Use university introductory physics techniques.

Historically, 20% of graduates of the engineering school at a major university have been women. In a recent, randomly selected graduating class of 210 students, 58 were females. Does the sample data present convincing evidence that the proportion of female graduates from the engineering school has shifted (changed)? Use α = 0.05. Determine what type of error (Type I or II) could be made in the question above.

A survey of 300 students is selected randomly on a large university campus. They are asked if they use a laptop in class to take notes. Suppose that based on the​ survey, 135 of the 300 students responded​ "yes."

​a) What is the value of the sample proportion p^?

​b) What is the standard error of the sample​ proportion?

​c) Construct an approximate 95 confidence interval for the true proportion p by takingplus or minus 2 SEs from the sample proportion.