Week 1 Assignment

Complete this two page assignment by the end of week 1! Download and open the Word document below....fill in the blank and highlight the answer to the questions or fill in the blank. Resubmit here when you're finished by adding your completed assignment as a file!

BIO 212 Assignment 1

1. Fill in the Blank: Use the table on pg. 848-853 in your textbook to help you fill in the blank.

1. Which of the following drug classifications produces a calming effect?
   1. Sedative
   2. Hypnotic
   3. Tranquilizer
   4. All of the above

2. Mr. Adkins is a diabetic who takes insulin. What medicinal method describes how insulin is used?
   1. Diagnostic
   2. Replacement
   3. Curative
   4. Therapeutic

3. List 5 different sources of drugs.
   1. _________________

2. _________________

3. _________________

4. _________________

5. _________________

Your employer, a midsized human resources management company, is considering expansion into related fields, including the acquisition of Temp Force Company, an employment agency that supplies word processor operators and computer programmers to businesses with temporarily heavy workloads. Your employer is also considering the purchase of Biggerstaff & McDonald (B&M), a privately held company owned by two friends, each with 5 million shares of stock. B&M currently has free cash flow of $24 million, which is expected to grow at a constant rate of 5%. B&M’s financial statements report short-term investments of $100 million, debt of $200 million, and preferred stock of $50 million. B&M’s weighted average cost of capital (WACC) is 11%.

You have just learned that B&M has undertaken a major expansion that will change its expected free cash flows to −$10 million in 1 year, $20 million in 2 years, and $35 million in 3 years. After 3 years, free cash flow will grow at a rate of 5%. No new debt or preferred stock were added, the investment was financed by equity from the owners. Assume the WACC is unchanged at 11% and that there are still 10 million shares of stock outstanding.

A) What is its horizon value (i.e., its value of operations at year three)? What is its current value of operations (i.e., at time zero)?

B) What is its value of equity on a price per share basis?

C) If B&M undertakes the expansion, what percent of B&M’s value of operations at Year 0 is due to cash flows from Years 4 and beyond?
Hint: use the horizon value at t = 3 to help answer this question.

Decision Making Gone Awry

Sometimes social influences and societal pressures can influence decision making for the better and sometimes for the worse. In addition to these pressures, there are risks that need to be evaluated and measured when making decisions. In this assignment, you will reflect on decisions you made using social influence, persuasion, and risk taking that went awry.

Examine a time when you were involved in decision making that went awry as a result of protocols, social norms, or persuasive techniques. If you do not want to use an example from your business or personal experience, you can select a journal article on which you can base your assignment. Here are some key words to help you find an article for this assignment:

Decision making

Risk taking

Persuasion

Social heuristics

Write a 3–5-page paper in Word format that addresses the following:

Describe a decision-making scenario using your business experience, personal decision making or cited journal article; include an example of the decision-making process, describe the risk, and whether persuasion was used. What were the social heuristics?

Explain the incentives in this scenario. Were they effective?

Identify the risks and the potential decision biases in your scenario. Propose the corrective steps that should have been taken to overcome these biases. If a risk assessment was conducted how did this affect the decision-making process?

Analyze your scenario for what happened in terms of social heuristics. Explain how decisions were made and the social factors that shaped the decision-making environment.

Discuss the greatest challenges to sound decision-making in your scenario.

Critique the decision-making process used by the sponsor(s) and leader(s) of the decision. Identify the mistakes made by the sponsor(s), leader(s), and team members or others impacted by the decision during the implementation of the decision.

Variables typically included in a multivariate supply function (other than the price and quantity of the item the supply function represents) are prices of other goods that use similar input resources for production, expectations, the number of suppliers, techniques of production, taxes and subsidies, and prices of input resources, weather. Please answer the following questions about the affect changes in other variables might have on the supply of the item. These changes will either cause supply to increase (shift right) or decrease (shift left). Use either word as applicable, for the short answer.

1. It is rumored that refiners are taxed 5.4 cents/gallon more than they are taxed for gas mixed with Ethanol. The tax is used to subsidize the growth of more corn (from which Ethanol is made). The result is an ____________ in the supply of Ethanol.

2. E-book readers can now be bought for about $100. Digital books are considerably cheaper than printed versions.   Predictably then the supply of e-books will _____________.

3. T. Boone Pickens spent millions of his own money advertising the benefits of “Cleaner American- Produced Natural Gas” as an alternative vehicle fuel. Advertising seeks to increase the demand for an item. Suppose instead he had spent his millions to help service stations install natural gas fueling equipment (pumps ??). This would be an effort to _____________ the supply of readily available natural gas fueling facilities

