Page 1 of 1
HALP! need Excel advice.
#1
Posted 10 February 2009 - 06:55 AM
can anyone explain to me how to transform numbers in excel?
I have a 16 by 16 matrix, and i need to get a sum of all the numbers, with each number being multiplied by its log 2.
any advice would be greatly appreciated.
I have a 16 by 16 matrix, and i need to get a sum of all the numbers, with each number being multiplied by its log 2.
any advice would be greatly appreciated.
#2
Posted 10 February 2009 - 07:03 AM
take a new slot
type = then all the cordiantes with a + between
if this is not working press F1 and hope for the best
type = then all the cordiantes with a + between
if this is not working press F1 and hope for the best
i want to see this world where T'lan imass kneels
#3
Posted 10 February 2009 - 07:10 AM
sigh
I know how to do sums
the problem is, i need to convert ALL the numbers into a multiple of a number with that number's log...
basically apply the following formula:
where nij is each number inthe matrix and ni is the row sum
I worked out the denominator part, but numerator requires multiple transformations of all 64 numbers.
I know how to do sums
the problem is, i need to convert ALL the numbers into a multiple of a number with that number's log...
basically apply the following formula:
where nij is each number inthe matrix and ni is the row sum
I worked out the denominator part, but numerator requires multiple transformations of all 64 numbers.
Attached File(s)
-
SO_formula.JPG (6.7K)
Number of downloads: 4
#4
Posted 10 February 2009 - 07:14 AM
then go to plan b press F1
or google it beacuse i have NO idea what the hell that equasion is about
or google it beacuse i have NO idea what the hell that equasion is about
i want to see this world where T'lan imass kneels
#5
Posted 10 February 2009 - 07:31 AM
Microsoft help's useless..
but i mayhave figured out how to do each column separately.
but i mayhave figured out how to do each column separately.
#6
Posted 10 February 2009 - 07:38 AM
I like icecream.
QUOTE (amphibian @ Nov 11 2008) <Rake himself was a huge weight inside Draconus and he didn't go in with an army.>
#7
Posted 10 February 2009 - 07:44 AM
hah, i seem to have figured it out... the things we must learn for the sake of success in education..
now, just to flter out the messed up data that results from taking a log of 0....
now, just to flter out the messed up data that results from taking a log of 0....
#8
Posted 10 February 2009 - 10:05 AM
Mentalist, on Feb 10 2009, 07:55 AM, said:
can anyone explain to me how to transform numbers in excel?
I have a 16 by 16 matrix, and i need to get a sum of all the numbers, with each number being multiplied by its log 2.
any advice would be greatly appreciated.
I have a 16 by 16 matrix, and i need to get a sum of all the numbers, with each number being multiplied by its log 2.
any advice would be greatly appreciated.
RTFM
It is not the critic who counts; not the man who points out how the strong man stumbles, or where the doer of deeds could have done them better. The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood, who strives valiantly; who errs and comes short again and again; because there is not effort without error and shortcomings; but who does actually strive to do the deed; who knows the great enthusiasm, the great devotion, who spends himself in a worthy cause, who at the best knows in the end the triumph of high achievement and who at the worst, if he fails, at least he fails while daring greatly. So that his place shall never be with those cold and timid souls who know neither victory nor defeat.
#9
Posted 10 February 2009 - 05:11 PM
The way I'd do it would be to create a second 16x16 matrix which displays the value of nlogn, and then sum those.
Sir Thursday
Sir Thursday
Don't look now, but I think there's something weird attached to the bottom of my posts.
#10
Posted 10 February 2009 - 11:34 PM
So would the new matrix...and I'm assuming that a new matrix will be created, where each entry is the product of wat? I'm still a little confused by this, but I'm damned if I'm going to walk away from a maths problem...
Would it be an idea to practice with a 4x4 matrix and then develop it up? from there.
basically I want to help, but you got to help me help you
Would it be an idea to practice with a 4x4 matrix and then develop it up? from there.
basically I want to help, but you got to help me help you
souls are for wimps
#11
Posted 11 February 2009 - 02:34 AM
problem has been solved.
to clarify for frook
I had a frequency martix.
essentially, I needed to calculate redundancy.
to do so, you divide the actual redundancy by the maximum redundancy.
actual redundancy = sigma n times n log 2, where n represents a number in every cell of the matrix.
what I was having trouble with was not performing a single transformation, but extending it so that I cover the entire matrix and don't have to calculate each number separately.
basically due to my noobness in Excel I didn't know about the dragging feature. but once you do the f(x) = PRODUCT (cell * LOG(cell, 2)) for the first cell of the matrix, you can drag the cursor so that the same formula's applied to all ajacent cells.
and that's how i learned to use excel,
to clarify for frook
I had a frequency martix.
essentially, I needed to calculate redundancy.
to do so, you divide the actual redundancy by the maximum redundancy.
actual redundancy = sigma n times n log 2, where n represents a number in every cell of the matrix.
what I was having trouble with was not performing a single transformation, but extending it so that I cover the entire matrix and don't have to calculate each number separately.
basically due to my noobness in Excel I didn't know about the dragging feature. but once you do the f(x) = PRODUCT (cell * LOG(cell, 2)) for the first cell of the matrix, you can drag the cursor so that the same formula's applied to all ajacent cells.
and that's how i learned to use excel,
#12
Posted 11 February 2009 - 08:05 PM
I see...So we can safely let this thread drop down into page two plus
souls are for wimps
#13
Posted 11 February 2009 - 08:12 PM
Mentalist, on Feb 10 2009, 09:34 PM, said:
basically due to my noobness in Excel I didn't know about the dragging feature.
lol!! You must have been looking at a lot of typing before you discovered that one. I don't know what I would do without the dragging feature!
Burn rubber =/= warp speed
Share this topic:
Page 1 of 1