How to solve the question below in excel: Question 8.25 Data -0.0020 0.0005 0.0025 0.0010 0.0020...
How to solve the question below in excel:
Question 8.25
| Data |
| -0.0020 |
| 0.0005 |
| 0.0025 |
| 0.0010 |
| 0.0020 |
| 0.0010 |
| 0.0050 |
| -0.0020 |
| 0.0000 |
| 0.0010 |
| -0.0025 |
| -0.0030 |
| 0.0010 |
| -0.0005 |
| 0.0000 |
| -0.0030 |
| -0.0010 |
| 0.0005 |
| 0.0025 |
| -0.0025 |
| 0.0020 |
| 0.0010 |
| 0.0010 |
| 0.0010 |
| -0.0020 |
| -0.0030 |
| -0.0015 |
| -0.0005 |
| 0.0000 |
| -0.0025 |
| -0.0030 |
| -0.0010 |
| 0.0020 |
| -0.0010 |
| 0.0000 |
| 0.0030 |
| 0.0015 |
| 0.0000 |
| 0.0000 |
| -0.0025 |
| 0.0005 |
| 0.0010 |
| 0.0005 |
| 0.0010 |
| 0.0025 |
| 0.0010 |
| 0.0000 |
| -0.0025 |
| -0.0010 |
| 0.0035 |
| 0.0000 |
| -0.0030 |
| -0.0020 |
| -0.0010 |
| -0.0015 |
| -0.0015 |
| -0.0020 |
| 0.0010 |
| -0.0025 |
| -0.0005 |
| -0.0015 |
| -0.0005 |
| -0.0015 |
| -0.0005 |
| -0.0005 |
| -0.0010 |
| -0.0015 |
| 0.0025 |
| 0.0010 |
| 0.0005 |
| 0.0000 |
| -0.0020 |
| -0.0005 |
| 0.0005 |
| 0.0005 |
| 0.0000 |
| -0.0005 |
| 0.0020 |
| 0.0010 |
| -0.0015 |
| -0.0010 |
| -0.0010 |
| 0.0005 |
| -0.0025 |
| 0.0025 |
| 0.0020 |
| 0.0025 |
| -0.0020 |
| 0.0000 |
| -0.0005 |
| -0.0010 |
| 0.0000 |
| -0.0020 |
| 0.0000 |
| 0.0000 |
| 0.0020 |
| -0.0030 |
| -0.0005 |
| -0.0020 |
| -0.0020 |
One operation of a mill is to cut pieces of steel into parts that are used in the frame for front seats in an automobile. the steel is cut with a diamond saw, and the resulting parts must be cut to be within +,- 0.005 inch of the length specified by the automobile company. the measurement reported from a sample of 100 steel parts (stored in steel) is the difference, in inches, between the actual length of the steel part, as measured by a laser measurement device, and the specified length of the steel part. for example, the first observation, -0.002, represents a steel part that is 0.002 inch shorter than the specified length.
a. Construct a 95% confidence interval estimate for the population mean difference between the actual length of the steel part and the specified length of the steel part.
b. What assumption must you make about the population distribution in order to construct the confidence interval estimate in (a)?
c. Do you think that the assumption needed in order to construct the confidence interval estimate in (a) is valid? Explain.
Homework Answers
Add Answer to:
How to solve the question below in excel:
Question 8.25
Data
-0.0020
0.0005
0.0025
0.0010
0.0020...
One operation of a mill is to cut pieces of steel into parts that will later be used as the frame for front seats in an automobile
One operation of a mill is to cut pieces of steel into parts that will later be used as the frame for front seats in an automobile. The steel is cut with a diamond saw and requires the resulting parts to be within ±0.005 inch of the length specified by the automobile company. The data in the file comes from a sample of 100 steel parts. The measurement reported is the difference in inches between the actual length of the...
2.2.19 Question Help One operation of a mill is to cut pieces of steel into parts...
2.2.19 Question Help One operation of a mill is to cut pieces of steel into parts that will later be used as the frame for front seats in an automobile. The steel is cut with a diamond saw and requires the resulting parts to be within ± 0.005 inch of the length specified by the automoble company Data are colected from a sample of 50 steel parts and are shown in the following table. The measurement reported is the difference...
Are 0 0.66 0.07 .08 0.00 0.01 0.09 0.02 0.0003 0.0005 0.0007 0.0010 0.0013 0.0019 0.0026...
Are 0 0.66 0.07 .08 0.00 0.01 0.09 0.02 0.0003 0.0005 0.0007 0.0010 0.0013 0.0019 0.0026 0.0035 0.0003 0.0005 0.0007 0.0009 0.0013 0.0018 0.0025 0.0034 0.0045 0.0060 0.0080 0.0104 0.01.36 0.0174 0.0003 0.0005 0.0006 0.0009 0.0013 0.0018 0.0024 0.0033 0.0044 Standard Normal Distribution 0.03 0.04 0.05 0.0003 0.0003 0.0003 0.0004 0.0004 0.0004 0.0006 0.0006 0.0006 0.0009 0.0008 0.0008 0.0012 0.0012 0.0011 0.0017 0.0016 0.0016 0.0023 0.0023 0.0022 0.0032 0.0031 0.0030 0.0043 0.0041 0.0040 0.0057 0.0055 0.0054 0.0075 0.0073 0.0071 0.0094...
The data shown below represent the age (in weeks) at which babies first crawl, based on...
The data shown below represent the age (in weeks) at which babies first crawl, based on a survey of 12 mothers. Complete parts (a) through (c) below. 52 30 44 350 47 37 56 26 39 35 30 62 Click here to view the table of crical correlation coefficient values for normal probability clots. Click here to view.cage 1 of the standard normal distribution table. Click here to view page 20the standard roma distribution Click here to view the table...
Question 3 (9 marks) Consider the following information about a non-dividend paying stock: The current stock...
Question 3 (9 marks) Consider the following information about a non-dividend paying stock: The current stock price is $36, and its return standard deviation is 30% per year. The continuous compound risk-free rate is 3% per year. Assume that the Black-Scholes model correctly prices all the options written on the stock given the information above. a). A call option written on the stock expires in 1 year and has an exercise price of $36. Calculate the Black-Scholes value of the...
how to solve B? 6.2.1 Question Help Given a standardized normal distribution (with a mean of...
how
to solve B?
6.2.1 Question Help Given a standardized normal distribution (with a mean of O and a standard deviation of 1), complete parts (a) through (d) EI! Click here to view page 1 of the cumulative standardized normal distribution table. Click here to view page 2 of the cumulative standardized normal distribution table. G. WE WC PM WIB The probability that is less than 1.53 is 0.9370 (Round to four decimal places as needed) b. What is the...
A television sports commentator wants to estimate the proportion of citizens who follow professional football." Complete...
A television sports commentator wants to estimate the proportion of citizens who follow professional football." Complete parts (a) through (c). Click here to view the standard normal distribution table (page 1) Click here to view the standard normal distribution table (page 2). (a) What sample size should be obtained if he wants to be within 4 percentage points with 95% confidence if he uses an estimate of 54% obtained from a poll? The sample size is (Round up to the...
A random sample of 1021 adults in a certain large country was asked "Do you prosty...
A random sample of 1021 adults in a certain large country was asked "Do you prosty much think televisions are a necessity or a luxury you could do wthout of the 1021 adults surveyed, 638 indicated that televisions are a ury they could do without Complete parts() through ( below Click here to view the standard formal distribution table lage 11 Cick here to view the standard normal distribution table page 21 (a) Obtain a point estimate for the population...
The data shown below represent the age in weeka) at which babies frut crawl, based on...
The data shown below represent the age in weeka) at which babies frut crawl, based on a survey of 12 mother completo porta (8) through (c) below. 5230 44350 47 26 90353062 Clos here to view the fubiectertion constaton coefficient for normal orobabile Click here to view.pronto the standard rom. dirbtitatie, Click here view.pon 20 the standard somal distribution Care for the table critical () Draw a normal probability plot to determine is reasonable to conclude the data come from...
9.3.11 Question Help In a random sample of 39 criminals convicted of a certain crime, it...
9.3.11 Question Help In a random sample of 39 criminals convicted of a certain crime, it was determined that the mean length of sentencing was 50 months, with a standard deviation of 11 months. Construct and interpret a 95% confidence interval for the mean length of sentencing for this crime. Click here to view the standard normal distribution table (page 1) Click here to view the standard normal distribution table (page 2) Click here to view the table of critical...
2.2.19 Question Help One operation of a mill is to cut pieces of steel into parts that will later be used as the frame for front seats in an automobile. The steel is cut with a diamond saw and requires the resulting parts to be within ± 0.005 inch of the length specified by the automoble company Data are colected from a sample of 50 steel parts and are shown in the following table. The measurement reported is the difference...
Are 0 0.66 0.07 .08 0.00 0.01 0.09 0.02 0.0003 0.0005 0.0007 0.0010 0.0013 0.0019 0.0026 0.0035 0.0003 0.0005 0.0007 0.0009 0.0013 0.0018 0.0025 0.0034 0.0045 0.0060 0.0080 0.0104 0.01.36 0.0174 0.0003 0.0005 0.0006 0.0009 0.0013 0.0018 0.0024 0.0033 0.0044 Standard Normal Distribution 0.03 0.04 0.05 0.0003 0.0003 0.0003 0.0004 0.0004 0.0004 0.0006 0.0006 0.0006 0.0009 0.0008 0.0008 0.0012 0.0012 0.0011 0.0017 0.0016 0.0016 0.0023 0.0023 0.0022 0.0032 0.0031 0.0030 0.0043 0.0041 0.0040 0.0057 0.0055 0.0054 0.0075 0.0073 0.0071 0.0094...
The data shown below represent the age (in weeks) at which babies first crawl, based on a survey of 12 mothers. Complete parts (a) through (c) below. 52 30 44 350 47 37 56 26 39 35 30 62 Click here to view the table of crical correlation coefficient values for normal probability clots. Click here to view.cage 1 of the standard normal distribution table. Click here to view page 20the standard roma distribution Click here to view the table...
Question 3 (9 marks) Consider the following information about a non-dividend paying stock: The current stock price is $36, and its return standard deviation is 30% per year. The continuous compound risk-free rate is 3% per year. Assume that the Black-Scholes model correctly prices all the options written on the stock given the information above. a). A call option written on the stock expires in 1 year and has an exercise price of $36. Calculate the Black-Scholes value of the...
how
to solve B?
6.2.1 Question Help Given a standardized normal distribution (with a mean of O and a standard deviation of 1), complete parts (a) through (d) EI! Click here to view page 1 of the cumulative standardized normal distribution table. Click here to view page 2 of the cumulative standardized normal distribution table. G. WE WC PM WIB The probability that is less than 1.53 is 0.9370 (Round to four decimal places as needed) b. What is the...
A television sports commentator wants to estimate the proportion of citizens who follow professional football." Complete parts (a) through (c). Click here to view the standard normal distribution table (page 1) Click here to view the standard normal distribution table (page 2). (a) What sample size should be obtained if he wants to be within 4 percentage points with 95% confidence if he uses an estimate of 54% obtained from a poll? The sample size is (Round up to the...
A random sample of 1021 adults in a certain large country was asked "Do you prosty much think televisions are a necessity or a luxury you could do wthout of the 1021 adults surveyed, 638 indicated that televisions are a ury they could do without Complete parts() through ( below Click here to view the standard formal distribution table lage 11 Cick here to view the standard normal distribution table page 21 (a) Obtain a point estimate for the population...
The data shown below represent the age in weeka) at which babies frut crawl, based on a survey of 12 mother completo porta (8) through (c) below. 5230 44350 47 26 90353062 Clos here to view the fubiectertion constaton coefficient for normal orobabile Click here to view.pronto the standard rom. dirbtitatie, Click here view.pon 20 the standard somal distribution Care for the table critical () Draw a normal probability plot to determine is reasonable to conclude the data come from...
9.3.11 Question Help In a random sample of 39 criminals convicted of a certain crime, it was determined that the mean length of sentencing was 50 months, with a standard deviation of 11 months. Construct and interpret a 95% confidence interval for the mean length of sentencing for this crime. Click here to view the standard normal distribution table (page 1) Click here to view the standard normal distribution table (page 2) Click here to view the table of critical...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago