Questions
School Type Cost 30 Year ROI Annual ROI School Type Cost 30 Year ROI Annual ROI...

School Type Cost 30 Year ROI Annual ROI School Type Cost 30 Year ROI Annual ROI
Private $222,700.00 $1,786,000.00 7.70% Private $221,700.00 $2,412,000.00 8.70%
Private $176,400.00 $1,758,000.00 8.40% Private $213,000.00 $2,064,000.00 8.30%
Private $212,200.00 $1,714,000.00 7.80% Private $230,100.00 $1,949,000.00 7.90%
Public $125,100.00 $1,535,000.00 9.10% Private $222,600.00 $1,947,000.00 8.00%
Private $212,700.00 $1,529,000.00 7.40% Private $225,800.00 $1,938,000.00 8.00%
Public $92,910.00 $1,501,000.00 10.10% Public $87,660.00 $1,937,000.00 11.20%
Private $214,900.00 $1,485,000.00 7.30% Private $224,900.00 $1,915,000.00 7.90%
Private $217,800.00 $1,483,000.00 7.20% Private $221,600.00 $1,878,000.00 7.90%
Private $225,600.00 $1,444,000.00 7.00% Public $125,100.00 $1,854,000.00 9.80%
Private $217,300.00 $1,442,000.00 7.10% Private $215,700.00 $1,794,000.00 7.90%
Private $226,500.00 $1,441,000.00 7.00% Public $92,530.00 $1,761,000.00 10.60%
Private $215,500.00 $1,438,000.00 7.20% Private $217,800.00 $1,752,000.00 7.70%
Private $223,500.00 $1,428,000.00 7.00% Public $89,700.00 $1,727,000.00 10.70%
Private $226,600.00 $1,414,000.00 7.00% Private $229,600.00 $1,716,000.00 7.50%
Private $189,300.00 $1,397,000.00 7.50% Public $101,500.00 $1,703,000.00 10.20%
Public $89,700.00 $1,382,000.00 9.90% Public $115,500.00 $1,694,000.00 9.70%
Public $87,030.00 $1,376,000.00 10.00% Public $104,500.00 $1,690,000.00 10.10%
Private $218,200.00 $1,343,000.00 6.90% Public $69,980.00 $1,685,000.00 11.50%
Private $229,900.00 $1,339,000.00 6.70% Private $219,400.00 $1,676,000.00 7.60%
Private $148,800.00 $1,321,000.00 8.10% Public $64,930.00 $1,668,000.00 11.70%

 

  1. In a highlighted box, explain how each hypothesis test contributes to the central question of which major would give the better ROI. Why do we need hypothesis testing? Isn't it enough to look at the sample of 20 schools and look at those numbers? What exactly does hypothesis testing do that looking at the numbers in the sample and saying "one is higher than the other" cannot do? This answer is critical to your final project. It demonstrates that you understand why you just can't look at the mean, median, and mode of the spreadsheet and "call it a day
  2. . For Business versus Engineering majors conduct a full, two-sample, full hypothesis test at the 5% significance level (assume the variances are not equal):The average ’30-Year ROI’ for Business majors is less than for Engineering Majors.
    • The mean ‘Cost’ for a college is $160,000.
  3. For each of the 2 majors, conduct a full hypothesis test at the 10% significance level:

In: Statistics and Probability

U.S. Civilian Labor Force (thousands) Year Labor Force Year Labor Force 2007 153,918 2012 155,628 2008...

U.S. Civilian Labor Force (thousands)
Year Labor Force Year Labor Force
2007 153,918 2012 155,628
2008 154,655 2013 155,151
2009 153,111 2014 156,238
2010 153,650 2015 157,957
2011 153,995 2016 159,640

(c) Fit three trend models: linear, exponential, and quadratic. Which model would offer the most believable forecasts? (You may select more than one answer.)

  • Linear
  • Quadratic
  • Exponential



(d)
Make forecasts using the following fitted trend models for years 2017-2019. (Round your answers to the nearest whole number.)

t Linear Quadratic Exponential
11
12
13

In: Statistics and Probability

Category Prior Year Current Year Accounts payable 3,200.00 5,904.00 Accounts receivable 6,998.00 9,042.00 Accruals 5,786.00 6,074.00...

Category Prior Year Current Year
Accounts payable 3,200.00 5,904.00
Accounts receivable 6,998.00 9,042.00
Accruals 5,786.00 6,074.00
Additional paid in capital 20,474.00 13,653.00
Cash ??? ???
Common Stock 2,850 2,850
COGS 22,850.00 18,391.00
Current portion long-term debt 500 500
Depreciation expense 975.00 1,049.00
Interest expense 1,270.00 1,124.00
Inventories 3,060.00 6,685.00
Long-term debt 16,894.00 22,918.00
Net fixed assets 75,390.00 74,138.00
Notes payable 4,095.00 6,512.00
Operating expenses (excl. depr.) 19,950 20,000
Retained earnings 35,190.00 34,849.00
Sales 46,360 45,998.00
Taxes 350 920

What is the firm's cash flow from operations?

In: Finance

Category Prior Year Current Year Accounts payable 3,200.00 5,904.00 Accounts receivable 6,998.00 9,042.00 Accruals 5,786.00 6,074.00...

Category Prior Year Current Year
Accounts payable 3,200.00 5,904.00
Accounts receivable 6,998.00 9,042.00
Accruals 5,786.00 6,074.00
Additional paid in capital 20,474.00 13,653.00
Cash ??? ???
Common Stock 2,850 2,850
COGS 22,850.00 18,391.00
Current portion long-term debt 500 500
Depreciation expense 975.00 1,049.00
Interest expense 1,270.00 1,124.00
Inventories 3,060.00 6,685.00
Long-term debt 16,894.00 22,918.00
Net fixed assets 75,390.00 74,138.00
Notes payable 4,095.00 6,512.00
Operating expenses (excl. depr.) 19,950 20,000
Retained earnings 35,190.00 34,849.00
Sales 46,360 45,998.00
Taxes 350 920

What is the firm's cash flow from financing?

In: Finance

Category Prior Year Current Year Accounts payable 3,167.00 5,980.00 Accounts receivable 6,928.00 9,085.00 Accruals 5,681.00 6,133.00...

Category Prior Year Current Year
Accounts payable 3,167.00 5,980.00
Accounts receivable 6,928.00 9,085.00
Accruals 5,681.00 6,133.00
Additional paid in capital 19,785.00 13,738.00
Cash ??? ???
Common Stock 2,850 2,850
COGS 22,141.00 18,485.00
Current portion long-term debt 500 500
Depreciation expense 1,031.00 958.00
Interest expense 1,283.00 1,120.00
Inventories 3,079.00 6,723.00
Long-term debt 16,586.00 22,497.00
Net fixed assets 75,786.00 73,890.00
Notes payable 4,083.00 6,532.00
Operating expenses (excl. depr.) 19,950 20,000
Retained earnings 35,688.00 34,732.00
Sales 46,360 45,639.00
Taxes 350 920

What is the firm's total change in cash from the prior year to the current year?

In: Finance

Category Prior Year Current Year Accounts payable 3,196.00 5,993.00 Accounts receivable 6,902.00 9,010.00 Accruals 5,631.00 6,152.00...

Category Prior Year Current Year
Accounts payable 3,196.00 5,993.00
Accounts receivable 6,902.00 9,010.00
Accruals 5,631.00 6,152.00
Additional paid in capital 20,434.00 13,339.00
Cash ??? ???
Common Stock 2,850 2,850
COGS 22,532.00 18,865.00
Current portion long-term debt 500 500
Depreciation expense 961.00 1,040.00
Interest expense 1,280.00 1,129.00
Inventories 3,009.00 6,747.00
Long-term debt 16,888.00 22,882.00
Net fixed assets 75,751.00 74,135.00
Notes payable 4,039.00 6,539.00
Operating expenses (excl. depr.) 19,950 20,000
Retained earnings 35,849.00 34,640.00
Sales 46,360 45,756.00
Taxes 350 920

