Question

In: Statistics and Probability

Please provide excel functions to answer!! Thanks! An experiment was conducted to investigate the machine performance...

Please provide excel functions to answer!! Thanks!

An experiment was conducted to investigate the machine performance
of deep hole drilling when chip congestion exists. The length, in mm, of 50 drill chips had
a sample mean of 71.2 mm. Assume the population standard deviation is 15.2 mm.
Conduct a test to determine whether the true mean drill chip length is less than 75 mm at α=.01.

Sample size

xbar

sigma

null hypothesis

alternative hypothesis

standard error

test statistic (z)

p value - lower tail

p value - upper tail

p value two tail

significance level (alpha)

appropriate p value

conclusion (write in terms with alternative hypothesis)

Solutions

Expert Solution

Here we have given that,

n=Sample size i.e. the number of drill chips = 50

= sample mean =71.2 mm

= Population standard deviation= 15.2 mm

Here, the population standard deviation is known we are using the one-sample z-test to test the hypothesis.

Claim: To check whether the mean drill chip length is less than 75 mm.

The null and alternative hypothesis is as follows

Versus

where = Population mean of drill chip length

This is left one-tailed test.

Now, we can find the test statistic

z-statistics =

                  =

                  = Here, we get the standard error ==2.150

                   = -1.77

The Test statistic is -1.77

Now we can find the P-value

This is left one-tailed test

P-value = P(Z < z-statistics)

               =P( Z < -1.77)

               =0.0384 Using standard normal z table see the value corresponding to the z=-1.77

we get the P-value is 0.0384

= level of significance=0.01

Decision:

P-value (0.0384) greater than (>) 0.01 ()

Conclusion:

we fail to reject the Ho (Null Hypothesis).

There is not sufficient evidence to conclude that the mean drill chip length is less than 75 mm.


Related Solutions

CAN YOU PLEASE SOLVE THESE IN EXCEL. a large city hospital conducted a study to investigate...
CAN YOU PLEASE SOLVE THESE IN EXCEL. a large city hospital conducted a study to investigate the relationship between the number of authorized days that employees are absent per year and the distance between home and work for the employees. A sample of 10 employees was selected and the following data were collected Distance to work: Number of days absent: 1 8 3 5 4 8 6 7 8 6 10 3 12 5 14 2 14 4 18 2...
W72A) I am learning EXCEL Functions. Please answer in EXCEL Functions in detail Stock Returns (relationship...
W72A) I am learning EXCEL Functions. Please answer in EXCEL Functions in detail Stock Returns (relationship between hypothesis testing and confidence intervals) Suppose you as an investor with a stock portfolio of hundreds of thousands of dollars decide to sue your broker because of low returns due to lack of portfolio diversification, i.e., too many holdings with similar return prospects. The 39 monthly returns, expressed as percentages, are shown in the table below and reproduced in your Excel answer template....
please, answer in detail answer, thanks. Question 1. Finding a company in the Electronics sector, provide...
please, answer in detail answer, thanks. Question 1. Finding a company in the Electronics sector, provide one example to show how environmental forces positively influence company performance, and one example to show how environment forces negatively influence company performance.
Please provide me with the right answer and clear handwriting . Thanks Identify the hormones and...
Please provide me with the right answer and clear handwriting . Thanks Identify the hormones and neurotransmitters that modulate learning and memory
4.27- An experiment was conducted to investigate the filling capability of packaging equipment at a winery...
4.27- An experiment was conducted to investigate the filling capability of packaging equipment at a winery in Newberg, Oregon. Twenty bottles of Pinot Gris were randomly selected and the fill volume (in ml) measured. Assume that fill volume has a normal distribution. The data are as follows: 753, 751, 752, 753, 753, 753, 752, 753, 754, 754, 752, 751, 752, 750, 753, 755, 753, 756, 751, and 750. (a) Do the data support the claim that the standard deviation of...
An experiment was conducted to investigate the effect of extrusion pressure (P) and temperature at extrusion...
An experiment was conducted to investigate the effect of extrusion pressure (P) and temperature at extrusion (T) on the strength y of a new type of plastic. Two plastic specimens were prepared for each of five combinations of pressure and temperature. The specimens were then tested in a random order and the breaking strength for each specimen was recorded. The independent variables were coded (transformed) as follows to simplify the calculations: x1= (P-200)/10, x2= (T-400)/25. The n=10 data points are...
In an experiment to investigate the performance of four different brands of spark plugs intended for...
In an experiment to investigate the performance of four different brands of spark plugs intended for use on a 125-cc motorcycle, five plugs of each brand were tested, and the number of miles (at a constant speed) until failure was observed. A partially completed ANOVA table is given. Fill in the missing entries, and test the relevant hypotheses using a .05 level of significance. (Give the answer to two decimal places.) Source of Variation df Sum of Squares Mean Square...
(Please answer this question in an excel format if possible.) Please provide very detailed explanation and...
(Please answer this question in an excel format if possible.) Please provide very detailed explanation and answers if possible. The Poster Bed Company believes that its industry can best be classified as monopolistically competitive. An analysis of the demand for its canopy bed has resulted in the following estimated demand function for the bed: P ¼ 1760 12Q The cost analysis department has estimated the total cost function for the poster bed as TC ¼ 1 3 Q3 15Q2 þ...
Hi please answer these questions with short description. please type the answers. thanks. wind power Provide...
Hi please answer these questions with short description. please type the answers. thanks. wind power Provide a short description of the following terms: Roughness Turbulence Rossby Circulation.
Answer using excel and please provide excel instructions for all outputs meaning what formula was used...
Answer using excel and please provide excel instructions for all outputs meaning what formula was used to calculate the output and how was it implemented using excel and which excel functions to use. Thank you. Conch Republic Electronics is a midsized electronics manufacturer located in Key West, Florida. The company president is Shelly Couts, who inherited the company. The company originally repaired radios and other household appliances when it was founded over 70 years ago. Over the years, the company...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT