How do I show descriptive statistics in Excel 2008 on an IMAC? Cant seem to find it anywher:(Follow. Need help making summary statistics table in Excel using Descriptive statistics tool!? Statistics to show children NEGATIVELY AFFECTED? Show Season 2008? Is Mac better than Windows.or windows better than mac? Choose Data from the menu, Data Analysis from the ribbon bar, Descriptive Statistics from the box of selections and then choose OK. Credit: Image courtesy of Microsoft Type the range of cells containing the data for the variable or click the cell selector button, highlight the range with your mouse and click the button again.
We bring together earlier articles to create a quick and simple Excel data analysis. By David Goodmanson In the final article of this series we will bring together what we have learnt in earlier articles to create a data analysis. We started with then. Entering all those formulas, even simple ones like Average() is a pain. Thankfully Microsoft has put in a simple way to get statistical details from a list of numbers. Using the descriptive statistics tool we can create an analysis quickly and easily in Excel 2002 (XP) and later.
The descriptive statistics tool simplifies the calculation and display of statistics. The analysis below starts by considering a sample of student scores from a history test. Open Excel to a new worksheet. The data consists of a sample of 18 scores from a history test. Key the student results data into columns A and B of your worksheet.
Scores are marked out of 100. Once the data is in, the Excel Data Analysis tool can be used to produce a range of descriptive statistics. First, select the history scores in column B rows 2 to 19 as shown. Next, we engage the Excel Data Analysis tool. In Excel 2007, go to the Data tab on the ribbon and in the Analysis section click on Data Analysis. If you are using Excel 2003 and Excel 2002 (XP), go to Tools -> Data -> Data Analysis.
You may need to install the Data Analysis add-in from Tools| Add-ins or Excel Options| Add-ins| Go in Excel 2007/2010. Clicking “Data Analysis” calls the Data Analysis dialogue box, as shown below. From the Analysis Tools list, select “Descriptive Statistics” and click OK.
![For For](https://i.ytimg.com/vi/25Lb8TA_Qts/maxresdefault.jpg)
As can be seen from the data analysis table, the spread for history scores is from 7 to 100 – equating to a range of 93 marks. This indicates how dispersed the data is, considering the test was scored out of 100. However the Range is limited by the fact that it only uses 2 values. These two values could be outlier values thereby give a false indication of the spread of the data. The mean and the median are relatively close in value (mean = 53 and median = 54.5) indicating that the distribution of results are not significantly skewed to one end. The spread of values is evenly distributed around the mean and the median.