AUTONOMOUS UNIVERSITY OF NUEVO LEÓN FACULTY OF PUBLIC ACCOUNTING AND ADMINISTRATION

INTEGRATIVE LEARNING PRODUCT

Descriptive Statistics
Integrative Learning Product
Bachelor's Degree in Administration

Semester: 2nd Group: BV

Master: Jesús Roberto Martínez Rodríguez

Team members:

Name Enrollment
Hernández del Ángel Gabriela 1954696
Hernández Martínez Anetth Samantha 1974604
Milan Leija Alicia Guadalupe 1850967
Muñoz García María Fernanda 1842394
Ramos Soto Mayra Jantcely 1872884
Salazar Leyva Catherine Gabriela 1686155
Santes Diaz Britany Yuliana 1949744

Minimum Content to Evaluate Compliance

Index ☐
Introduction. - includes values ☐
UANL applied
Analysis and issuing of judgment ☐
Individual conclusions ☐
Team conclusion ☐
Activity in English ☐
---------------------------------------------------------------------------------------------------
PIA rating Final grade.

Company:

University City, May 9, 2021

 Introduction

Descriptive statistics is a set of numerical and graphical techniques for

describe and analyze a group of data.
In this work, we will develop different formulas and procedures for
to reach the results that each problem asks for.
Through a table on Major League Baseball during the 2015 season, it is
how the base data is provided to us to apply the formulas and reach a
result.
Some formulas that we will use are the probability formula and the Poisson formula, as well as

some operation to calculate the average or make comparisons of data.

Among the problems that develop, we will notice that under tables and
comparisons is that we get the results, well thanks to statistics
Descriptive analysis can achieve data analysis.
Statistics allows us to keep track of different data and organize them.
agreement with categories or variables, such as those found in this project.
Some variables depend on others and others can be completely independent.
The probability is another of the problems that are developed in this project, and it is
Import recalculate that the obtained results are compared with the total of
probability of those situations occurring.
 Introduction

Descriptive statistics is a set of numerical and graphical techniques to describe and

analyze a group of data.
In the present work we will develop different formulas and procedures to reach the
results that each problem asks of us.
Using a table on Major League Baseball during the 2015 season, we are provided
with the base data to apply the formulas and arrive at a result.
Some formulas that we will use are probability and Poisson's, as well as some
operation to take the average or make data comparisons.
Among the problems that are developed we can note that under tables and
Comparisons provide us with results, thanks to descriptive statistics data.
analysis can be achieved.
Statistics allow us to keep track of different data, and arrange them according to
categories or variables, such as those found in this project.
Some variables depend on others and others can be totally independent.
Probability is another of the problems that are developed in this project, and it is
It is important to recalculate that the results obtained are compared with the total.
probability of such situations happening.
 Values of UANL

• Responsibility: it is a value or quality of every human being, that fulfills

your obligations when doing, saying, or offering something with full awareness of your actions.
We practice this value when we deliver things on time and in the correct manner, for

we have to complete the activities assigned to us by each teacher.

• Respect: It is the special consideration and valuation given to someone or to

something that is recognized for its social value or special deference.
This value is applied when we respect everyone's opinion and it is taken into
It’s clear that we all deserve respect and it should be mutual.

• Teamwork: As its name suggests, it is when we maintain a team.

with 1 or more people.
We applied it when we did this activity and we all shared the work.
to work as a team, in addition to communicating ideas to each other.

• Equity: Using impartiality to recognize each person's rights.

using equality through justice, understood as virtue
through which others are given what is due to their rights.
We apply it when we divide the work and we distribute it equally, no more.
not to mention, everyone was taken into account equally.

• Honesty: It is a quality of human character that consists of behaving

and express oneself with coherence and sincerity, respecting the truth in relation to
the world, the facts, and the people.
We applied this value when we solved the problems and put the results.
with their respective formulas, demonstrating how we arrived at that answer.
 Values of the UANL

Responsibility: it is a value or quality of every human being, who fulfills his

obligations by doing, saying or offering something with full awareness of his actions.
We practice this value when we deliver things on time and in the correct form, as we have to.

comply with the activities assigned to us by each teacher.

Respect: It is the special consideration and appreciation that you have for
someone or something, which is recognized as social value or special deference.
We apply this value when we respect everyone's opinion and it is taken into account.
that we all deserve respect and must be mutual.

Teamwork: As its name says, it is when we maintain a team with 1 or more people.
We applied it when we did this activity and we all divided the work to work as a team.
in addition to communicating ideas to each other.

