LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Applying a rating scale to numerical measurements

I have two lists of data that i need to graph. An example is given below.

Project Ref Investment/Beneficiary in $ Efficiency Rating
1 87.3 2.3
2 156.6 3.8
3 185.8 3.8
4 8250.0 3.0
5 1164000.0 1.8
6 1500000.0 2.1
7 2812000.0 1.6
8 21462700.0 1.7

The Efficiency column represents the results of a survey on quality using a
rating scale of 1-4 with 1 being poor and 4 good for each project. We now
want to graph the relationship of efficiency with the investment per
beneficiary that each project received.Ideally we want our data in a matrix
with the Project references as data labels. This will help us identify
projects with lets say high Investmement and poor efficiency. Because the
scales are so different (refer to project 8 compared to the others) we
thought it would be easier to apply the same scale 1-4 for the
Investment/Beneficiary results. How do you apply a rating scale to a list of
numbers so that "proportional" representation is ensured? Is this the right
thing to do with the data above?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rating according to 2 criteria. bollard Excel Worksheet Functions 5 September 6th 07 09:24 AM
Rating Arne Hegefors Excel Worksheet Functions 5 March 19th 07 05:25 PM
rating cells 1-5 colour coded HOW? treetop40 New Users to Excel 1 August 9th 05 12:03 PM
RAG Rating Andy Brander Charts and Charting in Excel 1 April 27th 05 02:25 PM
Rating 1 to 10 Kevin Lin Excel Discussion (Misc queries) 5 March 2nd 05 02:09 PM


All times are GMT +1. The time now is 03:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"