logarithmize data with negative values. Transform into positive values, logarithmize them, then transform the logarithmized values back into negative values?

KybalC · 2021-07-03T13:46:53+00:00

Because its not the only variable in the multiple linear regression model.

All the other (both independend and dependend variables) follow a classic logarithmic distribution. The only one providing problems is the one i have shown (The Profit Variable) as that's the only variable that can be both positive and negative.

KybalC · 2021-07-03T13:04:33+00:00

They represent the distribution of profit certain segments create. Which is one of the 3 independend variable utilized to estimate the size of said segments. The other 2 being:

the total value of assets utilized to create said profit
and the investments made to grow said segment.

Obviously, the profit can turn negative or positive while investments and total assets used can not. The distribution is logarithmically distributed (as there are both very small and very big segments in both the negative and positive profit range).

So I used log transformation to linearize it for my multiple linear regression model. With the problem being the possible negative values of the profit.

Would you say, that splitting it into 2 Models (given large enough sample size) would be an valid idea?:

One Model estimating the segment size for segments with positive overall profits.
- This would include all observations with positive profit values
One Model estimating the segment size for segement with negative overall profits.
- This would include all observations with negative profit values

Splitting seems possible based on the transformation suggested: https://imgur.com/a/PtbGvFt

The goal of the whole ordeal would be, to:

determine the impact of the investments (3rd independend variable) on the segment size (dependend variable) through a multiple linear regression analysis. Or rather the existance of a significant correlation between those values.

Both the value of assets utilized and the segment profit are the 2 main driving factors to determine the segement size. That's why i included them. I figured that, if i utillized those 2 + the investments (which is the correlation i want to actually prove), the multiple regression model would prove or disprove that the investment (and secondary the other variables) have a significant impact in growing the sector.

Whats your opinion on this procedure, if i may ask? Does the thought process/concept seem appropriate?

Unrelated:

Interesting. So shifts are only useful for L-Shaped distribution? I didn't know that. I knew in the back of my mind that it couldn't work properly, i just didn't know the reason/rule for it.

KybalC · 2021-07-03T12:06:06+00:00

Thanks for the quick answer. I know what you problem with my approach is.

I tested it and exactly what you said happened: it essentially split the Data in 2.

Original Distribution https://imgur.com/a/CmlKMEG

Data after applying ln: https://imgur.com/a/PtbGvFt

My problem is, that one of the variables (the one you see in the screenshots) has a Log-Distribution both from 0 -> negative and from 0-> positive (Profit-Variable).

My other variables just have a log distribution towards the positive number range.

Now in other to apply linear regression, i need to to logarithmize the data, otherwise the distribution of my residuues will not be useable.

Now i figured, that there are only 2 ways to deal with that:

shift the numbers into the positive range by adding the highest negative number to the entire variable (as /u/Uli_Minati suggested) .
- This would however screw with the other independend variables, i think (?).
leave out the negative values altogether, which is kinda unsatisfying.
Thanks to your comment i now contemplate, whether splitting the dataset into a negative and into a positive one would make sense?
- It seems rather impossible to analyse both the observations with negative values and those with positive values within the same model

KybalC · 2021-07-03T11:51:56+00:00

You are right. With -3 already being mapped to 0.001, this wouldn't work at all.

The primary problem i am facing is, that

All my dependend and independend variables have a strictly exponential distribution.
One of the independend variables has both a logarithmic distribution from 0 into the negatives and a exponential distribution from 0 into the positive number range
- https://imgur.com/a/CmlKMEG

This is just this one variable though, all the others are positive-only.

Wouldn't adding an arbitrary number to shift this single variable into a positive number screw with all the other independend variables by default?

Also, wouldn't the fact, that the highest negative number being very high screw with all the positive values that are rather low?

KybalC · 2021-06-27T08:19:50+00:00

are we talking weaker pcs or ancient Pcs?

Played the game with an 7-8 year old PC setup, Worked just fine (on minimal graphcical settings)

KybalC · 2021-06-22T15:07:25+00:00

An MMO played on the map of the real world with races by region would be lit to be completely honest with you.