• Equity: Use of impartiality to recognize the right of each one, using equality through
Justice, understood as the virtue by which others are given what is due to their rights.
We apply it when we distribute the work and we distribute it equally, neither more
nor less, in addition, their opinion was taken equally.

• Honesty: It is a quality of human character that consists of behaving and expressing

oneself with coherence and sincerity, respecting the truth in relation to the world,
facts and people.
We applied this value when we did the problems and put the results with their
respective formulas, demonstrating how we arrived at that answer.
 Consult the Baseball 2015 data, which contains information about the 30 teams.
from Major League Baseball during the 2015 season. Set three variables:

Team League Construction Salary Assistance Victorias ERA BA HR

St. Louis National 2006 120.30 3,520,889 100 2.94 0.253 137
Pittsburgh National 2001 85.90 2,498,596 98 3.21 0.260 140
Chicago Cubs National 1914 117.20 2,959,812 97 3.36 0.244 171
Kansas City American 1973 112.90 2,708,549 95 3.73 0.269 139
Toronto American 1989 116.40 2,794,891 93 3.8 0.269 232
LA Dodgers National 1962 230.40 3,764,815 92 3.44 0.250 187
New York Mets National 2009 100.10 2,569,753 90 3.43 0.244 177
Texas American 1994 144.80 2,491,875 88 4.24 0.257 172
NYYankees American 2009 213.50 3,193,795 87 4.05 0.251 212
Houston American 2000 69.10 2,153,585 86 3.57 0.250 230
LA Angels American 1966 146.40 3,012,765 85 3.94 0.246 176
San Francisco National 2000 166.50 3,375,882 84 3.72 0.267 136
Minnesota American 2010 108.30 2,220,054 83 4.07 0.247 156
Washington National 2008 174.50 2,619,843 83 3.62 0.251 177
Baltimore American 1992 118.90 2,281,202 81 4.05 0.250 217
Cleveland American 1994 87.70 1,388,905 81 3.67 0.256 141
Tampa Bay American 1990 74.80 1,287,054 80 3.74 0.252 167
Arizona National 1998 65.80 2,080,145 79 4.04 0.264 154
Boston American 1912 168.70 2,880,694 78 4.31 0.265 161
Chicago Sox American 1991 110.70 1,755,810 76 3.98 0.250 136
Seattle American 1999 123.20 2,193,581 76 4.16 0.249 198
Detroit American 2000 172.80 2,726,048 74 4.64 0.270 151
San Diego National 2004 126.60 2,459,742 74 4.09 0.243 148
Miami National 2012 84.60 1,752,235 71 4.02 0.260 120
Colorado National 1995 98.30 2,506,789 68 5.04 0.265 186
Milwaukee National 2001 98.70 2,542,558 68 4.28 0.251 145
Oakland American 1966 80.80 1,768,175 68 4.14 0.251 146
Atlanta National 1996 89.60 2,001,392 67 4.41 0.251 100
Cincinnati National 2003 117.70 2,419,506 64 4.33 0.248 167
Philadelphia National 2004 133.00 1,831,080 63 4.69 0.249 130

Divide the teams into two groups, those that had a winning season and those that did not.
no. That is to say, create a variable to count the teams that won 81 games.
or more, and those who won 80 games or less.

More than 81 or more 80 games or less

16 14
 Team Victorias Team Victorias
St. Louis 100 Tampa Bay 80
Pittsburgh 98 Arizona 79
Chicago Cubs 97 Boston 78
Kansas City 95 Chicago Sox 76
Toronto 93 Seattle 76
LA Dodgers 92 Detroit 74
NYMets 90 San Diego 74
Texas 88 Miami 71
NYYankees 87 Colorado 68
Houston 86 Milwaukee 68
LA Angels 85 Oakland 68
San Francisco 84 Atlanta 67
Minnesota 83 Cincinnati 64
Washington 83 Philadelphia 63
Baltimore 81
Cleveland 81

Create a variable for attendance, with three categories: attendance lower than
2.0 million; one from 2.0 to 3.0 million and one of 3.0 million or more.

Assistance
Less than 2.0 million 2.0 million to 3.0 million 3.0 million or more
They won 6 19 5

Team Assistance Team Assistance Team Assistance

