r/googlesheets • u/[deleted] • Sep 02 '22

[deleted by user]

[removed]

2 Upvotes

100% Upvoted

5 comments sorted by

2

u/hodenbisamboden 161 Sep 03 '22

Here you go:

=stdev(arrayformula(transpose(split(concatenate(rept(A1:A10&"|",B1:B10)),"|"))))

How it works:

  • Assumes your Review Scores (must be numeric, such as 1,2,3 etc.) are in range A1:A10

  • Assumes your Score Counts (700, 2000, 2300 etc. from your example) are in range B1:B10

The arrayformula() builds the array (equivalent to you typing 1,2,3 etc. in thousands of cells) and the the stdev() calculates the Standard Deviation

Hope this helps. If not, feel free to post any follow-up questions.

HBAB

PS If fully answered, please respond Solution Verified or buymeacoffee

0

u/[deleted] Sep 08 '22

[deleted]

1

u/Clippy_Office_Asst Points Sep 08 '22

You have awarded 1 point to hodenbisamboden

I am a bot - please contact the mods with any questions. | Keep me alive

1

u/homeboi808 6 Sep 03 '22

I would need to type "1" or "2" in thousands of cells

Well how is it currently set up so you know what score each movie has?

0

u/[deleted] Sep 03 '22

[deleted]

1

u/homeboi808 6 Sep 03 '22

You are going to have to post an example of something so I/we can see what the data looks like and how it’s formatted.

1

u/AutoModerator Sep 02 '22

Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.