Question: 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
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 Liter). You are planning a hiking trip to the Mission Peak for 10 people and will bring 35 Liters of water. What is the probability that you will run out? What if the hiking trip will have 20 people and the amount of water you bring also doubles to 70 Liters. What is the probability you will run out? Please solve this problem in Excel and submit your Excel file. Will the probability of running out of water increase or decrease? Why?
Please use excel step by step for the answer.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