What is the firm's total change in cash from the prior year to the current year?

Submit

Answer format: Number: Round to: 0 decimal places.

In: Finance

Category Prior Year Current Year Accounts payable 3,135.00 5,968.00 Accounts receivable 6,966.00 9,072.00 Accruals 5,764.00 6,074.00...

Category Prior Year Current Year
Accounts payable 3,135.00 5,968.00
Accounts receivable 6,966.00 9,072.00
Accruals 5,764.00 6,074.00
Additional paid in capital 19,681.00 13,488.00
Cash ??? ???
Common Stock 2,850 2,850
COGS 22,967.00 18,382.00
Current portion long-term debt 500 500
Depreciation expense 968.00 1,031.00
Interest expense 1,258.00 1,166.00
Inventories 3,048.00 6,692.00
Long-term debt 16,712.00 22,065.00
Net fixed assets 75,176.00 74,064.00
Notes payable 4,088.00 6,531.00
Operating expenses (excl. depr.) 19,950 20,000
Retained earnings 35,388.00 34,596.00
Sales 46,360 45,859.00
Taxes 350 920

What is the firm's total change in cash from the prior year to the current year?

In: Finance

Category Prior Year Current Year Accounts payable 3,108.00 5,961.00 Accounts receivable 6,914.00 9,090.00 Accruals 5,614.00 6,025.00...

Category Prior Year Current Year
Accounts payable 3,108.00 5,961.00
Accounts receivable 6,914.00 9,090.00
Accruals 5,614.00 6,025.00
Additional paid in capital 19,932.00 13,389.00
Cash ??? ???
Common Stock 2,850 2,850
COGS 22,997.00 18,346.00
Current portion long-term debt 500 500
Depreciation expense 1,041.00 1,003.00
Interest expense 1,290.00 1,162.00
Inventories 3,095.00 6,666.00
Long-term debt 16,687.00 22,417.00
Net fixed assets 75,344.00 73,998.00
Notes payable 4,016.00 6,568.00
Operating expenses (excl. depr.) 19,950 20,000
Retained earnings 35,943.00 34,480.00
Sales 46,360 45,852.00
Taxes 350 920

What is the firm's total change in cash from the prior year to the current year?

In: Finance

Item Prior year Current year Accounts payable 8,144.00 7,791.00 Accounts receivable 6,059.00 6,782.00 Accruals 1,000.00 1,336.00...

Item Prior year Current year
Accounts payable 8,144.00 7,791.00
Accounts receivable 6,059.00 6,782.00
Accruals 1,000.00 1,336.00
Cash ??? ???
Common Stock 11,882.00 12,879.00
COGS 12,688.00 18,245.00
Current portion long-term debt 5,050.00 4,905.00
Depreciation expense 2,500 2,777.00
Interest expense 733 417
Inventories 4,172.00 4,794.00
Long-term debt 14,883.00 13,304.00
Net fixed assets 51,305.00 54,473.00
Notes payable 4,359.00 9,908.00
Operating expenses (excl. depr.) 13,977 18,172
Retained earnings 28,204.00 29,275.00
Sales 35,119 47,717.00
Taxes 2,084 2,775

What is the firm's total change in cash from the prior year to the current year?

In: Finance

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500...

Category

Prior year

Current year

Accounts payable

41,400

45,000

Accounts receivable

115,200

122,400

Accruals

16,200

13,500

Additional paid in capital

200,000

216,660

Cash

???

???

Common Stock @ par value

37,600

42,000

COGS

131,400

178,880.00

Depreciation expense

21,600

23,341.00

Interest expense

16,200

16,489.00

Inventories

111,600

115,200

Long-term debt

135,000

139,816.00

Net fixed assets

378,907.00

399,600

Notes payable

59,400

64,800

Operating expenses (excl. depr.)

50,400

64,589.00

Retained earnings

122,400

136,800

Sales

255,600

338,143.00

Taxes

9,900

18,931.00

What is the firm's gross profit margin for the current year?

In: Finance