Math Final project

timer Asked: May 8th, 2018

Question description

Final Project

Conceptual Problems: Probability Density Function and Binomial Convergence

Problem 1

a/Use Excel/Megastat to find the discrete probability and cumulative probability of the Binomial distribution with probability of success p = 0.4 and n = 60. Find its mean and variance.

b/Based upon the chart on Excel, what can you conclude about the binomial convergence?

Hint: Use binom.dist function on Excel and sketch the curve.

Problem 2

Use Excel/Megastat to create the density probability plot of normal distribution. Take μ = 60 and σ = 5. Set up the range values of x from 40 to 80.

Hint: Use norm.dist function and sketch the curve with tick = 0.1

Problem 3 (extra credit)

Demonstrate the Central Limit Theorem(CLT) of the sample mean by sampling a 100 uniform distribution data with 50 variables. Verify the result by computing the sample mean, sample variance and sketch the histogram on Excel/Megastat.

Hint: Generate 100 datasets of 50 variables and calculate 50 sample means to determine the distribution of X̅ and SX̅.

Practical Problems: Historical Trends and Patterns in Stock Prices

Choose two publicly traded companies with a sample size of 50 and a time range (long term/short term) for its stock prices so that you can download the data from or Make sure to STATE the COMPANY HISTORY and WHY YOU PICK THESE 2 STOCKS for comparison.

Problem 4

Use a statistical package (Excel/Megastat) to find the summary measurements: min, max, mean, median, standard deviation of the historical prices of 2 stocks

a/Draw a Box Plot for both stocks that you picked. Identify the highest and lowest stock prices.

b/Repeat this exercise with histogram/bar-charts and scatter plots for each stock.

c/Write a short paragraph describing how the two stock prices are different. Hint: Base your answer on any notable differences you observe in the two Box Plots. Pace University Math 117 Instructor: Vinh Ly Spring 2018 Data Analysis Project April 4th, 2018

Problem 5

Use Megastat/Excel to find the value of the linear correlation coefficient between these 2 stock prices? Is the correlation significant? Explain the reason for your answer.

a) If the correlation is significant, what does it imply about the trend in the predicted stock?

b) Find the equation for the least squares regression (LSR) line.

c) Interpret the meaning of the slope of the LSR line.

d) Based on the equation of LSR line, what is the “best predicted” value for the stock that you treated as a dependent variable?

Problem 6

Run the hypothesis testing for difference in mean prices of 2 stocks that you picked from the sample size of 50. Assume the difference prices between the two and compare the result with equal/unequal variances or matched-paired hypothesis.

Hint: since F = 𝜎12𝜎22, Use F-test to compare the variances of 2 stocks before choosing the right model to test.

Problem 7

Test the hypothesis that the periodic returns follow a normal distribution, as required by certain models of mathematical finance. Predict the periodic returns that you want to be tested for both population stock prices and run the hypothesis testing based upon your prediction.

Hint: Use z points on the table to test for linearity and periodic return r = 𝑃𝑟𝑖𝑐𝑒2−𝑃𝑟𝑖𝑐𝑒1𝑃𝑟𝑖𝑐𝑒1

Problem 8 (extra credits)

Investigate models which predict the stock price at time t as a function of the stock price at previous times (say St-1 and St-2 for example).

Hint: Run a multiple linear regression model (time series model). Forecast are made on St+1 with respect to St, St-1 and St-2.

Tutor Answer

(Top Tutor) Studypool Tutor
School: Carnegie Mellon University
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors