Question

1

Graduate	Monthly Starting Salary ($)
1	3850
2	3950
3	4050
4	3880
5	3755
6	3710
7	3890
8	4130
9	3940
10	4325
11	3920
12	3880

Using Excel functions compute, Mean, Median,Mode,Variance, Standard deviation and Box Plot.

2.

Number of Trails(n)	10
Probability of Success(p)	0.3

Create the discrete probabilty distribution using above values.

Answer 1

Solution-:

Q.1

By using MS-Excel:

We enter the data from celll E2: E13

Graduates	Monthly Starting salary($)
1	3850
2	3950
3	4050
4	3880
5	3755
6	3710
7	3890
8	4130
9	3940
10	4325
11	3920
12	3880

Tool	Value	Functuin used
Mean	3940	=AVERAGE(E2:E13)
Median	3905	=MEDIAN(E2:E13)
Mode	3880	=MODE(E2:E13)
Variance	25154.17	=VARP(E2:E13)
Standard Deviation	158.6007	=SQRT(variance)

For Boxplot:

Tool	Value	Functuin used
Min	3710	=MIN()
Q1	3872.5	=QUARTILE(array,1)
Q2	3905	=QUARTILE(array,2)
Q3	3975	=QUARTILE(array,3)
Max	4325	=MAX()

Q.2

n=10	p=0.3
x	P(x)
0	0.02825
1	0.12106
2	0.23347
3	0.26683
4	0.20012
5	0.10292
6	0.03676
7	0.00900
8	0.00145
9	0.00014
10	0.00001