Data Analysis Project

DATA ANALYSIS
PROJECT
STUDENT ID:
[Pick the date]

Problem 1
(a) Probability of success = p = 0.15
Number of trials = n = 150
Mean ¿ np=150∗0.15=22.50
Variance ¿ npq=150∗0.15∗(1−0.15)=19.13
Discrete and cumulative probability of binomial distribution is highlighted in excel.
(b) Discrete probabilityand cumulative probability charts
2

Based on the above graphs, convergence is clear towards 1 for the cumulative probability
function.
Problem 2
μ=50
σ =3.5
Range value of x = 40 to 80
3

35.0 40.0 45.0 50.0 55.0 60.0 65.0 70.0 75.0 80.0 85.0
0
0.02
0.04
0.06
0.08
0.1
0.12
Probability Distribution
X
Probability
Problem 4
The two stocks that have been picked are Facebook and Amazon. These have been picked as
the recent rise in NASDAQ is attributed to these two stocks which have a e-commerce based
business model.
Numerical summary for the prices of the above two stocks is shown below.
(a) Box plot of both the stocks and lowest and highest stock prices
4