Midterm Exam

Data Science ~ ITSB ~ Class B

Logo


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

  1. Create at least five types of visualizations (e.g., bar chart, histogram, and line-chart) to explore the data.
  2. Label each graph clearly with appropriate titles, axis labels, and legends.
  3. Briefly interpret each visualization (e.g., describe trends, patterns, or potential outliers).

1.2 Central Tendency Analysis

  1. Calculate the mean, median, and mode for at least two numerical variables.
  2. Compare and interpret the results — discuss what each measure indicates about the data distribution.
  3. Identify any skewness in the data based on the relationship between the mean, median, and mode (use Histogram).

1.3 Measures of Dispersion

  1. Compute the range, variance, standard deviation, and interquartile range (IQR) for the same numerical variables used above.
  2. Interpret these values — explain what they reveal about the spread or variability in the dataset (use Box-plot, Histogram, and Scatter-plot).
  3. 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.