I calculated the mode in excel, the weight columns have one while the farenheit columns dont.
EDIT: I realize that this was a somewhat curious result.
What tool would *you* use to solve this?
21–30 of 57 posts
Re: What tool would *you* use to solve this?
#22I would use one of these two tools:
Orange http://orange.biolab.si/ "Open source data visualization and analysis for novice and experts. Data mining through visual programming or Python scripting. Components for machine learning. Extensions for bioinformatics and text mining. Packed with features for data analytics."
Weka http://www.cs.waikato.ac.nz/ml/weka/ "Weka is a collection of machine learning algorithms for data mining tasks. The algorithms can either be applied directly to a dataset or called from your own Java code. Weka contains tools for data pre-processing, classification, regression, clustering, association rules, and visualization. It is also well-suited for developing new machine learning schemes."
Re: What tool would *you* use to solve this?
#23A computer.
Re: What tool would *you* use to solve this?
#24I used a spreadsheet to calculate the standard deviations. A,D and E have twice the deviation of B,C and F. (10 vs 5)
The means are all the same.
Re: What tool would *you* use to solve this?
#25I would use my right hand to slap Alison and Charlie and get them to do their work again... this time forcing them to label their samples.
I would then take them into my office and hold an inquest on how two completely different data-sets got mixed up in the first place.
At which point I would probably find out Alison and Charlie have been knocking boots on company time.. Alison and Charlie would then be fired as this is against company policy.
Due to the difficulty in finding new jobs Alison and Charlie's fledgling romance would end... leaving Alison unexpectedly pregnant and Charlie with an 18 year bill for child support.
The morale of this story? Label your fking work.
Note: I was unable to solve this problem as my math skills are poor.
Re: What tool would *you* use to solve this?
#26SPSS.
Re: What tool would *you* use to solve this?
#27Several people have said they would, or have, ploted histograms - but how? * By hand? * With Excel? * With R? * With processing? I'm a little sad to see that this item has been flagged heavily, but I guess there are people who think this is sufficiently off-topic that it should be in the same category as spam.
use R
#copy data into a txt file without the first two lines from the xls
par(mfrow = c(3,2))
dat for(let in c("A","B","C","D","E","F"))
plot(density(dat[,let]), main = let)
easy...(why doesnt HN recognise newlines?)
Re: What tool would *you* use to solve this?
#28I would use my right hand to slap Alison and Charlie and get them to do their work again... this time forcing them to label their samples. I would then take them into my office and hold an inquest on how two completely different data-sets got mixed up in the first place. At which point I would probably find out Alison and Charlie have been knocking boots on company time.. Alison and Charlie would then be fired as thi…
You're on the management fast track aren't you ?
Re: What tool would *you* use to solve this?
#29I'm sure you can easily identify which set is which using statistical methods. It's probably as simple as finding out which type of distribution each set resembles. Then again, my undergrad statistics is very rusty.
Re: What tool would *you* use to solve this?
#30I used my app https://app.prettygraph.com to quickly look at the histograms. B and F look almost identical with a very normal distribution. The others look more like twin-peaks. Edit: If you want to try, copy the data and click the "Paste data from Excel link" on the left under the Data Tab, paste and load. Then choose histogram under the Graph tab. It plots the X var (ignores Y). Sorry it's a bit shabby, I haven't w…
Nice app! Computing the histogram hung on the Apple stock data for me.