View the step-by-step solution to:

# Pace University Math 117 Instructor: Vinh Ly Spring 2018 Data Analysis Project April 4th, 2018 Final Proiect Conceptual Problems: Probability Density...

It would be great if someone could answer these questions except the extra credit ones in excel. It would appreciated if it was done ASAP

Pace University Math 117 Instructor: Vinh Ly
Spring 2018 Data Analysis Project April 4th, 2018 Final Proiect 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 u = 60
and o = 5. Set up the range values ofx 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? and 52. 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 quote.yahoo.com
or google.com/finance. 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.

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents