How Do You Analyze Statistics Using Excel?
Microsoft’s popular Excel spreadsheet program is not only an excellent tool for data collection and management. It also can conduct many of the statistical procedures performed by more specialized statistical software. Excel’s wide availability and user-friendliness make it a great analysis tool for most users. It offers a variety of wizards to guide users through the analysis, and by simply clicking and dragging on a particular cell or column, you can choose the range of data and variables you want analyzed. Open a spreadsheet and enter your data. Give some thought as to how your organize your spreadsheet, setting it up in such a way as to make your analysis easier. Let each variable be a column and each row a line of data. For example, a spreadsheet of data on a classroom of 30 students might include columns with such variables as the student’s ethnicity, gender, grade level and grades in tests and courses. Visually examine your data with the chart/graphic wizard. Excel’s tool bar fe
