|
|
-
|
|
In this article we will see the implementation of Excel's Simple Linear regression function and Multi Linear Regression in C#
Excel's Simple Linear Regression function
public static Dictionary SimpleLR(List X, List Y)
{
///Variable declarations
int num = 0; //use for List coun......
|
|
-
|
|
In this article we will see how to open the IE explorer using Interop.SHDocVw.dll
public class IEUtil
{
///
/// Function:OpenIE
/// Opens the IE explorer
/// Note: COM reference to "Microsoft Internet Controls"
/// will give an Interop.SHDocVw.dll assembly,
/// and the SHDocVw n......
|
|
-
|
|
In this short article we will look into how can we post a message/twit in Twitter application
Before going to do any programming, first we need to create an application in Twitter. We will follow the below steps for doing so.
Steps to create an application
Step 1: We need to create an Twitter ap......
|
|
-
|
|
Total number of rows or records.
e.g. We have a set with 10 elements. We need to find the Percentile_Disc of the 7th row.Let us first find the Cumulative_distribution as
So, Cumulative_Distribution = (7)/(10) = 0.7
So, Percentile_Disc = Cumulative_Distribution * N = 0.7 * 10 = 7
The range of v......
|
|
-
|
|
Percentile_Cont Function
Purpose: An inverse distribution function which takes a percentile value and a sort specification and returns an interpolated value that would fall into that percentile value with respect to the sort specification.It accepts any numeric datatype or any nonnumeric datatype t......
|
|
-
|
|
Cume_Dist Function
Purpose: Within a group of rows, it calculates the cumulative distribution of a value in a group of values.
Syntax: Cume_Dist() Over ([partition_by_clause] order_by_clause)
Formula:
Cumulative_Distribution = (R)/(N)
Where,
R => The row whose rank needs to be found
N => Tot......
|
|
-
|
|
Percent_Rank Function
Purpose: Within a group of rows, it calculates the relative rank of a row.
Syntax: Percent_Rank () Over ( [partition_by_clause] order_by_clause)
Formula:
Percent_Rank = (R -1)/(N-1)
Where,
R => The row whose rank needs to be found
N => Total number of rows or records.
......
|
|
-
|
|
Last_Value
Purpose: Returns the last value from the order set of values.
Syntax: Last_Value(expression) over( [ Partition_By_clause] order by clause [rows_range_clause])
Where,
Expression => A table column or built-in function but not analytical functions
Rows_range_clause => It helps to f......
|
|
-
|
|
An Introduction to SSIS Balanced Data Distributor Transformation Component
Table of Content
Introduction
How it Works
Adding Balanced Data Distributor(BDD) in the SSIS toolbox
Let us look an example
When to use the BDD
References
Conclusion
Introduction
Microsoft has released ......
|
|
-
|
|
First_Value Function
Purpose: It returns the first value from the order set of values.
Syntax: First_Value(expression) over( [ Partition_By_clause] order by clause [rows_range_clause])
Where,
Expression => A table column or built-in function but not analytical functions.
Rows_range_clause =......
|
|