Question

In: Statistics and Probability

I need a step by step for entering in excel. For this assignment, your group will...

I need a step by step for entering in excel.

For this assignment, your group will utilize the preliminary data collected in the Topic 2 assignment. Considering the specific requirements of your scenario, complete the following steps using Excel. The accuracy of formulas and calculations will be assessed.

  1. Select the appropriate discrete probability distribution. If using a binomial distribution, use the constant probability from the collected data and assume a fixed number of events of 20. If using a Poisson distribution, use the applicable mean from the collected data.
  2. Identify the following: the probability of 0 events occurring, the probability of <5 events occurring, and the probability of ≥10 events occurring.
  3. Using the mean and standard deviation for the continuous data, identify the applicable values of X for the following: Identify the value of X of 20% of the data, identify the value of X for the top 10% of the data, and 95% of the data lies between two values of X.

Solutions

Expert Solution

Sol:

1).

20 n
0.4 p
cumulative
X P(X) probability
0 0.00004 0.00004
1 0.00049 0.00052
2 0.00309 0.00361
3 0.01235 0.01596
4 0.03499 0.05095
5 0.07465 0.12560
6 0.12441 0.25001
7 0.16588 0.41589
8 0.17971 0.59560
9 0.15974 0.75534
10 0.11714 0.87248
11 0.07099 0.94347
12 0.03550 0.97897
13 0.01456 0.99353
14 0.00485 0.99839
15 0.00129 0.99968
16 0.00027 0.99995
17 0.00004 0.99999
18 0.00000 1.00000
19 0.00000 1.00000
20 0.00000 1.00000
1.00000
8.000 expected value
4.800 variance
2.191 standard deviation

2)

. 0 = 0.00004

< 5 = 0.05095

10 = 0.24466

3).

cumulative
X P(X) probability
0 0% 0%
1 0% 0%
2 0% 0%
3 1% 2%
4 3% 5%
5 7% 13%
6 12% 25%
7 17% 42%
8 18% 60%
9 16% 76%
10 12% 87%
11 7% 94%
12 4% 98%
13 1% 99%
14 0% 100%
15 0% 100%
16 0% 100%
17 0% 100%
18 0% 100%
19 0% 100%
20 0% 100%

X of 20% = 6

X of top 10% = 11

95% = 4 < X < 12


Related Solutions

I need step by step instructions on using Excel to do this assignment and the values...
I need step by step instructions on using Excel to do this assignment and the values I need to enter to compute what is being asked of me. I don't know how to use Excel and you tube is no help right now because I can't find specifics of what I need done. I'll post part two of this assignment as a seperate question. I need to get through part one first. Thanks... 1. Exercise 11   Section 3-1 11. Weight...
Note: I need a step by step answer to the question with an explanation of your...
Note: I need a step by step answer to the question with an explanation of your answer so that I can understand how to reproduce the steps. Marsha Inc. has the following budgeted data for 2016: Cash balance, beginning $15,000 Collections from customers 145,000 Direct materials purchases 25,000 Expenses: Operating expenses 50,000 Payroll 75,000 Income taxes 6,000 Other: Machinery purchases 30,000 Operating expenses include $20,000 depreciation for buildings and equipment. All purchases of materials are paid for in the period...
Note: I need a step by step answer to the question with an explanation of your...
Note: I need a step by step answer to the question with an explanation of your answers: White Corporation’s budget calls for the following sales for next year: Quarter 1 90,000 Quarter 3 68,000 Quarter 2 76,000 Quarter 4 96,000 Each unit of the product requires 3 pounds of direct materials. The company’s policy is to begin each quarter with an inventory of product equal to 5% of that quarter’s estimated sales requirements and an inventory of direct materials equal...
explain your answer step by step, i already have the answer but i need the explnations...
explain your answer step by step, i already have the answer but i need the explnations and type your answer, thanks 4 FeS2   +   11 O2    ®    2 Fe2O3    +    8 SO2 1.    How many moles of oxygen are required to react with 3.75 moles of FeS2?        2.    How many moles of Fe2O3 are formed when 2.83 moles of oxygen reacts with        excess FeS2? 3.    How many moles of SO2 are formed when 2.81 moles of Fe2O3 are...
Answers are provided but need step by step solutions without excel just basic step by step...
Answers are provided but need step by step solutions without excel just basic step by step with formulas 1. John invested $20,000 fifteen years ago with an insurance company that has paid him 8 percent (APR), compounded quarterly (every 3 months). How much interest did John earn over the 15 years?= $45,620.62 2. You are running short of cash and really need to pay your tuition. A friend suggests that you check out the local title pawn shop. At the...
I need give me example in every step. Do not use Excel. Thank you. On January...
I need give me example in every step. Do not use Excel. Thank you. On January 1,2018, Vidalia Company accepted a 14 % note, dated January 1, 2018 with a face amount of $ 2,480,000 in exchange for cash. The note is due in 10 years. For notes of similar risk and​ maturity, the market interest rate is 16 %Interest is paid each December 31. Requirement a.   Determine the present value of the note at January ​1,2018. (Use the present value...
I need step by step instructions of inserting these into a heap. this, is, the, house,...
I need step by step instructions of inserting these into a heap. this, is, the, house, that, jack, built. They should be inserted in this sequence. THen swap the first and last variables and do it again. I know the answer is suppose to be but not sure how I'm suppose to get that answer.    2nd iteration would be.   built, is, the house, that jack, this. I know the ansers in array format would be just keep getting it...
How can I solve this in Excel? Please show how to solve it in excel step...
How can I solve this in Excel? Please show how to solve it in excel step by step. 1) Speedy Wheels is a wholesale distributor of bicycles for the western United States. Its Inventory Manager, Ricky Sapolo, is currently reviewing the inventory policy for one popular model — a small, one-speed girl's bicycle that is selling at the rate of 250 per month. The administrative cost for placing an order for this model from the manufacturer is $200 and the...
I need name of the final compound, and step by step equations of the reaction for...
I need name of the final compound, and step by step equations of the reaction for the experiment below. Ethylenediamine complexes of Cobalt Procedure 1. Dissolved 1.5 g CoCl2 in 5mL water 2. While the CoCl2 6H2O is dissolving, measure out 10mL of an ethylenediamine solution. (The solution is prepared by dissolving 130mL of anhydrous ehylenediamine in one liter of water) 3.Cool the ethylenediamine solution in ice. 4.Slowly add 2.1mL 3M HCl 5.Add the CoCl2 solution to the partially neutrolized...
Chapter 6 Excel Assignment - Managerial Accouting NEED FORMULAS
 The Chapter 6 Form worksheet is to be used to create your own worksheet version of the Review Problem in the text.Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B26 enter the formula "= B17".After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the numbers in Review Problem 1.The LIFO inventory flow assumption is used throughout the problem.Check your worksheet by...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT