Subscribe to DSC Newsletter

All Blog Posts Tagged 'excel' (5)

Conditional Formatting in Excel – Highest Number in Each Row

Conditionally formatting each row individually is an issue that I struggled with for some time and finally found an answer.  I have a table that lists 28 different activities by day of the week.  On the report I need to highlight the day with the highest count per activity.

The solution is to essentially conditionally format each row to highlight the highest number.  But who wants to take time formatting 28 rows?  Plus, there are several other cities to analyze.  So it’s…

Continue

Added by Nicole on September 5, 2013 at 5:29am — No Comments

DropQuery - A project from AngelHack Sydney, love to hear some feedback.

I attendedAngelHack Sydney recently during the month of May.

AngelHack is a hackathon where developers and entrepreneurs come together to prototype a viable business idea within 24 hours.

The project that I worked on was called "DropQuery". The basic concept is this.

* You have some data files - CSV, XLS, XML

* You want to quickly query it.

I talked to a few people at the…

Continue

Added by Eric Bae on June 6, 2013 at 6:28pm — No Comments

SAS Enterprise Guide: Import Odd Spreadsheet Data

Perhaps you took my advise a few weeks back and took advantage of the amazing (trumps blare!) SAS Enterprise Guide ability to import MS Excel spreadsheets.  However, if your spreadsheet is a little different – then you may run into some issue when you go to import it.  For instance, look at this…

Continue

Added by Tricia Aanderud on May 30, 2012 at 3:27pm — No Comments

Sophisticated time series analysis in Excel with Inference for R

Inference for R places the power of R statistical analysis software inside the productivity rich environment of MS Office. With Inference for R you can combine R code, data, and text in Excel, Word, and PowerPoint documents to create reports and deploy analysis solutions.





While Excel spreadsheets are an excellent tool for simple analysis, they are ill suited for performing complex analysis… Continue

Added by Ben Hinchliffe on May 26, 2009 at 7:30am — No Comments

New Inference for R update

We’re pleased to announce a new update (Version 3.0.2) to Inference for R. This update includes the following:



• Support for R 2.9

• Support for running Inference for R on 64-bit (x64) versions of Windows XP and Windows Vista



If you're a user of R 2.9 or 64-bit Windows, you should download a new version today. We’re offering extended trial license keys to anyone who would like to try this updated version. You may request an… Continue

Added by Ben Hinchliffe on May 22, 2009 at 11:37am — No Comments

Monthly Archives

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

On Data Science Central

© 2019   AnalyticBridge.com is a subsidiary and dedicated channel of Data Science Central LLC   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service