A lending institution supplied the following data on loan approvals by four loan officers. Conduct an...

A lending institution supplied the following data on loan approvals by four loan officers. Conduct an appropriate Hypothesis test to determine whether the loan approval decision is independent of the loan officer reviewing the loan application.

	Loan Approval Decision
Loan Officer	Rejected	Approved	Total
Sean	14	12	26
Bruce	14	18	32
Debbie	16	34	50
Susie	16	26	42
Total	60	90	*150*

State the Null and Alternate Hypotheses.
Determine the value of the test statistic. Show all the steps in your solution.
Determine p-value. Conduct Hypothesis test using p-value approach with α = .025. What is the test decision?
Determine Critical-Value. Conduct Hypothesis test using Critical-Value approach with α = .05. What is the test decision?
Do the results in parts c) and d) lead to different conclusions? Why or Why not?
Based on test decisions under parts c) and d), what conclusion would you draw?

PLEASE NO HANDWRITTEN ANSWERS,AND PLEASE WITH EXCEL FORMULAS!

Expert Solution

orchestra answered 2 years ago

A lending institution supplied the following data on loan approvals by four loan officers. Use α...

A lending institution supplied the following data on loan approvals by four loan officers. Use α = .05 and test to determine whether the loan approval decision is associated with the loan officer reviewing the loan application. Loan Approval Decision Loan Officer Approved Rejected Miller 24 16 McMahon 17 13 Lee 35 15 Sanchez 11 9 Hint: Consider what types of variable Loan Officer and Approval Decision are. Conduct a hypothesis test and upload a file with your answer. To...

A small mortgage lender has one receptionist, four loan officers, and two office managers. When applicants...

A small mortgage lender has one receptionist, four loan officers, and two office managers. When applicants apply for a new loan in person, they first fill out paperwork with the receptionist. Then the applicants meet with one of the loan officers to discuss their needs. The loan officer spends additional time processing the application after the applicants leave the office. Finally, the application must be reviewed by an office manager before it can be approved. The following table lists the...

Data Modeling question: model a personal lending app where Borrowers can request loan amounts, Lenders can...

Data Modeling question: model a personal lending app where Borrowers can request loan amounts, Lenders can offer Loans that are either amortized, installment-based, or interest-based, Borrowers can accept or reject loan offers, and the app tracks the principal, balance and payments made or missed.

A cement manufacturer has supplied the following data: Tons of cement produced and sold 220000 Sales...

A cement manufacturer has supplied the following data: Tons of cement produced and sold 220000 Sales revenue $924000 Variable manufacturing expense $297000 Fixed manufacturing expense $285498 Variable selling and administrative expense $165000 Fixed selling and administrative expense $81917 If the company increases its unit sales volume by 5% without increasing its fixed expenses, what would operating income be closest to

1. A company that makes organic fertilizer has supplied the following data: Bags produced and sold...

1. A company that makes organic fertilizer has supplied the following data: Bags produced and sold 240,000 Sales revenue $1,896,000 Variable manufacturing expense $804,000 Fixed manufacturing expense $520,000 Variable selling and administrative expense $180,000 Fixed selling and administrative expense $270,000 Net operating income $122,000 The company's margin of safety in units is closest to: Select one: a. 140,000 units b. 202,238 units c. 125,714 units d. 32,105 units 2. Davey Corporation is preparing its Manufacturing Overhead Budget for the fourth...

A cement manufacturer has supplied the following data: Tons of cement produced and sold 262,000 Sales...

A cement manufacturer has supplied the following data: Tons of cement produced and sold 262,000 Sales revenue $ 1,179,000 Variable manufacturing expense $ 431,000 Fixed manufacturing expense $ 228,000 Variable selling and administrative expense $ 93,000 Fixed selling and administrative expense $ 218,000 Net operating income $ 209,000 What is the company's unit contribution margin? (Round your intermediate calculations to 2 decimal places.) Multiple Choice $2.00 per unit $0.52 per unit $4.50 per unit $2.50 per unit

(TCO C) A tile manufacturer has supplied the following data. Tons of cement produced and sold...

(TCO C) A tile manufacturer has supplied the following data. Tons of cement produced and sold 220,000 Sales revenue $924,000 Variable manufacturing expense $297,000 Fixed manufacturing expense $280,000 Variable selling and admin expense $165,000 Fixed selling and admin expense $82,000 Net operating income $100,000 Required: Calculate the company's unit contribution margin. Calculate the company's contribution margin ratio. If the company increases its unit sales volume by 5% without increasing its fixed expenses, what would the company's net operating income be?

A cement manufacturer has supplied the following data: Tons of cement produced and sold 275,000 Sales...

A cement manufacturer has supplied the following data: Tons of cement produced and sold 275,000 Sales revenue $ 979,000 Variable manufacturing expense $ 232,000 Fixed manufacturing expense $ 313,000 Variable selling and administrative expense $ 110,650 Fixed selling and administrative expense $ 93,000 Net operating income $ 230,350 The company's contribution margin ratio is closest to: Multiple Choice 44.3% 65.0% 68.0% 23.5%

A manufacturer of tiling grout has supplied the following data: Kilograms produced and sold................... 300,000 Sales...

A manufacturer of tiling grout has supplied the following data: Kilograms produced and sold................... 300,000 Sales revenue............................................. 1,960,000 Variable manufacturing expense.......................960,000 Fixed manufacturing expense..........................266,000 Variable selling and admin expense................360,000 Fixed selling and admin expense.....................232,000 Net operating income.......................................132,000 Required: Calculate the: The company's break-even in unit sales The company's contribution margin ratio The company's degree of operating leverage

The following data is supplied from the comparative balance sheets and income statement information from Westerman,...

The following data is supplied from the comparative balance sheets and income statement information from Westerman, Inc. 2020 2019 Cash 88,000 64,000 Accounts Receivable 48,000 32,000 Inventory 56,000 64,000 Prepaid Insurance 32,000 40,000 Property, plant & equipment 88,000 64,000 Accumulated Depreciation (24,000) (16,000) Total 288,000 248,000 Accounts Payable 80,000 64,000 Salaries Payable 56,000 64,000 Long-term notes payable 40,000 48,000 Common...

Question