How to convert 1-5 scale Likert scale to 0-10 scale

[Excel_beginner]

How would I transform a column consisting of values 1-5 to a 0-10 scale?
Thanks in advance.

 

[p45cal]

Subtract 1 then multiply by 2.5
=(A1-1)*2.5

 

[bosco_yip]

How would I transform a column consisting of values 1-5 to a 0-10 scale?
Thanks in advance.

You always make your question unclear.

Please give us a sample file, showing that: what you have? and what you want?

Without that >>

We reserve to close your post should you fail to give us a clear reply.

Regards

 

[Excel_beginner]

Thank you, but the 0-10 scale must start from 0.
You can't just multiple 1-5 by 2.
In case of =1 would 1x2=2 when it needs to be =0.

 

[bosco_yip]

Subtract 1 then multiply by 2.5
=(A1-1)*2.5

@p45cal,

1] I thank you for your reply and let me learn a new thing of Likert scale.

2] I used your formula and built up a table as in below.

3] In B3, formula copied across

=(B1-1)*2.5

 

[Peter Bartholomew]

I wonder whether more is 'lost in translation' than is gained. Looking at the 5-point Likert scale (@bosco_yip, like you, I didn't know it had a name), each scale point might be interpreted as capturing a range of sentiments

I am not convinced that the 0-10 scale equivalents do the job much better despite the spurious accuracy implied be the additional decimal place.
Turning to a 7-point Likert scale and the conversion gets even messier.

My formulas for the 0-10 scale and range calculations were

= LET(
    scale,     SEQUENCE(n_point,,n_point,-1),
    ten_point, 10 * (scale - 1) / (n_point - 1),
    ten_point
  )
 
 
= LET(
    scale, SEQUENCE(n_point,,n_point,-1),
    upper, TEXT( scale / n_point,   "0%"),
    lower, TEXT((scale-1) / n_point,"0%"),
    range, lower & "-" & upper,
    range
  )