An author argues that more​ American-born baseball players have birth dates in the months immediately following July 31 because that was the age cutoff date for nonschool baseball leagues. The table below lists months of births for a sample of​ American-born baseball players and​ foreign-born baseball players. Using a 0.01 significance​ level, is there sufficient evidence to warrant rejection of the claim that months of births of baseball players are independent of whether they are born in​ America? Do the data appear to support the​ author's claim? Jan. Feb. March April May June July Aug. Sept. Oct. Nov. Dec. Born in America 384 326 367 347 335 310 310 502 420 432 396 374 Foreign Born 100 81 84 82 95 84 59 91 69 101 102 83 Identify the null and alternative hypotheses for this test. A. Upper H 0​: Months of births of baseball players are independent of where they are born. Upper H 1​: Months of births of baseball players are dependent of where they are born. B. Upper H 0​: The frequency of births is dependent of the month. Upper H 1​: The frequency of births is independent of the month. C. Upper H 0​: The frequency of births is independent of the month. Upper H 1​: The frequency of births is dependent of the month. D. Upper H 0​: Months of births of baseball players are dependent of where they are born. Upper H 1​: Months of births of baseball players are independent of where they are born. Identify the test statistic. nothing ​(Round to three decimal places as​ needed.) Identify the​ P-value. nothing ​(Round to three decimal places as​ needed.) State the final conclusion that addresses the original claim. ▼ Reject Do not reject Upper H 0. There is ▼ sufficient not sufficient evidence to warrant rejection of the claim that months of births of baseball players are independent of whether they are born in America.

Consider the following database schema for a BOOKSTORE database:

• Books (bookid, title, author, year)
• Customers (customerid, name, email)
• Purchases (customerid, bookid, year)
• Reviews (customerid, bookid, rating)
• Pricing (bookid, format, price)

The Books relation stores information about books sold by the bookstore. Note that bookid is the primary key. An example tuple is as follows:

(105, 'JAVA PROGRAMMING', 'JOHN DOE', 2001)

The Customers relation stores information about the customers of the bookstore. Note that customerid is the primary key. An example tuple is as follows:

(210, 'JOHN SMITH', '[email protected]')

The Purchases relation stores information about the customer purchases of books. Note that customerid and bookid form the primary key. An example tuple is as follows:

(210, 105, 2002), indicating that 'JOHN SMITH' with customerid 210 purchased the 'JAVA PROGRAMMING' book with bookid 105 in the year 2002.

The Reviews relation stores information about the customer reviews/ratings of the books. The ratings field refers to the number of "stars" given to the book. Note that customerid and bookid form the primary key. An example tuple is as follows:

(210, 105, 3), indicating that 'JOHN SMITH' with customerid 210 gave a 3-star rating to the 'JAVA PROGRAMMING' book with bookid 105.

The Pricing relation stores information about the price of the various books sold by the bookstore. Note that the same book can be available in multiple formats at possibly different prices. The price field refers to the number of dollars. For instance a $25 purchase will have a price field of 25. Note that the bookid and format fields form the primary key for the relation. An example tuple is as follows:

(105, 'AUDIO', 25), indicating that the 'JAVA PROGRAMMING' book with bookid 105 is available in the audio format for $25.

Given the above schema, write queries for the following:

1. Find books (show their titles) written by 'EDMUND MORGAN' since year 1990.
2. Find books (show their titles, authors and prices) that are on 'CIVIL WAR' (i.e., the title field contains 'CIVIL WAR'), available in 'AUDIO' format.
3. For each year, 'JOHN CHAMBERS' purchased at least one book, find the number of books purchased. That is, the output should be a set of tuples, each indicating a year and the number of books purchased by 'JOHN CHAMBERS' in that year.
4. Find customers (show their names and email addresses) who purchased more than one book in year 2003.
5. Find the ratings information (show titles, authors and average ratings) for books on 'CIVIL WAR' (i.e., title contains 'CIVIL WAR').