4. Think of highways as a resource used in the production of highway transportation. Thus building more and better highways is likely to _______________ the supply of vehicles using them.

5. A problem getting the public to buy automobiles equipped to use both gasoline and natural gas as fuel is the cost of adding natural gas capability to the vehicles. Suppose a small amount of tax was added to the cost of a gallon of gas (maybe one cent, for example). This could be used to encourage manufacturers to install natural gas using capability in vehicles, thus ______________ the supply of these vehicles on the road.

1. Cognitive science consistently shows that one of the most effective studying tools is to self-test. A recent study reinforced this finding. In the study, 118 college students studied 48 pairs of Swahili and English words. All students had an initial study time and then three blocks of practice time. During the practice time, half the students studied the words by reading them side by side, while the other half gave themselves quizzes in which they were shown one word and had to recall its partner. Students were randomly assigned to the two groups, and total practice time was the same for both groups. On the final test one week later, the proportion of items correctly recalled was 15% for the reading-study group and 42% for the self-quiz group. The standard error for the difference in proportions is about 0.07. Test whether giving self-quizzes is more effective and show all details of the test. The sample size is large enough to use the normal distribution. Remember – there are four steps for the hypothesis test: Hypotheses with explanation of what the parameter represents, Find the Test statistic, Find the P-value, Give the Conclusions, including the justification, conclusion about the null and conclusion in context of the problem.

   2. We have the following two-way table showing the servers and whether or not the customer used a credit card to pay for their meal. TABLE A B C Yes 21 15 15 No 39 50 17
2. a) Compute and interpret a 95% confidence interval for the proportion of bills paid with a credit card. SE = 0.0373 b) From the confidence intervals In part b) does it appear that Server B is responsible for 1/3 of the bills this week? c) Compute and interpret 90% confidence intervals for the proportion of bills for each server. A: SE = 0.0388, B: SE = 0.0393, C: SE = 0.0321

Here you will be plotting results and commenting in written form. Hence, you must show your work in the form of some numbers, some plots, and some simple statements. You may write your answers out on a sheet of paper (pen/pencil & paper), do this in an electronic spreadsheet or word processing document. You may submit your work and answers electronically or turn it in physically before end of class (1:15 pm) on February 27, 2018. In discrete time, the logistic equation can be written (see the hint on Problem Set HW 2, question 3): where N is the population, our time is represented by “t” (let’s use days), K is the “carrying capacity”, r is the growth rate. Consider the growth of a population of bacteria. At initial time, N(0) = 0.2 bacteria. The net growth rate has a value, r = 1. Carrying capacity, K = 1. Don’t worry about the units here (you can think of them as fractions of 1000 individuals). You are going to plot out the population to the 30th day, starting at day 0. You can use a spreadsheet or your calculator and paper/pencil, or software like matlab (if you use that). There are many graphical software packages that can manage plotting this. a) What is the population on each day - plot this. b) Change the net growth rate to, r = 2. What is the population on each day – plot this. Is a pattern emerging? What would you call this pattern? c) Change the net growth rate to, r = 3. What is the population on each day – plot this. Is this pattern similar to b or different? What is happening to this population? Is it reaching carrying capacity, K? d) change the net growth rate to, r = 3.001 (a tiny change). Now what happens?

For this assignment you have to create tables as reviewed in class Manufacturer table, Product table and Stock table. The code is in Week 7 PPT lecture. You are to add update as needed to make the tables the same as below and match Product, Manufacturer and Stock as below.

For this assignment you will be working with these same tables.  

Please complete the following tasks and submit in word file or notepad.

1. First insert tuples into two of the tables and make sure the contents of the tables match below.  

Write and execute the SQL to insert three records ProductID 844, 555 and 645 to the Product table (see below)

Write and execute the SQL to insert the one record to the Stock table (see below).  

2. Write and execute the SQL select statements to do the following selections of ALL TUPLES IN A TABLE

a. Select all (attributes) tuples in Product

b. Select all (attributes) tuples in Manufacturer

c. Select all (attributes) tuples in Stock

3. Write and execute the SQL select statements to do the following selections of ONLY SOME TUPLED IN A TABLE

a. Select Manufacturer ID = 1 tuples in Product table.

b. Select ProductID of Products that have a quantity of 300.

c. Select ProductID of Products that have quantity of 300 and less.