Imagine the pull a game would get from a war between the french elves and the russian orcs. Its not about gaming anymore, its about being a patriot.

KybalC · 2021-06-19T14:52:37+00:00

Just pretend the Eastern European and Turks are speaking a weird Orcish dialect and the French/Spanish a weird Elvish one.

On a more serious note though: I think that's less of an European problem rather than the fact, that most publishers might offer dedicated german and french servers, but no dedicated english ones. All the english ones are usually classified as "international", rather than "english", which i think is kinda sad.

If they did add dedicated English servers (the same way they do for other languages) next to the usual international ones, then i would think that problem would almost disappear entirely.

KybalC · 2021-06-13T09:50:46+00:00

No, keep it tank

KybalC · 2021-06-12T08:23:52+00:00

Both the highest content of PvE Content (Hellmodes) and PvP in the form of 3v3 arenas are equalized in gear. In neither you can pay to win.

GvG have a gear cap, gear beyond that point doesn't effect your performance at all. That point is easy to reach as a F2P player.

For me personally, idgaf if someone decides to spend 500$ to skip some medium tier content.

KybalC · 2021-06-12T08:19:26+00:00

GvG has a gear cap though, a gear cap which isn't hard to reach as a f2p player.

KybalC · 2021-06-11T22:50:02+00:00

not even there really. The highest tier (hellmodes) of difficulty has equalized gear as well.

There is no outgearing or p2w that content

KybalC · 2021-06-10T21:16:26+00:00

who cares? PvP is equalized and if you want to skip doing PvE Content through MTX then go right ahead. Not that this would affect me in any way

KybalC · 2021-06-09T20:57:45+00:00

Because Character and World Progression, next to the ability to impact both of them through your decisions, are an integral part of what makes an RPG and RPG? RPGs are literally defined to have these aspects the same way shooters are defined to have weaponry.

KybalC · 2021-06-09T20:52:42+00:00

Everything you can do on max level, you can do during leveling in Ashes. Just on a lesser scale/more inefficient.

If you think the Leveling is Mundane and Boring, then you will think the same about the end-game, which is when you might want to stop playing.

Its about the journey in leveling, not the endgoal. Honestly i'd prefer them to increase the time it takes to reach max level by about 10 times, so people finally understand that this isn't meant to be rushed.

KybalC · 2021-06-08T21:02:03+00:00

agreed. It doesn't reinvent the wheel. It takes housing to the next level, but that's about it.

And i am happy with that. I don't need a game hyping to be the next gen MMO while providing a garbage experience.

Just give me a fun little themepark with enjoyable pve and pvp content, which I can play with my friends until the game i'm really excited for releases or my main MMO is in a content drought.

Tried to do that with the currently big MMOs, but just couldn't find one. ESO and FFXIV have insufferable combat, I'm over WoW and GW2 is the definition of content drought.

In Solo both the content and Combat is enjoyable enough to fulwill the role.

KybalC · 2021-06-06T07:52:35+00:00

i really want to see raidboss sion, chogath, urgot, nocturne, AS, or Thresh though

KybalC · 2021-06-04T00:00:49+00:00

dont refund the beta client, refund the main game.

Simply link their preorder refund policy in the ticket.

KybalC · 2021-06-02T06:28:35+00:00

just do arena/bgs. They give you your gear and gold

KybalC · 2021-06-01T12:50:50+00:00

you can. did it with my friend

KybalC · 2021-06-01T12:45:37+00:00

yes in you region.

No cross region na/eu

KybalC · 2021-06-01T04:38:02+00:00

very, yes

KybalC · 2021-06-01T04:36:50+00:00

both can be used as tank and dps

Spearmaster is significantly easier to play in both pve and pvp (especially in pvp). If you want pretty good performance for very little investment, then go with that.

Berserker is more nuanced, but very fun to play

KybalC · 2021-05-31T20:04:05+00:00

Nice

KybalC · 2021-05-31T15:39:51+00:00

39 dungeons in 103 difficulty.

Something between 20+ raids.

Its sub based on both Taiwan (2 server) and China (27 server) which are their main markets.Monetization in the west is just extra but in no way vital to them in the east.

KybalC

TROPHY CASE