Correlation application on Stock Analysis- Google Colab Python

 

#Correlation #StockAnalysis #GoogleColab Correlation explains the relationship between two variables, Correlation coefficient is a measure to define the strength of relationship between variables. Correlation coefficient lies between -1 to +1. Google Colab Python is used to calculate Correlation Coefficient with simple codes. Correlation matrix / Correlation Plot creation is explained in this video. Application of Correlation in stock analysis with real time example explaining correlation between Sensex and TCS price is explained in the video. 00:00 Correlation 01:58 Correlation Matrix 05:42 Correlation plot / Correlation heatmap 11:50 Correlation application on Stock Analysis 14:42 Conclusion Google Colab Python Playlist - https://www.youtube.com/watch?v=pedhtDm-qhc&list=PLIo8gVJ3Lwqhq_C0-OrWxxJsCpAgNYMNi If you have any queries, please post it in comment section.

Nested IF Vs Vlookup Vs Lookup - Excel tips and tricks

 

Watch the video above...

#NestedIF #Vlookup #Excel As a part of Excel tips and tricks we have posted this video - Nested IF Vs Vlookup Vs Lookup, all three functions give similar results which you can learn and apply based on your comfortability. Nested IF formula looks longer compared to Vlookup and #Lookup formula. Vlookup requires an array / table of conditions to return result. People who are finding difficult in using Nested IF formula then they may use Vlookup or lookup formula in Excel. 00:00 Introduction 01:03 Nested IF Function 02:51 Vlookup Function 05:08 Lookup function 06:36 Data Validation 08:35 Conclusion Excel tips and tricks Playlist - https://www.youtube.com/watch?v=6xjqhQXHGMg&list=PLIo8gVJ3LwqhkLGdoyZWW1UTKUT2jGXHV If you have any queries, please post it in comment section...

Optimization Model - Production Planning - Maximize Profit - Part 2

 

Watch the video above...

#Optimization #ProductionPlan #MaximizeProfit Optimization models for decision making is very important on #business point of view, primary objective of any business is to maximize profit and minimize cost. Optimization models and methods are effective and help businesses to achieve their objectives. Production plan plays a vital role in any #manufacturing company in maximizing production considering constraints at minimum cost and achieving maximum profit or maximum #production to the company. Applying optimization techniques in production planning will surely helps the company to maximize their profit with available resources. Video shows how to Maximize profit using linear programming through excel solver, maximize profit in business will become easy task. Minimize cost can also achieved through Optimization model excel Optimization Model - Production Planning - Maximize Profit - Part 1 : https://youtu.be/MT0_Zg1wDlo In Part 2, we have worked on maximizing profit by increasing number of machines to ensure biscuit manufacturing at the rate of 3 tons per hour, further we have shown how to utilize excel solver to find optimum number of machines to maximize profit with the available inventory. 00:00 Introduction 01:27 Maximize profit with fixed number of machines 05:07 Finding Optimum Number of machines to maximize profit 08:43 Revising all four scenarios of Production Plan 09:15 Conclusion If you have any queries, please post it in comment section or at our blog - https://pakuppaivu.blogspot.com

Descriptive Statistics - Box plot and Histogram in Google Colab Python

Watch the video above...

 #BoxPlot #Histogram #Colab

Creating Box plot / whisker's plot and histogram using Google Colab #python will become simple task after watching this video. We have explained the need to use Python for chart preparation on comparison to Spreadsheet as Python helps to create charts with better visualization by writing simple codes and also it saves time which in turn will improve the productivity of Data #Analysts. Histogram and Box plot plays a vital role in Descriptive Statistics. Both plots are used to visualized the spread range of data. Histogram shows the frequency in bar graph format whereas box plot is representation of the distribution of a variable through its quartiles. Various types of #distribution in histogram - a) Normal Distribution, b)Right Skewed / Positively Skewed distribution, c) Left Skewed / Negatively Skewed distribution Some the important things we need to know about box plots are, a) Inter-Quartile Range (IQR) :Central 50% data spread, 25th Percentile to 75th Percentile of data spread. i.e., IQR = Value of 75th Percentile - Value of 25th Percentile b) Upper Control Limit (UCL) : 75th Percentile + 1.5*IQR or Maximum c) Lower Control Limit (LCL) : 25th Percentile - 1.5*IQR or Minimum d) Outliers: Any value above upper control limit and any value below lower control limit We have explained all the above statistical details related to histogram and box plot in this video. 00:00 Introduction 01:23 Creating Histogram in Google Colab Python 04:32 Right Skewed & Left Skewed Histogram 06:49 Creating Box Plot in Google Colab Python 11:56 Box plot showing relationship 14:41 Conclusion If you have any queries please post it in comment section or at our blog - https://pakuppaivu.blogspot.com

