Docsity
Log inSign up
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Excel Charts and Pivot Tables, Study Guides, Projects, Research of Design

Design

An analysis of student data using excel charts and pivot tables. It includes a gender-based chart, an age range chart, and a detailed pivot table showing the number of students and their department of residence. The analysis provides insights into the gender distribution of students, the age range of the student population, and the geographic distribution of students across different regions of colombia. The document could be useful for students, instructors, or researchers interested in understanding student demographics and trends in the education sector.

Typology: Study Guides, Projects, Research

2023/2024

Uploaded on 07/31/2024

angelica-suaza-lopez
angelica-suaza-lopez 🇺🇸

4 documents

1 / 5

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Gráficos y tabla dinámica en Excel.
Presentado por:
Angelica Suaza Lopez
Instructor:
Ruberney
SERVICIO NACIONAL DE APRENDIZAJE –
SENA
ANÁLISIS Y DESARROLLO DE SOFTWARE
(2977410)
pf3
pf4
pf5

Partial preview of the text

Download Excel Charts and Pivot Tables and more Study Guides, Projects, Research Design in PDF only on Docsity!

Gráficos y tabla dinámica en Excel.

Presentado por:

Angelica Suaza Lopez

Instructor:

Ruberney

SERVICIO NACIONAL DE APRENDIZAJE –

SENA

ANÁLISIS Y DESARROLLO DE SOFTWARE

Medellín

Colombia

Realizar un gráfico por género y otro

gráfico por rango de edades.

Grafico por genero

Etiquetas de columna F M Total general Cuenta de ESTU_CONSECUTIVO 57199

Total 0 10000 20000 30000 40000 50000 60000 70000 F M En este grafico podemos observar que es mayor la cantidad del genero femenino que esta cursando sus estudios con una diferencia de 15,838 estudiantes, es decir el 58% de la población estudiantil es del genero femenino.

En esta tabla tenemos todos los datos sobre la cantidad de

estudiantes que hay en cada departamento del país y los del extrangero podemos ver que departamentos, municipios

  • CAQUETA
  • CASANARE
  • CAUCA
  • CESAR
  • CHOCO
  • CORDOBA
  • CUNDINAMARCA
  • EXTRANJERO
  • GUAINIA
  • GUAVIARE
  • HUILA
  • LA GUAJIRA
  • MAGDALENA
  • META
  • NARIÑO
  • NORTE SANTANDER
  • PUTUMAYO
  • QUINDIO
  • RISARALDA
  • SAN ANDRES
  • SANTANDER
  • SUCRE
  • TOLIMA
  • VALLE
  • VAUPES
  • VICHADA
  • (en blanco)
  • SI
    • BOGOTÁ
    • (en blanco)
  • Total general