Pranav Badanapally

Temporal Analysis of Earning Trends in Boston City: Unveiling Patterns, Departments and Job Titles

Thinking of time series data as a rolling movie of a single variable, showing how it changes over time. Whether collected on a regular basis (such as hourly temperatures) or in real-time (like heart rate), this type of data is incredibly versatile and has many practical applications. These include predicting future trends – such as sales, weather, or stock prices – by analyzing past data. It can also help identify long-term patterns in complex phenomena like climate change, economic growth, and website traffic. Additionally, time series data can be used to spot anomalies, such as fraud or equipment failure. By applying various analysis techniques unlock the secrets hidden within this data. Decomposition separates trends, seasonality, and noise components. Autocorrelation and partial autocorrelation measure relationships between data points at different time lags. The Box-Cox transformation aids analysis by improving data stationarity. Powerful statistical models, like ARIMA/SARIMA, help forecast future trends and understand the data’s behavior.

Autocorrelation (ACF) and partial autocorrelation (PACF) plots are like “fingerprint” tools for time series data. They reveal patterns and dependencies between data points at different time lags. ACF shows the overall correlation, while PACF focuses on the direct relationship after accounting for previous lags. This helps identify the order of the ARIMA model, a powerful tool for capturing trends and seasonality in data. By analyzing ACF and PACF, we can build accurate SARIMAX models to forecast future values of the time series, leading to better decision-making and planning.

Hyperparameter Tuning for Xgboost: A Balancing Act

Today explored about the Xgboost and got to know its significance and it’s importance for our project . Where i have briefed about XGBoost as followed below:

XGBoost’s success hinges on fine-tuning its hyperparameters, which control its learning process. This involves balancing various tradeoffs:

Underfitting: Insufficient power, leading to poor accuracy.

Overfitting: Excessive learning, resulting in poor generalizability.

Computational cost: Time and resources required for training.

Tuning involves optimizing parameters like learning rate, n_estimators, and tree complexity. Common approaches include:

Grid search: Exhaustively testing combinations of values.

Random search: Efficiently exploring a sample of parameter combinations.

Bayesian optimization: Exploiting past results to guide further exploration.

The goal is to find a sweet spot where XGBoost effectively learns from the data without overfitting, ensuring good generalizability and maximizing performance within a reasonable time frame.

In the above, total gross earnings for top departments in Boston, Massachusetts in 2022. The graph shows that the Boston Police Department, Boston Fire Department, and Boston Public Schools Special Education are the top earners, followed by a number of other important departments. It also shows that there is a significant range in earnings between the top and bottom departments.

The Insights are:

The top five departments in terms of earnings are all essential services providers. This suggests that the city of Boston prioritizes funding for these departments.

The range in earnings between the top and bottom departments is significant. This could be due to a number of factors, such as the size of the department, the number of employees, and the type of services provided.

Overall, it provides a valuable snapshot of the total gross earnings of the top departments in Boston, Massachusetts. The data shows that the city prioritizes funding for essential services and that there is a significant range in earnings between the top and bottom departments.

The graph shows the average salary of substitute teachers in Boston Public Schools from 2018 to 2022. The average salary has increased steadily over the past five years, from $120,000 to $140,000.

This increase in salary could be due to a number of factors, such as an increase in the demand for substitute teachers, a shortage of full-time teachers, or changes in state or federal laws governing the pay of substitute teachers.

The increase in salary is a positive development for substitute teachers, as it makes the profession more attractive and financially rewarding. However, it also means that the Boston Public Schools system is spending more money on substitute teachers. This could lead to increased taxes for residents of Boston or to cuts in other areas of the Boston Public Schools budget.

Overall, the trend of increasing salaries for substitute teachers in Boston Public Schools is a complex one with a number of potential implications. It is important to continue to monitor this trend in order to understand its causes and to develop appropriate policies in response.

The bar graph showing the total earnings by top 20 departments in Boston, Massachusetts. The x-axis shows the department name, and the y-axis shows the total earnings in millions of dollars.

The top departments in terms of earnings are the Boston Police Department, Boston Fire Department, and Boston Public Schools Special Education. These departments all provide essential services to the city of Boston, and their high earnings reflect their importance.

Other notable departments with high earnings include the Boston Public Schools Substitute Teachers/Nurses, Boston Facility Management, Boston Transportation, Boston Public Library, Boston Center for Youth and Families, and Public Works Department. These departments also play important roles in the city, and their high earnings reflect their contributions.

The graph shows that there is a significant range in earnings between the top and bottom departments. For example, the Boston Police Department earned over $1.4 billion in 2022, while the Traffic Division earned just over $200 million. This range in earnings reflects the different sizes and budgets of the different departments.

Overall, the graph provides a good overview of the total earnings of the top 20 departments in Boston, Massachusetts. The data shows that the Boston Police Department, Boston Fire Department, and Boston Public Schools Special Education are the top earners, followed by a number of other important departments. The image also shows that there is a significant range in earnings between the top and bottom departments.

This graph is about total gross earnings of the Boston Fire Department (BFD) from 2018 to 2022. It shows that the total gross earnings of the BFD has increased steadily over the past five years, from $1.2 billion in 2018 to $1.4 billion in 2022.

The increase in total gross earnings could be due to a number of factors, such as an increase in the number of BFD employees, an increase in the average salary of BFD employees, or an increase in the cost of providing fire services.

The BFD is an essential service provider, and its increasing budget reflects the city’s commitment to public safety.

The increase in budget could also be due to the rising cost of living in Boston, which has led to higher salaries for all city employees.

It is important to note that the graph only shows the total gross earnings of the BFD. It does not provide any information about the cost of providing fire services, such as the cost of salaries, benefits, and equipment. Therefore, it is difficult to draw any definitive conclusions about the efficiency or effectiveness of the BFD based on the graph alone.

