Next Question
RSS
You need to provide more details about what you're trying to accomplish.
If you want to simply put in data about 4 quadrants (e.g. ++, +-, -+, --) and get the fraction of each, why not just have four cells for the data input(call these A1, A2, B1, B2) , then another cell for their sum (call this A3), then four more cells for the fraction of each quadrant (call these A4, A5, B4, B5) by calculating the ratios:
A4 = A1/A3
A5 = A2/A3
B4 = B1/A3
B5 = B2/A3
If you want, you can also put in line and column sums around the first 4 cells (moving the other cells further down as needed), and then put in the same set of sum cells around the 4 ratio cells to get the ratio sums.
Permalink | Report
Answered Question
M$1
November 13, 2009 03:53 PM
Trying to create four quadrant Perceptual/Gap map in Excel (OS X), yet find it nearly impossible. Can someone give me the basic frame?
I am finding it hard to create a four quadrant perceptual map/gap map in Excel for a concept test and analysis I am doing. I just need the basic framework and I can input the data myself.
Interesting Question?
Yes (0)
No (0)
RSS
Best Answer Chosen by Asker
| November 13, 2009 08:56 PM |
If you want to simply put in data about 4 quadrants (e.g. ++, +-, -+, --) and get the fraction of each, why not just have four cells for the data input(call these A1, A2, B1, B2) , then another cell for their sum (call this A3), then four more cells for the fraction of each quadrant (call these A4, A5, B4, B5) by calculating the ratios:
A4 = A1/A3
A5 = A2/A3
B4 = B1/A3
B5 = B2/A3
If you want, you can also put in line and column sums around the first 4 cells (moving the other cells further down as needed), and then put in the same set of sum cells around the 4 ratio cells to get the ratio sums.
| Asker's Rating: |
• Excellent response. Worked perfectly.
Permalink | Report
Reply
Answer this Question
Related Questions
Ask a Question
Buy Mahalo Dollars with Credit Card or PayPal
Top Members
Most Popular Tags
Categories
- Anonymous
-
Arts & Design
-
Beauty & Style
-
Books & Authors
-
Business
-
Cars & Transportation
-
Consumer Electronics
- Coupons Deals
-
Education
-
Entertainment
-
Environment
-
Fitness
-
Food & Drink
- From Email
- From Iphone
- From Twitter
-
Health
-
History
-
Hobbies
-
Home & Garden
-
How Tos
-
Humor
-
Jobs
-
Legal
-
Local
-
Love & Relationships
-
Mahalo Answers Community
-
Money
-
Music
-
News
-
NSFW
-
Parenting
-
Pets
-
Science & Mathematics
-
Services
-
Shopping
-
Social Science
-
Society & Culture
-
Sports
-
Technology & Internet
-
Travel
-
Video Games
Welcome New Members
- ncsa, November 25, 2009 12:58 AM
- blonde, November 25, 2009 12:55 AM
- sfcjl, November 25, 2009 12:41 AM
- macapa, November 25, 2009 12:39 AM
- nelliebrown, November 25, 2009 12:38 AM
Mahalo Dollars are the currency of Mahalo Answers.
Each Mahalo Dollar costs $1.
Once you earn more than 40 Mahalo Dollars, you can request to be paid via PayPal. Each Mahalo Dollar is currently worth $0.75 when paid out via PayPal. Learn More
