8. a) Using Excel's 'series fill' function make a column of data from -10 to 10 witheach cell increasing in value by 0.1b) Using Excel's normal distribution function,NORM.DIST(x,mean.stdev.cumulative), make 3 columns of values for the normaldistribution using the column from part 'a' as x and the following values for and o (use FALSE for cumulative):a. = 0, 0=1b. = 0, o=2c. = 5, o=1Plot all of these data series with respect to x in a single smooth line scatterplot in Excel (be sure to format the axes properly and include a legend, notitle or caption is required). Describe in word the differences among thethree curves

a) The Series values from -10 to 10 has been calculated using the Excel 'Series' function is as…

Answered: 8. a) Using Excel's 'series fill'…

A First Course in Probability (10th Edition)

10th Edition

ISBN:9780134753119

Author:Sheldon Ross

Publisher:Sheldon Ross

Chapter1: Combinatorial Analysis

Section: Chapter Questions

Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...

See similar textbooks

Similar questions

Suppose that Xhas a normal distribution, Find E[ex].
Let, X has a normal distribution with a mean of 60 and a standard deviation of 4. The z-value for x = 53 is?
The one in the yellow is the previous tab.
Use the formula to find the standard error of the distribution of differences in sample means, I1 – X2. Samples of size 110 from Population 1 with mean 82 and standard deviation 14 and samples of size 80 from Population 2 with mean 76 and standard deviation 17 Round your answer for the standard error to two decimal places. standard error = i
Total plasma volume is important in determining the required plasma component in blood replacement therapy for a person undergoing surgery. Plasma volume is influenced by the overall health and physical activity of an individual. Suppose that a random sample of 46 male firefighters are tested and that they have a plasma volume sample mean of x = 37.5 ml/kg (milliliters plasma per kilogram body weight). Assume that ? = 7.80 ml/kg for the distribution of blood plasma. (d) Find the sample size necessary for a 99% confidence level with maximal margin of error E = 2.90 for the mean plasma volume in male firefighters. (Round up to the nearest whole number.) ________ male firefighters
The manager of a fleet of automobiles is testing two brands of radial tires and assigns one tire of each brand at random of eight cars and runs the cars until the tires wear out. The data (in kilometers) follow. Is there any difference in mean life of these two brands of tires? Car Brand Brand 36,925 34.318 42,280 1 45.300 36,240 3 4 35.500 32,100 31,950 38,015 37.210 48,360 5 47,800 38,200 37,810 33.500 33,215 6. 7 8. 1. Is this samples independent or paired samples? Explain. 2. Write Ho and H1 3. Calculate Test statistics(T). 4. What is the critical value (T from tables)? 5. What is your conclusions if a = 0.05? 6. Estimate with 90% confidence the different in the means. Which brand would you prefer based on this calculation?
The two data sets in the table below are dependent random samples. The population of (x - y) differences is approximately normally distributed. A claim is made that the mean difference (x - y) is less than 29.3. X y DII For each part below, enter only a numeric value in the answer box. For example, do not type "z =" or "t=" before your answers. Round each of your answers to 3 places after the decimal point. (a) Calculate the value of the test statistic used in this test. Test statistic's value = -2.760 61 71 58 48 38 41 (b) Use your calculator to find the P-value of this test. P-value $ 4 44 48 66 43 32 30 29 33 (c) Use your calculator to find the critical value(s) used to test this claim at the 0.07 significance level. If there are two critical values, then list them both with a comma between them. Critical value(s) = -1.700 (d) What is the correct conclusion of this hypothesis test at the 0.07 significance level? O There is sufficient evidence to support the claim that the mean…
A food manufacturer claims that eating its new cereal as part of a daily diet lowers total blood cholesterol levels. The table shows the total blood cholesterol levels (in milligrams per deciliter of blood) of seven patients before eating the cereal and after one year of eating the cereal as part of their diets. Use technology to test the mean difference. Assume the samples are random and dependent, and the population is normally distributed. At a = 0.05, can you conclude that the new cereal lowers total blood cholesterol levels? Patient Total Blood Cholesterol (Before) Total Blood Cholesterol (After) OA. Ho Hd #0 HA Hd=0 OC. Ho Hd ≤0 HA Hd >0 Calculate the standardized test statistic t= (Round to three decimal places as needed.) Calculate the P-value P-value= (Round to four decimal places as needed) State the conclusion. 1 205 204 Ho. There C 2 225 222 Let the blood cholesterol level before eating the cereal be population 1. Let the blood cholesterol level after eating the cereal be…
Let x be a random variable that represents red blood cell count (RBC) in millions of cells per cubic millimeter of whole blood. Then x has a distribution that is approximately normal. For the population of healthy female adults, suppose the mean of the x distribution is about 4.64. Suppose that a female patient has taken six laboratory blood tests over the past several months and that the RBC count data sent to the patient's doctor are as follows. 4.9 4.2 4.5 4.1 4.4 4.3 (1) Use a calculator with sample mean and standard deviation keys to find x and s. (Round your answers to two decimal places.) x=| S= (ii) Do the given data indicate that the population mean RBC count for this patient is lower than 4.64? Use a = 0.05. (a) What is the level of significance? State the null and alternate hypotheses. Ο Hg: μ= 4.64; H1: μ 4.64 Ο Ηρ: μ> 4.64; H1: μ = 4.64 Ho: u = 4.64; H1: u * 4.64 (b) What sampling distribution will you use? Explain the rationale for your choice of sampling distribution. O…
For any variable X, if: the standard deviation = and the variance = Var(X) Which of the following statement is true: Select one: a. SD < Var(X) O b. (SD)² = Var(X) (SD) C. SD = [var(x)]²
Suppose that the duration of a particular type of criminal trial is known to be normally distributed with a mean of 20 days and a standard deviation of 5 days. Let X be the number of days for a randomly selected trial. Round all answers to 4 decimal places where possible.
If the iron cutting machine in a factory works continuously for a certain period of time under the same conditions, it goes into malfunction. In this type of failure, the machine takes 24 hours to cool down. After the machine has cooled down, it continues to work the next day. Assume that the running time (minutes) of this machine until it malfunctions has a normal distribution. The working time of the iron cutting machine until the failure was measured for 9 different days, which were chosen at random. Continuous working time (minutes): 14-26-18-29-12-19-22-30-19 a) Establish the 95% confidence interval for the average uninterrupted working time of this iron cutting machine and interpret the result.b) The factory chief claims that the average continuous operating time of the machine is less than 23 minutes. Test the claim that the average continuous working time of this iron cutting machine is less than 23 minutes at the 0.05 significance level and the result isPlease comment.

SEE MORE QUESTIONS

Recommended textbooks for you

A First Course in Probability (10th Edition)

Probability

ISBN:

9780134753119

Author:

Sheldon Ross

Publisher:

PEARSON

A First Course in Probability

Probability

ISBN:

9780321794772

Author:

Sheldon Ross

Publisher:

PEARSON

A First Course in Probability (10th Edition)

Probability

ISBN:

9780134753119

Author:

Sheldon Ross

Publisher:

PEARSON

A First Course in Probability

Probability

ISBN:

9780321794772

Author:

Sheldon Ross

Publisher:

PEARSON

SEE MORE TEXTBOOKS