Fall 2024 In-Person |
Presented 11/9/2024 |
||||||||
|
|||||||||
|
|||||||||
1. |
|
|
7. |
Straight
vs. Weighted Average |
|||||
2. |
|
8. |
|||||||
3. |
|
9. |
|||||||
4. |
|
10. |
|||||||
5. |
|
11. |
|||||||
6. |
|
12. |
|||||||
|
|||||||||
|
|
This concept is actually a separate walkthrough from this presentation with
multiple scenarios. For the sake of slideshow publication, ‘Straight vs. Weighted Average’ is
combined with this lecture presentation/walkthrough on ‘Key Excel and Spreadsheet Concepts’. The spreadsheet I used during
the ‘Straight vs. Weighted Average’
walkthrough has been published in Canvas. That spreadsheet contains these
four scenarios (a) what is the household raise when both spouse received
different raises? (b) what is the stock portfolio’s return on investment when
each of four stocks in the portfolio have return of investment already
calculated, (c) what is the return on investment for a single stock when the quarterly
return on investment is already calculated, and (d) how may patients did you
see when you have the monthly count of patients you saw. |
|
|
|||||