Malazan Empire: HALP! - Malazan Empire

Jump to content

Help

Page 1 of 1

You cannot start a new topic
You cannot reply to this topic

HALP! need Excel advice.

#1 Mentalist

Martyr of High House Mafia

Group: High House Mafia
Posts: 9,501
Joined: 06-June 07
Location:'sauga/GTA, City of the Lion
Interests:Soccer, Chess, swimming, books, misc
Junior Mafia Mod

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.

The problem with the gene pool is that there's no lifeguard
THE CONTESTtm WINNER--чемпіон самоконтролю

Jump Around, on 23 October 2011 - 11:04 AM, said:

And I want to state that Ment has out-weaseled me by far in this game.

#2 beru

shy guy

Group: Malaz Regular
Posts: 780
Joined: 14-December 08
Location:norway
Interests:gaming (strategy/tactic first persons)<br />reading<br />swiming

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

i want to see this world where T'lan imass kneels

#3 Mentalist

Martyr of High House Mafia

Group: High House Mafia
Posts: 9,501
Joined: 06-June 07
Location:'sauga/GTA, City of the Lion
Interests:Soccer, Chess, swimming, books, misc
Junior Mafia Mod

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.

Attached File(s)

SO_formula.JPG (6.7K)
Number of downloads: 4

The problem with the gene pool is that there's no lifeguard
THE CONTESTtm WINNER--чемпіон самоконтролю

Jump Around, on 23 October 2011 - 11:04 AM, said:

And I want to state that Ment has out-weaseled me by far in this game.

#4 beru

shy guy

Group: Malaz Regular
Posts: 780
Joined: 14-December 08
Location:norway
Interests:gaming (strategy/tactic first persons)<br />reading<br />swiming

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

i want to see this world where T'lan imass kneels

#5 Mentalist

Martyr of High House Mafia

Group: High House Mafia
Posts: 9,501
Joined: 06-June 07
Location:'sauga/GTA, City of the Lion
Interests:Soccer, Chess, swimming, books, misc
Junior Mafia Mod

Posted 10 February 2009 - 07:31 AM

Microsoft help's useless..

but i mayhave figured out how to do each column separately.

The problem with the gene pool is that there's no lifeguard
THE CONTESTtm WINNER--чемпіон самоконтролю

Jump Around, on 23 October 2011 - 11:04 AM, said:

And I want to state that Ment has out-weaseled me by far in this game.

#6 eekwibble

Only...

Group: Malaz Regular
Posts: 193
Joined: 21-March 08
Location:Manchestoh
Interests:West Haaaaaaaaaaam!!!!!

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 Mentalist

Martyr of High House Mafia

Group: High House Mafia
Posts: 9,501
Joined: 06-June 07
Location:'sauga/GTA, City of the Lion
Interests:Soccer, Chess, swimming, books, misc
Junior Mafia Mod

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....

The problem with the gene pool is that there's no lifeguard
THE CONTESTtm WINNER--чемпіон самоконтролю

Jump Around, on 23 October 2011 - 11:04 AM, said:

And I want to state that Ment has out-weaseled me by far in this game.

#8 Gothos

Map painting expert

Group: Malaz Regular
Posts: 5,428
Joined: 01-January 03
Location:.pl

Posted 10 February 2009 - 10:05 AM

Mentalist, on Feb 10 2009, 07:55 AM, said:

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 Sir Thursday

House Knight

Group: High House Mafia
Posts: 1,819
Joined: 14-July 05
Location:Enfield, UK

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

Don't look now, but I think there's something weird attached to the bottom of my posts.

#10 frookenhauer

Mortal Sword

Group: Malaz Regular
Posts: 1,113
Joined: 11-July 08
Location:England
Interests:Women
Money
AI
Writing

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 :ph34r:

souls are for wimps

#11 Mentalist

Martyr of High House Mafia

Group: High House Mafia
Posts: 9,501
Joined: 06-June 07
Location:'sauga/GTA, City of the Lion
Interests:Soccer, Chess, swimming, books, misc
Junior Mafia Mod

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, :ph34r:

The problem with the gene pool is that there's no lifeguard
THE CONTESTtm WINNER--чемпіон самоконтролю

Jump Around, on 23 October 2011 - 11:04 AM, said:

And I want to state that Ment has out-weaseled me by far in this game.