Software Estadistico

The use of computers and calculators facilitates students to understand complex math topics. It is clear that in many cases the technology is faster and exceeds the computing capacity of the human mind. With the help of technology, students have more time to concentrate on enriching their mathematical learning.
New technologies have come to change the traditional outlook as they did, and weretaught mathematics. Getting into this new landscape involves profound changes in our educational programs.
It's very wide range of applications available for statistics and probability:
* Excel.
* Spss.
* S Plus.
* Minitab
* Statgraphics.
* Statsoft.
* PH stats 2.5.

The Excel Spreadsheet / Calc can be a powerful tool to create learning environmentsthat enrich the representation (modeling), understanding and problem solving in the area of statistics and probability. Excel provides features that go beyond the tabulation, calculation formulas and graphing data:

* In descriptive statistics represents all types of graphics and calculates the mean, mode, median, route, variance and standard deviation.
* In two-dimensional statisticrepresents the point cloud and the regression line. Calculate the center of gravity, the marginal deviations, covariance, correlation coefficient, regression line and look for targets.
* In the binomial distribution, calculated any probability, the mean, variance and standard deviation.
* In the normal distribution, calculates any chance in the standard normal N (0, 1) and any normal N(m, s) and generates the table N (0, 1)
* In statistical inference calculated confidence intervals, the size of the sample and can be applied to hypothesis testing, both bilaterally and unilaterally.
* In probability simulates all types of pitches.

The installation is very simple program, Microsoft Excel also includes a command for data analysis within the "analysis tools", its useis rare because not careful installing all functions within "tools", losing the opportunity to use a powerful means to study in statistics.

Examples of exercises solved with Excel:

Studying the number of children from 30 randomly selected families in a city we have obtained the following data:
1, 2, 3, 5, 6, 0, 7, 8, 4, 1, 3, 4, 5, 2, 6, 5, 2, 3, 4, 6, 2, 3, 46, 4, 3, 6, 6, 3, 3Representing the pie chart and line graph

     We obtain most common statistical measures.
After opening the EXCEL spreadsheet, enter data in column A and rows 1 through 30.
In column C we introduce the different values ​​of the variables from row 1 to row 9. The spreadsheet would be as shown in the figure:

For column absolute frequencies COUNTIF use the function (). Column D will containthese values​​. For them will place the cursor in the direction D1. We select the "Insert" from the taskbar the "fx" function, and statistical functions des function, COUNTIF as shown in the graph.



Should appear in the toolbar function fx, simply select it and choose it from the statistical functions.
Accepted and in the new window that appears specify the range A $ 1: A $ 30 andCriterion C1, pressing OK.
As a result, cell D1 displays a 1, ie, the number of times that the value of the cell C1, since the row A1 to A30. We can repeat the procedure for all values ​​of the variable, changing the cell cursor and the next row and Criteria window COUNTIF function () placing the appropriate value.


However, it can perform a more automatic way, through utilities Copy, andPaste. This is selected with the right mouse button cell D1, left-clicking the Copy option, which will cut cell D1 with intermittent pieces. Select with the mouse the cells where we want to copy the formula by placing the cursor in cell D2 and clicking the left button dragging your mouse to cell D9 (cells D2 to D9 should appear in black background), press Enter to end.

       Once calculated the...