UT 4600 Census Form

Instructions and help about UT 4600 Census

[ Music ] Welcome to Using Census Data  with Excel. I'm Adam Heckman. The vast majority of time, Excel, as it  is, provides you what you need to access, combine and query, massage, transform, visualize, and otherwise play with your census data using the visualizations, the formulas, and  the functions that are built-in. There are however advanced tools for statistical analysis that you can use on census data. You just have to turn it on. You don't have  to download anything, you need to turn it on. Let's do so. File, Options and you'll see add-ins and at the bottom of the add-in, it says Manage Excel Add-Ins. Click on Go and check Analysis Tool Pack and you'll note that once you check that off, you'll have a new button in your Data tab called Data Analysis. If I click on Data Analysis, I can see some of the things that I can do here. I can do regression testing, histograms, Anova, correlation and covariance analyses, exponential smoothing, all of the tests, F tests, Z tests, T