See pdf file for the detailed analysis report on Philippine Healthcare System
Performing statistical analysis and modeling on the Philippine healthcare system using Excel involves utilizing spreadsheet functions and tools to analyze and interpret data related to various aspects of healthcare in the Philippines.
Objective:
The objective of the statistical analysis and modeling using Excel on the Philippine healthcare system is to gain insights into the key factors influencing healthcare outcomes, resource allocation, and overall system performance. This analysis aims to provide a data-driven understanding of the current state of healthcare in the Philippines and identify areas for improvement.
Data Collection:
Gathering relevant data from reliable sources. Our data sources is from psa.gov.ph, doh.gov.ph, WHO
Descriptive Statistics:
Utilize Excel's statistical functions to generate descriptive statistics such as mean, median, mode, standard deviation, and percentiles. This provides an initial overview of the data and helps identify patterns or trends.
Data Visualization:
Created charts and graphs in Excel to visually represent key insights from the data. This can effectively illustrate trends in population health, healthcare infrastructure, and financial aspects of the system.
Regression Analysis:
Perform regression analysis to identify relationships between different variables.
Predictive and Prescriptive Analysis using Excel:
We use Excel's modeling capabilities to predict and create a possible best scenarios and assess their potential impact on the healthcare system. This include changes in funding, improvement in healthcare infrastructure, etc.
Conclusion and Recommendations:
We conclude that Philippine healthcare needs a lot of improvements and which should be prioritize from our analysis. We also provide recommendations for improving the Philippine healthcare system based on the identified sectors and insights.
By leveraging Excel's analytical tools, the statistical analysis and modeling process can offer valuable insights into the Philippine healthcare system, supporting evidence-based decision-making for policymakers, healthcare professionals, and other stakeholders.