PROJECT FILE FOR STATISTICS AND PROBABILITY
NAME : KRISH ISRANI
COURSE : B.S.C MATHS(HONS)
ROLL NO. : 2023MTA1009
SEMESTER : 1
PAPER CODE : MAC-103
LIST OF ALL PRACTICALS
SERIAL NO. PRACTICALS
Presentation and analysis of data (univariate and bivariate) by frequency table,descriptive statistics, stem
1 and leaf plot, dotplots, histograms, boxplots, comparative boxplots,and probability plots
2 Fitting of binomial,poisson and normal distribution
3 Illustrating central limit theorum through excel
4 Fitting of regression line using the principle of least squares
5 Computation of sample correlation coefficient
able,descriptive statistics, stem
obability plots
ares
NORMAL DISTRIBUTION:
Normal distribution, also known as the Gaussian distribution
It is a probability distribution that is symmetric about the mean
it shows that data near the mean are more frequent in occurrence than data far from the mean
In graphical form, the normal distribution appears as a "bell shaped curve".
STEPS TO FIND NORMAL DISTRIBUTION
1) Data X and its corresponding frequencies F(X)are given , calculate the sum of all frequencies using syntax =
2) Now add a heading p(x) which denotes probability of x whose values will be calculated by using the comman
3) Make sure that sum of p(x) should be 1 , find it by using syntax =SUM(RANGE1:RANGE2)
4) Select a new column and give heading MEAN .Calculate mean for every cell by using the command =X*P(X)
5) Sum up all the values of mean using the syntax=SUM(RANGE1:RANGE2)
6) Select a new column give heading variance and calculate variance for each cell
7) For variance we use this formula square of (x-mean)*p(x) we will use the command =(x-$column$cell)^2*p(x)
8) Now sum up all the values of variance using the syntax=SUM(RANGE1:RANGE2)
9) For standard deviation find root of sum of variance by using syntax =SQRT(RANGE)
10) Select a column for normal distribution and calculate using syntax=[Link](X,MEAN,STD,FALSE) put required
11) Select all cells with normal distribution then click 'insert' select chart type and further select 'lines with points' yo
X FX PX MEAN VARIANCE STD NORM .DIST NORM
0 1 0.019231 0 0.573623 2.231432 0.008943 0.2
1 1 0.019231 0.019231 0.382795 0.024224 0.18
2 3 0.057692 0.115385 0.691284 0.053676 0.16
3 5 0.096154 0.288462 0.582613 0.097294 0.14
0.12
4 7 0.134615 0.538462 0.287551 0.144269
0.1
5 10 0.192308 0.961538 0.040965 0.175
0.08
6 8 0.153846 0.923077 0.044606 0.173654
0.06
7 6 0.115385 0.807692 0.2731 0.140964
0.04
8 6 0.115385 0.923077 0.743514 0.093608 0.02
9 4 0.076923 0.692308 0.963132 0.05085 0
10 1 0.019231 0.192308 0.396108 0.022597 1 2 3 4
52 1 5.461538 4.97929
ll frequencies using syntax =SUM(RANGE1:RANGE2)
culated by using the command =range of frequency/sum of frequency
using the command =X*P(X).
d =(x-$column$cell)^2*p(x)
EAN,STD,FALSE) put required values and calculate normal distribution for each cell
her select 'lines with points' your bell shaped curve will be ready
NORMAL DISTRIBUTION
0.2
0.18
0.16
0.14
0.12
0.1
0.08
0.06
0.04
0.02
0
1 2 3 4 5 6 7 8 9 10 11 12
Column G
DOT
A dot plot, also known as a strip plot or dot chart, is a simple form of data
visualization that consists of data points plotted as dots on a graph with an x- and y-axis
These types of charts are used to graphically depict certain data trends or groupings
STEPS TO MAKE DOT PLOT
1) visualization that consists of data points plotted as dots on a graph with an x- and y-axis
2. Now use command ‘=COUNTIF(<range>,<cellrange>)’, in adjacent cell of next column, to
