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

Comments

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 -

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.

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

Data Delight

Search This Blog