Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Instructions: Read this very carefully. In one Excel file create two sheets. Label one sheet "Problem 1" and label the second sheet "Problem 2." Your solutions to the two problems should be recorded on the corresponding sheet. Additionally, you should clearly label each part of the problems with (a), (b), etc., and every computation should be labeled. For example, in the cell next to the mean of the data, you should have typed the word mean or average.Be sure to do your computations using Excel. Do not do computations using Table A or on a calculator and then type the answers into Excel.1. Breast-feeding mothers secrete calcium into their milk. Some of the calcium may come from their bones, so mothers may lose bone mineral. Previous research shows that the average percent change in mineral content for breast-feeding mothers is µ = -4% with standard devi- ation σ = 2.5%. Researchers suspect that mothers who drink at least 8 ounces of milk per day while breastfeeding (milk-drinking mothers) lose less bone mineral. They measured the per- cent change in mineral content of the spines of 52 milk-drinking mothers during three months of breastfeeding. The data is contained in the Excel file that accompanies this worksheet.(a) Make a histogram of the data (use class sizes of 1.5 or 2) to see that they appear to follow an approximately Normal distribution.(b) Consider the question: Do milk-drinking mothers lose less bone mineral than all breast-feeding mothers? State the null and alternative hypotheses in terms of mean percent change µ in mineral content.(c) Find the z test statistic.(d) What is the P -value for your z?(e) What do you conclude about the population of milk-drinking mothers?2. Most professional athletes will agree that resources (money, equipment, etc.) matter when it comes to success in sports. One way to measure a country's success in sports would be to count the total number of medals won by athletes from a country in the Olympics. We know that the average number of medals won by countries in the 2012 Summer Olympics was 11.4. Countries not classified as first world countries have fewer resources to aid in the training of their athletes. A random sample of countries with fewer resources was chosen and the total medal count from the 2012 Summer Olympics was recorded.(a) Consider the question: Do countries with fewer resources win fewer medals in the Olympics? State the null and alternative hypotheses relative to this question.(b) Find the t test statistic.(c) What is the P -value for your t?(d) Is the data significant at significance level α = 0.05?
Attachment:- Worksheet4Data.xls
What is the probability that at least one inspector will find a defective widget?
Barbara invested $150 at a certain rate of interest compounded anually for two years. If the accumulated value at the end of two years is $175, find the rate of interest.
Demonstrate the use of the Pythagorean Theorem in the solution of this problem
soybean meal is 16 protein and corn meal is 9 protein. how many pounds of each should be mixed to get a 350-lb.
what is the probability that the mean weight of a random sample of 35 college football players is between 207 pounds and 212 pounds.
Define a relation R on the set of all integers Z by xRy iff x+y = 3k for some integer k. Is R an equivalence relation on Z? Why or why not?
36. A souvenir retailer has an opportunity to establish a new location inside a large airport. The annual returns will depend primarily on the size of the space she rents and if the economy will be favorable. The retailer has worked with the airport ..
How many different four-digit numbers can be formed from the digits 0 through 9 if the first digit must be even and cannot be zero?
Definition of a measurable function: the function f is measurable on the interval [a,b] if for all c in R, the set {x in [a,b] : f(x) >c} is measurable.
A sailboat is 3 miles directly west of a lighthouse. If the sailboat sails at an average rate of 10mph in the direction S30ºW, find its distance from the lighthouse at the end of 30 minutes.
Elena bicycle 6km/h faster than javier. in the same time it takes javier to bicycle 36km,elena can bicycle 54km. how fast do each bicycles travel?
Suppose that he must add the same number of bags to each side. How many bags must he add to each side in order to balance the scale?
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd