Recent Client Projects | Our Areas of Expertise

Click on the categories below to learn more about some of our recent client projects.

Demand Forecasting

Forecasting Demand for Airline Tickets at Varying Price Levels

(2010,  Revenue Management Systems, Inc )

Assessed different statistical models for their accuracy in predicting demand for airline tickets of different prices based on the number of days before the flight.

Statistical Models Used for Forecasting: Exponential Smoothing, ARIMA at Wikipedia

Assessment Measures for the Models: MAPE, SMAPE, MASE (Make these links Wikipedia)

Forecasting Call Center Call Volume

(2005, T-Mobile)

Built a set of SAS macros to input data from many sources, clean and combine the data, generate data reports, and generate forecasts for call volume by date, time of day, and holidays. Assessed the accuracy of different statistical models for these forecasts.

Statistical Models Used: Exponential Smoothing, ARIMA, Multivariate ARIMA

Assessment Measures for the Models: MAPE, SMAPE

Estimating the Impact of an Initiative

Estimating the Effect of OSHA Inspections on Compensation Claims

(2011, Oregon  Department of Consumer and Business Services)

Determined the effectiveness of OSHA inspections on reducing workers’ compensation  claims.

Statistical Models Used: Poisson Regression, Negative Binomial Regression,

Zero-Inflated Poisson Regression, Zero-Inflated Negative Binomial Regression

Estimating the Impact of a Visa Incentive Network Campaign

(2008, Visa)

Performed several statistical analyses to determine whether or not a highly-targeted direct marketing program to high-spending customers significantly increased the average spending per account and the average number of transactions per account.

Statistical Models Used: Fisher’s exact test, t-test, and Pearson’s Chi-squared test.

Estimating the Impact of New Automated Systems on Call Volume

(2005, T-Mobile)

Created a data repository for call center data to analyze the impact of new initiatives on call center demand. These new initiatives included text messaging for bill paying and speech recognition software to answer caller questions without involving a customer service representative.

Statistical Models Used: Multivariate ARIMA

Estimating the Size of Something

Estimating Disease Rates for Sparsely Populated Regions

(2010, Looking Glass Analytics)

Used advanced statistical techniques (Empirical Bayesian methods) to estimate the incidence rates of various diseases in sparsely-populated regions of Washington State.

Statistical Models Used: Empirical Bayesian methods 

Calculating Age-Adjusted Incidence Rates for Diseases

(2009, Looking Glass Analytics)

Derived formulas for computing age-adjusted incidence rates for various diseases and other conditions. Wrote code for implementing those formulas in a SAS macro.

Statistical Models Used: Binomial, Poisson and Chi-squared distributions.

Determining the Size of Event Ticket Aftermarket

(2008, QL2 Software)

Estimated the aftermarket (reselling/scalping) sales of tickets for various venue events, based on online prices listed on various websites. Developed a data-gathering algorithm to aggregate data from different sources and assess their quality.

Visualizing Trends in the Data

An Exploratory Analysis of User Behavior with Web Ads

(2010, Fabric Worldwide)

Produced graphs of click-through rates on various ads over time and used those graphs, along with a specialized algorithm, to create working hypotheses of where users were coming from for different times of day and days of the week--and to try to predict where they might come from in the future.

Statistical Models Used: Logistic regression

Market Basket Analysis

(2010, Intel)

Developed an algorithm for determining what items were bought together using an industry-standard method for computing the correlations between pairs of items.

Automating Excel Processes

Weekly Updating of an Interest Rate Database

(2007, Washington Mutual)

Used SAS to create an automated process for transferring and consolidating interest rate data from multiple Excel spreadsheets in different formats into a single internal database. 

Generating Monthly Loan Portfolio Reports in Excel

(2007, Washington Mutual)

Used SAS to create an automated process for inputting data from several different files and data formats into multiple customized Excel spreadsheets that produced graphical summaries of monthly loan portfolio data.

Upcoming Conferences

Stakana will be attending the following conferences:

 

IFSUG
Cary, NC, March 4-6, 2012

SAS Global Forum
Orlando, FL, Apr 22-25, 2012

exportToXL

Export data from SAS to Excel

Support Forum—Coming Soon
Documentation—Coming Soon

download-exporttoxlDownload
exportToXL

 

exportToXL DownloadBefore you download exportToXL...

The current version of exportToXL only works with Excel 2000 and Excel 2003. We are currently upgrading exportToXL to work with Excel 2007 and Excel 2010. 

If you'd like to be notified when the new version is available, Contact Us.

Click here to download exportToXL .

SAS Partner

statistical-analysis-solutions partner

Stakana Analytics is a SAS Partner

Testimonials

T-Mobile

We had data stored in various separate locations. Nate Derby, founder of Stakana designed and implemented a...

Read more...
Oregon CBS

We approached Stakana to solve a statistical modeling problem that we didn’t have the internal expertise to tackle....

Read more...