### Computer Stuff

Here are random videos about Computer Hardware and Software that Don't Fit Anywhere Else.  My videos on GIS Programs are HERE and my videos on the R Statistics Software are HERE with my econometrics videos.

Happy Holidays!  Here are some songs programmed in R (A Data Analysis Programming Language). Links to Code are in the video descriptions!

Also: Want to know the best FREE software out there? Check out TANSTAFL.burkeyacademy.com.  It is just a brief listing of some of my good finds of free programs and tools.

Excel Tips and Tricks
 Excel Match Function In response to a reddit statistics question: How can you find numbers that repeat in different columns?  Here is my solution. *File:MatchFunction.xlsx Excel vlookup A quick introduction to exact and range vlookups in Microsoft Excel. *FILE* Excel HIstograms: Labeling the Bins Properly The easy way is to put the bin ranges in the center of each bar.  A viewer asks: Can you put the limits at each end of the bar?  Yes: but it is difficult.  Let me show you how, the easiest way. Excel locate scatterplot points An easy way to create an ID to label scatterplot points and find them. Excel locate scatterplot points: EXTREME EDITION I created an Excel Spreadsheet with over 1,000 checkboxes, to allow you to highlight points in a scatterplot... or do whatever else you'd like to do with them. File Download Two Scatterplots on One Graph Here we add two series in one scatter plot, and make separate trendlines for them. Add parallel lines to a trendline "How can I add parallel lines to a trendline at 15% above and below the trendline?" It isn't as easy as it sounds, but I show a straightforward way to do it. Add pictures to a graph in Excel A few ways to add pictures to either the background, or use pictures as bars or points in a graph.

Computer Tricks and Other Research Tools: