File with calculations 

 

in this sheet we have learned how to make a frequency distribution

just to explore the shape of the data. We also mentioned that
when we take a major number of values (observations) from the population with size n = 1
the distribution approaches the shape of the population distribution.
don't forget to use the formula Frequency(data, classes)
to make your histogram.
In this very first tutorial i provide the random choice of 1000 users (obseravations) for n size =1
because we have many samples of n = 1 , we can simulate the population distribution
In the next tutorial we are going to test the central limit theorem , we are going to increase the
n to n = 2 and n = 5 to approach a normal distribution.
Before you proceed with analytics, clean your data
for a range 1 - 99 in your sample an observation i.e "asd" or 999 or 99' is not acceptable
https://klout.com/corp/score"}">https://klout.com/corp/score
https://en.wikipedia.org/wiki/Klout"}">https://en.wikipedia.org/wiki/Klout
The actual source of my practice :
https://docs.google.com/spreadsheets/d/11A9tK-aRdukQ5lqTOO_yfQABJIUndmvehByu7JZtor8/edit#gid=0"}">https://docs.google.com/spreadsheets/d/11A9tK-aRdukQ5lqTOO_yfQABJIUndmvehByu7JZtor8/edit#gid=0
The n = 1 , n= 2 , n = 3 source ( needs cleaning to make sense ) :
https://docs.google.com/spreadsheets/d/1VP6RgkrrJlBjMtHoSwgBmUSqmzFuVVJ-8x1Nrmw7PZw/edit#gid=0"}">https://docs.google.com/spreadsheets/d/1VP6RgkrrJlBjMtHoSwgBmUSqmzFuVVJ-8x1Nrmw7PZw/edit#gid=0
if you want to participate with avgs :
https://docs.google.com/forms/d/1B1qKyyMYIKS-Uryi4vOm0DHwPQnQcc10XPvbnXxmQdE/viewform"}">https://docs.google.com/forms/d/1B1qKyyMYIKS-Uryi4vOm0DHwPQnQcc10XPvbnXxmQdE/viewform