Tagged Questions

The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
20 views

How can I grab specific data points from one spreadsheet based on another spreadsheet? [closed]

I am a journalist currently trying to crunch some data for a story I'm writing about Maine's craft beer industry. I have been given two spreadsheets related to beer production from the state, and ...
1
vote
1answer
457 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
612 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 ...