Worksheet: Spearman’s Rank Correlation Coefficient

In this worksheet, we will learn about Spearman’s rank correltion coefficient. Spearman’s correlation coefficient can be calculated whether the data are quantitative or descriptive.

Q1:

The data shows the relation between a company’s production and its employees’ salaries in 5 years.

Production1,0002,0002,5004,0002,300
Salaries150200250700180

Find the Spearman’s correlation coefficient between production and salaries.

Q2:

What type of data is Spearman’s rank correlation coefficient appropriate for?

  • AContinuous and discrete data
  • BDiscrete data
  • CContinuous data

Q3:

Find the Spearman’s correlation coefficient between sales and advertising from the given data.

Advertising1,000 800 1,0001,500
Sales5,0004,5004,5006,500

Q4:

Which of the following is the formula of Spearman’s rank correlation coefficient?

  • A16𝑑(𝑛1)
  • B16𝑑𝑛(𝑛1)
  • C6𝑑𝑛(𝑛1)
  • D16𝑑𝑛(𝑛1)
  • E1𝑑𝑛(𝑛1)

Q5:

The following table represents the relation between sale and profit for six models of televisions.

Television Sale 500 600 550 100 480 400
Television Profit 300 400 400 90 250 200

Find Spearman’s correlation coefficient between television sale and profit. Round your answer to three decimal places.

Q6:

Find Spearman’s correlation coefficient between 𝑥 and 𝑦. Round your answer to three decimal places.

𝑥 4 7 8 5 8 12
𝑦 7 6 6 4 6 10

Q7:

In a study of the relation between students’ grades in mathematics and science, the following results were found for six students.

MathematicsDBABDD
ScienceCCBACF

Find the Spearman’s correlation coefficient. Round your answer to three decimal places.

Q8:

The following table represents the relation between the results of employees’ appraisal this year and last year.

Last YearMeets expectationsNeeds improvementExceptionalMeets expectationsExceeds expectations
This YearExceeds expectationsMeets expectationsExceptionalNeeds improvementExceeds expectations

Find the Spearman’s correlation coefficient between last and current years results.

Q9:

In a study to discover the relationship between the age of a mother and the number of her children, the following data were found.

Mother’s Age 19 22 24 28 29 32 34 35
Number of Children 2 1 1 2 3 4 3 5

Find Spearman’s correlation coefficient. Round your answer to three decimal places.

Q10:

The table shows the relation between two variables, 𝐿 and 𝑀. Find Spearman’s correlation coefficient between them, rounded to the nearest thousandth.

𝐿 50 90 75 150 63 35 75 90 50
𝑀 130 130 64 80 100 55 80 100 80

Q11:

Using the information given in the table, find the Spearman’s rank correlation between the variables 𝑥 and 𝑦. Give your answer to four decimal places.

𝑥GoodExcellentGoodExcellentExcellentExcellent
𝑦PoorGoodPoorExcellentVery GoodGood

Q12:

Using the information from the table, find the Spearman’s rank correlation coefficient and determine the type of correlation between the age of a mother and number of children. Give the numerical part of your answer to four decimal places.

Age of Mothers (Years)2427352435213533
No. of Children (n)14353124
  • A0.2113, direct correlation
  • B0.1845, inverse correlation
  • C0.2113, inverse correlation
  • D0.1845, direct correlation

Q13:

Using the information from the table, find the Spearman’s rank correlation coefficient and determine the type of correlation between the variables 𝑋 and 𝑌. Give the numerical part of your answer to four decimal places.

𝑋149101369
𝑌212023162016
  • A0.2714, inverse correlation
  • B0.3, inverse correlation
  • C0.2714, direct correlation
  • D0.3, direct correlation

Nagwa uses cookies to ensure you get the best experience on our website. Learn more about our Privacy Policy.