1. For the compounds present, list all intermolecular forces present and then rank the compounds in order of increasing boiling point (lowest to highest). Hint: draw the structures to make this easier.
   1. Ethane (C₂H₆)
   2. Ethanol (C₂H₅OH)
   3. Acetic acid (CH₃COOH)
   4. Dimethyl ether (C₂H₆O)

Transport plays an essential role in supply chain and when managed properly can allow supply chains to work more efficiently and effectively. Dertemine the modal split for freight in South Africa. Provide reasons for your choice of the mode with the highest split.

A ship is carrying 30 travelers from various great houses on a long sea voyage from Braavos to King’s Landing where they will participate in the Game of Thrones:

• 5 are from House Targaryen(TAR), and 5 from House Lannister (LAN)
• 4 are from House Stark (STA) and 4 from House Tyrell (TYR)
• 3 are from House Baratheon (BAR) and 3 from House Martell (MAR)
• 1 from each of the following houses: House Arryn (ARR), House Tully (TUL), House Greyjoy (GRE), House Bolton (BOL), House Frey (FRE), House Mormont(MOR)

You are now asked to evaluate probabilities relating to this voyage.

The following 9 competitors end up leaving the ship and participating in the Game of Thrones:
3 from TAR, 2 from LAN, 2 from STA, 1 from GRE' and 1 from MAR.

At the end of the Game of Thrones,only 3 of the 9 competitors will win titles:

• 1 will win the Iron Throne (I),
• 1 will end up being the Hand of the King (H)
• 1 will be the King of the North (N)

Nobody can win more than one title.

1. In how many different ways can these 3 titles be distributed among the 9 competitors?
2. In how many different ways can these 3 titles be distributed among the 5 participating houses? (in other words we are asking you to figure out how many possible combinations of titles by houses there can be.) Your answer should not be derived by listing all the possibilities one by one. Instead you should derive your answer by reasoning with known formulas for permutations and combinations.
3. Based solely on the number of competitors per house and not on their ability to wield a sword, axe, or their ability to devise a cunning plan, what is the probability that GRE will win at least one title?
4. Based solely on the number of competitors per house and not on their ability to wield a sword, axe, or their ability to devise a cunning plan, what is the probability that LAN will win at least one title?
5. Based solely on the number of competitors per house and not on their ability to wield a sword, axe, or their ability to devise a cunning plan, what is the probability that TAR will win at least one title?

SQL ONLY. WRITE CLEAR AND CORRECT ANSWERS.

Consider the following relations (PRIMARY KEYS ARE WRITTEN IN BOLD)
departments (dept_no, dept_name)
dept_emp (emp_no, dept_no, from_date, to_date)
dept_manager (dept_no, emp_no, from_date, to_date)
employees (emp_no, birth_date, first_name, last_name, gender, hire_date)

salaries (emp_no, salary, from_date, to_date)
titles(emp_no, title, from_date, to_date)

Write the following queries in SQL. No duplicates should be printed in any of the answers.

1. List all the titles for which there is at least one employee having the title.

2. Find the current employee(s) (only id) who has/have the most (highest) experience working in a department [across all departments]. Here, we are referring to working only in one department. For example, let's assume there are only two employees: A and B. Now, A has been working in department X for 15 years and B worked in department X for 10 years and is working in department Y for 8 years. Although B has worked for a total of 18 years, he worked for 10 years in one department. So, for this query the output should be the id of A because A has worked for 15

   years in one department which is the highest.

3. Find the names (both first and last) and current salary of all employees who were hired after 31st

   December 1998.

   (Hint: The to_date for current salary is '9999-01-01')

4. Find the id and name (both first and last) of all employees who are currently not in the

   'Development' department and whose first name start with 'Tom'.

5. Find the names (both first and last) and current salaries of all employees who earn more than the

   current average salary of all employees. List them in the descending order based on their salary

   (highest salary first).

6. Some employees have worked in multiple departments. Find the names (both first and last) and

   the number of departments of all the female employees who have worked in more than one

   department.

7. Write SQL query to find out the name and current average salary of the department that has the

   maximum current average salary?

8. Find the employee id of the current managers who currently manages more than 16000

   employees.

9. Find the name and current average salary of the departments whose current average salary is

   more than the current average salary of 'Development' department.

10. Find the name of the employees who currently have the same salary but currently works in

    different department.

SQL ONLY. WRITE CLEAR AND CORRECT ANSWERS.

SQL ONLY. WRITE CLEAR AND SIMPLE ANSWERS.

Consider the following relations (PRIMARY KEYS ARE WRITTEN IN BOLD) departments (dept_no, dept_name) dept_emp (emp_no, dept_no, from_date, to_date) dept_manager (dept_no, emp_no, from_date, to_date) employees (emp_no, birth_date, first_name, last_name, gender, hire_date) salaries (emp_no, salary, from_date, to_date) titles(emp_no, title, from_date, to_date) Write the following queries in SQL. No duplicates should be printed in any of the answers. List all the titles for which there is at least one employee having the title. Find the current employee(s) (only id) who has/have the most (highest) experience working in a department [across all departments]. Here, we are referring to working only in one department. For example, let's assume there are only two employees: A and B. Now, A has been working in department X for 15 years and B worked in department X for 10 years and is working in department Y for 8 years. Although B has worked for a total of 18 years, he worked for 10 years in one department. So, for this query the output should be the id of A because A has worked for 15 years in one department which is the highest. Find the names (both first and last) and current salary of all employees who were hired after 31st December 1998. (Hint: The to_date for current salary is '9999-01-01') Find the id and name (both first and last) of all employees who are currently not in the 'Development' department and whose first name start with 'Tom'. Find the names (both first and last) and current salaries of all employees who earn more than the current average salary of all employees. List them in the descending order based on their salary (highest salary first). Some employees have worked in multiple departments. Find the names (both first and last) and the number of departments of all the female employees who have worked in more than one department. Write SQL query to find out the name and current average salary of the department that has the maximum current average salary? Find the employee id of the current managers who currently manages more than 16000 employees. Find the name and current average salary of the departments whose current average salary is more than the current average salary of 'Development' department. Find the name of the employees who currently have the same salary but currently works in different department.

SQL ONLY. WRITE CLEAR AND SIMPLE ANSWERS. READ THE QUESTIONS CAREFULLY. IF AN ANSWER IS WRONG, I WILL DOWNVOTE.

1. Binomial Experiment application:
   1. In order to be considered for a tier 1 point guard in women’s basketball, you need to be 5’8”. Let’s consider a “success” as finding a woman who is 5’8” or taller. The probability of success is approximately 5%. If we consider a sample of 1000 women, calculate the mean and the standard deviation of the binomial random variable.
   2. Calculate the range of “normal” observations (not unusual) for the number of women that we would expect to be 5’8” or taller in a sample of 1000 women and use it in a sentence.
   3. Use a binomial calculator to calculate the probability of selecting*:
      1. Less than 40 women who are 5’8” or taller
      2. Exactly 60 women who are 5’8” or taller
      3. Between 50 and 80, inclusive, women who are 5’8” or taller
      4. More than 70 women who are 5’8” or taller
      5. At least 60 women who are 5’8” or taller

*Don’t just give answers here, use complete sentences. Graphs would be a nice addition here (StatCrunch screen grabs or Excel graphs).

4. Can we use the normal distribution as an approximation for the binomial in this case? Why or why not? If yes, what is the probability that we would choose less than 40 women who are 5’8” or taller using this approximation? How does this value compare with the value calculated in part c(i) above?

In a certain presidential election, Alaska's 40 election districts averaged 1,951.8 votes per district for a candidate. The standard deviation was 572.3. (There are only 40 election districts in Alaska.) The distribution of the votes per district for one candidate was bell-shaped. Let X = number of votes for this candidate for an election district.

1. State the approximate distribution of X. (Enter your numerical values to one decimal place.)

2. Is 1,951.8 a population mean or a sample mean? How do you know? (1) A population mean, because all election districts are included. (2) A population mean, because only a sample of election districts are included. (3) A sample mean, because only a sample of election districts are included. (4) A sample mean, because all election districts are included.

3. Find the probability that a randomly selected district had fewer than 1,600 votes for this candidate. (Round your answer to four decimal places.)

4. Write the probability statement.

5. Find the probability that a randomly selected district had between 1,800 and 2,000 votes for this candidate. (Round your answer to four decimal places.)

6. Find the third quartile for votes for this candidate. (Round your answer up to the next vote.)

Problem 11-15
Risky Cash Flows

The Bartram-Pulley Company (BPC) must decide between two mutually exclusive investment projects. Each project costs $7,000 and has an expected life of 3 years. Annual net cash flows from each project begin 1 year after the initial investment is made and have the following probability distributions:

BPC has decided to evaluate the riskier project at a 13% rate and the less risky project at a 8% rate.

1. What is the expected value of the annual net cash flows from each project? Do not round intermediate calculations. Round your answers to nearest dollar.

   	Project A	Project B
   Net cash flow	$	$

   
   What is the coefficient of variation (CV)? Do not round intermediate calculations. (Hint: σ_B=$5,097 and CV_B=$0.70.)

   	σ (to the nearest whole number)	CV (to 2 decimal places)
   Project A	$
   Project B	$

2. 
   
3. What is the risk-adjusted NPV of each project? Do not round intermediate calculations. Round your answer to the nearest dollar.

   Project A		$
   Project B		$

A retailer discovers that 3 jars from his last shipment of Spiffy peanut butter contained between 15.85 and 15.92 oz of peanut butter, despite the labeling indicating that each jar should contain 16 oz. of peanut butter. He is wondering if Spiffy is cheating its customers by filling its jars with less product than advertised. He decides to measure the weight of 50 jars from the shipment and use hypothesis testing to verify this.

1. (f) In his sample of 50 jars, the retailer finds an average weight of 15.84 oz and a sample standard deviation of 0.5 oz. He decides to use a significance level of 0.04. What is the conclusion from this hypothesis testing? Can you conclude that Spiffy is cheating its customers?

2. (g) What is the p-value? What is the meaning of this number?

3. (h) For what values of the sample mean would the null hypothesis be rejected?

4. (i) Calculate the probability of type II error if the true mean is 15.7 oz.

5. (j) Solve (f), (h) and (i) when the level of significance is 0.01. Is your new answer for (f) consistent with the p-value found in (g)? How is the probability of type II error affected when the probability of type I error changes?