Excel can produce a number of different kinds of graphs for you. Once you have counted up the number of scores you have in given categories, you can ask Excel to create a histogram or bar graph showing this information. 1. Create a data table on the Excel

Using Excel for Statistical Analysis: Descriptive Statistics. Descriptive Statistics tool in the Data Analysis add-in can be used on an existing data set to get up to 16 different descriptive statistics, without having to enter a single function on the wo

Perhaps the most common Data Analysis tool that you’ll use in Excel is the one for calculating descriptive statistics. To see how this works, take a look at this worksheet. It summarizes sales data for a book publisher. In column A, the worksheet shows