Problems


The data for this chapter’s problems is contained in the file Ch59data.xlsx.

  1. In the Problem 1 worksheet, you are given data about the duration of a machine’s lifetime.

    • What is the probability that the machine will last at least 10 hours?

    • What is the probability that the machine will last from 1 through 5 hours?

    • What is the probability that the machine will fail within 6 hours?

  1. You need to clean your house today. In the Problem 2 worksheet, you are given data about how long it has taken to clean your house in the past. If you start cleaning at noon, what are the chances that you’ll be finished in time to leave at 7:00 P.M. for a movie?




Microsoft Press - Microsoft Office Excel 2007. Data Analysis and Business Modeling
MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)
ISBN: 0735623961
EAN: 2147483647
Year: 2007
Pages: 200

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net