Fancy Company is a wholesaler distributor of automotive replacement parts. Initial amounts taken from accounting records on December 31, 2016 are as follows: Inventory on December 31, based on physical count, P1,250,000; accounts payable, P1,000,000; sales, P9,000,000.Parts held on consignment from another company to Fancy, the consignee, amounting to P165,000 were included in the physical count on December 31, 2016, and in accounts payable on December 31, 2016.P20,000 of parts which were purchased and paid for in December 2016, were sold in the last week of 22016 and appropriately recorded as sales of P28,000. The parts were included in the physical count on December 31, 2016 because the parts were on the loading dock waiting to be picked up by the customers Parts in transit on December 31, 2016 to customers shipped FOB shipping point on December 28 2016 amounted to P34,000. The customer received the parts on January 6, 2017. Sales of P40,000 to customers for the parts were recorded by Fancy on January 2, 2017Retailers were holding P210,000 at cost and P250,000 at retail of goods on consignment from Fancy Company on December 31, 2016Goods were in transit from a vendor to Fancy Company on December 31, 2016. The cost of goods was P25,000. The goods were shipped FOB shipping point on December 31, 2016.What is the correct amount of inventory?

The New York city that has a 12/31 fiscal year end has adopted a policy of recognizing property tax revenue consistent with the 60-day rule allowable period under GAAP. Property taxes of $600,000 (of which none are estimated to be uncollectible) are levied in October 2016 to finance the activities of fiscal year 2017. Property taxes are due in two installments June 20 and December 20. Cash collections related to property taxes are as follows:

                2/15/17    for property taxes levied in 2015, due in 2016                            $ 25,000

                3/15/17    for property taxes levied in 2015, due in 2016                            $ 15,000

                4/15/17    for property taxes levied in 2015, due in 2016                            $ 10,000

                6/20/17    First installment of taxes levied in 2016, due 6/20/17                $350,000

                12/20/17   Second installment of taxes levied in 2016, due 12/20/17       $150,000

                1/15/18    for property taxes levied in 2016, due in 2017                            $ 15,000

                3/15/18    for property taxes levied in 2016, due in 2017                            $ 10,000

                4/15/18    for property taxes levied in 2016, due in 2017                            $    5,000

. The total amount of property tax revenue that should be recognized in the governmental fund financial statements in 2017 is:

South Sea Baubles has the following (incomplete) balance sheet and income statement.

a&b. What is shareholders’ equity in 2015 and 2016? (Enter your answers in millions.)

c&d. What is net working capital in 2015 and 2016? (Enter your answers in millions.)

e. What are taxes paid in 2016? Assume the firm pays taxes equal to 35% of taxable income. (Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places.)

f. What is cash provided by operations during 2016? (Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places.)

g. Net fixed assets increased from $800 million to $900 million during 2016. What must have been South Sea’s grossinvestment in fixed assets during 2016? (Enter your answer in millions.)

Next Visit question map

Question17of20Total17 of 20

Problem 3-6 Financial Statements (LO1,4)

South Sea Baubles has the following (incomplete) balance sheet and income statement.

a&b. What is shareholders’ equity in 2015 and 2016? (Enter your answers in millions.)

c&d. What is net working capital in 2015 and 2016? (Enter your answers in millions.)

e. What are taxes paid in 2016? Assume the firm pays taxes equal to 35% of taxable income. (Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places.)

f. What is cash provided by operations during 2016? (Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places.)

g. Net fixed assets increased from $900 million to $1,000 million during 2016. What must have been South Sea’s gross investment in fixed assets during 2016? (Enter your answer in millions.)

On january 1st 2016, the company purchased the above asset.

36) Eric, an employee of sam’s club, earned $ 120000 in 2016. The taxable wage base in 2016 is $ 118500 How much FICA tax should Eric pay in 2016? Please answer the following two questions ?

A) $9180

b) $9065.25

c) $9087

d) $8789

37) How much federal unemployment tax should been on behalf of Eric in 2016 ?

A) $7440

B) $434

C) $7200

D) $420

Aiello, Inc. had the following inventory in fiscal 2016. Compute the company’s cost of goods sold for fiscal 2016 assuming the company used a) FIFO and b) LIFO methods of accounting for inventory:

Beginning Inventory, January 1, 2016: 130 units @ $15.00

Purchase 200 units @ $18.00

Purchase 50 units @ $13.50

Purchase 110 units @ $15.75

Ending Inventory, December 31, 2016: 120 units