sâmbătă, 19 ianuarie 2013

Excel Statistics for SEO and Data Analysis


Everybody has probably already realized that there is almost no data that we cannot get. We can get data about our website by using free tools, but we also spend tons of money on paid tools to get even more. Analyzing the competition is just as easy, competitive intelligence tools are everywhere, we often use Compete or Hitwise. Opens Site Explorer is great for getting more data about our and competitors backlink profile. No matter what information we are trying to get, we can, by spending fortunes or no money. My favorite part is that almost every tool has one common feature and that is the "Export" button. This is the most powerful feature of all these tools because by exporting the data into Excel and we can sort it, filter it and model it in any way we want. Most of us use Excel on the regular basis, we are familiar with the basic functions but Excel can do way more than that. In the following article I will try to present the most common statistical techniques and the best part it is that we don't have to memorize complicated statistical equations, it's everything built into Excel!
Statistics is all about collecting, analyzing and interpreting data. It comes very handy when decision making faces uncertainty. By using statistics, we can overcome these situations and generate actionable analysis.
Statistics is divided into two major branches, descriptive and inferential.




Semantic Web and Link Building without Links > The Future for SEO?

Rand’s recent WBF about co occurrence was a real wake up call for those still transfixed with link building practices of old. While anchor text based links may still have some effect there is little arguing the fact that the factor’s importance is dwindling. In its place are things like social signals, link age and most importantly a growing reliance on relevancy and how that is deciphered.

For those that haven’t read it yet, I wrote a piece a few weeks ago about what I felt recent Google penalties are really trying to solve. My view is that Google is really trying to clear up the link graph and with it valueless links so that it can clearly understand relevance and associations again.

It’s something that web ‘creator’ Tim Berners Lee first wrote about back in 2006 in this magazine article and Google has been talking about ever since, ploughing lots of cash into acquisitions to get it there.

So, why invest so much time, effort a resource into such a game-changing project? Quite simply because its existing keyword based info retrieval model is in danger of being bettered by semantic search engines.

To understand why this is the case we must first delve into semantics and why it changes the way search engines work.

http://www.seocompany21.com/seo-prices/

www.seocompany21.com/los-angeles-seo

Source : http://www.seomoz.org/blog/semantic-web-and-link-building-without-links-the-future-for-seo