1261 search results for "excel"

Loading SPSS (.sav) into Stata

October 11, 2012
By

Most statistical softwares nowadays are able to convert their files to a wide range of other packages. Perhaps it is the reason for the discontinuity of old converter bundles like SAS Transport and DBMS. Interesting, however, Stata, a quite popular statistical package, still lack built-in support for exporting and importing files among concurrent softwares like

Read more »

Cyber Summit 2012: a bit of big data and a lot of small tweets

October 7, 2012
By
Cyber Summit 2012: a bit of big data and a lot of small tweets

Last week (October 1-3) MPK Analytics attended the annual Cyber Summit in Banff. The theme for this year was; “Leading the Way in the Age of Big Data“. As might

Read more »

Style your R charts like the Economist, Tableau … or XKCD

October 5, 2012
By
Style your R charts like the Economist, Tableau … or XKCD

As we noted last month, the new Themes feature in ggplot2 helps you customize the design of R charts to your liking. Now, R user Jeffrey Arnold has built on this feature to create standardized themes to make R graphics looks like those from major publications and other software systems. You can use his ggthemes package to make your...

Read more »

Tips on accessing data from various sources with R

October 3, 2012
By

Jeffrey Breen (the man behind the Twitter airline sentiment analysis example) recently posted a collection of slides with some great tips for accessing data from R. "Tapping the Data Deluge" includes information on: Using the XLConnect package to read data from Excel spreadsheets Using the foreign package to read SPSS, SAS, Stata and dBase data files Using SQL queries...

Read more »

Working with Bipartite/Affiliation Network Data in R

September 30, 2012
By
Working with Bipartite/Affiliation Network Data in R

Data can often be usefully conceptualized in terms affiliations between people (or other key data entities). It might be useful analyze common group membership, common purchasing decisions, or common patterns of behavior. This post introduces bipartite/affiliation network data and provides … Continue reading →

Read more »

Football, an ordinal model

September 30, 2012
By
Football, an ordinal model

On September 19th, flo2speak remarked under a post that his/her experience is that ordinal models had better performance. That seems reason enough to try, so there we are. In examining this type of model it is found that more complex models can be...

Read more »

Modifying select off-diagonal items in a matrix

September 25, 2012
By

This is something I have had the occasion to do, and never remember how, so this is legitimately a reminder to my future self of how to do things with off-diagonal elements of a matrix. Select rows and columns are easy: mat or mat, for...

Read more »

Transition probabilities when adjacent sequence items must be different

September 24, 2012
By

Generating a random sequence from a fixed set of items is a common requirement, e.g., given the items A, B and C we might generate the sequence BACABCCBABC. Often the randomness is tempered by requirements such as each item having each item appear a given number of times in a sequence of a given length,

Read more »

Federal Register API/R Package Ideas?

September 21, 2012
By

The other day Critical Juncture put up an API for the Federal Register. I thought it would be great if there was a package that could use this API to download data directly into R (much like the excellent WDI package). This would make it easier to anal...

Read more »

Technical Analysis of Montana Voter Registration Files

September 18, 2012
By
Technical Analysis of Montana Voter Registration Files

By Earl F Glynn | Franklin Center This article shows how to analyze Montana voter registration files using R. The Montana Secretary of State sells two files of voter registration records for a fee of $1000: Statewide Voter File Voter History File The Montana Secretary of State provides information about the two files on this

Read more »