Questions
Boomerang Generation - Short Term: In a 2010 Pew Research Center survey, suppose 83 out of...

Boomerang Generation - Short Term: In a 2010 Pew Research Center survey, suppose 83 out of 396 randomly selected young adults (ages 18–34) had to move back in with their parents after living alone. In a 2012 survey, suppose 199 out of 808 young adults had to move back in with their parents. The table below summarizes this information. The standard error (SE) is given to save calculation time if you are not using software.

Data Summary:

number who total number Proportion
Year moved back (x) in survey (n) = (x/n)
2012 199   808 0.24629
2010 83 396 0.20960

SE = 0.02598

The Test: Test the claim that a greater proportion of all young adults moved back in with their parents in 2012 than in 2010. Use a 0.05 significance level.

(a) Letting 1 be the proportion of young adults that had to move back in with their parents in 2012 and 2 be the proportion from 2010, calculate the test statistic using software or the formula

z =

(12) − δp
SE

where δp is the hypothesized difference in proportions from the null hypothesis and the standard error (SE) given with the data. Round your answer to 2 decimal places.
z =
To account for hand calculations -vs- software, your answer must be within 0.01 of the true answer.

(b) Use software or the z-table to get the P-value of the test statistic. Round to 4 decimal places.
P-value =

(c) What is the conclusion regarding the null hypothesis?

reject H0

fail to reject H0    


(d) Choose the appropriate concluding statement.

The data supports the claim that a greater proportion of all young adults moved back in with their parents in 2012 than in 2010.

There is not enough data to support the claim that a greater proportion of all young adults moved back in with their parents in 2012 than in 2010.

We have proven that a greater proportion of all young adults moved back in with their parents in 2012 than in 2010.

We reject the claim that a greater proportion of all young adults moved back in with their parents in 2012 than in 2010.

In: Statistics and Probability

4. There is data for you in the tab called EComSales. It comes from the Federal...

4. There is data for you in the tab called EComSales. It comes from the Federal Reserve and represents quarterly e-commerce sales data in the U.S. for Quarter 4, 1999 to Quarter 4, 2019. Month 1=Q1, Month 4=Q2, Month 7=Q3, Month 10 = Q4. Run a regression forecasting sales for all 4 quarters in 2020. Print your regression results in a new tab. Rename that tab Answer Q4. In that cells below your regression results, forecast sales for Q1:2020, Q2:2020, Q3:2020, and Q4:2020. Round all answers to the nearest dollar in Excel and put a comma in so I can read it easier (do not round by hand or put the comma in by hand– set up excel to do the rounding and the comma for you).

IT IS NOT LETTING ME POST CORRECTLY, THE COLUMN OF 5553 IS FOR Q1, THE 6059 FOR Q2, THE 6892 FOR Q3 AND THE 5241 FOR Q4

Year Years since 1999 (X) Q1 Q2 Q3 Q4
1999 0 5241
2000 1 5553 6059 6892 9104
2001 2 7923 7816 7737 10784
2002 3 9621 10076 10760 14166
2003 4 12358 12973 13909 17915
2004 5 16201 16502 17371 22523
2005 6 20142 20953 22171 28121
2006 7 25490 25817 26892 35135
2007 8 30403 31589 32352 42126
2008 9 34270 34260 33486 39576
2009 10 32284 32924 34494 45805
2010 11 37059 38467 40075 54320
2011 12 44243 45426 46159 64435
2012 13 51722 52542 53832 73827
2013 14 58355 60181 61344 83766
2014 15 66148 69715 71331 95830
2015 16 75918 79916 81769 109362
2016 17 86811 91969 93830 124697
2017 18 99805 107094 108905 145230
2018 19 115602 122934 124214 160894
2019 20 129015 139647 145833 187252

PLEASE EXPLAIN STEP BY STEP AND PUT EXCEL FORMULAS! THANK YOU

In: Statistics and Probability

Let's assume you just received a check out of nowhere that is enough to pay the...

Let's assume you just received a check out of nowhere that is enough to pay the downpayment and closing costs for a house. Assuming your career as a Financial Analyst for a bank earned $75,350 in 2010 and has increased at the rate of inflation.

All calculations must be done in Excel, input each number only once, in other words, use Excel functions and formulas and let Excel do the math.  

  1. Assuming an average inflation rate of 1.5%, what is the salary in 2020. Use the Excel FV function. You will get a negative number, ignore the sign, the explanation will be in a future chapter.
  2. What is the monthly gross income of your answer in 1 above? Remember to let Excel do your calculations.
  3. Lenders use the front-end ratio as one of the measures of determining your maximum monthly payment allowed for a mortgage. If this lender uses 25% as the front-end ratio, what is the your maximum monthly mortgage payment?
  4. Lenders also use the back-end ratio as the maximum monthly total debt allowed including your mortgage payment. If this lender uses 40% as the front-end ratio and you have $500 as debt repayment, what is left for a mortgage payment?   (hint: maxdebt=(monthly income * .40) - existing debt repayment)
  5. You are required to use the smaller of the two, what is the maximum payment you will be allowed to purchase a house?
  6. Your banker tells you the maximum sales price you can afford is 400,000 with 20% down payment at a 3.2% annual rate (approx 0.27% monthly) with monthly payments over 30 years (360 payments).
    1. How much is your downpayment?
    2. What is the balance which is your loan amount?
    3. Use the PMT function in Excel to calculate your monthly payments. Hint: use the PMT function in Excel.

