29 Sep Responses should be a minimum of 100 words and may
Responses should be a minimum of 100 words and may include direct questions. In peer responses, compare the probabilities that I found with those of my classmates. Were they higher/lower and why? In the responses, refer to the specific data from my classmates’ posts that I will include.PEER 1 (William): I thought the excel assignment for this weeks forum was easy to understand after completing last weeks assignment. The assignment asks us to find four different probabilities for the next 4 cars that are sampled. First, we must calculate a new standard deviation using the central limit theorem. In excel this looks like, =oldSD/SQRT(4) because the new sample size is 4. The new standard deviation is 13071.36, and I will use the same mean 36720.00.The first question asks us to find the probability that (x<36,220). In excel I enter =NORM.DIST(36220,36720,E18,TRUE) and get an answer of 48.47%. The second question asks us to find P(x>37,720). In excel this appears as =1-NORM.DIST(37720,E13,E18,TRUE) and receive an answer of 46.95%. The third question asks us to find P(x=36,720). In excel this appears as =NORM.DIST(E13,E13,E18,FALSE). The chances of this happening are very slim and we receive an answer of 0.00%. Finally, the assignment asks us to find P(35,220
About Writemia
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Place Order” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.