The daily net cash flows in the table below represent a 5-day sample. Use the Data Analysis
Fantastic news! We've Found the answer you've been seeking!
Question:
The daily net cash flows in the table below represent a 5-day sample. Use the Data Analysis tool in Excel to calculate the 95% and 99% confidence intervals for the daily net cash flows. Along with your calculation, interpret the meaning behind your confidence interval estimates and discuss why the 99% confidence interval is wider.
| Day | Net Cash Flow |
| 1 | 15,000 |
| 2 | 17,000 |
| 3 | 13,000 |
| 4 | 20,000 |
| 5 | 14,000 |
Expert Answer:
Related Book For 
Spreadsheet Modeling and Decision Analysis A Practical Introduction to Business Analytics
ISBN: 978-1285418681
7th edition
Authors: Cliff Ragsdale
Posted Date:
