Question: Please use Excel to solve this problem and submit your Excel file. The problem is as follows: The weight of bags of fertilizer is normally

  1. Please use Excel to solve this problem and submit your Excel file. The problem is as follows:

The weight of bags of fertilizer is normally distributed, with a mean of 100 pounds (the target) and a standard deviation of 0.5 pounds.

  1. What is the probability that the weight of a bag of fertilizer will be within 0.5 pound of the target 100 pounds?
  2. If a bag of fertilizer is more than 101 pounds or less than 99 pounds, it is considered off-standard or defect. What is the probability that a bag of fertilizer is off-standard?

Please use Excell to answer and solve. and explain how

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 General Management Questions!

Q:

Please use Excel to solve this problem and submit your Excel file. The problem is as follows: 1. The weight of bags of fertilizer is normally distributed, with a mean of 100 pounds (the target) and a...

Q:

1.Problem 1 is adapted from Problem 29 at the end of Chapter 11. Please use Excel to solve this problem and submit your Excel file. The problem is as follows: A warehouse distributor of carpet faces...

Q:

1. Problem 1 is adapted from Problem 29 at the end of Chapter 11. Please use Excel to solve this problem and submit your Excel file. The problem is as follows: A warehouse distributor of carpet faces...

Q:

Please use Excel to solve this problem and submit your Excel file. The problem is as follows. The average person drinks 3 Liters of water when hiking the Mission Peak (with a standard deviation of 1...

Q:

Please use Excel to solve this problem and submit your Excel file. The problem is as follows. Solve this problem in Excel using a format in Video 2-6. Hahn Engineering is planning on bidding on a job...

Q:

Please use EXCEL to solve this problem (a) Formulate an algebraic model for the problem. Submit this in Word or pdf. (b) Use LINGO or the Excel Solver to solve this model, including your name and...

Q:

please use excel to solve this problem:) (a) Formulate an algebraic model for the problem. Submit this in Word or pdf. (b) Use LINGO or the Excel Solver to solve this model, including your name and...

Q:

i can send the excel file. not sure how to upload it. Homework 2 (26 points) 1. (16 points) The file Homework2Data.xls contains monthly returns for Amazon stock, the equity market, and one-month...

Q:

Can you please use LINGO to solve the problem instead of excel, thanks. to write them in standard form, i.e. all variables on the left-hand side, and a number of the right-hand side. If you use...

Q:

PLEASE USE EXCEL FORMAT PROVIDED T O SOLVE!! Golding Landscaping and Plants, Inc. Kenneth and Patricia Golding spent a career a s a husband - and - wife real estate investment partnership i n...

Q:

The State of Kentucky is planning major renovations in its parks during 2020 and enters into a contract with Grill Master to purchase 400 durable, easy maintenance, standard charcoal grills during...

Q:

Imagine that you work in the accounting department at the firm and your CEO has just purchased a building and some land in a basket purchase for $5,000,000. The firm has two appraisals performed,...

Q:

The answer to number one is $ 4 4 7 8 . The answer to number three is project X . I need help with question two please Show all images Show all images Show all images done loading

Q:

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...