Optimization Model - Production Planning - Maximize Profit - Part 1

Watch the video above...

 #Optimization #ProductionPlan #MaximizeProfit

Optimization models for decision making is very important on #business point of view, primary objective of any business is to maximize profit and minimize cost. Optimization models and methods are effective and help businesses to achieve their objectives. Production Plan plays a vital role in any #manufacturing company in maximizing production considering constraints at minimum cost and achieving maximum profit or maximum #production to the company. Applying optimization techniques in production planning will surely helps the company to maximize their profit with available resources. 00:00 What is #Optimization? 01:10 Explaining Business Case 02:36 Building Optimization Model 04:48 Production Plan for Optimizing / Maximizing Profit with Inventory Constraint 08:10 Maximizing Profit with Inventory and Machine constraints 12:48 Impact of additional constraint on profit explained 14:01 Conclusion If you have any queries, please post it in comment section or at our blog - https://pakuppaivu.blogspot.com

Year, Month, Day, Weekday, Hour from Date - Google Colab Python

 

Watch the video above...

#DateTime #GoogleColab #Python Extract Year, Month, Day, Weekday, Hour from Date is very useful when performing #DataAnalysis to show different dimensions of analysis. In this video we have used Google Colab Python to extract month, weekday, hour, minute, day from date using Pandas and "DateTime" package in Python. After watching this video, you will find easy to extract, 1. Year from Date in Python 2. Month from Date in Python 3. Day of month from Date in Python 4. Weekday from Date in Python 5. Hour from Date in Python 6. Minute from Date in Python 7. Week of Year from Date in Python You will also learn about how to create a new column or new variable in data frame in Google Colab Python. Creating new variable is one of the methods in #DataEngineering of Data Analysis. Python datetime package is used to calculate day of week from date, day name from date, month from date, week number from date. 00:00 Introduction 01:38 Understanding the necessity 02:50 Month from Date in Python 04:41 Day of Month from Date in Python 05:54 Weekday from Date in Python 06:15 Month Name from Date in Python 07:04 Week Day Name from Date in Python 08:10 Hour from DateTime in Python 08:23 Minute from DateTime in Python 08:49 Week of Year from Date in Python 09:29 Final Dataset with new columns for Month, Day, Hour, Week extracted from Date 11:58 Conclusion Google Colab Python Playlist - https://www.youtube.com/watch?v=pedhtDm-qhc&list=PLIo8gVJ3Lwqhq_C0-OrWxxJsCpAgNYMNi If you have any queries, please post it in comment section.

Radio Button, Name Manager & Hash(#) application in Excel Charts

 

Watch video above...

#RadioButton #NameManager #ExcelCharts #Pakuppaivu channel's last video on Excel shown about Radio Button in #Excel. Excel Charts with Radio Button is extensively used in #Dashboards. In this video we have explained 1. #Howto #sort filtered data table and bar in charts 2. Name Manager 3. Application of Hash (#) in array 4. Application of Name Manager in Excel Charts 5. How to dynamically select data for Excel Charts 6. Creating Excel Chart with Radio Button 00:00 Introduction 00:42 Sort Function in Excel 02:35 Accessing Name Manager 03:24 Application of Hash (#) 05:41 Application of Name Manager in Excel Chart 06:54 Dynamic Selection of Chart Data with Radio Button 07:30 Conclusion Last video on how to create Radio Button in Excel - https://www.youtube.com/watch?v=9r2lNH8VWZ0 If you have any queries post it at comment section...