An automated machine in a manufacturing process is operating properly if the length of animportant component is normally distributed, with mean = 117 cm and std. dev = 5.2 cm. In Excel, find the probability that, if four units are randomly selected, their mean length is greater than 120 cm. *note-please show functions used in excel step by step

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.4: Distributions Of Data
Problem 7PPS
icon
Related questions
icon
Concept explainers
Question
100%

An automated machine in a manufacturing process is operating properly if the length of animportant component is normally distributed, with mean = 117 cm and std. dev = 5.2 cm.

In Excel, find the probability that, if four units are randomly selected, their mean length is greater than 120 cm.

*note-please show functions used in excel step by step

 

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Continuous Probability Distribution
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill