how to rank rank two occurrence variables in spearman ranking statistical analysis Answer question

Rank ScoresWrite a SQL query to rank scores. If there is a tie between two scores, both should have the same ranking. Note that after a tie, the next ranking number should be the next consecutive integer value. In other words, there should be no "holes" between ranks.IdScore13.5023.6534.0043.8554.0063.65For example, given the above Scores table, your query should generate the following report (order by highest score):ScoreRank4.0014.0013.8523.6533.6533.504Optionsselect Score over(order by Score desc) to Rank from Scores;select Score, dense_rank() as Rank from Scores;select Score, dense_rank() over(order by Score desc)select Score, dense_rank() over(order by Score desc) as Rank from Scores;

Which of the following is true about Spearman's rank correlation coefficient?Question 2Answera.It measures the strength and direction of a monotonic relationshipb.It is highly sensitive to outliersc.It can only be used with continuous datad.It assumes a linear relationship between variables

Rank weighting

Consider the following data set:1.21.31.31.31.61.71.81.81.81.92.12.22.5 The rank assigned to the three observations of value 1.3 is:Group of answer choices2.5.3.5.3.2.

Which of the following ranking functions can return duplicate values?Review LaterRANKDENSE_RANKROW_NUMBERnone of the above