stats

How can I access the sitemap stats from webmaster tools from a script?

When you are on the Sitemaps page of Google Webmaster tools (i.e. https://www.google.com/webmasters/tools/sitemap-list?hl=en&siteUrl=http://yoursite.com/) you will see something like: Sitemap stats Total URLs: 10 Indexed URLs: 5 Is there a way to access these numbers using an API? ...

How can I check the last time stats was run on Oracle without using OEM

I want to check the last time stats was run on my Oracle 10g server. I would normally do this via OEM, but for unrelated reasons OEM is down. Is there some way I can check this using just sqlplus? It would be extra helpful if the output was reasonably formatted. ...

Good open source analytics/stats software in PHP?

The url shortening service I'm building needs to display some basic click stats to users: # of clicks, conversions, referring domains, and country (filterable by a date range). I'll possibly want more advanced stats in the future. Is there existing open source software that will allow me to pass events to it and then easily display a ba...

Google Analytics - async tracking with two accounts

I'm currently testing GAs new async code snippet using two different tracking codes on the same page; _gaq.push( ['_setAccount', 'UA-XXXXXXXX-1'], ['_trackPageview'], ['b._setAccount', 'UA-XXXXXXXX-2'], ['b._trackPageview'] ); Although both codes work, I've noticed that they present inconsistent results. Now, we aren'...

In R, How to add Row for Information:

Hi, I'm trying to add a Row to my data.frame to spit out the average of the column. This is my data frame: Weight Response 1 Control 59 0.0 2 Treatment 90 0.8 3 Treatment 47 0.1 4 Treamment 106 0.1 5 Control 85 0.7 6 Treatment 73 0.6 7 Control 61 0.2 I...

Statistics of IMAP vs POP vs Exchange ?

Hello, I'm desperately looking for some statistics about usage of POP versus IMAP versus Exchange-MAPI, especially in professional context. I know IMAP is used for accessing mails from mobile devices with limited bandwidth, whereas POP is the good old standard, and Exchange is more business-oriented. Does someone know the approximate pe...

ANCOVA in Python with Scipy/Numpy stats

I would like to know a way of performing ANCOVA(analysis of covariance) using Python with scipy. It is basically a statistical comparison of regression lines. I know Python can do ANOVA and it can also do regression line fitting with Scipy.stats. I'm not sure how to put those together to get an effective ANCOVA though, if it is possible....

Detecting abuse for post rating system

I am using a wordpress plugin called "GD Star Rating" to allow my users to vote on stories that I post to one of my websites. http://everydayfiction.com/ Recently we have been having a lot of abuse of the system. Stories that have obviously been voted up artificially. "GD Star Rating" creates some detailed logs when a user votes on a sto...

How to convert a z score to a percentage in Perl

Seems like in Perl this should be easy or a module, but I have not found an easy answer yet. I have a calculated z normal score and the mean, but have not found an easy method to calculate the percentage. The solutions I have found are for looking it up using a statistics table, but it seems like something that common would have a modul...

iphone ios4 stats

Hello Does anybody know where can stats for ios be found? Percents of use for iOS4, iOS3 including per device/os version e.g. how many users have ios4 on iphone 3g, 3gs thank you ...

Grouping by X days

Hey, I have a database that shows me different stats about different campaigns, each row has a timestemp value name "date". I wrote the code for choosing and summerizing a range of dates, for example: 21-24/07/2010. Now I need to add an option to choose a range of dates, but also to group the stats for each X days. Let's say the user...

Track incoming Referring site via link in PDF file?

I have recently placed an ad in a weekly publication that sends out a PDF file. My ad is directly linked so that the reader can click on it and go to my website. The PDF file is hosted on a different server, but is, in fact, a PDF file that has to be downloaded and viewed on that site, not emailed or shared that way. I have Google Ana...

Possibly inconsistent behavior in qplot() ??

I'm trying to use qplot() to plot a simple time series as one might do using plot(). The x variable is as.POSIXlt and the y is just some continuous measurement. Here is the code with some brief comments. Any help on why these data.frames behave differently would be very much appreciated. As you can see below, I can work around the pr...

How do I find out a server's load?

Hi, I'm creating a php script that will capture certain information from the server and database at regular intervals. The server is running LAMP. Is there a way to output the server load, or other statistics that may indicate the performance or load on the server including mysql? Thanks :) ...

PHP and MySQL stats system.

What is the best database model to store user visits and count unique users using the IP in a big database with 1.000.000 rows for example? SELECT COUNT(DISTINCT ip) FROM visits But with 1.000.000 diferent ip's it can be a slow query. Caching will not return the real number. How big stats systems counts uniques visits? ...

MySQL group integer column into groups of 100

I have a MySQL table and I am looking to create a stats page on the data. Id (integer), Pri (integer), blab1, blab2, blab3, ect... The "pri" field has a number between 0-1000. I would like to how the rows are spread across the pri in the table. I am looking for a way to group the "pri" by 100s and count the number of rows in each gro...

For a stats systems what's better in MySQL: InnoDB, Archive or MyISAM?

I want to store all accesses to a webpage with user-agent, script-execution-time, request-uri, full referer and some more variables. What I have been doing is use normalized MyISAM tables like: stats stats_user_agents stats_referers stats_requested_uris But in a normal webpage this takes some SELECT's and 1 INSERT. It's better use A...

measuring unix machine responsiveness

I am one of the n users of a shared unix machine. For reasons unknown, the machine is not "responsive" enough. For example, it is slow on interactive commands, it takes few noticeable moments for any action (e.g. mouse movement, editor (e.g. gvim) keystrokes) to be visible. The problem is, the people supposedly responsible for addressing...

Python - Most efficient way to find how often each possible pair of words occurs in the same line in a text file?

Hi all, This particular problem is easy to solve, but I'm not so sure that the solution I'd arrive at would be computationally efficient. So I'm asking the experts! What would be the best way to go through a large file, collecting stats (for the entire file) on how often two words occur in the same line? For instance, if the text cont...

using R programming in java

We are working on a complex statistical project on java. The original code we did it in R programming language http://en.wikipedia.org/wiki/R_%28programming_language%29 is there a way to convert this code in java code (converter) or otherwise how can we use R in a java project ...