Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies

1. Perform Gradient Descent in Python with any loss function.Refer to Jupyter Notebook attached.2. Difference between L1 & L2 Gradient descent method.The L1 and L2 Gradient Descent methods refer to optimization techniques used to minimize a loss function in machine learning, often in conjunction with regularization.…

 Why there is a difference in the formula of variance for population and sampleChatGPT said:ChatGPTThe difference in the formula for variance between a population and a sample arises due to the concept of1. Population Variance:The formula for the population variance is:σ2=1N∑i=1N(xi−μ)2\sigma^2 = \frac{1}{N} \sum_{i=1}^{N}…

1)The values from the table:X:0,1,2,3,4P(X):0.35,0.25,0.15,0.15,0.101. Mean (μ):The mean is calculated as:μ=∑X⋅P(X)μ=(0⋅0.35)+(1⋅0.25)+(2⋅0.15)+(3⋅0.15)+(4⋅0.10)μ=0+0.25+0.30+0.45+0.40=1.40Mean (μ) = 1.402. Variance (σ2):The variance is:σ2=∑P(X)⋅(X−μ)2First, calculate (X−μ)2 for each X:X=0(0−1.4)2=1.96X=1(1−1.4)2=0.16X=2(2−1.4)2=0.36X=3(3−1.4)2=2.56X=4(4−1.4)2=6.76Now…

Detailed Documentation of Renewable Energy Share AnalysisBy Yeragudipati AnupamaAim:The aim of this project is to analyze the renewable energy share across various regions from 1965 to 2021, focusing on identifying global trends, regional differences, and the impact of economic development on the adoption of renewable…

Project Objective:As a Data Scientist at an international humanitarian NGO, the task is to strategically allocate $120 million in newly raised funding. The core objective is to identify and prioritize countries in dire need of aid based on socio-economic and health indicators that reflect overall development levels. Through…

I have successfully completed the project on Heart Disease Prediction using various Machine Learning Models. I tried to incorporate all Features with Target Column to identify the most important marker to predict a Heart attack. I used graphs where necessary and incorporated Skewness and Kurtosis taking each feature…

Project 1 - COVID-19 Vaccinations Trend Analysis Aim The aim of this project is to analyze the data in detail on vaccinated people and fully vaccinated people by country in 2021-2022 Introduction Since the start of the COVID-19 outbreak, WHO has worked with countries and areas in Different regions on public health measures…

I saved this Dashboard on public.tableau.com The Dashboard speaks for itself. https://public.tableau.com/views/Project2TableauLiteracyRateinTamilNaduFINAL/Dashboard1?:language=en-US&publish=yes&:display_count=n&:origin=viz_share_link  

 EDA on Vehicle Insurance Customer Data I used  pandas to create dataframes and analyzed data. I analyzed data using different criterias  Age, Vs Annual Premium Vehicle Age Vs annual premium Gender Vs annual premium Is data balanced between genders in relation to annual premium I did cleaning of  data checking nulls and…

1A: English Dictionary App I used pickle class module for file management as it can serialize data Alternatively json class can be used for file management I used decorator to check on value being added or updated into file as title case I used another decorator for adding designs. I used a dictionary to enter words…

Once a student is passed out from a Institute or College, he/she is known as Alumni of the Institute. Alumni’s career growth plays important role in Institute’s ranking and other networking activities. In this project, career choices of alumni of two Universities will be analyzed with respect to their passing…

The below is link to Dashboard https://docs.google.com/spreadsheets/d/1U2-YBp2mopGDFowI7Vaj00PJdOvxRCIc/edit?usp=drive_link&ouid=103286046492277190255&rtpof=true&sd=true   The below is link to macros file https://docs.google.com/spreadsheets/d/1km0Bm8VFvkT84pGQcgMnOc94rPY083yD/edit?usp=drive_link&ouid=103286046492277190255&rtpof=true&sd=true…

I have attached the techradar.sql file   I am still sending a copy of the contents of files techradar.sql here -- Create new schema as ecommerce-- Import .csv file users_data into MySQL-- (right click on ecommerce schema -> Table Data import Wizard -> Give path of the file -> Next -> choose options : Create…

e)