Recognizing Easily Creating Basic Statistics With Microsoft Excel.

Make the processing of research data or administrative data are not always with statistical programs, Microsoft Excel was also able to do so.

A student confusion when given the task of teachers to create statistical data, because its on a laptop or PC there is no statistical program. In his mind, statistical data must be processed with statistical program, such as SPSS, SAS, and other students sebagainya.Yang even funnier is actually surprised to be told that statistical data can be processed by Microsoft Excel program. He thinks that Microsoft Excel only functions that use very limited statistics on the statistics themselves.

Thus the picture of some people about the usefulness of the program Microsoft Excel in the processing of statistical data. Therefore in this paper, FastNCheap will invite you to play with Microsoft Excel 2010 statistics.

Statistics is the science and art or technique for collecting data, presenting data, collect data and draw conclusions based on the data collected.

How to Enable Reference Tools Statistics In Excel 2010.

Microsoft Excel 2010 already provides two facilities for processing statistical data, namely by using statistical functions available, and orders that an analysis of additional commands (add-ins) that can not be displayed on the main menu Microsoft Excel 2010.

Before you can use the command data analysis, the first step that must be done adlah enable reference tools already provided by Microsoft Excel, where the steps are as follows:

1. Turn Microsoft Excel program until there is a blank worksheet.
2. Click the Microsoft Office Excel button located on the left edge of the main window.
3. Click the Options menu located in a collection of vertical menu, ranging from back to exit the menu.
4. An Excel Options dialog box appears, and click the add-ins menu in the window next to Easily Make kiri.Mengenali Elementary Statistics With Microsoft Excel. Image
5. Select and Click Analysis tool pack in the application list of add-ins that are not active.
6. Click the Go button, and an add-ins dialog box is displayed.
7. Give a check mark (see picture) on the check box analysis tool Easily Make pack.Mengenali Elementary Statistics With Microsoft Excel. Image
8. Finally, click the OK button and wait a while until the installation process berakhir.Mengenali Easily Creating Basic Statistics With Microsoft Excel. Image

How to perform a descriptive analysis stastik with Excel can be done with a few steps that anyone can actually do it. Several steps can be taken in the standard analysis process is as follows:

1. From the main menu MS.Excel, click the Data menu (see picture). Recognize Easily Creating Basic Statistics With Microsoft Excel. Image
2. Click the Data Analysis in the group analysis and an analysis of data dialog box appears (see picture).

Statistical analysis to be done is to seek convergence of a cluster size of data processed. Concentration of any size is a measure of the central cluster of data that has been sorted from the smallest to the largest. Concentration of most sizes include:

* Mean.

Mean is the average or median values ​​of the cluster data.

* Median.

The median is the value in the middle of a cluster of data in ascending order.

Modes.

The module is a value that most often arises from a cluster of existing data.

Example:

Calculate the mean, median, mode of data cluster Semester Final Examination score, ie: 95, 75, 70, 80, 75, 68, 80, 78, 97, 85, 64, 100, 70, 67, 90, 68, 65 , 89, and 75.

Answer:

1. Input the data UAS (see picture).
Recognizing Easily Creating Basic Statistics With Microsoft Excel. Image
2. Click on the Data menu MS.Excel Main menu, and click the menu in Data Analysis Group Analysis.
3. In the Analysis Dialog box, select Descriptive Statistics menu, and click the OK button to exit the dialog box.
4. Further Descriptive Statistics dialog box is displayed.
5. Click the button on the Input Range, and enter data into the Input Range field, namely by blocking the data on the sheet (see picture). Recognize Basic Easily Creating Statistics With Microsoft Excel. Image
6. Give a check mark on Labels in First Row if cell contains a label that is inserted before the data.
7. Click Output Range, click on the column output range, and place the pointer in any cell is empty.
8. Give a check mark on the choice of Summary Statistics.
9. Click the OK button.
Recognizing Easily Creating Basic Statistics With Microsoft Excel. Image

Conclusion:

From the calculation is known that the average (mean) is 77, 8, the median value of 75, and the mode is 75.

HISTOGRAM

And the last tutorial is on the histogram.

Must have the bored look at the tutorial extension right? Do not worry, this is the last really.

A little story first, word histogram is derived from the Greek word Histos and Gramma.

Microsoft Excel 2010 provides facilities to create a histogram, namely through the Histogram command in the Data Analysis dialog box.

Example:

Create a histogram from the sale of books per day for a month, which form the data is like-the picture below.

Answer:

1. Click the Data menu, and the group Analysis menu click Data Analysis.
2. In the Analysis dialog box, click Histogram menu.
3. Click the OK button until the Histogram dialog box appears.
4. Enter the book sales data in the Input Range field, and ignore the Bin Range field.
5. Give a check mark in the check box Pareto (Sorted Histogram). Cummulative Percentage and Basis Chart Output.Mengenali Easily Creating Statistics With Microsoft Excel. Image
6. Click the OK button, the process of histogram see figure dibawah.Mengenali Easily Create a Basic Statistics With Microsoft Excel. Image

So first tutorial to play these statistics with Excel.