• Suddenly unable to log into your ZooVille account? This might be the reason why: CLICK HERE!

Count to ∞!

138035

But if we do build a mathematical model in Excel, we can put any number we want and figure out how often any consecutive combinations of numbers occur.
But now that Dane mentioned that we can't count the times those consecutive combinations appear multiple times, the building of that model suddenly became a lot more difficult with a lot more equations and variables needed.
 
138037

For my two calculations here today, it was just brain counting and keeping track of what I did by reading what I had written so far.

Excel is something I use rather often. A couple of sheets with whatever variables that exist in any given location, some models to calculate how those variables effects each other or something else and finally a model for regression analysis on all already existing calculations to predict variables or other things using what data you have from a location.
Better programs exist, but with Excel you can do all those things in the same program.
Really easy to print out all your data and make diagrams too, so I think that it is a pretty good software.
 
Last edited by a moderator:
138041

I sure glad that my work doesn't deal with these types of math equations. Most of the time I only have to calculate rates and percentages, stuff that's way easier than trying to figure this stuff out. X is the percentage of V, and of that X%, this is the percentage of W, and this is the percentage of Y, and every once in awhile I'll have to calculate the percentage that just Z makes up. Easy peasy. That, and basic additional and subtraction sometimes.
 
138046

"If x effect y differently depending on if z exist or not and at what level, and ą have a direct effect on the amount of ş in x, how would ð decrease in x, considering that ž is absent?"
☝️ this and similar is pretty commonly occurring in my line of work.
Protip:
When you have atleast two variables effecting something, just mark the columns with those data and have Excel calculate the equation for you. Takes less than a second for the software, but unless you are a mathematical genius, it will most likely take a lot longer for you to form an equation of the the correlation between them.
 
You must log in or register to reply here.
Back
Top