Data Analysis Project

DATA ANALYSIS PROJECT
STUDENT ID:
[Pick the date]

Problem 1
(a) Binomial Distribution
p = 0.15
n = 150
Mean = n ∗ p = (150) ∗ (0.15) = 22.50
Variance = n ∗ p ∗ ሺ1 − pሻ= (150) ∗ (0.15) ∗ (1 − 0.15) = 19.13
Discrete probability and cumulative probability arerepresented in excel spreadsheet.
(b) Discrete probability distribution display
Cumulative probabilitydistribution display
2

The cumulative probability curve becomes convergent towards 1 as X approaches value
greater than 30. This is on expected lines as the requisite probabilities for higher values of X
would be almost zero.
Problem 2
Normal distribution
Mean=50
Standard deviation=3.5
X 40 ¿ 80 with an interval of 0.1
Density Probability Plot
3

Problem 4
Two stocks that have been selected are indicated below. The reason behind the selection of
these stocks is the recent outperformance in the market that has been witnessed by these two
stocks. Further, these two companies have a global footprint and gradually the share of the
foreign markets in their overall turnover and profitability is on the rise.
 NFLX
 Microsoft.
Descriptive statistics for stock prices
4