MHB Weighted Criteria and comparing different investments

  • Thread starter Thread starter rbv27
  • Start date Start date
  • Tags Tags
    Criteria
AI Thread Summary
A user is developing a spreadsheet to compare various cryptocurrencies using nine criteria, each normalized to a score of 0-5 points. They seek guidance on how to assign weights to these criteria based on their importance for ranking investments. The criteria include factors such as the type of coin, project idea, prototype availability, team quality, market cap, return on investment since listing, listing duration, advisors, and community support. A suggestion was made to utilize the sumproduct() function for calculating weighted scores. The discussion emphasizes the need for a systematic approach to weight assignment in investment analysis.
rbv27
Messages
1
Reaction score
0
I am trying to make a spread sheet that compares different investments (cryptocurrencies). So far each investment has 9 criteria. I have normalized each criteria to be worth 0-5 points. I would like to be able to rank each investment based on their total score depending on different criteria. I need to assign weights to different criteria but what is the correct method of assigning weights based on level of importance? Please help.

example: below are the criteria i am using listed in order from most important to least important.
Type of coin, idea, is there a prototype?, team, market cap, roi since listing, months since listing, advisors, community
coin:
 
Mathematics news on Phys.org
Pretty hard to say what you can do, based on the very vague description.

Have you met the sumproduct() function?
 

Thread 'Non-orthogonal bases'

Suppose ,instead of the usual x,y coordinate system with an I basis vector along the x -axis and a corresponding j basis vector along the y-axis we instead have a different pair of basis vectors ,call them e and f along their respective axes. I have seen that this is an important subject in maths My question is what physical applications does such a model apply to? I am asking here because I have devoted quite a lot of time in the past to understanding convectors and the dual...
View full post »

Thread 'What Exactly is Dirac’s Delta Function? - Insight'

Insights auto threads is broken atm, so I'm manually creating these for new Insight articles. In Dirac’s Principles of Quantum Mechanics published in 1930 he introduced a “convenient notation” he referred to as a “delta function” which he treated as a continuum analog to the discrete Kronecker delta. The Kronecker delta is simply the indexed components of the identity operator in matrix algebra Source: https://www.physicsforums.com/insights/what-exactly-is-diracs-delta-function/ by...
View full post »

Similar threads

MHB Binary Search Tree - Sort the same BSTree by name or by weight
Replies
3
Views
2K
B Which probability calculation is "more correct" in Baccarat games?
Replies
9
Views
5K
Buy and Hold Beats Active Investing
Replies
46
Views
5K
Comparing the variance of two samples with differing measurement error
Replies
1
Views
1K
I The Actual Sleeping beauty Problem
Replies
45
Views
5K
I Comparing Clock Rates in Accelerated vs Constant Velocity Frames
Replies
14
Views
2K
MHB Which Catering Service Maximizes Charity Profit for a Business Banquet?
Replies
2
Views
6K
Weighted Mean: different sample size and variance
Replies
10
Views
2K
Is the observed result significantly different from the expected result?
Replies
6
Views
2K
Plan for study in the US as an international student
Replies
10
Views
2K

Hot Threads

Recent Insights

Back
Top