Question
Please help me to solve this calculation in EXCEL 1. the average stock price for companies making up the S&P 500 was $30, and the
Please help me to solve this calculation in EXCEL
1. the average stock price for companies making up the S&P 500 was $30, and the standard deviation was $8.20 (BusinessWeek, Special Annual Issue, Spring 2018). Assume the stock prices are normally distributed.
a.What is the probability that a company will have a stock price of at least $40?
b.How high does a stock price have to be to put a company in the top 10%?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Elementary Algebra
Authors: Jerome E Kaufmann, Rosemary Karr, Karen L Schwitters, Marilyn Massey, R David Gustafson
10th Edition
1305161769, 9781305161764
