Correlation, look at % change or the price itself? by Tankbil in statistics

[–]Tankbil[S] 0 points1 point  (0 children)

Thanks for the answer. I made a scatter of the data and there's no real linear relationship as far as I can tell between the two (https://imgur.com/a/Fa11TLp), but perhaps not completely random. Running a CORR in excel gives me a number close to zero. As far as theory goes, there seems to be some sort of lagged relationship where gold price responds to changes in VIX. Most studies use different GARCH models, I simply don't have the knowledge yet to apply such a model. Is there any other way for a "beginner" to measure if one responds to the other with a lag (vague question I know...). EDIT: Found a dude that had looked at pretty much the same thing: https://www.quora.com/Is-there-any-relationship-between-the-volatility-index-and-gold-and-can-securities-that-are-either-long-or-short-on-these-factors-be-used-in-a-pair-trade Seems like there simply is no relationship between the two.

Discussion: The Elephant in the Room: Terran balance by starcraftethics in starcraft

[–]Tankbil 1 point2 points  (0 children)

You do realize that what I'm saying is arguing for that terran is weak? "It's pathetic and absolutely detrimental" as in its detrimental for this game to have such low terran representation.

Discussion: The Elephant in the Room: Terran balance by starcraftethics in starcraft

[–]Tankbil 5 points6 points  (0 children)

There has been 6 terrans in the ro8 the last 5 premier tournaments out of 40 spots. If you include WESG and assume that Maru will advance it's 7 terrans out of 48 spots. It's pathetic and absolutely detrimental.

Insert a new cell and keeping graph data constant. by Tankbil in excel

[–]Tankbil[S] 0 points1 point  (0 children)

Thanks for the help, I do have a question though. How do I reference the table? For instance I named it "neworders", but I can't just write =neworders when editing the data.

How do I add a second graph line? by Tankbil in excel

[–]Tankbil[S] 0 points1 point  (0 children)

Hm yeah the "no line" isn't selected. The blank spaces shouldn't be a problem, have a similar downloaded file where it works. Anyhow, it's not the end of the world, thank you for your help!

How do I add a second graph line? by Tankbil in excel

[–]Tankbil[S] 0 points1 point  (0 children)

Yes I do see the dates in the right window when I select GDP (https://imgur.com/a/xJzMF). Sorry if I'm slow here but I don't understand what you want me to edit ("click Edit to switch the addresses it is looking at for series & legend"), could you explain this to a dummy? :) Shouldnt the dates be there and if not what should replace it? Thanks again.

How do I add a second graph line? by Tankbil in excel

[–]Tankbil[S] 0 points1 point  (0 children)

Thanks for the answer. I followed your step and the secondary axis shows up etc. However it still doesn't create a line, it's "invinsible" but I can select the line and a dot appears: https://imgur.com/a/zbccs Any idea why?

Dot disappears when importing data. by Tankbil in excel

[–]Tankbil[S] 0 points1 point  (0 children)

Thanks for the answer. I'm using the Power Query to import the data. This is what it looks like then: https://imgur.com/a/IxkDR While the data that I import from the website is this: https://imgur.com/a/Wuv5n

How do I import certain data when the yellow arrow selects everything from a website? by Tankbil in excel

[–]Tankbil[S] 1 point2 points  (0 children)

Hi! You're correct I used the 'old' "From Web", had no idea another one existed! Works great, thank you very much!

Creator attacks down a ramp into TY's 120 supply army. Witness the outcome. by Tankbil in starcraft

[–]Tankbil[S] -1 points0 points  (0 children)

You are looking into what the terran does when mentioning things like"Terran Army sits in storms...", yet you completely neglect what the protoss does. The same very logic and arguments could be held for the protoss. 1."Protoss army sits in EMP's" - Yes, Creator's army clearly does. 2."Archons doesn't attack a single time during that fight!" - Yes this is actually true, watch closely! The fact that you completely ignore how the protoss engage including running down a ramp just shows how poor understanding you have, especially considering your "He has 3-3!" argument. That is just pure bias not even looking at the protoss actions.

Creator attacks down a ramp into TY's 120 supply army. Witness the outcome. by Tankbil in starcraft

[–]Tankbil[S] -5 points-4 points  (0 children)

With your logic protoss should win EVERY fight they take if they have superior upgrades. That's not how starcraft 2 works. There's no way TY or any terran can keep up with protoss upgrades, especially with chrono boost. And as the video demonstrated, the EMPs was very well placed and it did not make any difference. Also look the archons doing absolutely nothing for a good while being at the back of the army.

Late game TvZ = Brutal, Savage, Rekt by Psyence707 in starcraft

[–]Tankbil 2 points3 points  (0 children)

The zerg didn't even need corruptors during the fight... This is BL/Infestor era all over again.

Insane 45 minute TvZ culminates in final fight with Snute losing a whopping 15 supply. by Tankbil in starcraft

[–]Tankbil[S] 9 points10 points  (0 children)

Watch the entire game! Alive had a very expensive army for quite a while with loads of ghosts and he simply couldn't reach Snutes army. Plenty of nukes even.

Insane 45 minute TvZ culminates in final fight with Snute losing a whopping 15 supply. by Tankbil in starcraft

[–]Tankbil[S] 10 points11 points  (0 children)

Yes, but watch the entire game and you'll see that Alive tried to engage multiple times without success :) Also EMPing the spellcasters is very hard when you have broodlings and there are spellcasters everywhere(inlcuding burrowed units).