i have to solve a math problem in which it gives the names of 15 people and of 7 different books and then gives 14 different conditions about who read what book and i have to find out who read what book. the conditions are very complicated and i need to know if there is any way to input the data into Excel or Access and then set the conditons for the data and have it solve the problem for me. HELP PLEASE!
2007-01-05 13:32:19 · 6 answers · asked by Raptor1589 1 in Computers & Internet ➔ Software
i have to solve a math problem in which it gives the names of 15 people and 7 different books and then gives 14 different conditions about who read what book and i have to find out who read what. the conditions are very complicated and i need to know if there is any way to input the data into Excel or Access and then set the conditons for the data and have it solve the problem for me. HELP PLEASE!
*****the problem with the conditions are that they are too complicated; example: the 15 people have read a total of 45 books, and within those 45 books, the number of people who have read a certain number of books is the same as the number of people who have read any other number of books(example. # of people who read 3 books = # of people read 4)
the teacher mention Excel as a possible way of solving it so maybe some one knows how...?
2007-01-05 13:44:41 · update #1
i'm not sure i understand your question entirely, but I think (from what I understand) I can get you started in the general direction.
use access dbase - create tables - a table for each book with list of "unique" conditions (e.g. 7 tables), table listing all the readers;
design a query/form to question each person (make a unique form OR make a "radial" selection for each reader) with a multiple choice selection button detailing those "conditions"- should be able to select more than one condition since you said there are 14 of them.
Run a query per person from this form to find out who read what book.
Good luck!
2007-01-05 13:45:08 · answer #1 · answered by m m 3 · 0⤊ 0⤋
since there are the same number of people who have read x number of books who have read y number, and so on, and fifteen total people, they must split into three groups of five, five groups of three, or one group of 15.
So 15 people read three books each could be one solution, unless there is a condition you didn't mention. For the rest of the possibilities, make column B=3*A . (Repeat with B=5*A). In B6, put the sum of column B. Then you can change the numbers in column A (the number of books read by that group) until you come up with a combo that equals 45. You can see that when you repeat for B=5*A ,you need to move the total up to B4.
2007-01-08 18:29:43 · answer #2 · answered by wayfaroutthere 7 · 0⤊ 0⤋
I don't think there is a way to input that data to excel or word BUT
you can solve this problem using pen and paper and draw it they say there are 15 persons draw 15 squares that represent them and the books two as soon as you start you will have the possibility to know who didn't read what and then you reducing the options for him until you have only what book they did read.
2007-01-05 13:39:19 · answer #3 · answered by Anonymous · 0⤊ 0⤋
They are just as good as guys. The girls suck at this while guys are better theory is acutally based on the macho principle. Which has existed since the begining of time. Many women buy into it and dont perform well. The fact is that woman and men as groups are equal in eveything mental. So dont believe that psudo science that shows SCANS of brains as proof. The only thing I can think of that girls do not match men on is physical. They just have a differnt composition. They were not made to grow as large as men. But then men cant do some things that women can do. Like give birth. In this case we are just different. That we may prefer not to give birth if given the choice is subjective. but that we cant do it is a fact. so we really are more equal than many men (and some women) may care to admit.
2016-03-28 21:36:22 · answer #4 · answered by Anonymous · 0⤊ 0⤋
No. not likely. this is a logic question, a bit like a puzzle. You need read the statements carefully to get the solutions. One condition can give you a few hints.
2007-01-05 13:36:01 · answer #5 · answered by mslenora 3 · 0⤊ 0⤋
You're asking this on a Friday night? I'm great with Excel but I'm a bit tipsy right now so I'm of no use to you. Maybe I'll edit my answer tomorrow.
2007-01-05 13:34:23 · answer #6 · answered by Bored Enough To Be Here 6 · 0⤊ 0⤋