Question: How do I respond to this post:Hello class, This weeks lesson was very interesting to me especially because I got to learn about a new

How do I respond to this post:Hello class, This weeks lesson was very interesting to me especially because I got to learn about a new function and practice it in excel. The average for my data set is $22,453. I then had 6 cars that fell below that average, leaving me with p = .60 and q = 1 - .60 = .40 To find the probability of exactly 4 of them falling below the average (P(x=4)), I entered the function =BINOM.DIST(4,10,0.6,FALSE) and got 11.15%. To find the probability of fewer than 5 of them falling below the average (P(x < 5)), I entered the function =BINOM.DIST(4,10,0.6,TRUE) and got 16.62%. To find the probability of more than 6 of them falling below the average (P(x > 6)), I entered the function =1-BINOM.DIST(6,10,0.6,TRUE) and got 38.23%. To find the probability of at least 4 of them falling below the average (P (x 4), I entered the function =1-BINOM.DIST(3,10,0.6,TRUE) and got 94.52%. - Moriah

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Question: What as the average weekly safety inventory level of refined sugar from the beginning January 2022 to the end of July 2022? A. 512,465.9691 metric tons per week B. 316,002.1474 metric tons...

How should I respond to this post: The workbook I used to complete the questions is attached. I found the PDFs very helpful and well laid out! The average Price for the cars in my data set is...

HOw do I respond to this peer response: Amelia, You are very thorough in your discussion. I wish I would've sawn this breakdown prior to me taking the test for this week. For me, it was a very...

MATHEMATICIANS RISE TO A CHALLENGE ne of the theorems we teach in eighth grade is a + b= *, where c is the length of the hypotenuse of a right triangle in Euclidean space, and a and b are the lengths...

Please read chapter 5 and answer the questions and see the ( guide to answer number 3) For each case study, you will view the material as the student's teacher, read the information provided and...

Please read chapter 8 and answer the questions and see the (guide to answer number 3) For each case study, you will view the material as the student's teacher, read the information provided and write...

Please read chapter 8 and answer the questions and see the ( guide to answer number 3) For each case study, you will view the material as the student's teacher, read the information provided and...

Please read chapter 6 and answer the questions and see the ( guide to answer number 3) For each case study, you will view the material as the student's teacher, read the information provided and...

Please read chapter 6 and answer the questions and see the ( guide to answer number 3) 1. Decide what assessment you would like to do to provide you with more information about the student, 2....

Please read the question Question: On pages 5 and 6 the authors write, "Narrative provides not only meaning but also a mental framework for imbuing future experiences and information with meaning, in...

On August 8, 2007, ZZ, Inc. purchased 5,000 shares (8%) of EZ Company stock for $18 per share. The following information relates to the EZ Company stock: EZ Company paid a dividend of $2 per share...

The following is a report from a not-very-efficient BLS survey taker: "There were 65 people in the houses I visited, 10 of them children under 16; 25 people had full-time jobs, and 5 had part-time...

s i n 2 ( x 4 ) d x

XYZ Ltd currently has 1 million ordinary shares, each with a nominal value of $1. The company wants to raise an additional $0.6 million and has decided to raise it by issuing new shares at $1.5 per...

Clay changes jobs in 2018 and decides to roll his $50,000 retirement plan balance from his old employer's plan into an IRA. He instructs the trustee of the retirement plan to transfer the money...

X company intend to manufacture 100,000 units of product M. Each unit of product M requires one unit of the three types of raw materials namely A,B and C. Material A is in regular use of the company...

Define what management means to you. The definition must reflect your personal insight and include example(s) from your everyday experience. If you have previous or current work experience, you may...

Determine if the overhead allocated to the product relates to a single plantwide overhead rate method, multiple production department factory overhead rate method, or activity-based costing...

41. Show in Example 6.22 that the limiting probabilities satisfy Eqs. (6.33), (6.34), and (6.35).

39. Suppose in Exercise 38 that an entering customer is served by the server who has been idle the shortest amount of time. (a) Define states so as to analyze this model as a continuous-time Markov...

42. In Example 6.22 explain why we would have known before analyzing Example 6.22 that the limiting probability there are j customers with server i is . (What we would not have known was that the...