Question

In: Math

2. Problem 2 is adapted from the Problem 39 at the end of Chapter 11. Please...

2. Problem 2 is adapted from the Problem 39 at the end of Chapter 11. Please solve this problem in Excel and submit your Excel spreadsheet. The problem is as follows: The state of Virginia has implemented a Standard of Learning (SOL) test that all public school students must pass before they can graduate from high school. A passing grade is 75. Montgomery County High School administrators want to gauge how well their students might do on the SOL test, but they don't want to take the time to test the whole student population. Instead, they selected 20 students at random and gave them the test. The results are as follows: 83 79 56 93 48 92 37 45 72 71 92 71 66 83 81 80 58 95 67 78 Assume that SOL test scores are normally distributed. a. Compute the mean and standard deviation for these data. b. Determine the probability that a student at the high school will pass the test. c. How many percent of students will receive a score between 75 and 95? d. What score will put a student in the bottom 15% in SOL score among all students who take the test? e. What score will put a student in the top 2% in SOL score among all students who take the test? 3. The average male drinks 2 L of water when active outdoors (with a standard deviation of 0.8L). You are planning a full day nature trip for 100 men and will bring 210 L of water. What is the probability that you will run out? Please solve this problem in Excel and submit your Excel file.

Solutions

Expert Solution

2) Let X be the SOL test score of a student at the high school. X is normally distributed.

a)

be the sample mean and sample standard deviations of SOL test scores at the high school.  

We will estimate the population mean  SOL test scores at the high school using the sample mean as

We will estimate the population standard deviation of scores as

b. Determine the probability that a student at the high school will pass the test is same as the probability that a student at the high school scores 75 or more

P(X>=75)

c. How many percent of students will receive a score between 75 and 95?

P(75<X<95)

d. What score will put a student in the bottom 15% in SOL score among all students who take the test?

Let q be the score that will put a student is the bottom 15%

P(X<q)=0.15

e. What score will put a student in the top 2% in SOL score among all students who take the test?

Let r be the score that will put a student in the top 2%

P(X>r) = 0.02 or P(X<r)=1-0.02=0.98

Prepare the following sheet

get this

3) Let X be the amount of water any given male drinks, with mean and standard deviation

Let be the average water consumed by a sample of n=100 males. Using the central limit theorem (since the sample size is greater than 30), we can say that has normal distribution with mean and standard deviation (or standard error of mean)

If you bring 210 L of water for 100 men, then we have on an average 2.1 L of water per person in the group.

the probability that you will run out is the probability that the average consumption of a sample of 100 is greater than 2.1L

Prepare the following sheet

Get this

ans:  the probability that you will run out is 0.1056


Related Solutions

Read from chapters 36 to 39 from your Textbook II. Read chapter 39 and write a...
Read from chapters 36 to 39 from your Textbook II. Read chapter 39 and write a summary about alternative feeding techniques that may be used when food and fluids are withheld (NPO) from a child. III. Review the conditions that necessitate nasogastric gavage, gastrostomy, nasoduodenal, or nasojejunal tube feedings. IV. Guidelines for Nasogastric Tube feedings in children
Read from chapters 36 to 39 from your Textbook II. Read chapter 39 and write a...
Read from chapters 36 to 39 from your Textbook II. Read chapter 39 and write a summary about alternative feeding techniques that may be used when food and fluids are withheld (NPO) from a child. III. Review the conditions that necessitate nasogastric gavage, gastrostomy, nasoduodenal, or nasojejunal tube feedings. IV. Guidelines for Nasogastric Tube feedings in children
C++ problem 11-2 In this chapter, the class dateType was designed to implement the date in...
C++ problem 11-2 In this chapter, the class dateType was designed to implement the date in a program, but the member function setDate and the constructor do not check whether the date is valid before storing the date in the member variables. Rewrite the definitions of the function setDate and the constructor so that the values for the month, day, and year are checked before storing the date into the member variables. Add a member function, isLeapYear, to check whether...
2. What is Chapter 7 liquidation and Chapter 11 reorganization? When should each be used? Please...
2. What is Chapter 7 liquidation and Chapter 11 reorganization? When should each be used? Please choose one company that has gone through either type of bankruptcy proceeding and describe the circumstances leading up to the filing.
Write program for the exercise 11(Sales Analysis) as explained at the end of the chapter. 11....
Write program for the exercise 11(Sales Analysis) as explained at the end of the chapter. 11. sales Analysis The file SalesData.txt, in this chapter’s source code folder, contains the dollar amount of sales that a retail store made each day for a number of weeks. Each line in the file contains seven numbers, which are the sales numbers for one week. The numbers are separated by a comma. The following line is an example from the file: 2541.36,2965.88,1965.32,1845.23,7021.11,9652.74,1469.36 Write a...
Chapter 4 Problem 11 Problem 15, part f. in Chapter 3 asks you to construct a...
Chapter 4 Problem 11 Problem 15, part f. in Chapter 3 asks you to construct a five year financial projection for Aquatic Supplies beginning in 2015. The five year projection appears below. a. Calculate Aquatic Supplies's sustainable and actual growth rates in these years.   b. What do these numbers suggest to you? Aquatic Supplies Co. Five Year Projected Income Statements and Balance Sheets Income Statement (in $ millions) Pro Forma Forecasts 2015 - 2019 2014 Assumptions 2015 2016 2017 2018...
The question is from the textbook Inequality, Discrimination, Poverty, and Mobility Question 2 from chapter 11:...
The question is from the textbook Inequality, Discrimination, Poverty, and Mobility Question 2 from chapter 11: "As a matter of law and a matter of economics are the anti-discrimination laws interpreted correctly by the courts?"
Please read Financial Statement Analysis Case 2: Wiebold in the end of chapter materials in the...
Please read Financial Statement Analysis Case 2: Wiebold in the end of chapter materials in the e Text. Answer questions a) b) & c) listed under Instructions. Please post your answer and respond to at least two of your classmates. Case 2: Wiebold, Inc. The following note related to stockholders' equity was reported in Wiebold, Inc.'s annual report. On February 1, the Board of Directors declared a 3-for-2 stock split, distributed on February 22 to shareholders of record on February...
Chapter 11 Estimation and Confidence Intervals - Please answer 2-4 Practice 2) Estimation for the one-sample...
Chapter 11 Estimation and Confidence Intervals - Please answer 2-4 Practice 2) Estimation for the one-sample t Test In chapter 9, we computed a one-sample t test examining the social functioning of relatives of individuals with OCD compared to the general healthy population. In 18 participants, M = 62.00; SD = 20.94 Find the 95% CI for these data Practice 3) Estimation for the two-independent-sample t test In chapter 9, we tested the mean difference of calorie consumption between two...
The project is adapted from the Chapter 4 Case Study dealing with North–South Airline In January...
The project is adapted from the Chapter 4 Case Study dealing with North–South Airline In January 2012, Northern Airlines merged with Southeast Airlines to create the fourth largest U.S. carrier. The new North–South Airline inherited both an aging fleet of Boeing 727-300 aircraft and Stephen Ruth. Stephen was a tough former Secretary of the Navy who stepped in as new president and chairman of the board. Stephen’s first concern in creating a financially solid company was maintenance costs. It was...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT