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 |
Related Book For
Spreadsheet Modeling and Decision Analysis A Practical Introduction to Business Analytics
ISBN: 978-1285418681
7th edition
Authors: Cliff Ragsdale
Posted Date: