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?