Question

In: Statistics and Probability

A producer of steel cables wants to know whether the steel cables it produces have an...

A producer of steel cables wants to know whether the steel cables it produces have an average breaking strength of 5000 pounds. An average breaking strength of less than 5000 pounds would not be adequate, and to produce steel cables with an average breaking strength in excess of 5000 pounds would unnecessarily increase production costs. the producer collects a random sample of steel cable pieces. the breaking strength for each of these cable pieces is recorded in the file p09_03.xlsx .

a. identify the null and alternative hypotheses for this situation. (Please do in Excel)

b. using a 5 % significance level , what statistical conclusion can the producer reach regarding the average breaking strength of its steel cables ? would the conclusion be any different at the 1 % level ? explain your answers . (Please do in Excel)

show all working and steps in excel

the file p09_03.xlsx . is shown below.

Cable

Breaking Strength

1

4919.00

2

5048.09

3

5482.85

4

5461.08

5

4583.24

6

4926.37

7

5460.99

8

5214.26

9

5286.32

10

4767.98

11

3931.76

12

5191.09

13

5453.64

14

4543.81

15

6060.19

16

6356.22

17

5306.83

18

4515.58

19

4713.03

20

4827.88

21

5873.37

22

4474.94

23

4659.81

24

5255.17

25

5216.45

26

5929.35

27

5258.75

28

4797.17

29

5060.31

30

4434.27

31

5359.47

32

5684.72

33

4959.64

34

4492.24

35

4407.15

36

4936.43

37

5928.43

38

5796.95

39

5470.01

40

5347.04

41

5245.09

42

4723.65

43

5077.84

44

5785.64

45

4390.91

46

5402.91

47

5101.36

48

5471.37

49

5823.75

50

6123.87

51

5168.42

52

4829.37

53

4870.35

54

4884.67

55

4822.61

56

5019.64

57

5560.57

58

5815.23

59

4922.61

60

4393.84

61

5500.39

62

4957.40

63

5258.44

64

5591.10

Expert Solution

Step 1: Enter the Breaking Strength values in the cell P4 to P67 of Excel sheet

Step 2: Calculate number of observations(count), mean, standard deviation values in the cell B3, B4 and B5 of the same Excel sheet

Step 3: Develop the test for single mean as follows

orchestra answered 2 years ago

A factory produces steel cables, whose resilience follows a normal distribution of unknown mean and standard...

A factory produces steel cables, whose resilience follows a normal distribution of unknown mean and standard deviation σ = 10 KJ / m3. A sample of 100 pieces was taken and through a statistical study a confidence interval (898.04 - 901.96) was obtained for the average resilience of the steel cables produced in the factory. a) Calculate the value of the average resilience of the 100 pieces of the sample. b) Calculate the confidence level with which this interval has...

8. A business wants to know whether two versions of an email offer have the same...

8. A business wants to know whether two versions of an email offer have the same click-through proportion. It sent a random sample of customers an email. It randomly decided which of the two offers went in each email. In the end, it had the following data. 505 out of the 1218 customers that received the first email, clicked on the offer. 468 out of the 1221 customers that received the second email, clicked on the offer. (a) What is...

Betty's works in a steel mill making steel cables. Suppose cable strength can be altered in...

Betty's works in a steel mill making steel cables. Suppose cable strength can be altered in two different ways: thickness and the amount of molybdenum (an element used to make steel) it has. She wants to figure out the strongest cable she can make so she test several different cable formulas each many times. Below is a portion of the data she uses to run a regression with Thickness and Molydenum predicting Strength: Strength (Kilonewton, kN) Thickness (mm) Molybdenum (%)...

A consumer organization wants to know whether there is a difference in the price of a...

A consumer organization wants to know whether there is a difference in the price of a particular toy at three different store types. The price of the toy was checked in a sample of five discount stores, five variety stores, and five department stores. The sample results and the excel output are shown below: Discount Variety Dept. 12 15 19 13 17 17 14 14 16 12 18 20 15 17 19 Anova: Single Factor SUMMARY Groups Count Sum Average...

Ethics and Sustainability: Tata Steel Tata Steel is the second largest steel producer in Europe and...

Ethics and Sustainability: Tata Steel Tata Steel is the second largest steel producer in Europe and has its main steelmaking plants in the UK and Holland. It supplies steel and related services to major industries such as construction, vehicle production and packaging. Business ethics means ‘taking the right course’. Acting ethically takes into account all the factors of doing business. These include production, business processes and the company’s behavior with its customers and the communities in which it operates. It...

An advertising company wants to know whether the size of an advertisement and the color of...

An advertising company wants to know whether the size of an advertisement and the color of the advertisement make a difference in the response of magazine readers. A random sample of readers shown ads of 4 different colors and 3 different sizes. Assume that the ratings follow the normal distribution. The rating is shown in the following table: Size of Ad Color of Ad Red Blue Orange Green Small 4 3 3 8 Medium 3 5 6 7 Large 6...

A proponent of a new proposition on a ballot wants to know whether the proposition is...

A proponent of a new proposition on a ballot wants to know whether the proposition is likely to pass. The proposition will pass if it gets more than 50% of the votes. Suppose a poll is taken, and 560 out of 1000 randomly selected people support the proposition. Should the proponent use a hypothesis test or a confidence interval to answer this question? Explain. If it is a hypothesis test, state the hypotheses and find the test statistic, p-value, and...

Q 3) Essar Steel Ltd. (Essar Steel) is the largest integrated producer of steel in Western...

Q 3) Essar Steel Ltd. (Essar Steel) is the largest integrated producer of steel in Western India with a capacity of 4.6 million tonnes per annum (mtpa). Essar diversified its business by expanding into various sectors. The simultaneous launch of several projects during the 1990s pushed the group towards a liquidity crunch. To tide over the financial crisis, Essar Steel decided to avail the option of CDR to get out of the debt trap and strengthen its balance sheet. The...

You are a pork producer in Indiana. We now have a tariff on imported steel from...

You are a pork producer in Indiana. We now have a tariff on imported steel from China. In turn, China has a tariff on imported pork from the U. S. In one page, doubled spaced; 12 Font tell me how does this affect you; the pork exporter in Mexico.

Question 3 part 1: A researcher wants to know whether Aurors (magical police) have different drink...

Question 3 part 1: A researcher wants to know whether Aurors (magical police) have different drink preferences than the general wizarding population (these are known from prior research). He takes a sample of n = 300) Aurors and asks each one what their favorite drink is (see the table below). The goal was to see whether Aurors’ preferences differed from those of the general population. Assume all assumptions are met. Do all hypothesis testing for this part of question 3...