Use the Securities and Exchange Commission’s EDGAR corporate filings database to search for and view the annual reports on Form 10-K of Google and Yahoo.

Google: https://www.sec.gov/Archives/edgar/data/1288776/000128877615000008/0001288776-15-000008-index.htm

Yahoo: https://www.sec.gov/Archives/edgar/data/1011006/000119312515066560/0001193125-15-066560-index.htm

Click on the Document Link for 10-K, In the Table of Contents, go to Item 8 Financial Statements and Supplementary Data.

Using information from the statement of cash flows, answer the following questions for each company:

1. Which method, direct or indirect, was used to prepare the company’s Statement of Cash Flows? How can you tell?

2. How much cash and cash equivalents did the company have on hand at the end of its most recent fiscal year?

3. What is the trend in the company’s net cash from operations over the past three years?

4. What were the significant cash flows from or used by financing activities during its most recent fiscal year?

5. What were the significant cash flows from or used by investing activities during its most recent fiscal year?

A. The Train Station has a database of travel times on the blue line ever sense it began running. An analyst pulls a report of all the travel times from the Washington stop to the Oak Park stop. The average is 14 and the standard deviation is 4.

B. The analyst calculates 81 average travel times based on a random sample of 49 travel times in each sample. A subset of these averages is 14.5, 16.8, 17.2, etc.

C. One of the sets of 49 travel times has values such as 12, 14, 18, 17, etc.

Question 1

Indicate which of the three is a sample distribution

Choice A

Choice B

Choice C

Question 2

Indicate which of the three is the population distribution

Choice A

Choice B

Choice C

Question 3

Indicate which of the three is a sampling distribution

Choice A

Choice B

Choice C

Question 4

According to the Central Limit Theorem (and only the Central Limit Theorem) what will be the average of the sampling distribution

A) 14

B) 4/2

C) 14/81

D) 4/7

Question 5

According to the Central Limit Theorem (and only the Central Limit Theorem) what will be the standard deviation of the sampling distribution

A) 14

B) 4/6

C) 14/10

D) 4/7

Question 6

According to the Central Limit Theorem (and only the Central Limit Theorem) what will be the shape of the sampling distribution

A) Regular

B) Normal

C) Non-normal

D) Rectangular

Question 7

Now suppose that the analyst calculates 100 averages each with a random set of 36 travel times in each sample. What will be the standard deviation of the sampling distribution. All other facts are the same.

A) 14

B) 4/6

C) 14/10

D) 4/7

Question 8

Which of the two sampling distributions will have a WIDER spread?

A) The first

B) The second

For this assignment, you will use the provided database in the Unit 5 script file. You will add statements to this file to query the database tables. For your reference, below is a screenshot of the enhanced entity relationship diagram (ERD) as a reference when you write your queries. With the data types listed in the diagram, this will help you identify the types of operators that you can use for particular queries.

Use paiza.io for MySQL to execute and troubleshoot your Structured Query Language (SQL) statements. It is recommended that you use Notepad to write your SQL statements. Then, copy and paste your SQL statements to paiza.io to test your statements to ensure that they execute without errors. Save your work frequently.

The asterisk (*) indicates that a column is not null (i.e., required to have a value).

1. If you would like to see the test SQL statements, click on “Run” to see the statements execute. You should see “Hello” appear in the Output window (see the following screenshot).
2. Because you do not require these test SQL statements for your assignment, delete the sample SQL statements. To do this, select the text, and click on the Delete key on your keyboard. Your MySQL paiza.io screen should now be blank, as you see in the following screenshot. Note that if you ran the test statements, “Hello” will still appear in the Output window.
3. Copy and paste the code from the provided script file into the code editor, and click on “Run” (“Ctrl + Enter”). You should see no error messages displayed in the Output area at the bottom of your paiza.io screen. After you click on “Run,” you should see a green bar with “Success” at the top. You will see this circled in the following screenshot:
4. Next, you will write 1 query to respond to each of the following questions. Note that you can only use the information that is in the question or the enhanced ERD. Write a query to do the following:
   1. Display all of the rows in the publisher table.
   2. Display all of the books in the book table that were written by the author whose author ID is 1504192.
   3. Display all of the purchases in the shopbasket that were ordered on 2020-02-29.
   4. Display the largest quantity ordered in the shopbasket.
   5. Display the authors' first and last names sorted by their last name.
   6. Display a count of the number of orders placed via the shopbasket.
   7. Display the order date and quantity of orders in the shopbasket that have a quantity of more than 25.
   8. Display the first and last names of those authors who have a null Facebook.
   9. Display all of the customers' names, city, and state if they live in GA, FL, or CA.
   10. Display the book titles of those books that were not published by Scholastic Press.
   11. Display the first and last names of the authors and the book titles. Only display those authors who wrote a book with the word database in the title.
   12. Add a multiline comment before the first CREATE TABLE statement that includes your name, the course code (ITCO231), and the date when you are submitting your assignment.
5. Save your script file using your last name, ITCO231, U5, and the file extension .sql, as in “Smith_ITCO231_U5.sql.”
   1. Tip: When saving a Notepad file, you can change the file extension to .sql as required for the assignment by changing the “Save as type” to “All Files” and then typing the .sql extension, as shown in the example.

