## EXPLORATORY DATA ANALYSIS

### Course

Code: 1263

Degree: Bachelor's in Business Administration and Management

Faculty of Social and Legal Sciences of Elche

Year: Year 1 of Bachelor's in Business Administration and Management

Semester: Spring

Type: Core

Language: Spanish

ECTS credits: 6 Lecture: 3 Laboratory: 3 | Hours: 150 Directed: 60 Shared: 30 Autonomous: 60 |

Subject matter: Statistics

Module: Quantitative Methods

Department: Statistics, Mathematics and Informatics

Course instructors are responsible for the course content descriptions in English.

### Description

### Faculty

Name | Coordinator | Lecture | Laboratory |
---|---|---|---|

SANCHEZ SORIANO, JOAQUIN | ■ | ■ | ■ |

CALVO CALABUIG, ROLAND | ■ | ||

ESTAÑ PEREÑA, MARIA TERESA | ■ | ||

LLORCA PASCUAL, NATIVIDAD | ■ |

### Professional interest

Likewise, itt contributes to better knowledge and understanding of basic economic terminology such as indexes (prices, consumption, production, ...), trends, seasonality, variability, ... which are useful in assessing the contour conditions in decision-making in the business environment.

Finally, it provides the basic knowledge and basic skills to introduce the notion of randomness (probability) in the process of decision making, as relevant element when assessing the risk assumed in the decision alternatives being considered.

### Competencies and learning outcomes

#### General competencies

- Capacity to identify, interpret, formulate, and resolve basic problems within the branch of social and legal sciences.
- Ability to use the tools and instruments needed to properly observe the systems under study.
- Critical and analytical skills in the relevant specialty area.
- Capacity to evaluate, optimize, and compare criteria in decision making.
- Ability to work with multidisciplinary and multicultural teams.

#### Specific competencies

- Capacity to perceive and value the importance of new technologies within the business environment and its economic surroundings.
- Capacity to analyze general problems in the field of business and markets.
- Capacity to use and interpret business data and information for specialized reporting and decision making.
- Capacity for quantitative problem solving.

#### Objectives (Learning outcomes)

- 01To know and identify the importance and interest of data analysis to obtain relevant information to improve decision-making in real problems
- 02To know and apply the concepts of population, parameters, censuses, samples, variables and estimators on real problems.
- 03To know and apply basic sampling procedures to infer on simple populations.
- 04To adequately describe data numerically and graphically. Derive conclusions.
- 05To describe relationships between different variables of several types, numerically and graphically. Derive conclusions.
- 06To know and apply index numbers on real applications.
- 07To identify chronological series; to know and apply adequate numerical and graphical description procedures. To derive conclusions.
- 08To identify randomness and probability in real problems.
- 09To apply the basic results on probabilistci dependence and independence, to calculate probabilities in real problems.
- 010To identify the basic distributions presented in real problems and to make probabilistic assessments to resolve questions of interest.

### Contents

#### Teaching units

#### Association between objectives and units

Objective/Unit | U1 | U2 | U3 | U4 | U5 | U6 |
---|---|---|---|---|---|---|

01 | ||||||

02 | ||||||

03 | ||||||

04 | ||||||

05 | ||||||

06 | ||||||

07 | ||||||

08 | ||||||

09 | ||||||

010 |

#### Schedule

Week | Teaching units | Directed hours | Shared hours | Autonomous hours | Total hours |
---|---|---|---|---|---|

1 | 4 | 1 | 2 | 7 | |

2 | 4 | 1 | 2 | 7 | |

3 | 4 | 2 | 4 | 10 | |

4 | 4 | 1 | 4 | 9 | |

5 | 4 | 1 | 4 | 9 | |

6 | 4 | 2 | 4 | 10 | |

7 | 4 | 2 | 4 | 10 | |

8 | 4 | 2 | 4 | 10 | |

9 | 4 | 2 | 4 | 10 | |

10 | 4 | 2 | 4 | 10 | |

11 | 4 | 2 | 4 | 10 | |

12 | 4 | 2 | 4 | 10 | |

13 | 4 | 2 | 4 | 10 | |

14 | 4 | 2 | 4 | 10 | |

15 | 4 | 6 | 8 | 18 |

#### Basic bibliography

- Montiel Torres, A. M. Rius Díaz, F. / Barón López, F. J. "Elementos básicos de estadística económica y empresarial". Madrid [etc.] Prentice-Hall 1998.
- Moore, David S. Comas, Jordi. "Estadística aplicada básica". Barcelona Antoni Bosch Editor D.L. 1998.

#### Complementary bibliography

- Mason, Robert D. Lind, Douglas A. "Estadística para administración y economía". México Alfaomega 1998.
- Newbold, Paul. Maydeu Olivares, Alberto / Estévez M"?oz, Macarena. "Estadística para los negocios y la economía". Madrid [etc.] Prentice Hall 2000.
- Pérez López, César 1955-. "Estadística aplicada a través de excel". Madrid Prentice Hall D.L. 2002.
- Pérez López, César 1955-. "Muestreo estadístico conceptos y problemas resueltos ". Madrid [etc.] Pearson-Prentice Hall 2006.

#### Software

- Microsoft Office 2013
- UMH Statistics

### Methodology and grading

#### Methodology

**Case studies:**Learning through the analysis of actual or simulated cases in order to interpret and resolve them by employing various alternative solution procedures.**Problem-based learning:**Develop active learning strategies through problem solving that promote thinking, experimentation, and decision making in the student.**Solving exercises and problems:**Exercise, test, and apply previous knowledge through routine repetition.

#### Grading

FINAL GRADE: The final grade will be obtained as follows:

FINAL NOTE = 0.75xEF + 0.2xEC + 0.05xT,

where EF = final exam grade (0-10); EC = computer practice score (0-10). T = score for tutorials, participation in class and in activities to be programmed (0-10).

To pass the subject will be necessary to have passed EF and EC with a grade of at least 4.5 points out of 10 each and also obtain a FINAL NOTE equal or higher than 5 points.

CHARACTERIZATION AND FINAL QUALIFICATION OF EXAMINATIONS (EF): The subject consists of two blocks of differentiated contents, so the final exam will consist of two parts, one for each block, with different weights. Each block of contents is composed of the following didactic units: 1. BLOCK 1: Didactic units 1, 2, 3 and 4. 2. BLOCK 2: Didactic Units 5 and 6. The weight of each block is as follows: 1. BLOCK 1: 60% of the EF rating. 2. BLOCK 2: 40% of the EF rating.

The EF rating is calculated as follows:

If the test scores for each of the blocks are equal to or greater than 4 points out of 10:

EF = 0.6 x Grade examination Block 1 + 0.4 x Grade examination Block 2

If any of the marks in the blocks are less than 4 points out of 10:

EF = min{Grade exam Block 1;Grade exam Block 2}

In order to facilitate the passing of the subject, two opportunities will be given for each block, that is, two exams will be carried out for each of the blocks. The temporary programming of the exams is as follows:

1. The first exam (first opportunity) of each block will be made during the course once the corresponding contents have been given. The first exam of BLOCK 1 will be during the month of APRIL and the first exam of BLOCK 2 will be at the end of MAY.

2. The second exams (second chance) of each of the blocks will be held on the day of the date determined for the final exam of the subject.

In addition, students who attend classes regularly may voluntarily take the continuous assessment controls (0.5 points each) of the didactic units to add them to the result of the exams of the corresponding blocks.

Those who in the ordinary call of June have not passed EF with at least 5 points on 10 points, will be examined of both blocks in the following calls.

CHARACTERIZATION AND QUALIFICATION OF COMPUTER PRACTICES (EC):

OPTION CONTINUOUS EVALUATION: 3 practical evaluations (ON-LINE), which will consist of problem solving with EXCEL: First evaluation: PRACTICE 1, 2 AND 3 Second evaluation: PRACTICE 4 AND 5 Third evaluation: PRACTICE 6 AND 7 In order to be considered to have passed CE by continuous assessment, an average grade of 4.5 points or above (above 10 points) must be obtained. In case of not fulfilling the above conditions the final exam of practices can be done.

OPTION SINGLE FINAL EXAM: Conducting a final exam, which will consist of solving problems with EXCEL, without using any support material, except the help offered by the EXCEL program itself. To pass EC you will need to get a score of 4.5 points (over 10 points) on the exam.

A UNIQUE FINAL EXAM:

Those students who want to make a unique final exam must make the written (EF) and computer (EC) exams planned for the day of the corresponding official call. To pass the subject a final grade of at least 5 points out of 10 points must be obtained. The final grade is calculated as follows:

FINAL GRADE = 0.75xEF + 0.25xEC.

Taking into account the minimal requirements for each part pointed out at the beginning.

#### Correction criteria

CHARACTERIZATION AND FINAL QUALIFICATION OF EXAMINATIONS (EF):

The exams will be written to solve problems and questions related to the contents of the subject. Each problem or issue will be scored according to the quality of its approach and numerical resolution. The score of each exam will be about 10 points.

CHARACTERIZATION AND QUALIFICATION SCORE FOR TUTORIALS, PARTICIPATION IN CLASS AND IN THE ACTIVITIES TO BE PROGRAMED:

The number and the quality of the class participations will be fundamentally evaluated. A minimum grade is not necessary to overcome this part.