What's the best way to setup a MacBook Pro so that it can be regularly hooked up to an iPhone's Personal Hotspot without unexpected background processes (Dropbox, iTunes Match, auto OS or app updates, etc) resulting in massive data charges? [more inside]
posted by puffmoike
on Dec 17, 2013 -
Glorious SO and I plan to buy a home in the next 18-30 months. I'd like to line up all the best tools, maps, and data to keep track of homes we've seen, neighborhoods and towns we'd consider, flood maps, commute times, train lines--really anything and everything that could inform this decision. Yes, yes, friends, colleagues and a good agent are great resources--but we want tools
at this point! [more inside]
posted by Admiral Haddock
on Dec 16, 2013 -
What are some potential career paths for someone who loves doing data analysis? What can I be doing right now to build my skills and experience? [more inside]
posted by capricorn
on Dec 4, 2013 -
I will be visiting toronto during christmas/new years and would like to have a prepaid data plan. What is the cheapest/best carrier for data sim while in toronto. Minutes matter less since i will be using phone primarily as directions, trip advisor etc .
similar to this question but reversed
Samsung galaxy s3 tmobile lte version phone if that matters.
Also great places to go in toronto during later christmas/new years timeframe is also helpful
posted by radsqd
on Dec 2, 2013 -
I'm going to be travelling to India soon and I wanted to get a prepaid cellular connection for my iPhone to avoid roaming charges and for internet access.
What's the cheapest/best prepaid connection in India (going to be travelling around South India)? Is there some way I can buy it in the US so I can have cellular access from when I immediately arrive? [more inside]
posted by touareg
on Dec 1, 2013 -
How do I use SPSS to analyze a range of approval ratings which vary by participant and correlate the skew to one demographic variable? [more inside]
posted by lettuchi
on Nov 25, 2013 -
I'm interested in joining the UK personal genome project (PGP)
, as I like big science and think that the project looks interesting and has some admirable aims. However, I'm not so sure about having my genetic information freely available on the internet, and I don't fully understand what the risks of this could be. I found this article on the gurdian
, but any more information, resources or advice would be appreciated. Thanks.
posted by Ned G
on Nov 13, 2013 -
I don't know where I should be looking in order to search for a job. (Peculiar Einstein-Bose Condensate details inside) [more inside]
posted by Hactar
on Nov 1, 2013 -
What can I do to become a database administrator or developer if I'm starting basically from zero? [more inside]
posted by anonymous
on Oct 28, 2013 -
I'm looking to gather data on the top selling laptop and desktop models for each year (preferably over the past 20 years and with total units sold each year in U.S. and in world). Does anyone know of a source or would be able to point me in the direction of one? Is there an industry newsletter? Ideally, I want something like "2003's Top 10 Bestselling Laptops: 1) Gateway 450: X million sold; 2) Dell Inspiron 8500: x million sold" etc, but I'm not too picky, any leads would be better than what I got now.
posted by jng
on Oct 25, 2013 -
I have a table of data that I need to average, but I need to come up with averages using multiple different rows. For example average A=row 1, row 2, row 4: Average B= row 1, row 2, row 3: Average C= row 2, row 3. I would like to add a column that has the names of each average I need, (A, B, C) and then let excel average them based on which set they belong to. I have been looking around at other excel related forums, but I am not sure what this process is called, so I don't know how to find it. Right now I have been copying rows for each time they show up in a set I need averaged. It would be nicer to have column that says, this row belongs to set A and C, next one belongs to set A, B, and C.
posted by djpuddings
on Oct 24, 2013 -
I want to measure and test things in my life (home, car, etc.) for maximum efficiency, thrift, and measuration, which is a word I just made up to combine measurements and data wankery. What measurements can I make and what fun tools do I need to buy? [more inside]
posted by Admiral Haddock
on Oct 23, 2013 -
My beloved 60GB "Fat" PS3 has kicked, after many years of faithful service. I'm trying to figure out how to replace it with minimal hassle and without losing anything from the hard drive. Google search turns up conflicting advice. Long-ish explanation follows. [more inside]
posted by churl
on Oct 7, 2013 -
In advance of the World Cup, I plan on writing an op-ed that would benefit from emigration/immigration data. [more inside]
posted by lhtw90
on Oct 4, 2013 -
I'd really like to write a paper exploring the macroeconomic effects of the Iran sanctions for a grad-level class, which requires some analysis of raw data. However, official data sources are obviously unreliable and I'm not having much luck finding unbiased unofficial data, gah. Does anyone have any ideas of potential data sources?
I have access to a good academic library.
posted by superquail
on Oct 2, 2013 -
Near where I live in Boston, there is a dangerous road, and a particularly dangerous intersection. I'd like to take action to have someone take steps to remediate it. Can you recommend specific resources and data to use to make the most compelling call to action? [more inside]
posted by Admiral Haddock
on Sep 27, 2013 -
I have a Samsung Galaxy for TMobile, with a fixed dataplan. Two months ago, my phone began burning through data. Can you help me figure out why? [more inside]
posted by vignettist
on Sep 25, 2013 -
Way back in 2008, I started logging my son's milestones and growth on totspot.com, which mysterious closed earlier this year. (Here's
their defunct Facebook page).
I'd like to get that information back. How does one effectively contact a dead website?
posted by k8t
on Sep 15, 2013 -
I live in Spain and travel regularly to London. I have a Sony Xperia Arc S which I unlocked when I changed mobile companies. It works fine here in Spain for voice and data.
HOWEVER, when I go to London, voice works fine but I cannot get data to work. [more inside]
posted by BigBrownBear
on Sep 14, 2013 -
A friend is visiting from Brazil and is bringing his iphone 4s with him. He wants to use it while he's here. What's the least painful way to make that happen? [more inside]
posted by msali
on Sep 10, 2013 -
I currently work for a growing company doing various social media marketing for small businesses. I have been finding that I receive a lot of satisfaction doing activities related to what I learned in library school. I enjoy collecting, organizing, and providing data and information for our internal staff and making things approachable. One weakness I see is that we are especially data rich and insight poor with social media. I would like to know if there are any recommended programs for data mining or statistical analysis? [more inside]
posted by andendau
on Sep 8, 2013 -
I want to create a form with Open Office that lets me enter numbers in the right column of a page that corresponds to the text in the left. I want to be able to past the entire text document into the right column and have the left column remain blank for my entries. A spreadsheet won't work because the text won't word wrap. I've also tried a table and inserting a column into a text document. I've also tried to write in the margin, but I'll be moving a lot of documents, so I don't want to do a lot of specific typing, which would likely be spread across thousands of pages of documents. I'd like to automate and past as much of this as possible. Think of how books of poetry or philosophy number each line of corresponding text, making it easy to find a specific verse. That's the form I want to create. Or if it has already been created and exists somewhere, I'd gladly download it. Help.
posted by CollectiveMind
on Aug 29, 2013 -
I have been looking at Chartbuilder
as a means to generate chart images for clients. We make them a video and instream advertise it. We report monthly impressions and views of the video. What would be the best way to present this data? [more inside]
posted by andendau
on Aug 24, 2013 -
I'm very interested in TrueCrypt
, and am experimenting with moving some of my files (especially stuff I keep in my Dropbox) into TrueCrypt containers. But there's one possible scenario that concerns me, and about which I can't find any solid information -- not on TrueCrypt's site, not via Google, and not here on the green: What happens to my newly generated data if my computer crashes before the TrueCrypt volume I'm working in is dismounted? [more inside]
posted by Artifice_Eternity
on Aug 17, 2013 -
Will editing a photo in a program like Photoshop destroy the original EXIF data from that photo? If I cut and pasted part of a photo and saved it as "NEW" what would the EXIF data of that "NEW" photo show? [more inside]
posted by BillyAnne
on Aug 14, 2013 -
On average, or an educated guess, how much energy does it take to store a terabyte of data? I don't mean how much does storage cost. I want to know what the environmental impact of a terabyte of data. [more inside]
posted by Nanukthedog
on Aug 9, 2013 -
I purchased a Spanish Vodafone sim card for use while on vacation and have successfully added credit (20 EUR) and then activated the Smart16 tariff which includes 1.5GB of data. How do I know how much of this is left? [more inside]
posted by samworm
on Aug 5, 2013 -
I'm looking for the easiest way to find data about "how big" various industries are, by revenue. For instance, when you hear a reporter say, "Video games are a $X billion a year business," where are they getting that information? I've poked around the census bureau's website and found their various reports, but it doesn't seem to be that granular (or easy to read, for that matter). I'm trying to create as diverse a list as possible, of various non-related industries (banking, retail, trade shows, sporting events, hotel, video games, Hollywood, pest control, you name it - virtually any business that is its own discrete thing) and how they stack up relative to one another in terms of the dollar-figure size.
posted by jbickers
on Aug 2, 2013 -
Where/how can I find comprehensive military deployment statistics going back to the Civil War? [more inside]
posted by clockzero
on Jul 23, 2013 -
I have an unlocked iPhone 5 with Verizon. (It is verifiably unlocked for foreign SIM card use -- and yes, even though it is Verizon it does have GSM as well as CDMA). I'm looking for advice on how to travel with it to four countries, with the ability to receive/send calls and texts. I'd like to buy and use one SIM card only. And I want to be sure that I don't use any data, which gets expensive.
So the question boils down to:
(1) Keep the iPhone or ditch it for my unlocked travel phone?
(2) Use the Verizon international plan, or buy an offering from Telestial, Global, etc.?
More inside. [more inside]
posted by bchaplin
on Jul 21, 2013 -
I’m finally signing up for an unlimited Crashplan package this weekend. This is my first time using web storage for any of my backup needs. Can you let me know if I’m thinking correctly about 1) what I back up online and 2) what makes sense for backing up in the future? [more inside]
posted by Admiral Haddock
on Jul 19, 2013 -
I am a science teacher creating a professional development workshop for other science teachers. The topic is along the lines of "getting real scientific data and measurements from the web for your students to work with"
. The goal is to find "real" scientific data from the world beyond the classroom, that might make for more compelling classroom activities and investigations in high school and middle school science classes, such as biology/ecology, earth sciences, astronomy, physics, chemistry, etc. The data can be in the form of videos or images to be measured and analyzed, or raw numbers to crunch, or whatever. The data needs to be freely available on the web. Examples inside... [more inside]
posted by chr1sb0y
on Jul 8, 2013 -
I have a list of 625 English words, translations in a bunch of languages, and what-not in a giant excel file. We'll call that excel file "the Data." The Data is in alphabetical order. I also have a separate list of those same English words in a different order. Is there a way to sort the Data so that it's in the same order as my new, non-alphabetical list? [more inside]
posted by sdis
on Jul 7, 2013 -
I'm going to be traveling in Europe for 3 weeks, which PAYG SIM plan should I get for my unlocked iPhone 4? [more inside]
posted by Joh
on Jul 3, 2013 -
I'm taking a 10 day driving trip from Atlanta to Cooperstown (and back) in about two weeks. I want to be able to connect multiple devices, so a hotspot is needed. Where is the sweet spot in terms of initial investment, bandwidth allowance and data rate with no contract?
posted by donpardo
on Jun 28, 2013 -
Have an LTE Verizon iPad 3. Want to be able to discontinue data plan during months when I don't need it but easily reconnect if I am traveling etc. Was able to do this in the past (with ATT on an earlier iPad) but now seems only way is to cancel which may require complex dealings with Verizon to reestablish LTE sim.
Easy on and off was the attraction for getting a Verizon in the first place - now they seem to have changed policy without any warning.
posted by jjcurtis
on Jun 26, 2013 -
Are there ways to "cross" or "join" data results in Google Analytics? Just as a for instance, I have a list of Referrals and a list of audience Location demographics. Is there a way to join those two lists, so that I know where site referrals are visiting from? (Generally, are there resources which list "pro tips" for getting the most out of Analytics?)
posted by Blazecock Pileon
on Jun 18, 2013 -
I'm using my first smartphone ever -- a secondhand iPhone 4 - on a prepaid plan. I generally leave cellular data turned off because most of my day is spent in range of WiFi, and because data transmission on my otherwise cheap prepaid plan is very expensive: $0.99/MB. I have no idea how much data is transmitted in the course of typical online activities. What's it take to, say, download a few emails, perform a Google search or open a basic, non-video-laden web page?
posted by jon1270
on Jun 14, 2013 -
I'm designing and managing a very ambitious data visualization app for the arts and culture sector, and am trying to find the best way to organize the data types and attributes. Excel just ain't doin' it anymore. [more inside]
posted by nosila
on May 30, 2013 -
How can I misuse this bank account information? No, wait, that came out wrong. I’m looking for help justifying data security measures (at my office) for banking info. [more inside]
posted by Signed Sealed Delivered
on May 29, 2013 -
I have a list of paired numbers that span multiple orders of magnitude, and I need to find a method to a) compare within each pair in a way that does not disproportionately bias the comparison at the high or low end of the list, and b) define which pairs are dissimilar enough to be excluded from further analysis. The dataset itself follows a rough sigmoid curve, with a few pairs in the 1000s, more in the 100s, a lot in the upper 10's, some in the low 10's, and a few in the single digits. I have tried a few different comparison methods so far, including percent difference and relative percent difference of both the raw and log-transformed data. [more inside]
posted by nekton
on May 24, 2013 -
Let's say there is a database that I can only access from a front end tool, and that database cannot provide any extract of any sort. I also have no access to run reports off that database.
And let's say that the only way to preserve that data is to print to pdf or do screen shots.
btw- all legit and you are not helping me do something malicious. [more inside]
posted by BrodieShadeTree
on May 21, 2013 -
How can I easily analyse test score data in a spreadsheet with multiple independent and dependent variables in each row? [more inside]
posted by mxc
on May 15, 2013 -
This drawing or graphic appeared in the print section of either the Washington Post
or the New York Times
on Saturday or Sunday, May 11-12 (my house gets both papers on Sundays and inevitably mixes them up). All sections were put out for the recycle bin Monday before I could clip the article. [more inside]
posted by bad grammar
on May 14, 2013 -
Hi, I have a .csv that exceeds the maximum number of rows that Excel can handle, and before I can import it into a geodatabase in ArcGIS, I need to make one small edit – I need to delete the first row. Is there any way to do this and resave the file (preferably in a format other than .csv) in a way that retains the rows unable to be loaded in Excel?
posted by avocet
on May 9, 2013 -
Wife and I are now in the Child Protective Services database in Colorado after someone observed bruises and blisters on our three year old and spoke to a 'mandatory reporter' about it. I want to know what is retained in the record/database, how long is it retained, and who can access it. My own attorney was not helpful in answering these questions. [more inside]
posted by anonymous
on May 6, 2013 -