I didnt understand by what you mean by SQL TEST. If what you are asking me is that an SQL TEST? Yes! It is SQL QUERY TEST!!

Statistica is a well-known database that caters to the research requirements of economists and data scientists. The penetration rate for Statistica is however, not as high as compared to similar products in the market with much less functionality. A market research report on the use of Statistica shows that the main reason individual researchers haven’t signed up for the database is the price.

To boost revenues, the top management of CIE Ltd., the creator of Statistica is contemplating a promotional price. Since this offer will be a part of our supplier promotion plan and will be publicised, the same deal has to be offered to our existing subscribers as well. A genuine concern of the top management is that the additional subscribers generated by the lower price may not fully offset the revenues lost from our existing base of subscribers.

Based on data on the current sales in the excel sheet, please comment whether lowering the price will yield higher revenues? Can you also arrive at an estimate of the maximum monthly revenues that can be achieved?

Please write your answer in the answer sheet. Excel calculations need to be attached too. Answers without excel sheet will not be evaluated (sheet attached).

Access the CallCenterWaitingTime.xlsx file. Each row in the database corresponds to a different call. The column variables are as follows:

• Protocol Type: indicates protocol type, either PT or PE
• QueueTime: Time in Queue, in seconds
• Service Time: Service Time, in seconds
• Perform a test of hypothesis to determine whether the average TiQ is lower than the industry standard of 2.5 minutes (150 seconds). Use a significance level of α=0.05.  
• Evaluate if the company should allocate more resources to improve its average TiQ.
• Perform a test of hypothesis to determine whether the average ST with service protocol PE is lower than with the PT protocol. Use a significance level of α=0.05.  
• Assess if the new protocol served its purpose. (Hint: this should be a test of means for 2 independent groups.)
• Submit your calculations and a 175-word summary of your conclusions.
•         

  QueueTime

  service time

• PE	43	976
  PE	151	33
  PE	57	35
  PE	715	39
  PE	45	41
  PE	97	43
  PE	239	43
  PE	33	48
  PE	31	48
  PE	299	49
  PE	27	50
  PE	189	50
  PE	51	51
  PE	71	52
  PE	57	56

Write the following two functions maintaining a database of entries of type person in a file. (see .h file for the definition of point) person* find_person(const char* file_name, int ID) The function gets a name of a file and searches the file for a person with the given ID. It returns a pointer to the struct person (on heap) with the name and ID of the person. If the file does not exist or if the person with the required ID is not in the file, the function returns the NULL pointer. The file should not be changed by this function. int add_person(const char* file_name, person p) The function gets a name of a file, and a person p. If the person with the same ID is already in the file, the function does nothing. If the person is not in the file, the function adds p to the file. If the file does not exist, a new file is created and the person is added to the file. The function returns 0 if the person is added to the file. The function returns 1 if the person has already been in the file. The function returns -1 if there was an error (e.g. error opening a file)

For each of the following research cases, search the FASB ASC database for information to address the issues. Copy and paste the FASB ASC paragraphs that support your responses. Then summarize briefly what your responses are, citing the paragraphs used to support your responses.

• FASB ASC 1-3 Accounting for the Investment Tax Credit

The accounting alternative treatments for the investment tax credit originally outlined in APB Opinions 2 and 4 are still considered GAAP. Find and cite the FASB ASC paragraphs and copy the relevant information.

For this part, assume you are entering information about transactions into their relational database. You will be entering financial information, but you will also need to consider the other types of information Big Marker would want to know about that event. You will also utilize what you have learned to identify internal controls specific to each transaction.

The transactions are as follows:

a. Billed 30 communities for monthly dues of $600 (each).

b. Borrowed $10,000 from First National Bank with a 6-month, 4% note payable.

c. Created a Chief Financial Officer position and established a support team for that function. The CFO’s annual salary will be $150,000; each support team member will earn $60,000 annually.

d. Purchase new computer servers from Dell, $40,000.

e. Reimbursed employee for business expenses: Supplies, $500; Food, $250; and Travel, $1,500.

For each of the transactions, you should answer the following questions:

1. Which business process (from chapters 12-14) is most closely associated with each transaction?

2. What is the most appropriate journal entry (if any) to record the transaction? For each of the accounts you use, identify the element (asset, liability, equity, revenue or expense).

3. What forms/documents would be used to process this transaction?

4. For each transaction suggest at least two additional pieces of information you would want to capture in a relational database.

5. For each transaction, suggest two internal controls you would implement. The controls should be specific to each transaction and you should justify/explain your response.

1. A cosmetic product retailer needs to create a database to keep track of the information for its business operations. The company has a web site that posts all its products. The product information includes product ID, product name, description, and unit price. The company also needs to keep track of customers’ information, including customer names, their shipping addresses, and the email address. The company creates an account for each customer for identification and tracking purpose. A customer can purchase multiple products with different quantities in one order. The company’s products have many prospective customers. The company needs to keep track of information for all orders it received, including the order date, invoice number, and information about products purchased in an order such as IDs of products, and quantities, etc. Company’s products are stocked in several warehouses. So company also needs to keep track of the information about each warehouse such as its name, address, manager, telephone, etc. a. Create an E/R model for this scenario. In your E/R model you need to show the names of entities, names of attributes, keys and the name(s) of relationship(s). Also indicate maximum and minimum cardinalities You may hand-draw the ER model and insert its image here.