Weighted Criteria and comparing different investments

  • Context: MHB 
  • Thread starter Thread starter rbv27
  • Start date Start date
  • Tags Tags
    Criteria
Click For Summary
SUMMARY

This discussion focuses on creating a spreadsheet to compare various cryptocurrencies using a weighted criteria system. The user has established nine criteria for evaluation, normalized on a scale of 0-5 points. Key criteria include Type of Coin, Idea, Prototype Availability, Team, Market Cap, ROI Since Listing, Months Since Listing, Advisors, and Community. The user seeks guidance on effectively assigning weights to these criteria based on their importance to rank investments accurately.

PREREQUISITES
  • Understanding of investment evaluation criteria
  • Familiarity with spreadsheet software (e.g., Microsoft Excel or Google Sheets)
  • Knowledge of the SUMPRODUCT() function for weighted calculations
  • Basic concepts of cryptocurrency markets
NEXT STEPS
  • Research methods for assigning weights to criteria in investment analysis
  • Learn how to implement the SUMPRODUCT() function in Excel or Google Sheets
  • Explore different normalization techniques for scoring criteria
  • Investigate additional criteria that may impact cryptocurrency investments
USEFUL FOR

Investors, financial analysts, and anyone interested in systematically comparing cryptocurrency investments using a weighted criteria approach.

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?
 

Similar threads

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