| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate average of ratings as a function of length
I have roadway segments that have been rated 1-5. Each segment has a
different length. I want to calculate the average rating for the total length. How do I do that and make it a function of length. example: road A has a rating of 5 and is 3 miles long road B has a rating of 3 and is 1 miles long road C has a rating of 2 and is 2 miles long What is the average rating? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ratings | Excel Discussion (Misc queries) | |||
| formula help: calculate length of employment | Excel Worksheet Functions | |||
| Calculate the average using the Lookup function or similar | Excel Discussion (Misc queries) | |||
| calculate the number of words in a row whose length is greater than 2 | Excel Worksheet Functions | |||
| How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
Threaded Mode
