Week 3 Assignment Question 1 Seventy percent of the students applying to a university are accepted. Using the binomial probability tables or Excel, what is the probability that among the next 18 applicants:
1. At least 6 will be accepted? 2. Exactly 10 will be accepted? 3. Exactly 5 will be rejected? 4. Fifteen or more will be accepted? 5. Determine the expected number of acceptances. 6. Compute the standard deviation.
Question 2 Scores on a recent national statistics exam were normally distributed with a mean of 80 and a standard deviation of 6.
1. What is the probability that a randomly selected exam will have a score of at least 71? 2. What percentage of exams will have scores between 89 and 92? 3. If the top 2.5% of test scores receive merit awards, what is the lowest score eligible for
I need this done in a Excel word document and I need it to show how the work is done
Project Week 3 For these project assignments throughout the course you will need to reference the data in the ROI Excel spreadsheet. Download it here. Using the ROI data set:
1. If we select 7 colleges from a major and then record whether they are of ‘School Type’ ‘Private’ or not, is this experiment a binomial one? Why or why not?
2. For each of the 2 majors determine if the ‘Annual % ROI’ appears to be normally distributed. Consider the shape of the histogram and the measures of central tendency (mean and median) to justify your results. Report on each of these with charts and calculations to justify your answers. https://content.grantham.edu/at/BA215/2015/ROI_by_Major.xlsxhttps://content.grantham.edu/at/BA215/2015/ROI_by_Major.xlsxhttps://content.grantham.edu/at/BA215/2015/ROI_by_Major.xlsx
Submit Your Assignment and get professional help from our qualified experts!
What is the probability that a randomly selected exam will have a score of at least 71? was first posted on July 16, 2019 at 10:18 am.
©2019 "Submit Your Assignment". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. Please contact me at firstname.lastname@example.org