What is the calculated value of the highest yearly average (for one month) in Cell C51 of
Fantastic news! We've Found the answer you've been seeking!
Question:
What is the calculated value of the highest yearly average (for one month) in Cell C51 of the worksheet: SI and regression?
Submit
Month | Demand |
1/1/2019 | 2324 |
2/1/2019 | 2789 |
3/1/2019 | 2442 |
4/1/2019 | 3020 |
5/1/2019 | 2379 |
6/1/2019 | 3482 |
7/1/2019 | 3362 |
8/1/2019 | 2635 |
9/1/2019 | 2274 |
10/1/2019 | 3271 |
11/1/2019 | 3575 |
12/1/2019 | 4355 |
1/1/2020 | 2243 |
2/1/2020 | 2705 |
3/1/2020 | 2966 |
4/1/2020 | 3256 |
5/1/2020 | 3684 |
6/1/2020 | 3819 |
7/1/2020 | 4604 |
8/1/2020 | 3104 |
9/1/2020 | 3133 |
10/1/2020 | 3712 |
11/1/2020 | 4215 |
12/1/2020 | 5152 |
1/1/2021 | 2691 |
2/1/2021 | 3139 |
3/1/2021 | 2870 |
4/1/2021 | 3424 |
5/1/2021 | 3783 |
6/1/2021 | 3722 |
7/1/2021 | 3165 |
8/1/2021 | 3287 |
9/1/2021 | 3578 |
10/1/2021 | 4477 |
11/1/2021 | 5248 |
12/1/2021 | 5503 |
1/1/2022 | |
2/1/2022 | |
3/1/2022 | |
4/1/2022 | |
5/1/2022 | |
6/1/2022 | |
7/1/2022 | |
8/1/2022 | |
9/1/2022 | |
10/1/2022 | |
11/1/2022 | |
12/1/2022 |
Related Book For
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th edition
Authors: Cliff T. Ragsdale
Posted Date: