Midterm Exam
Data Science ~ ITSB ~ Class B
1 Instructions
You are provided with a dataset containing numerical and categorical variables. Using this dataset, complete the following tasks to demonstrate your understanding of data visualization, central tendency analysis, and measures of dispersion.
1.1 Data Visualization
- Create at least five types of visualizations (e.g.,
bar chart, histogram, and line-chart) to explore the data.
- Label each graph clearly with appropriate titles, axis
labels, and legends.
- Briefly interpret each visualization (e.g., describe trends, patterns, or potential outliers).
1.2 Central Tendency Analysis
- Calculate the mean, median, and mode for at least
two numerical variables.
- Compare and interpret the results — discuss what each measure
indicates about the data distribution.
- Identify any skewness in the data based on the relationship between the mean, median, and mode (use Histogram).
1.3 Measures of Dispersion
- Compute the range, variance, standard deviation, and
interquartile range (IQR) for the same numerical variables used
above.
- Interpret these values — explain what they reveal about the
spread or variability in the dataset (use Box-plot,
Histogram, and Scatter-plot).
- Identify which variable shows greater variability and discuss possible reasons.
1.4 Summary and Interpretation
Write a short summary (150–200 words) explaining the overall findings
from your analysis.
Your summary should address: - Which variables are most consistent (low
dispersion)
- Which variables show the greatest variation
- What patterns or insights you discovered through visualization
2 Group Assignments
To enhance collaborative learning and the application of statistical concepts, students are divided into five groups. Each group will work on assigned case studies and publish their analysis using R Markdown and RPubs. The project aims to develop analytical, technical, and communication skills through both written and video presentations.
- Work in Groups
Each group listed below must collaborate to complete a data analysis project based on materials from Chapters 1–5 of the course book.
Develop an R Markdown Report:
- Use RStudio to create a report in .Rmd format.
- Include data import, visualization, and interpretation.
- Publish the final report on RPubs.
Add a YouTube Explanation Video:
- Each group must actively stand up to create a 5–10 minute video presentation explaining the content of their RPubs report.
- Upload the video to YouTube.
- Include the YouTube video link at the end of your RPubs page under the section “Video Explanation”.
| Group | Student ID | Name | Dataset |
|---|---|---|---|
| Group 1 | 52250044 | Cloise Shafira | Education Dataset |
| 52250051 | Carol Dupino Pereira | ||
| 52250052 | Refantanur Husnul Haqib | ||
| 52250053 | Cahaya Medina Semidang | ||
| 52250054 | Raihania Syah Putri | ||
| Group 2 | 52250056 | Naifah Edria Arta | Hospital Dataset |
| 52250057 | Kayla Aprilia | ||
| 52250058 | Morris Alexander Pangaribuan | ||
| 52250059 | Fityanandra Athar Adyaksa | ||
| 52250060 | Syafif Azmi Lontoh | ||
| 52250061 | Boma Satrio Wicaksono Dewantoro | ||
| Group 3 | 52250062 | Frizzy Lithmentsyah | Business Dataset |
| 52250063 | Angelica Florentina M | ||
| 52250064 | Adam Richie Wijaya | ||
| 52250065 | Andre | ||
| 52250066 | Muhammad Nabil Khairil Anam | ||
| 52250068 | Chandra Rizal Alamsyah | ||
| Group 4 | 52250069 | Lulu Najla Salsabilla | Insurance Dataset |
| 52250070 | Naila Syahrani Putri | ||
| 52250071 | Dameria Adelina Mini Simarmata | ||
| 52250072 | Ni. Md Aurora Sekarningrum | ||
| 52250073 | Ignasius Rabi Blolong | ||
| Group 5 | 52250074 | Adinda Maiza Ishfahani | Investment Dataset |
| 52250075 | Chricyesia Winnerlady Frexisovara Uvas | ||
| 52250076 | Januaria Teresinha | ||
| 52250077 | Octavia Maia Rego | ||
| 52250055 | Adinda Adelia Futri |
3 Dataset
3.1 Sales Dataset
In the modern business era, strategic decisions are no longer made based solely on intuition but must be supported by comprehensive data analysis. Sales data, marketing expenditures, customer satisfaction levels, and organizational characteristics such as store size and managerial experience can all provide valuable insights into business performance.
3.2 Urban Business Dataset
In rapidly growing urban economies, businesses operate within highly dynamic environments influenced by population density, consumer preferences, technological adaptation, and competitive markets. Understanding the factors that drive monthly revenue — such as marketing expenditure, product pricing, workforce size, managerial experience, and customer satisfaction — has become increasingly vital for strategic decision-making.
Urban business performance also varies by city and industry sector, with unique patterns emerging between retail, technology, manufacturing, and food & beverage sectors. To uncover these patterns, it is necessary to apply data visualization, measures of central tendency, and measures of dispersion to explore how revenue fluctuates across business types, cities, and sales channels.
By conducting this descriptive and visual analysis, organizations can identify not only performance gaps but also opportunities for optimization in marketing strategy, pricing, and human resource management.
3.3 Hospital Dataset
In the modern healthcare system, hospitals generate massive amounts of data every day—from patient admissions, treatment records, and medication usage to doctor performance and cost management. These data hold valuable insights that can help improve patient outcomes, optimize operational efficiency, and support evidence-based decision-making.
However, healthcare data are often complex, involving both categorical variables (such as department, patient type, or region) and numerical variables (such as patient age, treatment cost, and recovery time). To make sense of this complexity, it is crucial to apply descriptive statistical analysis and data visualization methods.
Through measures such as central tendency (mean, median, mode) and dispersion (range, variance, standard deviation), analysts can understand variations in patient outcomes, resource allocation, and treatment performance.
3.4 Insurance Dataset
In the insurance industry, data-driven decision-making plays a vital role in managing risk, pricing policies, and predicting customer claims. Each insured individual represents a unique combination of demographic, behavioral, and health-related characteristics that collectively determine their risk profile and potential claim cost.
However, analyzing such data is challenging due to the interaction between categorical variables (e.g., region, insurance plan, smoking status, employment type) and numerical variables (e.g., age, BMI, income, and health score). Understanding these relationships requires the use of descriptive statistics, data visualization, and statistical modeling techniques. By applying measures of central tendency and measures of dispersion, analysts can explore the variability of claims across different customer segments.
3.5 Investment Dataset
Investment decisions in the modern financial landscape are increasingly complex and influenced by multiple economic and personal factors. Investors differ not only in terms of age, income level, and financial goals, but also in their risk tolerance and investment strategies. These variations contribute to diverse investment outcomes in terms of return, volatility, and asset growth.
To better understand investor behavior and performance, a comprehensive analytical approach is required. The dataset includes categorical variables such as investor segment, region, and investment type, along with numerical variables including investment amount, risk score, portfolio diversification, and annual return percentage.
Through the use of descriptive statistics, such as measures of central tendency (mean, median) and measures of dispersion (standard deviation, variance), analysts can quantify and visualize variations in investor performance. Meanwhile, data visualization techniques provide clear insights into patterns and distributions within the dataset.