Peter has $30,000 to invest in a mutual fund whose annual returns are normally distributed with a mean of 5.75% and standarddeviation of 4.97%.a. Use Excel's Analysis ToolPak, with a seed of 1, to simulate 5,000 trials to estimate the mean balance after one year. (RoundIntermediate calculations to at least 4 decimal places and your final answer to 2 decimal places.)Average balance after one yearb. What is the probability of a balance of $33,000 or more? (Round intermediate calculations to at least 4 decimal places and showyour final answer as a percentage point with 2 decimal places.)Probability of having a bailance of $33,000 or morec. Compared to another investment option at a fixed annual return of 3% per year, what is the probability of getting at least the samebalance from the mutual fund after one year? (Round intermediate calculations to at least 4 decimal places and show your finalanswer as a percentage point with 2 decimal places.)

a) In Excel Click Data-Data Analysis-Random Number generator. Then provide the inputs as shown in…

Answered: Peter has $30,000 to invest in a mutual…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

QUEST A set of final examination grades in a calculus course was found to be normally distributed with a mean of 69 and a standard deviation of 9. The top 15% of the students taking the test scored will receive a grade of B. What is the cur score?
Accrotime is a manufacturer of watches. Accotime researchers have shown that watches hwe an average life of 28 months before certain electronic components deteriorate causing the watch to become unreliable. The standard deviation of watch lifetimes is 5 months and the distribution is noemal. If Accrotime guarantees a full refund of any defective watch for 1.5 years after the purchase, what percentage of total production will the company expect to replace? Write your answer as a percentage rounded to 1 decimal place. For the toolbar, Press ALT+F10 (PC) or ALT+FN+F10 OMCA) 0 WOAOS POWEASD BY TINY
A distribution of values is normal with a mean of 120 and a standard deviation of 4.Find the interval containing the middle-most 68% of scores: Enter your answer using interval notation. Example: (2.1,5.6)
The time between arrivals of vehicles at a particular intersection follows an exponential probability distribution with a mean of 12 seconds. A. IN EXCEL sketch this exponential distribution, and Standard deviation. B. IN EXCEL What is the probability that the arrival time between vehicles is 12 seconds or less. C. IN EXCEL What is the probability that the arrival time between vehicles is 6 seconds or less.
Calcium levels in people are normally distributed with a mean of 9.7 mgdL and a standard deviation of 0.5 mgdL . Individuals with calcium levels in the bottom 10% of the population are considered to have low calcium levels. Find the calcium level that is the borderline between low calcium levels and those not considered low. Carry your intermediate computations to at least four decimal places. Round your answer to one decimal place.
Españiol A scientist has read that the mean birth weight of babies born at full term is 7.4 pounds. The scientist has good reason to believe that the mean birth weight of babies born at full term, µ, is different from this value and plans to perform a statistical test. She selects a random sample of birth weights of babies born at full term and finds the mean of the sample to be 7.8 pounds and the standard deviation to be 1.8 pounds. Based on this information, complete the parts below. (a) What are the null hypothesis H. and the alternative hypothesis H, that should be used for the test? Ho :0 O
ents this quarter: The Environmental Protection Agency (EPA) fuel economy estimates for automobile models tested recently predicted a mean of 25.8 miles per gallon, with a standard deviation of 5.2 miles per gallon. Assume that a Normal model applies. Find the probability that a randomly selected automobile will average: 1. Less than 21 miles per gallon. 2. More than 15 miles per gallon. 3. Between 24 and 30 miles per gallon. ular paper, making sure to number each problem so I know what work goes with which problem. e sure to complete and sign the academic honesty statement for each assignment you complete this quarter. If you a nvas. Make sure to check your f6ler for legibility and completeness before unlnading
A study discovered that Americans consumed an average of 13.2 pounds of chocolate per year. Assume that the annual chocolate consumption follows the normal distribution with a standard deviation of 3.2 pounds. d. What is the probability that an American will consume exactly 12 pounds of chocolate next year? enter your response here (Round to four decimal places as needed.) Part 5 e. What is the annual consumption of chocolate that represents the 80th percentile? The 80th percentile is represented by an annual consumption of enter your response here pounds of chocolate. (Type an integer or decimal rounded to one decimal place as needed.)
z Scores LeBron James, one of the most successful basketball players of all time, has a height of 6 feet 8 inches, or 203 cm. Based on statistics from Data Set 1 “Body Data” in Appendix B, his height converts to the z score of 4.07. How many standard deviations is his height above the mean?

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS