Converting Raw scores to percentages 
Author Message
 Converting Raw scores to percentages

Hey there,

I have a spreadsheet full of raw scores and I want to
convert them to percentages. for example, each homework
assignment is worth 5 points. I have a row of raw scores
such as 5, 3, 4, 5. I want to convert these raw scores to
percentages (100, 60, 80, 100, respectively), but I want
the percentages to appear in the same cell. That is, i
want the raw scores replaced with the percentages...any
way to do this?

Thanks,
Chad



Sat, 30 Apr 2005 10:32:33 GMT  
 Converting Raw scores to percentages
Chad

An easy way is to format the cells as %.  Then multiply them by .2 (edit -
paste special - values - multipy ).  This will work for all the scores that are
based on a max of 5.  The multiplier will be different if the max score is
different.  It may make more sense to leave the raw scores in place, and put a
formula in another area that does the calculation, but it may not.

Good luck.

Ken
Norfolk, Va



Sat, 30 Apr 2005 10:52:48 GMT  
 Converting Raw scores to percentages
Type 100 in an empty cell.
Edit|copy (that cell)
Select your range to convert to percentages

Edit|Paste special|check divide under operation
format as percentage

clean up that 100 cell.

Quote:

> Hey there,

> I have a spreadsheet full of raw scores and I want to
> convert them to percentages. for example, each homework
> assignment is worth 5 points. I have a row of raw scores
> such as 5, 3, 4, 5. I want to convert these raw scores to
> percentages (100, 60, 80, 100, respectively), but I want
> the percentages to appear in the same cell. That is, i
> want the raw scores replaced with the percentages...any
> way to do this?

> Thanks,
> Chad

--

Dave Peterson



Sat, 30 Apr 2005 10:52:04 GMT  
 Converting Raw scores to percentages

Hi Chad
 - Enter the number 5 in a blank cell and select that cell
 - From the toolbar "Edit>Copy"
 - Select the entire range of scores
 - From the toolbar "Edit>Copy>PasteSpecial" - In the "Paste box" select
"Values" and in the "Operations" box select "Divide". Ok back to the
worksheet
 - Format the range with a percentage
--

Regards

William


| Hey there,
|
| I have a spreadsheet full of raw scores and I want to
| convert them to percentages. for example, each homework
| assignment is worth 5 points. I have a row of raw scores
| such as 5, 3, 4, 5. I want to convert these raw scores to
| percentages (100, 60, 80, 100, respectively), but I want
| the percentages to appear in the same cell. That is, i
| want the raw scores replaced with the percentages...any
| way to do this?
|
| Thanks,
| Chad



Sat, 30 Apr 2005 10:51:57 GMT  
 Converting Raw scores to percentages
<<Type 100 in an empty cell>>
And then lock the doors to avoid a number of unhappy parents trying to knock
your door down due to the very low percentages awarded to their children!
<vbg>
--

Regards

William


| Type 100 in an empty cell.
| Edit|copy (that cell)
| Select your range to convert to percentages
|
| Edit|Paste special|check divide under operation
| format as percentage
|
| clean up that 100 cell.
|
|
|
|
|
| >
| > Hey there,
| >
| > I have a spreadsheet full of raw scores and I want to
| > convert them to percentages. for example, each homework
| > assignment is worth 5 points. I have a row of raw scores
| > such as 5, 3, 4, 5. I want to convert these raw scores to
| > percentages (100, 60, 80, 100, respectively), but I want
| > the percentages to appear in the same cell. That is, i
| > want the raw scores replaced with the percentages...any
| > way to do this?
| >
| > Thanks,
| > Chad
|
| --
|
| Dave Peterson



Sat, 30 Apr 2005 11:01:52 GMT  
 Converting Raw scores to percentages
Chad

One method....if your raw scores examples are representative....

Enter 20 in an unused cell....format it to percent......copy it to
clipboard.....select your range of raw scores and paste special>multiply>OK.

Clear the 20 and its format when you're done.

Gord Dibben  Excel MVP - XL97 SR2

Quote:

>Hey there,

>I have a spreadsheet full of raw scores and I want to
>convert them to percentages. for example, each homework
>assignment is worth 5 points. I have a row of raw scores
>such as 5, 3, 4, 5. I want to convert these raw scores to
>percentages (100, 60, 80, 100, respectively), but I want
>the percentages to appear in the same cell. That is, i
>want the raw scores replaced with the percentages...any
>way to do this?

>Thanks,
>Chad



Sat, 30 Apr 2005 10:55:43 GMT  
 Converting Raw scores to percentages
Oops.

I just read your post and saw the 5.  I had to go back and reread the OP.

Oops (again!)

Quote:

> <<Type 100 in an empty cell>>
> And then lock the doors to avoid a number of unhappy parents trying to knock
> your door down due to the very low percentages awarded to their children!
> <vbg>
> --

> Regards

> William



> | Type 100 in an empty cell.
> | Edit|copy (that cell)
> | Select your range to convert to percentages
> |
> | Edit|Paste special|check divide under operation
> | format as percentage
> |
> | clean up that 100 cell.
> |
> |
> |
> |
> |

> | >
> | > Hey there,
> | >
> | > I have a spreadsheet full of raw scores and I want to
> | > convert them to percentages. for example, each homework
> | > assignment is worth 5 points. I have a row of raw scores
> | > such as 5, 3, 4, 5. I want to convert these raw scores to
> | > percentages (100, 60, 80, 100, respectively), but I want
> | > the percentages to appear in the same cell. That is, i
> | > want the raw scores replaced with the percentages...any
> | > way to do this?
> | >
> | > Thanks,
> | > Chad
> |
> | --
> |
> | Dave Peterson


--

Dave Peterson



Sat, 30 Apr 2005 11:09:43 GMT  
 
 [ 7 post ] 

 Relevant Pages 

1. Converting to a Percentage from Raw Numbers - Applying a formula across multiple

2. Final score only if score is entered?

3. standard scores [z scores]

4. Averaging a range of scores, excluding lowest score

5. Final score only if score is entered?

6. convert raw data to numerical?

7. Converting Excel's formulas into raw data

8. convert data from a column to a raw or string

9. Convert raw data (codes) into number categories

10. Convert Oracle Long raw to CLOB ?


 
Powered by phpBB® Forum Software © phpBB Group