The Excel spreadsheet is a software considered as standard in all environments (educational, professional, family, etc.), which has the virtue of presenting a pleasant interface, a user-friendly praise and allows simple statistical analysis or more complex and advanced.

Manual and installation
The Excel Spreadsheet can become a powerful tool to create learning environments that enrich the representation (modeling), understanding and problem solving, in the area of ​​statistics and probability. Excel offers functionalities that go beyond tabulation, formula calculation and data graphing:

In descriptive statistics, it represents all types of graphs and calculates the mean, mode, median, distance, variance and standard deviation.
In two-dimensional statistics it represents the point cloud and the regression line. Calculate the center of gravity, the marginal standard deviations, the covariance, the correlation coefficient, the regression line and look for objectives.
In the binomial distribution, calculate any probability, mean, variance, and standard deviation.
In the normal distribution, calculate any probability in the standard normal N (0, 1) and in any normal N (m, s) and generate the table N (0, 1)
In statistical inference it calculates the confidence intervals and the sample size.
It is applied to the hypothesis contrast, both bilaterally and unilaterally.
In probability, it simulates all types of launches.

LIST OF EXCEL STATISTICAL FUNCTIONS  BRIEF MANUAL EXCEL-SIMULATION »

The installation of the program is very simple, as additional goodness Microsoft Excel includes a command for data analysis, within the “tools for analysis”, its use is uncommon, since care is not taken to install all the functions within of the “tools”, losing the opportunity to use a powerful medium for study within statistics.

Step by step exercises with Excel
Statistical graphs
By studying the number of children of 30 families chosen at random in a city, the following data have been obtained:
1, 2, 3, 5, 6, 0, 7, 8, 4, 1, 3, 4, 5, 2, 6, 5, 2, 3, 4, 6, 2, 3, 4,6, 4, 3, 6, 6, 3, 3
Represent the sector diagram and the frequency polygon
STEP BY STEP SOLUTION WITH EXCEL »

SOLVED EXERCISE »

One-dimensional statistics
By throwing two dice 30 times and writing down the sum of the top faces we have obtained the data that we represent in the following table:
Results 2 3 4 5 6 7 8 9 10 11 12
Frequency 1 2 4 3 2 1 4 3 5 4 1
We must obtain the most common statistical measures.

OLUCIÓN STEP BY STEP WITH EXCEL »

SOLVED EXERCISE »

Two-dimensional statistics
The ages of five children and their respective weights were observed and the following results were achieved:

a) Find the means and marginal deviations.
b) Calculate the linear correlation coefficient and the regression line of the weight on age.
STEP BY STEP SOLUTION WITH EXCEL »

SOLVED EXERCISE »

Outlier
The heights of 19 students of 1st ESO were measured and the following results were achieved:
150, 151, 147, 155, 145, 151, 152, 150, 149, 160, 142, 158, 153, 144, 190, 145, 147, 150, 156
a) Check if there are outlier using the method based on the standard deviation.
b) Check if there are outlier using the method based on the interquartile range.

STEP BY STEP SOLUTION WITH EXCEL »

SOLVED EXERCISE »

Difference between two means of independent populations
An assembly operation of an industrial plant requires that a new employee undergo a training period to achieve maximum efficiency.

A new training method was suggested and a test was carried out to compare the methods. Two groups of nine new employees were trained over a period of three weeks, one group using the new method and the other following the standard training procedure. At the end of the three week period, the time in minutes it took for each employee to assemble the device was observed.

Do the data present sufficient evidence to indicate that the average assembly time at the end of the three-week training period is less for the new method?

Standard procedure

New procedure

STEP BY STEP SOLUTION WITH EXCEL »

Difference between two means of dependent populations
One manufacturer wanted to compare the wear resistance of two different types of A and B tires. To make the comparison, a type A and a type B tire was randomly assigned to the rear wheels of 20 cars.

The cars traveled a specific number of kilometers and the wear of each tire was observed.

Car

Do the data present sufficient evidence to conclude that there is a difference in the average wear of the two types of tires?

STEP BY STEP SOLUTION WITH EXCEL »

Macros and simulations with Excel
The use of Excel Macros allows, on the one hand, to develop more complex applications (using a programming language); and on the other, automate routine tasks that are stored in a file which can be executed when needed again (with the menu option “Tools / Macros”).

Creating and using simulations with Excel and its macros enables students to use representations to build a bridge between intuitive ideas and formal concepts. With this goal in mind, teachers can use some simulations available on the Internet or create their own.

Here are a series of applications to open them with Excel, some include macros built with Visual Basic.

### Gallery of Biggest Loser Excel Spreadsheet

In addition to the image above, you can see a gallery of Biggest Loser Excel Spreadsheet below.

( Click Image to Enlarge )

See More!

Tag; Biggest Loser Excel Spreadsheet, Excel Spreadsheet, biggest loser workout schedule for contestants, biggest loser sign up sheet, biggest loser weigh in sheet, biggest loser spreadsheet, biggest loser workout schedule, biggest loser excel sheet, biggest loser step workout chart, biggest loser challenge spreadsheet, biggest loser sign up sheet at work,