Philadelphia 1,831,080 Chicago Cubs 2,959,812 LA Dodgers 3,764,815
Oakland 1,768,175 Boston 2,880,694 St. Louis 3,520,889
Chicago Sox 1,755,810 Toronto 2,794,891 San Francisco 3,375,882
Miami 1,752,235 Detroit 2,726,048 NYYankees 3,193,795
Cleveland 1,388,905 Kansas City 2,708,549 LA Angels 3,012,765
Tampa Bay 1,287,054 Washington 2,619,843
NYMets 2,569,753
Milwaukee 2,542,558
Colorado 2,506,789
Pittsburgh 2,498,596
Texas 2,491,875
San Diego 2,459,742
Cincinnati 2,419,506
Baltimore 2,281,202
Minnesota 2,220,054
Seattle 2,193,581
Houston 2,153,585
Arizona 2,080,145
Atlanta 2,001,392
Create a variable that shows which teams played in a stadium of less than
20 years of seniority, against one that is 20 years or older.

Teams that played in a historic stadium

Less than 20 20 years or more
17 13

Team Construction Team Construction

Miami 2012 Texas 1994
Minnesota 2010 Cleveland 1994
New York Mets 2009 Baltimore 1992
NYYankees 2009 Chicago Sox 1991
Washington 2008 Tampa Bay 1990
St. Louis 2006 Toronto 1989
San Diego 2004 Kansas City 1973
Philadelphia 2004 LA Angels 1966
Cincinnati 2003 Oakland 1966
Pittsburgh 2001 LA Dodgers 1962
Milwaukee 2001 Chicago Cubs 1914
Houston 2000 Boston 1912
San Francisco 2000
Detroit 2000
Seattle 1999
Arizona 1998
Atlanta 1996
Colorado 1995
Answer the following questions:
a. Elaborate a table that shows the number of teams that won in the
season against those who lost according to the three categories of
assistance.

They won They lost

category 1 LA Dodgers LA Angels
category 2 Chicago Cubs Atlanta
category 3 Philadelphia Tampa Bay
If a team is selected at random, calculate the following probabilities:
Attendance Teams that won Teams that lost Total
Less than 2.0 million 1 5 6
2.0 million to 3.0 10 9 19
millions
3.0 million or more 5 0 5
Total 16 14 30

Have a winning season.

Data
Equipos= 30 16/30
Winning teams: 16
Probability: 53.3%

2. To have a winning season or have an attendance of more than 3.0

millions.
Data: 16/30 + 5/30-(5/30) = 16/30 = 0.533
P(X>3000000)
Probability: 0.533
n= 5

Given attendance of more than 3.0 million, have a winning season.

Data:
P(X>3000000)
21/30 + 16/30 = 1.23
n= 5
Probability: 1.23

4. Having a winning season and having an attendance of less than 2.0

millions.
Data: 16/30 + 6/30 - (1/30) = 21/30 = 0.7
P(X>2000000)
Probabilidad: 0.7
n=6
b) Calculate the average of home runs per game. To do this,
first find the average of home runs per game; then divide this value
between 162 (a season consists of 162 games). Then multiply by 2,
given that there are two teams in each game. Use the Poisson distribution to
estimate the number of quadrangles that will be batted in a game.

=
!
2.020 162 −2.020
ⅇ
[] = = 2.39x 10 46
162!

Find the probability that:

There are no quadrangles in a game.

=
!
0 ⅇ
= . = 2.020
−2.020
= 0.1326
= 0!

b. There are two home runs in a game.

=
!
2 ⅇ
= . = 2.020
−2.020
0.2706
= 2!
There should be at least four home runs in a game.

=
!
4
= . . 2.020
= =−.9
=4 4!
5
. 2.020
=5 = = . 371
5!
6
. 2.020
=6 = = .15
6!

Probabilidad= 0.8127= 81%

c) The average attendance per team during the season was 2,439 million, with a
standard deviation of 0.618 million. Use the normal distribution to calculate the
number of teams with assistances over 3.5 million. Compare this
result with the real number. Make comments on the accuracy of the calculation.

−
=

σ = 0.618 3.5− ,439

=
.618
Z=3,940.93 = 0.9998/ 0.50
=1%

M=2,439 +3.5
d) The average salary per team was 121 million dollars, with a deviation
standard of 40 million. Use the normal distribution to calculate the number of
teams with a salary higher than 100 million dollars. Compare this result
with the actual amount. Make comments on the accuracy of your approximation

−
= 1 −11
=
4
Z=0.525
0.1985 + 0.50 = 0.6985
S=40
Z= 69.85

