How to get all 100% variants if I know that 23 is in range of 58-73%

%3CLINGO-SUB%20id%3D%22lingo-sub-3200199%22%20slang%3D%22en-US%22%3EHow%20to%20get%20all%20100%25%20variants%20if%20I%20know%20that%2023%20is%20in%20range%20of%2058-73%25%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3200199%22%20slang%3D%22en-US%22%3E%3CP%3EJust%20as%20my%20title%20says%2C%20i%20really%20need%20this%20urgently%2C%20because%20it's%20pain%20to%20do%20all%20by%20hand%20and%20there's%20a%20lot%20of%20people%20involved%20(It's%20because%20our%20marking%20system%20in%20school%20got%20changed%20and%20it's%20really%20hellish)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3200199%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3200796%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20all%20100%25%20variants%20if%20I%20know%20that%2023%20is%20in%20range%20of%2058-73%25%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3200796%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1314845%22%20target%3D%22_blank%22%3E%40RosalieN%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20general%2C%20for%20quicker%20constructive%20responses%2C%20it%20is%20always%20best%20to%20provide%20concrete%20examples%20and%20preferably%20an%20example%20Excel%20file.%26nbsp%3B%20That%20is%20even%20more%20important%20when%20the%20resolution%20is%20needed%20%22urgently%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsually%2C%20you%20can%20attach%20the%20Excel%20file%20by%20clicking%20%22browse%22%20at%20the%20bottom%20of%20the%20reply%20window.%26nbsp%3B%20But%20apparently%2C%20some%20(new%3F)%20users%20cannot.%26nbsp%3B%20In%20that%20case%2C%20upload%20the%20Excel%20file%20to%20a%20file-sharing%20website%2C%20and%20post%20the%20download%20URL%20in%20a%20response%20here.%26nbsp%3B%20I%20like%20box.net%2Ffiles%3B%20others%20like%20dropbox.com.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20no%20idea%20what%20you%20mean%20by%20%22all%20100%25%20variants%22%20(is%20that%20different%20from%20%22all%20variants%22%3F)%20and%20by%20the%20%22range%20of%2058-73%25%22%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20a%20%3CU%3E%3CEM%3Every%20wild%20guess%3C%2FEM%3E%3C%2FU%3E%2C%20are%20you%20saying%20that%20you%20have%2023%20frequencies%20of%20scores%20in%20the%20range%20of%2058-73%25%3F%26nbsp%3B%20And%20assuming%20that%20scores%20are%20%22normally%22%20distributed%20(TBD)%2C%20you%20want%20to%20predict%20the%20frequencies%20for%20all%20scores%20from%200%25%20to%20100%25%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDid%20I%20mention%20that%20that%20is%20a%20%22very%20wild%20guess%22%3F%20(wink)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3201278%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20all%20100%25%20variants%20if%20I%20know%20that%2023%20is%20in%20range%20of%2058-73%25%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3201278%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1314845%22%20target%3D%22_blank%22%3E%40RosalieN%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%3EAnd%20it%20would%20help%20us%20help%20you%20if%20you%20provided%20concrete%20examples%20that%20show%20us%20how%20you%20%3CU%3E%3CEM%3E%22do%20all%20this%20by%20hand%22%3C%2FEM%3E%3C%2FU%3E.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Just as my title says, i really need this urgently, because it's pain to do all by hand and there's a lot of people involved (It's because our marking system in school got changed and it's really hellish)

2 Replies

@RosalieN 

 

In general, for quicker constructive responses, it is always best to provide concrete examples and preferably an example Excel file.  That is even more important when the resolution is needed "urgently".

 

Usually, you can attach the Excel file by clicking "browse" at the bottom of the reply window.  But apparently, some (new?) users cannot.  In that case, upload the Excel file to a file-sharing website, and post the download URL in a response here.  I like box.net/files; others like dropbox.com.

 

I have no idea what you mean by "all 100% variants" (is that different from "all variants"?) and by the "range of 58-73%"?

 

As a very wild guess, are you saying that you have 23 frequencies of scores in the range of 58-73%?  And assuming that scores are "normally" distributed (TBD), you want to predict the frequencies for all scores from 0% to 100%?

 

Did I mention that that is a "very wild guess"? (wink)

@RosalieN 

 

And it would help us help you if you provided concrete examples that show us how you "do all this by hand".