project1

PROJECT 2

project1

project 2

project 1

d. Make Customized Ribbon by naming ABC and keep all data formatting commands in the newly created Ribbon. ANS:

Q) Create VBA Code to convert selected data into pdf from applicant data Q) Check Spelling mistakes in the workbook using VBA Code

project1 Q1) -A pie graph of women inBiological ScientistsChemists & Materials ScientistsComputer & Mathematical OccupationsEngineers & Architects   -The trend of percent women graduating in Computer science and Engineering from 2000-2015 What percent of women are graduating from stem majors (Computer…

Q1)Why there is a difference in the formula of variance for population and sample ANS: There is a difference in the fromula of a variance for the population and sample that why Because variance is calculated generally as sum[(obs – mean)^2]/(number of obs.) for the population, but sometimes sample mean comes out to be…

Q1)Calculate all 4 business moments using pen and paper for the below data set?     Q2)What is the significance of expected value when simple mean (Sum of all observations/number of observations) is already in place ANS:Expected value is used when we want to calculate the mean of a probability distribution. This…

Q1)Perform Gradient Descent in Python with any loss function ANS:Explanation about the code first we need to take all the requiered libraries and import it ,after that Initial data and parameters are initialized, next run a main body ,after that ,If the condition J>tol is true, then the while loop will be executed…

Q1)Pros and cons of SVM ANS: PROS OF SVM: SVM classifiers perform well in high-dimensional space and have excellent accuracy. SVM classifiers require less memory because they only use a portion of the training data. SVM performs reasonably well when there is a large gap between classes. High-dimensional spaces are better…

Q2)What are the pros and cons of knn ANS: PROS OF KNN: KNN is known for its simplicity, comprehensibility, and scalability. Learning and implementation are extremely simple and intuitive. It is easy to interpret. The mathematical computations are easy to comprehend and understand. The calculation time is less. Predictive…

Q1)What is a Neural Network? ANS: Neural networks, also known as artificial neural networks (ANNs) or simulated neural networks (SNNs), are a subset of Machine Learning and are at the heart of deep learning algorithms. Their name and structure are inspired by the human brain, mimicking the way that biological neurons signal…

Q1)How does similarity is calculated if data is categorical in nature ANS: similarity in categorical data is not as direct when itcomes to numerical data. the categorical data is first tranformed to numerical values and both are standardised to make sense of the similarity and dissimilarity between/among those features

project 1

Summary: In both the clustering method the optimum number of clusters were found to be 3. The Clusters form in both the algorithms were exactly the same.