Question

Do the following using Excel (cutting and pasting/snipping a photo to demonstrating your usage of the software). State step-by-step how you get to the results in Excel. The tensile strength of paper used to make grocery bags is normally distributed with a mean m of 40 lbs./ in² and a standard deviation of s = 2.5 lbs./in².

a) What is the probability that a bag produced from this paper will be less than 35 lbs./in²?

b) What is the probability that a bag produced from this paper will be less than 34 lbs./in²?

c) What is the probability that a bag produced from this paper will be between 35 lbs./in² and 45 lbs./in²?

Answer 1

a) the probability that a bag produced from this paper will be less than 35 lbs./in2

=NORMDIST(35,40,2.5,TRUE).............................using Excel command.

=0.02275

b) the probability that a bag produced from this paper will be less than 34 lbs./in2

=NORMDIST(34,40,2.5,TRUE).............................using Excel command.

=0.0082

c)  the probability that a bag produced from this paper will be between 35 lbs./in2 and 45 lbs./in2

=NORMDIST(45,40,2.5,TRUE)-NORMDIST(35,40,2.5,TRUE).........................using Excel command.

=0.9545