4. Write and execute the SQL select statements that select attributes (not all) based on a condition.

a. Select ProductID for items with ManufacturerID of 4.

b. Select ProductName for items with ManufacturerID of 1.

c. Select Products with the productName 'Keyboard'

5. Write and execute the SQL select statements that SELECT with and without DISTINCT modifier

a. Select ProductName and ManufacturerID from Product

b. Select Product Name and ManufacturerID from Product with the Distinct modifier.

c. Explain the difference in the results from a and b.

Using the information from the following scenario, conduct a one-way ANOVA and specify the LSD post hoc test.

Scenario

The superintendent is continuing to examine the data that has been reported for the district. Another question concerned the differences in performance on high stakes tests. To examine this issue, the superintendent obtained the average scale scores for schools that participated in the high stakes testing for the district and two comparison districts. The following scores were collected:

Questions

1. What is the mean scale score for each district?

Superintendent’s District=314.71

Comparison District 1=301.29

Comparison 2=297.86

2. What is the standard deviation of the scale scores for each district?
3. State an appropriate null hypothesis for this analysis.
4. What is the observed or computed value of F?
5. What are the reported degrees of freedom for the Between Groups variance?
6. What are the reported degrees of freedom for the Within Groups variance?
7. What is the reported level of significance?
8. Based on the results of the one-way ANOVA, would you accept or reject the null hypothesis?
9. Based on the results of the LSD post hoc test, identify which districts are significantly different.
10. Present the results as they might appear in an article. This must include a table and narrative statement that reports the results of the one-way ANOVA and LSD post hoc test.

Note: The table must be created using your word processing program. Tables that are copied and pasted from SPSS are not acceptable.

Must be coded in python.

Consuming A Web Service with Python

Consuming data from programmable web based API’s is growing rapidly. According to ProgrammableWeb, in just six years (2010-2016), web API counts increased 758 percent with the majority being REST based. This is driven by a myriad of factors but growth of cloud based applications, (distributed computing by another name), and the resulting need to integrate the different categories is a major factor.

Description

Write a client to consume a REST web service of you choice using Python. There are many listings of such services but an excellent resource is ProgrammableWeb. Your information should produce useful information. I.e. a dump of cryptic data is not the desired product. Examples could be a weather forecast, stock quote, Bible verse, etc.,

Your solution should present the user with a question with the answer contributing to the data used in the REST web service call. For example, a weather forecast would prompt the user to enter a zip code or other location information. Once the web transaction is complete, the program should prompt again with the same question to complete another transaction. This should continue until the user enters a specified termination condition.

You output must be presented in an understandable manner. Dumps of XML, JSON, etc., are substandard and will be graded accordingly.

Hint:

Be sure to click on the examples and look at the address bar of your browser. That is what you will need to generate with the Python requests module.

You are free to use any REST web service you find but I recommend this one if you are looking for something straightforward. One word of caution, some services require you to request access via an API key. The approval may not be immediate so you will want to find something sooner rather than later. The example I listed above requires no approval.

Please submit SQL statements as a plain text file (.txt). If blackboard rejects txt file you can submit a zipped file containing the text file. Word, PDF, or Image format are not accepted. You do not need to show screen shot. Make sure you have tested your SQL statements in Oracle 11g.

The list of tables is:

Tables:

Cust Table:

cid, -- customer id

cname, --- customer name

cphone, --- customer phone

cemail, --- customer email

Category table:

ctid, --- category id

ctname, --- category name

parent, --- parent category id since category has a hierarchy structure, power washers, electric power washers, gas power washers. You can assume that there are only two levels.

Tool:

tid, --- tool id

tname, --- tool name

ctid, --- category id, the bottom level.

quantity, --- number of this tools

Time_unit table allowed renting unit

tuid, --- time unit id

len, --- length of period, can be 1 hour, 1 day, etc.

min_len, --- minimal #of time unit, e.g., hourly rental but minimal 4 hours.

Tool_Price:

tid, --- tool id

tuid, --- time unit id

price, -- price per period

Rental:

rid, --- rental id

cid, --- customer id

tid, --- tool id

tuid, --- time unit id

num_unit, --- number of time unit of rental, e.g., if num_unit = 5 and unit is hourly, it means 5 hours.

start_time, -- rental start time

end_time, --- suppose rental end_time

return_time, --- time to return the tool

credit_card, --- credit card number

total, --- total charge

Problem . Insert at least three rows of data to each table above. Make sure you keep the primary key and foreign key constraints. [20 points]