Only need answers to 5 and 6.

In: Finance

. Determine whether K4 (the complete graph on 4 vertices contains the following: i) A walk...

. Determine whether K4 (the complete graph on 4 vertices contains the following: i) A walk that is not a trail. ii) A trail that is not closed and is not a path. iii) A closed trail that is not a cycle.

In: Advanced Math

Prove the converse of Theorem 3.3.4 by showing that if a set K ⊆ R is...

Prove the converse of Theorem 3.3.4 by showing that if a set K ⊆ R is closed and bounded, then it is compact.

Theorem 3.3.4 A set K ⊆ R is compact if and only if it is closed and bounded.

In: Advanced Math

describe how a closed circulatory system delivers oxygen and nutrients and picks up waste and carbon...

describe how a closed circulatory system delivers oxygen and nutrients and picks up waste and carbon dioxide. What types of organisms use a closed circulatory system?

In: Nursing

In the given circuit an inductor of L = 8.95-mH and a resistor of R =...

In the given circuit an inductor of L = 8.95-mH and a resistor of R = 17.9-Ω resistor are connected in series with a dc battery of E = 8.80-V.

What is the voltage across the resistor immediately after the switch is closed?

What is the voltage across the resistor after the switch has been closed for a long time?

What is the current in the inductor after the switch has been closed for a long time?

In: Physics

Van Hatten Consolidated has three operating divisions: DeMent Publishing Division, Ankiel Security Division, and Depp Advisory...

Van Hatten Consolidated has three operating divisions: DeMent Publishing Division, Ankiel Security Division, and Depp Advisory Division. Each division maintains its own accounting system but follows IFRS.

DeMent Publishing Division
The DeMent Publishing Division sells large volumes of novels to a few book distributors, which in turn sell to several national chains of bookstores. DeMent allows distributors to return up to 30% of sales, and the distributors give the same terms to bookstores. While returns from individual titles fluctuate greatly, the returns from distributors have averaged 20% in each of the past five years. A total of $7 million of paperback novel sales were made to distributors during fiscal 2020. On November 30, 2020 (the end of the fiscal year), $1.5 million of fiscal 2020 sales were still subject to return privileges over the next six months. The remaining $5.5 million of fiscal 2020 sales had actual returns of 21%. Sales from fiscal 2019 totalling $2 million were collected in fiscal 2020 less 18% returns. This division records revenue according to the revenue recognition method when the right of return exists.
Ankiel Security Division
The Ankiel Security Division works through manufacturers’ agents in various cities. Orders for alarm systems and down payments are forwarded from agents, and the division ships the goods f.o.b. factory directly to the customers (usually police departments and security guard companies). Customers are billed directly for the balance due plus actual shipping costs. The company received orders for $6 million of goods during the fiscal year ended November 30, 2020. Down payments of $600,000 were received, and $5.2 million of goods were billed and shipped. Actual freight costs of $100,000 were also billed. Commissions of 10% on product price are paid to manufacturing agents after goods are shipped to customers. Such goods are covered by the warranty for 90 days after shipment, and warranty claims have been about 1% of sales. Revenue is recognized at the point of sale by this division.
Depp Advisory Division
The Depp Advisory Division provides asset management services. This division grew out of Van Hatten’s own treasury and asset management operations, which several of its customers asked to have access to. On January 1, 2020, Depp entered into a contract with Scutaro Co. to perform asset management services for one year. Depp receives a quarterly management fee of 0.25% on Scutaro’s assets under management at the end of each quarter. In addition, Depp receives a performance-based incentive fee of 20% of the fund’s annual return in excess of the return on the S&P 500 index at the end of the year. At the end of the first quarter of 2020, Depp was managing $2.4 million of Scutaro assets. The annualized return on the portfolio was 6.2%. (The S&P 500 index had an annualized return of 5.7%.)


(a)

For each division’s revenue arrangements, identify the separate performance obligations, briefly explain the allocation of the transaction process to each performance obligation, and indicate when the performance obligations are satisfied.

In: Accounting

In Python iOverlap (a1, a2, b1, b2) Write the function iOverlap that tests whether 2 closed...

In Python

iOverlap (a1, a2, b1, b2)

Write the function iOverlap that tests whether 2 closed intervals overlap. It takes 4 numbers (ints or floats) a1, a2, b1, b2 that describe the two closed intervals [a1,a2] and [b1,b2] of the real number line, and returns True if these two closed intervals overlap (even if at only one point) and False otherwise. If a1>a2, then the interval [a1,a2] is empty. If b1>b2, then the interval [b1,b2] is empty. Both intervals are closed, so contain their endpoints. For example, the intervals [1,2] and [2,3] overlap at the point 2.

In: Computer Science

Can a closed linear map be unbounded?

Can a closed linear map be unbounded?

In: Advanced Math