Skip to main content

Posts

Ms Excel - Templates

 Creating a Template Goto the file section and choose on New button and select the template that you want Saving the template  Goto Save as and choose to save in Excel Template format as shown below
Recent posts

Ms Excel - Charts

Creating Charts in Excel Choose a the collection of cells for which you want to build charts out of and select charts option near recommended charts button from insert toolbar  And then select the type of chart that you want to build  Moving the charts to another sheet Select the chart and go into the design page and choose move chart , as shown below Creating Pie charts Choose the data that you need in to illustrate in a Pie chart and then choose pie chart option from charts bar, and customize your Pie chart by choosing on necessary attributes inside the '+' button next to the chart They can only handle single row or single column of data.

Excel Course - Beginner to Advanced - Udemy Notes - Basic operations in Excel and how to do it

  Ribbon tab - the top tool-bar of the Excel Sheets  Formula bar - the bar below the Ribbon Tab of the excel sheet Status bar - the bottom most tool bar where you can zoom in and zoom out of an excel sheet Excel workbook - A sheet of an excel, where it is made up of Rows and columns - it has about some 1,048,576 ROWS and 16,384 COLUMNS  Upto 256 Sheets can be added for Excel to optimally work, but then the limit on the number of sheets that can be added totally depends on the Processing power of the CPU To change the number type format ·          Home -> number format -> change the type of number format Relative reference It refers to the way by which Cells across another locations can be referenced and used from some other cell position - Example as given below, Values from B4 to B8 can be referenced and added in another totally different position ABSOLUTE REFERENCE - When some cells are referenced by absolute reference then the reference of it does not change

Cdf, Pdf and P - Value Explained

The probability density function ( pdf ) and cumulative distribution function ( cdf ) are two of the most important statistical functions in reliability and are very closely related. When these functions are known, almost any other reliability measure of interest can be derived or obtained. Figure 1 Figure 2 PDF - Probability Density Function or density  of a continuous random variable , is a function  whose value at any given sample (or point) in the sample space  (the set of possible values taken by the random variable) can be interpreted as providing a relative likelihood that the value of the random variable would equal that sample In a more precise sense , the PDF is used to specify the probability of a random variable falling within a particular range of values , as opposed to taking one value.   CDF -  cumulative distribution function  ( CDF ) of a real-valued random variable   X, or just  distribution function  of  X, evaluated at  x, is the probability  that  X will take

Sigmoid Function Simplified

                             Sigmoid function Equation Definition  Technical Wikipedia Definition :  A sigmoid function is a bounded , differentiable , real function that is defined for all real input values and has a non-negative derivative at each point  and exactly one inflection point. Simple Definition - It is basically a 'S' curve or activator function which is commonly used in Machine Learning, it is used to bound/transform/squash a wide range of values within [0,1]. Basic illustration of how Sigmoid Function works, Defining the Input - Array containing 99999 equally spaced numbers between -10,10 Defining the Sigmoid Function -  Plot of the transformed values -   Graph between input and transformed output                                              Distplot of the Transformed values As we can see from the above plots the values are bounded between 0,1 for any given value. Plot if it had been e^x instead of e^-x : Now going back to the Technical Definition, A sigmoid

SQL Murder Mystery - Knight Lab

  SQL Murder mystery is a project by Knight Lab team. Which focusses on using SQL Queries to solve a case which involves in finding the killer behind a murder crime. This blog walks through the approach i did in order to find the killer behind this murder. So this is the Schema Diagram of the given tables, which we should use to figure out the killer. get_fit_now_check_in - this table gives information about checkin details of each member of the gym get_fit_now_member - this table contains information about the general details of a member of the gym person - this table contains information about the address details of the person drivers_license - this table contains information about the vehicle used by the person interview - this table contains the information regarding what the person revealed during the interview with the detectives facebook_event_checkin - this table contains information about the events the person attended and uploaded about on facebook crime_scene_report -