ExcelHopeful
New Member
- Joined
- Jul 9, 2015
- Messages
- 18
Hello,
I hope you can all bare with me as I do not know the proper statistical terms.
Goal: I have 30% of my data (both numerical and text). How can I use statistics (probability) to estimate the remaining data?
Info: The table below is a simple example of my real data set. Instead of 9 suppliers, I really have 593. For every supplier I do have the data for their total spend, but I do not know their metal makeup, nore do I know their Fixed contract status. Therefore, I would like to estimate those by using that original 30% as the weight. I know this is very unreliable, but my manager says he'd rather see some data than no data...even if it's just estimates.
I appreciate any help, thank you.
I hope you can all bare with me as I do not know the proper statistical terms.
Goal: I have 30% of my data (both numerical and text). How can I use statistics (probability) to estimate the remaining data?
Info: The table below is a simple example of my real data set. Instead of 9 suppliers, I really have 593. For every supplier I do have the data for their total spend, but I do not know their metal makeup, nore do I know their Fixed contract status. Therefore, I would like to estimate those by using that original 30% as the weight. I know this is very unreliable, but my manager says he'd rather see some data than no data...even if it's just estimates.
I appreciate any help, thank you.
Supplier | Total Spend | Fixed Contract (Y/N)? | Metal 1 | Metal 2 | Metal 3 | Metal 4 | Metal 5 |
Supplier 1 | $132.88 | ||||||
Supplier 2 | $122.67 | Yes | 20% | 20% | 20% | 20% | 20% |
Supplier 3 | $187.54 | ||||||
Supplier 4 | $126.77 | ||||||
Supplier 5 | $108.55 | Yes | 5% | 75% | 10% | 5% | 5% |
Supplier 6 | $101.82 | No | 30% | 30% | 5% | 5% | 30% |
Supplier 7 | $115.05 | ||||||
Supplier 8 | $125.87 | ||||||
Supplier 9 | $147.72 |