DRSteele
Well-known Member
- Joined
- Mar 31, 2015
- Messages
- 2,652
- Office Version
- 365
- Platform
- Windows
Can some math genius please help me?
I wish to reckon the base prices for extended healthcare plan. There are three classes in the plans: Health, Dental and Prescriptions.
So we know the total prices for each of the 3^3=27 permutations. I wish to know the prices for each of the base plans (i.e., H-A, D-A, P-A)
Once those are known the rest falls into place. Right? or am I missing something? I tried matrix algebra and I became sorely vexed.
Here is the data. I hope to be able to fill out all the purple stuff.
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]
[/FONT]
I wish to reckon the base prices for extended healthcare plan. There are three classes in the plans: Health, Dental and Prescriptions.
Each of those three classes has three available variables: A, B and C.
By clicking through the co's website, I was able to come up with the various prices for all possible permutations of the various plans. [It only takes seven prices to compute the changes between the plans, so I didn't click through all 3^3=27 of them.]So we know the total prices for each of the 3^3=27 permutations. I wish to know the prices for each of the base plans (i.e., H-A, D-A, P-A)
Here is the data. I hope to be able to fill out all the purple stuff.
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]
| Book1 | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | |||
| 5 | Plan | Health | Dental | Prescriptions | Comment | Parameters | ||||
| 6 | A | |||||||||
| 7 | B | |||||||||
| 8 | C | |||||||||
| 9 | ||||||||||
| 10 | Selected | Health | Dental | Prescriptions | Health | Dental | Prescriptions | Price | ||
| 11 | A | A | A | 69.50 | ||||||
| 12 | A | A | B | 71.90 | ||||||
| 13 | A | B | A | 80.90 | ||||||
| 14 | A | B | B | 83.30 | ||||||
| 15 | B | B | B | 102.40 | ||||||
| 16 | B | A | B | 91.00 | ||||||
| 17 | B | B | A | 100.00 | ||||||
| 18 | B | A | A | 88.60 | ||||||
| 19 | B | B | C | 118.90 | ||||||
| 20 | B | C | B | 132.80 | ||||||
| 21 | B | C | C | 149.30 | ||||||
| 22 | C | B | B | 114.90 | ||||||
| 23 | C | B | C | 131.40 | ||||||
| 24 | C | C | B | 145.30 | ||||||
| 25 | C | C | C | 161.80 | ||||||
| 26 | A | A | C | 88.40 | ||||||
| 27 | A | B | C | 99.80 | ||||||
| 28 | A | C | B | 113.70 | ||||||
| 29 | A | C | C | 130.20 | ||||||
| 30 | B | A | C | 107.50 | ||||||
| 31 | B | C | A | 130.40 | ||||||
| 32 | B | C | C | 149.30 | ||||||
| 33 | C | A | B | 103.50 | ||||||
| 34 | C | B | A | 112.50 | ||||||
| 35 | C | A | A | 101.10 | ||||||
| 36 | C | B | B | 114.90 | ||||||
| 37 | C | C | A | 142.90 | ||||||
Sheet2 | ||||||||||
Last edited:
