The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
75 views

What's the best (Google chart) visualisation for displaying sparse timeline data across thousands of “columns”

I am trying to visualise a sparse dataset but am finding it hard to fit it into the standard categories of charts. I'm a developer building with Google Charts and I really want to stick with that ...
0
votes
1answer
94 views

De-normalizing Google Trends data?

Does anybody have suggestions on how to de-normalize Google Trends data? The site says that their trends are made with the following metric: The numbers on the graph reflect how many searches ...
1
vote
1answer
598 views

An Alternative to the tdist() Function in Excel for Google Spreadsheets?

I'm using Google Docs for a statistics class and my instructor suggested we use the "tdist()" function in Excel. http://office.microsoft.com/en-us/excel-help/tdist-HP005209312.aspx I can't find ...
0
votes
1answer
806 views

Equivalent of Google spreadsheet's arrayformula in Excel [closed]

Input 1 0 7 77 6 66 Expected Output 7 66 Solution in Google Spreadsheet ...
1
vote
2answers
1k views

How do calculate Present Value in Google Spreadsheet?

Let say I have this kind of data: 1 01/1/1980 2 01/2/1999 3 03/12/2000 -1 03/6/2005 -5 07/07/2007 how can I calculate the Present Value (PV) to them in respect ...