Question

In: Statistics and Probability

Put each problem on a separate worksheet in an Excel file. Type the tabular data into...

Put each problem on a separate worksheet in an Excel file. Type the tabular data into the spreadsheet
Make Excel do all of the necessary calculations
Report answers on the worksheet
Label answers as the questions are labelled: a, b, c,…
Use the probability notation p(A), p(Aand B),… etc

2. A manufacturing firm in Pittsburgh, Pennsylvania receives shipments of part from two suppliers (we’ll call them A1 and A2. The probability that the parts come from A1 is 0.65, the probability that they come from A2 is 0.35.

Past experience has shown that if the parts came from A1, the probability that they are good is 0.98. If the parts came from A2, the probability that they are good is 0.95.

a. Draw the probability tree

b. What is the probability that a part came from A1 and is good?

c. What is the probability that a part came from A2 and is bad?

d. Using the information given and your results from b and c complete the contingency table below


	Supplier A1	Supplier A2
Good part
Bad part

e. What is the probability that a randomly selected part is bad?

f. A randomly selected part has been found to be bad. What is the probability that is from Supplier A1?

g. A randomly selected part has been found to be bad. hat is the probability that is from Supplier A2?

Expert Solution

Solution:

Given:

P(A1) = 0.65

P(A2) = 0.35

if the parts came from A1, the probability that they are good is 0.98.

That is: P(Good | A1) = 0.98

If the parts came from A2, the probability that they are good is 0.95.

P( Good | A2) = 0.95

Part a. Draw the probability tree

Part b. What is the probability that a part came from A1 and is good?

P(A1 and Good) = P( Good | A1) x P(A1)

P(A1 and Good) = 0.98 x 0.65

P(A1 and Good) = 0.637

Part c. What is the probability that a part came from A2 and is bad?

P( A2 and Bad) = P( Bad | A2 ) x P(A2)

P( A2 and Bad) = 0.05 x 0.35

P( A2 and Bad) = 0.0175

Part d. Using the information given and your results from b and c complete the contingency table below

	Supplier A1	Supplier A2
Good part	0.637	0.3325	P(Good) = 0.9695
Bad part	0.013	0.0175	P(Bad) = 0.0305
	0.65	0.35	1

Part e. What is the probability that a randomly selected part is bad?

P(Bad) =0.013 + 0.0175

P(Bad) = 0.0305

Part f. A randomly selected part has been found to be bad. What is the probability that is from Supplier A1?

P(A1 | Bad) =............?

From table , we have:

P(A1 and Bad) = 0.013

and P(Bad) = 0.0305

Thus

Part g. A randomly selected part has been found to be bad. What is the probability that is from Supplier A2?

P(A2 | Bad) = .........?

orchestra answered 1 year ago

Complete each problem on a separate worksheet in a single Excel file. Rename the separate worksheets...

Complete each problem on a separate worksheet in a single Excel file. Rename the separate worksheets with the respective problem number. You may have to copy and paste the datasets into your homework file first. Name the file with your last name, first initial, and HW #2. Label each part of the question. When calculating statistics, label your outputs. Use the Solver add-in for these problems. For a telephone survey, a marketing research group needs to contact at least 600...

Find the data for the problem in the first worksheet named LightbulbLife of the data file....

Find the data for the problem in the first worksheet named LightbulbLife of the data file. It gives the data on the lifetime in hours of a sample of 100 lightbulbs. The company manufacturing these bulbs wants to know whether it can claim that its lightbulbs typically last more than 1000 burning hours. So it did a study. Identify the null and the alternate hypotheses for this study. Can this lightbulb manufacturer claim at a significance level of 5% that...

Please answer each question set on a separate Excel worksheet, labeled appropriately and include excel Formulas...

Please answer each question set on a separate Excel worksheet, labeled appropriately and include excel Formulas Question Set 1. You are in charge of quality control for computer monitors at Dell. You have data on twenty-five batches of monitors, tracking five types of defects: brightness, color, contrast, dead pixels, and stuck pixels. These data are given in the table below. 1. For each defect type, find the average number of defects per batch. So, you should have an average defect...

Answer the following questions in an Excel file. Each questions with multiple parts requires a separate...

Answer the following questions in an Excel file. Each questions with multiple parts requires a separate answer. Label your steps and show each answer (1, 2, 3, and 4) in a separate Excel tab. For problems that require a written answer, use a text box in Excel to record the text. Calculate the PV of $5,000 received 10 years from now compounded annually at discount rates of: 1% 4% 12% Calculate the FV of $5,000 invested for 20 years using...

Please answer each question set on a separate Excel worksheet, labeled appropriately. (Include all formulas) Question...

Please answer each question set on a separate Excel worksheet, labeled appropriately. (Include all formulas) Question Set 1. You are in charge of quality control for computer monitors at Dell. You have data on twenty-five batches of monitors, tracking five types of defects: brightness, color, contrast, dead pixels, and stuck pixels. These data are given in the table below. 1. For each defect type, find the average number of defects per batch. So, you should have an average defect rate...

SHOW YOUR WORK not only the solutions, on worksheet tab in Excel file A fully amortizing...

SHOW YOUR WORK not only the solutions, on worksheet tab in Excel file A fully amortizing mortgage loan is made for $80,000 at 6 percent interest for 25 years. Payments are to be made monthly. Calculate: a. Monthly payments. b. Interest and principal payments during month 1. c. Total principal and total interest paid over 25 years. d. The outstanding loan balance if the loan is repaid at the end of year 10. e. Total monthly interest and principal payments...

EXCEL #1 ASSIGNMENT: Aspire Food Group: ORIGINAL PROBLEM DATA (1ST Excel File): CHECK FIGURES: Conversion: $2.38...

EXCEL #1 ASSIGNMENT: Aspire Food Group: ORIGINAL PROBLEM DATA (1ST Excel File): CHECK FIGURES: Conversion: $2.38 per EU 7/31/2020 Ending Balance WIP $59,589 A unit of production is one bag of 1,000 crickets. For example, in the brooder department process, there were 6,000 physical units in July in the beginning work-in-process inventory; which are 6,000 bags (each bag contains 1,000 crickets). The following information is available for the brooding department during July for Aspire Food Group Beginning work in...

The worksheet title “Table 1” in the Excel file “Dayton Software Inc Table 1” provides an...

The worksheet title “Table 1” in the Excel file “Dayton Software Inc Table 1” provides an overview of the market research data K2 generated. The table shows the four market segments, the anticipated size of each segment, and each segment’s willingness to pay for the two different versions of Integrated. It also includes projected costs of production and marketing. You can see the estimated production completion cost for each version, the variable cost per unit sold for each version and...

Enter the data in Excel. Create Blue Sky’s income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Improve the readability of the data by using (000’s) format (#, ##0.00).

1. Using the data presented below for Blue Sky Inc.; 2017 2016 Sales $7,550,000 $6,150,000 Cost of Goods 5,750,000 4,550,000 Depreciation 120,000 100,000 Selling and G&A Expenses 820,000 730,000 Fixed Expenses 200,000 200,000 Lease Expense 150,000 150,000 Interest Expense 350,000 300,000 Tax Rate 40.00% 40.00% Shares Outstanding 100,000 80,000 Cash 108,000 50,000 Marketable Securities 150,000 100,000 Accounts Receivable 450,000 350,000 Inventory 1,250,000 850,000 Prepaid Expenses 120,000 40,000 Plant & Equipment 5,350,000 4,800,000 Accumulated Depreciation 410,000 290,000 Long Term Investments 450,000...

how to export source data to excel file in python?