Multiple Econometrics Projects
Part 1: CigInc Health Effects Project:
Regression Models (SLR & MLR) on how Cigarette use, Family Income Levels, & Birth weight influence one another. Data retrieved from the Wooldridge package in the "bwght" dataset.
Part 2: House Price Estimation/Prediction:
Regression model (MLR) on whether an individual paid over or under the estimated/predicted house price based on the size and number of bedrooms. Data retrieved from the Wooldridge package in the "hprice" dataset.
Part 3: Predicting Attendance Rates based on ACT score and GPA:
Regression model (MLR) on predicted attendance rated based on ACT score and GPA. Data retrieved from the Wooldridge package in the "attend" dataset.
Part 4: How Net Financial Assets is correlated with Annual Income and Age Increase:
Regression model (MLR) on showing the relation between Net Financial Assets, Annual Income, and Age Increase, along with another model on single households. Data retrieved from the Wooldridge package in the "401ksubs" dataset.
Part 5: Mathematical Regression based on set parameters
Regression models (3 total, 1 SLR, 2 MLR) on given mathematical problems, and practicing using variables in R, dataset created in R.
close modal
Sales Analysis - Power B.I.
Overview
- Data being pulled from SQL Server & multiple online resources
- Sources Setup and feed in via Power Query
- Automated Visualizations which update based on new data
- Visualized in Power B.I.
- Responsive Dataset Feeds & Visualizations
Full Summary
Sales & Logistics Analysis - Power B.I.
Utilized Power B.I., Power Query, Power Pivot, SQL, and Excel to organize, automate, and create responsive visualizations that are updated as new data comes in.
This project was from my Advanced Excel Data Analytics class. The Sales & Logistics Analysis project is based on common situations that Data and Business Analysts encounter when analyzing data and effective ways to solve these problems through creating responsive datasets that update directly from multiple databases and sources, responsive data paths and configurations, and responsive visualizations.
close modal
Credit Analysis
Overview
- Credit Analysis
- KNN Model
- Financial Visualization in Tableau
- Predictive Model on Credit Risk
Full Summary
Credit Analysis KNN Project
The Credit Analysis with KNN project was one of the final projects for my Predictive Modeling class.
In this project I utilized R to conduct a K Nearest Neighbor regression model and used Credit data to identify the likelihood of default based on a variety of characteristics and creditworthiness based on the defined parameters. I then visualized the data with Tableau.
close modal
Housing Price Analysis
Overview
- Financial Analysis
- Housing Appraisal Modeling
- Logistic Regression
- Predictive & Estimation/Explanatory Models on House Prices
Full Summary
Housing Price Analysis
In this Housing Financial Analysis project, Logistic Regression was used to analyze how House Prices change as a result of a variety of characteristics/parameters: the size in square feet, number of bedrooms, lot size, and distance from newly built negative external structures (like an incinerator built) and how each of these influence the projected house price.
close modal
Healthcare Rates Analysis
Overview
- Financial Analysis
- Healthcare Modeling
- Logistic Regression
- Predicting Healthcare Rates
Full Summary
Healthcare Rates Analysis
The Healthcare project was a part of another final project for my Predictive Modeling class where I utilized: R, Excel, and Tableau to analyze Healthcare outcomes and rates based on the results.
Log. Transforms were utilized to fit the data to a Normal Distribution since the context of the given healthcare data fits into this format well without overfitting/confounding the data.
The Test & Training models along with the Logistic Regression aim to identify the related outcomes and rates according to the available data in the context of Healthcare Insurance Analysis.
close modal
More Projects
Python Business Analytics: Sales Analysis Conducted Sales Analysis using Python, Excel, & Git/Github in my Python Business Analytics class. In this project I used Python to conduct sales and pricing analyses that business and data analysts commonly encounter.
Relationship Wage Project Analysis on the difference between relationship status and wage (Married, Nonmarried, & Single), and how other variables: Education, Experience, & Income are influenced. Data retrieved from "Wage2" dataset in the Wooldridge Econometrics package.
Python Business Analytics: Consulting Visuals In this project I coordinated with a group while using Python, Excel, and Git/Github to create visualizations through Python while making commits through Git to Github, we then worked together in our partners base repository to create each visualization we were tasked with in our partners repositories.
Education & Wage Project Created Regression Models (SLR & MLR) on how each additional year of Education & Experience resulted in a change in Wage/Income. Data retrieved from "Wage2" from the Wooldridge package.
Excel Orders Project Utilized Excel to create a variety of visualizations, conduct exploratory data analysis, and create responsive datasets that are work with databases to update when new data comes in.
Survival Titanic Predictions Project Used R, Excel, and Tableau to predict which individuals had the highest chance of survival through doing: exploratory data analysis, manipulating data, creating models for prediction, and creating visualizations. This project had test and training data from Kaggle. My professor had all of us in the class try to get the highest percentage correctly predicted we could. I got the highest percent accurately predicted in the class and presented to the class identifying the methods that were used to get this percentage predicted. This project was the mid-semester project before the final in my Predictive Modeling class.
Python Business Analytics: User Audit Utilized Python, Excel, Git/Github for my Python Business Analytics class to analyze data and conduct a user audit while working cohesively in a group and committing to a partners repository on Github.
Wage Plots Project Variety of visualizations, along with additional related statistics created in R on Wage Data. Data retrieved from "Wage1" dataset in the Wooldridge package.
Part 1: Wage Data Analysis & Plots
Part 2: Education & Fertility (Fertil) Data Analysis & Plot
Part 3: Abstract Math Focused Data Analysis & Plot
Part 4: Sleep Data (Sleep75) Analysis & Plot
Part 5: Tech Exports Data Analysis & Plot
Part 6: Spacecraft Imports Data Analysis & Plot
Bip-Python-UNH Worksheets Worksheets from my Python for Business Analytics class which focused on accomplishing tasks business analysts commonly encounter, and going through essential Python that is often useful for people in Analytics positions.
Mixed Visualizations Created visualizations from my Predictive Modeling class in Tableau, while also using R and Excel to clean data. I’m currently locked out of my Tableau account and can’t access Tableau Workbook files, these are visualizations I had screenshots of which I posted on Github. My Tableau Public is still active → public.tableau.com/app/mab1096
Business Excel Projects Created a variety of visualizations and utilized excel functions to set up datasets in Excel for Business Computing Essentials class.
Created from scratch with HTML5, Javascript, & CSS by Michael Botelho 2022