Overall, the image provides a good overview of the total gross earnings of the Boston Fire Department over the past five years. The data shows that the BFD’s budget has increased steadily over time, reflecting the city’s commitment to public safety.

Here the above line graph that shows the total gross earnings of substitute teachers in Boston Public Schools from 2018 to 2022. The graph shows that the total gross earnings of substitute teachers has increased steadily over the past five years, from $600 million in 2018 to $800 million in 2022.
There are a few possible explanations for this increase in earnings. One possibility is that the number of substitute teachers working in Boston Public Schools has increased. This could be due to a number of factors, such as a shortage of full-time teachers, an increase in the number of students in the Boston Public Schools system, or an increase in the number of days that full-time teachers are absent from work.

Another possibility is that the average daily pay rate for substitute teachers has increased. This could be due to a number of factors, such as increased demand for substitute teachers, collective bargaining agreements between the Boston Public Schools and the substitute teachers’ union, or changes in state or federal laws governing the pay of substitute teachers.

It is also possible that the increase in total gross earnings is due to a combination of these factors. For example, the number of substitute teachers working in Boston Public Schools may have increased while the average daily pay rate for substitute teachers has also increased.

The increase in the total gross earnings of substitute teachers in Boston Public Schools has a number of implications. First, it means that the Boston Public Schools system is spending more money on substitute teachers. This could lead to increased taxes for residents of Boston or to cuts in other areas of the Boston Public Schools budget.

Second, the increase in earnings could make substitute teaching a more attractive career choice. This could lead to an increase in the number of qualified substitute teachers available to the Boston Public Schools system.

Third, the increase in earnings could lead to improved working conditions for substitute teachers. For example, the Boston Public Schools system may be able to offer substitute teachers more benefits, such as health insurance and paid time off.

Overall, the trend of increasing earnings for substitute teachers in Boston Public Schools is a complex one with a number of potential implications. It is important to continue to monitor this trend in order to understand its causes and to develop appropriate policies in response

The above one is a line graph showing the total gross earnings of the Boston Police Department from 2018 to 2022. The graph shows that the total gross earnings of the Boston Police Department has increased steadily over the past five years, from $1.2 billion in 2018 to $1.4 billion in 2022.

There are a few possible explanations for this increase in earnings. One possibility is that the number of police officers working in the Boston Police Department has increased. This could be due to a number of factors, such as a need to increase public safety, an increase in crime rates, or an increase in the population of Boston.

Another possibility is that the average annual salary of police officers in the Boston Police Department has increased. This could be due to a number of factors, such as collective bargaining agreements between the Boston Police Department and the police officers’ union, or changes in state or federal laws governing the pay of police officers.

It is also possible that the increase in total gross earnings is due to a combination of these factors. For example, the number of police officers working in the Boston Police Department may have increased while the average annual salary of police officers in the Boston Police Department has also increased.

The increase in the total gross earnings of the Boston Police Department has a number of implications. First, it means that the city of Boston is spending more money on police protection. This could lead to increased taxes for residents of Boston or to cuts in other areas of the city’s budget.

Second, the increase in earnings could make police work a more attractive career choice. This could lead to an increase in the number of qualified police officers available to the Boston Police Department.

Third, the increase in earnings could lead to improved working conditions for police officers. For example, the city of Boston may be able to offer police officers more benefits, such as health insurance and paid time off.

Overall, the trend of increasing earnings for police officers in the Boston Police Department is a complex one with a number of potential implications. It is important to continue to monitor this trend in order to understand its causes and to develop appropriate policies in response.

In addition to the above insights, the following can also be observed from the graph:

The increase in total gross earnings has not been uniform over the past five years. There has been a gradual increase in earnings from 2018 to 2021, followed by a sharper increase in 2022.

The increase in earnings in 2022 may be due to a number of factors, such as the COVID-19 pandemic, which led to an increase in demand for police services, or the social unrest that occurred in Boston in 2020.

 

project_2_final_cut

Time series data captures the evolution of a variable over time, like a movie reel of events. It can be collected regularly (e.g., hourly temperatures) or at any moment (e.g., real-time heart rate). This data has diverse applications, including:

Forecasting future trends: Predict sales, weather, or stock prices based on historical data, identifying long-term patterns, spotting anomalies: Detect unusual events like fraud or equipment failure.

This data-driven approach offers valuable insights for informed decisions across various fields, but challenges like missing data and outliers must be addressed.

Every year, the City of Boston releases its “Employee Earnings Report”, a valuable and extensive collection of payroll data for its workers. This report covers a variety of information, such as the employees’ names, job details, and earnings breakdown. The breakdown of earnings is particularly thorough, including details on base salary, overtime pay, and total compensation for every employee.

This dataset reveals a wealth of valuable insights about the financial landscape of the City’s workforce. By delving into the Yearly Employee Earnings Report, one can uncover a deeper understanding of how wages and compensation are shaped over time. The inclusion of detailed categories such as base salary and overtime further enrich the analysis, allowing for a comprehensive examination of the various factors influencing overall earnings. Notably, the annual nature of the report adds a temporal dimension to the data. Each year’s release serves as a timestamped snapshot of the earnings landscape for City of Boston employees. This temporal structure lays the foundation for time series analysis, providing a framework for examining trends, seasonal patterns, and shifts in compensation trends over the years.

By utilizing time series methods, we have the opportunity to reveal noteworthy trends in base salary, pinpoint peak periods of overtime, and evaluate the overall progression of total compensation. Through the implementation of statistical techniques and modeling, we can make projections on future earning patterns and gain a deeper understanding of the intricate financial landscape within the workforce.