Posts

Standard Deviation & Variance

Image
Standard Deviation The Standard Deviation is a measure of how spread out numbers are. Its symbol is  σ  (the greek letter sigma) The formula is easy: it is the  square root  of the  Variance.  So now you ask, "What is the Variance?"     Formulas Here are the two formulas, explained at  Standard Deviation Formulas  if you want to know more: The " Population  Standard Deviation":               The “ Sample  Standard Deviation ”:           Looks complicated, but the important change is to divide by  N-1  (instead of  N ) when calculating a Sample Variance. When you have "N" data values that are: The Population : divide by  N  when calculating Variance (like ...

The Lognormal Distribution vs. the Normal Distribution

Image
        In a normal distribution, 68% (34%+34%) of the results fall within one  standard deviation , and 95% (68%+13.5%+13.5%) fall within two standard deviations. At the center (the 0 point in the image above) the  median  (the middle value in the set), the  mode  (the value that occurs most often), and the  mean  ( arithmetic average ) are all the same.     Summary The lognormal distribution differs from the normal distribution in several ways. A major difference is in its shape: the normal distribution is symmetrical, whereas the lognormal distribution is not. Because the values in a lognormal distribution are positive, they create a right-skewed curve. The lognormal distribution model is considered to be very useful in the fields of medicine, economics, and engineering. Overall the log-normal distribution plots the log of random variables from a normal distri...

Difference between Descriptive and Inferential Statistics

Image
Difference between Descriptive and Inferential Statistics   Descriptive Statistics Use  descriptive statistics  to summarize and graph the data for a group that you choose. This process allows you to understand that specific set of observations Descriptive statistics frequently use the following statistical measures to describe groups:          I.           Central tendency : Use the  mean  or the  median  to locate the center of the dataset. This measure tells you where most values fall.      II.           Dispersion : How far out from the center do the data extend? You can use the  range  or  standard deviation  to measure the dispersion. A low dispersion indicates that the values cluster more tightly around the center. Higher dispersion signifies that data points fall further away from t...

Data Blending in Tableau

 How the data blending works in Tableau? When you use data blending to combine data, a query is sent to the database for each data source that is used on the sheet. The results of the queries, including the aggregated data, are sent back to and combined by Tableau. The view uses all rows from the primary data source, the left table, and the aggregated rows from the secondary data source, the right table, based on the dimension of the linking fields. Data Blending 1-when the dataset is from a different data source 2-Uses only left join. 3-Data can be available at different levels of granularity. 4-Sends separate queries to each dataset, aggregates, and then perform blending Tableau Public Link: https://public.tableau.com/app/profile/arabinda.mohapatra/viz/BLENDING_16509621767950/definitation?publish=yes

Relationship in Tableau

  Relationships are a dynamic, flexible way to combine data from multiple tables for analysis. We recommend using relationships as your first approach to combining your data because it makes data preparation and analysis easier and more intuitive.  ----------------------------------------------------------------------------------- Requirements for using relationships When relating tables, the fields that define the relationships  1 must have the same data type. 2-Changing the data type in the Data Source page does not change this requirement. 3- Tableau will still use the data type in the underlying database for queries. 4-You can't define relationships based on geographic fields. 5-Circular relationships aren't supported in the data model. 6-You can't define relationships between published data sources. 7- - Relationships do not allow us to decide on the join type. 8- In the earlier versions of Tableau, in the absence of a relationships, this task would have require...

Coding Challenge Part 2

  Python program to find l.c.m. of two numbers num1 = int(input("Enter first number: "))   num2 = int(input("Enter second number: "))   if num1 > num2:       greater = num1   else:       greater = num2   while(True):       if((greater % num1 == 0) and (greater % num2 == 0)):           lcm = greater           break       greater += 1   print("LCM of",num1,"and",num2,"=",greater) Python program to calculate the cube of a number num=int(input("Enter the number:-")) import math cube_n=num*num*num print("cube  OF {} is {} ".format(num,cube_n) ) Python program to calculate the square root of a number ¶ num=int(input("Enter the number:-")) if num<0:     print("Negative numbers can't have square roots") else:     import math     sqrt_n=math.sqrt(num)   ...

Python Coding Intreview question

 #Coding challenge  Python program to reverse a number n = int(input("please give a number : ")) print("before reverse your numeber is : ",n) reverse = 0 while n!=0:     reverse = reverse*10 + n%10            n = (n//10) print("After reverse : %d" %reverse)  Python program for palindrome using an iterative method n=int(input("Enter a number: ")) reverse,temp=0,n while temp!=0:     reverse=reverse*10+temp%10     temp=temp//10 if reverse==n:     print("number is palindrom") else:     print("number is not palindrom") Program to check a number is Armstrong or not in num = int(input("please give a number : ")) if num!=0:     input_number=[]     res = [int(x) for x in str(num)]     print(res)     for i in res:         input_number.append(i**3)         result = 0         for ele in range(0, len(input_n...