Please solve in excel and show the excel steps and the excel sheet, specifically
ID: 2949928 • Letter: P
Question
Please solve in excel and show the excel steps and the excel sheet, specifically need to know the funtions . do not upload hand written steps or explanation. again please do not upload papers with explanations. thanks
12.7.5/10 points | Previous AnswersDevoreStat9 4.E.046 The Rockwell hardness of a metal is determined by impressing a hardened point into the surface of the metal and then measuring the depth of penetration of the point. Suppose the Rockwell hardness of a particular alloy is normally distributed with mean 70 and standard deviation 3. (a) If a specimen is acceptable only if its hardness is between 63 and 77, what is the probability that a randomly chosen specimen has an acceptable hardness? (Round your answer to four decimal places.) 9802 (b) If the acceptable range of hardness is (70-c, 70 + c), for what value of c would 95% of all specimens have acceptable hardness? (Round your answer to two decimal places.) (c) If the acceptable range is as in part (a) and the hardness of each of ten randomly selected specimens is independently determined, what is the expected number of acceptable specimens among the ten? (Round your answer to two decimal places.) specimens (d) What is the probability that at most eight of ten independently selected specimens have a hardness of less than 73.84? [Hint: Y= the number among the ten specimens with hardness less than 73.84 is a binomial variable; what is p?] (Round your answer to four decimal places.) 0.0159xExplanation / Answer
a) Use Excel formula
NORM.DIST(77,70,3,TRUE)-NORM.DIST(63,70,3,TRUE)
= 0.9802
b) Use Excel Function
NORMSINV(0.95+(0.05/2))*3
= 5.88
c) Use Formula
E(X) = 0.9802*10 = 9.802
d) First Find P(X<73.84)
Use Excel formula
NORM.DIST(73.84,70,3,TRUE)
= 0.8997
Use Excel formula
BINOM.DIST(8,10,0.8997,TRUE)
= 0.2650