100 M=121
 Group Conclusion

In conclusion, descriptive statistics allows us to analyze data and

classify them using variables or tables.
In this project, we developed some topics of descriptive statistics that
through formulas and procedures, a result can be achieved.
In the initial problems, we apply data analysis, as through the
observation and arrangement of variables, the equipment was arranged according to their
results in the game season. Tables were used to separate the variables.
and some comparisons.
The second topic was probability, where through percentages and comparisons
between data, a conclusion was reached regarding one another. The
probability formulas among a total of cases.
The third topic was Poisson, which through its formula and the interpretation of
data we reached the answer.
And finally in problem number four, we apply the normal distribution, in the
that this formula was applied and through a total of data and the probability it was reached
to the result.
Finally, we can say that thanks to statistics and the formulas that
it is possible to conduct an analysis of any data collection, and thus draw
conclusions and interpretations.
 Group Conclusion

In conclusion, descriptive statistics allow us to analyze data and classify it using

variables or tables.
In this project, we develop some topics of descriptive statistics that can be reached.
by means of formulas and procedures.
In the first problems we applied data analysis, since by observing and ordering
variables, the teams were arranged according to their results in the game season.
Tables and some comparisons were used to separate the variables.
The second topic was that of probability, where by means of percentages and
comparisons between data, a conclusion was reached with respect to each other.
The probability formulas were used among a total of cases.
The third topic was that of Poisson, which by means of his formula and the
interpretation of data we arrived at the answer.
And finally in problem number four, we apply the normal distribution, in which this
A formula was applied and based on the total data and probability, the result was
reached.
Finally, we can say that thanks to statistics and the formulas they entail, an
analysis of any data collection can be made, and thus conclusions and
interpretations can be drawn
 Individual Conclusion

Gabriela Hernández del Ángel

In the activity carried out, I reviewed the problems we saw earlier.
and I was able to better understand one in this case, the Poisson distribution, since it was explained to me.

it was a bit difficult, but I understood it better, I was also able to observe how to do it
the divisions or variables that are presented in this case in addition to seeing the

probability problems presented in section a.

I can say that currently we use statistics frequently and
we probably don't realize it like when something similar to exercise
the data of a football season would be based on the
the commentators study the results and mention them in their programs in that
if they apply descriptive statistics.

Anetth Samantha Hernandez Martinez.

At the end of this final project, I can conclude that I already have a greater knowledge
cheap regarding the topics that the project addresses that we were reviewing
Throughout this semester. Taking the probability of things is something that is
it was difficult for me, but by looking at examples and doing the problems that were asked of me, I put

to grasp it better, one thing that didn't make it difficult for me was what normal distribution, I think

It is one of the simplest topics seen in class and among those that were requested from us.
for this project. It was really interesting to research and solve the problems
what they were giving us.
Alicia Guadalupe Milán Leija
To conclude, it is important to know about the characteristics that it possesses
normal probability distribution in which this integrative product of
learning is carried out clearly. It has the shape of a bell and has a
single peak in the center of the distribution. The arithmetic mean, the median, and the mode
they are equal and are located at the center of the distribution. The total area under the curve
It is 1.00. Half of the area under the normal curve is located to the right of this.
central point, and the other half, to the left. On the other hand, as we already know it is
symmetric with respect to the mean. If you make a vertical cut through the central value, at the

normal curve, the two halves are mirror images. It descends smoothly
in both directions of the central value. That is, the distribution is asymptotic. The
the curve approaches the X-axis more and more, without touching it. In other words, the tails of

the curve extends indefinitely in both directions. This distribution of

normal probability shows us the specific possibilities that
a discrete value occurs.

Maria Fernanda Munoz Garcia

In conclusion, when developing this project we applied different formulas and analysis
What we study in class and thus arrive at the results.
Descriptive statistics, in general, is indispensable, as it allows us to
organize data, as well as analyze ourselves.

In this activity, we develop some topics such as probability, and the formula.
of fish, this is how we arrive at the results of the sections. Additionally, we were able to show

through graphics the response for better understanding.

Mayra Jantcely Ramos Soto

In conclusion, statistical tools are of vital importance for management.
of data, these can be very useful for calculating exact data that
they serve to have a better management of these and in this way obtain all the
possible information from some data, that is, they make the data show all the
information through the use of measures of central tendency.
Catherine Gabriela Salazar Leyva
Descriptive statistics is, along with inferential statistics, one of the
branches of statistics. What I imply in this work is that statistics
It has always been in the environment of civilization since there have been forms
simple, in civilization graphical representations and others were already used
symbols for counting the number of people or other things.
also that statistics helps us to collect, analyze, organize, and make
decisions that are in accordance with the analysis of this work.
In conclusion, it can be said that statistics since the beginning of
civilization has existed simple forms of statistics, since they were already used
graphic representations and other symbols to count the number of people,
animals or certain things.

Britany Yuliana Santes Díaz

In this Pia, an Excel table was presented and we were answering the
questions that were presented step by step, and the first thing we did was divide the
teams and create variables of themselves to extract the possibilities that existed in the
equipos al igual sacar la media, este trabajo fue muy completo ya que era lo que
we had seen throughout the semester, and since we were breaking it down little by little
in this work, I was resolving the doubts I had, and well in my personal life or in
some work the topics seen will help me, and the practice in Excel itself.
 Individual Conclusion

Gabriela Hernández del Ángel

In the activity carried out I reviewed the problems that we previously saw and I was
able to better understand one in this case the poisson distribution since it was a bit
difficult for me but I understood it better, I was also able to observe how to perform
the divisions or variables that are presented in this case in addition to looking at the
probability problems presented in part a.
I can say that nowadays we use statistics frequently and we probably do not realize
it is as if something similar to the exercise carried out would be the data of a
football season where, based on the results, the commentators study and mention
them in their programs in that case they apply descriptive statistics.

Anetth Samantha Hernandez Martinez.

At the end of this final project I can conclude that I already have cheaper knowledge.
regarding the issues that the project deals with that we have been seeing around
this whole semester. Finding the probability of things is something that was difficult
for me, but seeing examples and doing the problems that they asked me to do, I was
able to grasp it better, one thing that did not hinder me was the normal distribution I
I think it is one of the simplest topics seen in classes and among those that we were.
asked for this project. It was really interesting to investigate and solve the problems
they gave us.
Alicia Guadalupe Milán Leija
To conclude, it is important to know about the characteristics of the normal
Probability distribution in which we clearly carry out in this integrative learning.
product. It is bell-shaped and has a single peak in the center of the distribution. The
arithmetic mean, median, and mode are equal, and are located in the center of the
distribution. The total area under the curve is 1.00. Half of the area under the normal
curve is located to the right of this central point, and the other half, to the left. On the
on the other hand, as we already know, it is symmetric with respect to the mean. If you cut
vertically, through the center value, to the normal curve, the two halves are mirror
images. It descends smoothly in both directions from the center value. That is, the
distribution is asymptotic. The curve gets closer and closer to the X axis, without
touching it. In other words, the tails of the curve extend indefinitely in both directions.
What this normal probability distribution shows us are the specific possibilities of a
discrete value occurring.

Maria Fernanda Muñoz García

In conclusion, when developing this project we apply different formulas and analyzes
that we study in class and thus arrive at the results.
Descriptive statistics, in general, is essential, since it allows us to order data, as well
as to analyze ourselves.
In this activity we develop some topics such as probability, and the Poisson formula.
thus we arrive at the results of the sections. In addition, we were able to graphically
show the response for a lesser understanding.

Mayra Jantcely Ramos Soto

In conclusion, statistical tools are of vital importance for data management, they can
be very useful to calculate exact data that serve to have a better management of
them and in this way obtain all the possible information from some data, that is that
They make the data show all the information by using the trend measures.
Catherine Gabriela Salazar Leyva
Descriptive statistics is, along with inferential statistics, one of the branches
of statistics. What I imply in this work is that statistics have always been in the
environment of civilization since there have been simple forms, in civilization graphic
Representations and other symbols were already used to count the number of people.
or other things.
Also that statistics help us to collect, analyze, organize and make decisions that are
in accordance with the analysis of this work.
In conclusion, it can be said that statistics since the beginning of civilization have
existed simple forms of statistics, since graphic representations and other symbols
were already used to count the number of people, animals or certain things.

Britany Yuliana Santes Díaz

On this page, a table was presented in Excel and we were answering the questions.
that were presented step by step, and the first thing we did was divide the teams and
create variables of ourselves, get the possibilities that were in the teams as well as
take the average. This work was very complete since it was what we had seen
throughout the semester, and since we were breaking down this work little by little I
I was solving the doubts I had, and well in my personal life or in some work the topics.
seen will serve me, of himself he practices it in Excel.