please help for a example using SAS

[JaeGonKim]

Hi all,

 I have a question is quite complex data with 3 columns:

A company that manufactures motors receives reels of 10,000 terminals per reel. Before using a reel of terminals, 20 terminals are randomly selected to be tested. The test is the amount of pressure needed to pull the terminal apart from its mate. This amount of pressure should continue to increase from test to test as the terminal is “roughed up.” Let W equal the difference of the pressures: “test No. 1 pressure” minus “test No. 2 pressure.” Assume that the distribution of W is N(μw, σw2). We shall test the null hypothesis H0: μw = 0 against the alternative hypothesis HA: μw < 0 using 20 pairs of observations.

• Give the test statistic and a critical region that has a significance level of α = 0.05.

Terminal	Test #1	Test #2
1	2.5	3.8
2	4.0	3.9
3	5.2	4.7
4	4.9	6.0
5	5.2	5.7
6	6.0	5.7
7	5.2	5.0
8	6.6	6.2
9	6.7	7.3
10	6.6	6.5
11	7.3	8.2
12	7.2	6.6
13	5.9	6.8
14	7.5	6.6
15	7.1	7.5
16	7.2	7.5
17	6.1	7.3
18	6.3	7.1
19	6.5	7.2
20	6.5	6.7

• Verify by using a SAS.
• What is the approximate p-value of this test?

 Thanks,

Joe

[JaeGonKim]

Hi everyone,

The new question is quite complex data with 3 columns:

A company that manufactures motors receives reels of 10,000 terminals per reel. Before using a reel of terminals, 20 terminals are randomly selected to be tested. The test is the amount of pressure needed to pull the terminal apart from its mate. This amount of pressure should continue to increase from test to test as the terminal is “roughed up.” Let W equal the difference of the pressures: “test No. 1 pressure” minus “test No. 2 pressure.” Assume that the distribution of W is N(μw, σw2). We shall test the null hypothesis H0: μw = 0 against the alternative hypothesis HA: μw < 0 using 20 pairs of observations.

• Give the test statistic and a critical region that has a significance level of α = 0.05.

Terminal	Test #1	Test #2
1	2.5	3.8
2	4.0	3.9
3	5.2	4.7
4	4.9	6.0
5	5.2	5.7
6	6.0	5.7
7	5.2	5.0
8	6.6	6.2
9	6.7	7.3
10	6.6	6.5
11	7.3	8.2
12	7.2	6.6
13	5.9	6.8
14	7.5	6.6
15	7.1	7.5
16	7.2	7.5
17	6.1	7.3
18	6.3	7.1
19	6.5	7.2
20	6.5	6.7

• I want to import this table from Excel and than using SAS software to solve it.
• What is the approximate p-value of this test?

[JaeGonKim]

Hi everyone,

The new question is quite complex data with 3 columns:

A company that manufactures motors receives reels of 10,000 terminals per reel. Before using a reel of terminals, 20 terminals are randomly selected to be tested. The test is the amount of pressure needed to pull the terminal apart from its mate. This amount of pressure should continue to increase from test to test as the terminal is “roughed up.” Let W equal the difference of the pressures: “test No. 1 pressure” minus “test No. 2 pressure.” Assume that the distribution of W is N(μw, σw2). We shall test the null hypothesis H0: μw = 0 against the alternative hypothesis HA: μw < 0 using 20 pairs of observations.

• Give the test statistic and a critical region that has a significance level of α = 0.05.

Terminal	Test #1	Test #2
1	2.5	3.8
2	4.0	3.9
3	5.2	4.7
4	4.9	6.0
5	5.2	5.7
6	6.0	5.7
7	5.2	5.0
8	6.6	6.2
9	6.7	7.3
10	6.6	6.5
11	7.3	8.2
12	7.2	6.6
13	5.9	6.8
14	7.5	6.6
15	7.1	7.5
16	7.2	7.5
17	6.1	7.3
18	6.3	7.1
19	6.5	7.2
20	6.5	6.7

• I want to import this table from Excel and than using SAS software to solve it.
• What is the approximate p-value of this test?

[ChrisNZ]

Q1- Use proc import

Q2- Change the title so statisticians can chime in

[Reeza]

Note that I've merged this thread into one, as it's a duplicate post. 

[JaeGonKim]

Please help me make  this example using SAS.

Thanks,

Joe

[error_prone]

Please post the code you already have.

[Reeza]

---

@JaeGonKim wrote:

Please help me make  this example using SAS.

Thanks,

Joe

---

@JaeGonKim please explain how this is different than your previous question, which I linked to and why the solution there doesn't work for this data. Include the code and errors, if applicable.

[Reeza]

This is clearly homework. 

1. What statistical test are you trying to run?

2. Which SAS Procedure carries out that procedure?

3. Look up that procedure in the SAS documentation and check the examples sections for many examples. 

If you still need help, post back with what you've tried and details. 

If it's not homework, and you're interested in learning SAS for statistical analysis, the first SAS e-course is free and will cover these types of topics. And the steps above still apply 🙂

---

@JaeGonKim wrote:

Hi all,

 I have a question is quite complex data with 3 columns:

A company that manufactures motors receives reels of 10,000 terminals per reel. Before using a reel of terminals, 20 terminals are randomly selected to be tested. The test is the amount of pressure needed to pull the terminal apart from its mate. This amount of pressure should continue to increase from test to test as the terminal is “roughed up.” Let W equal the difference of the pressures: “test No. 1 pressure” minus “test No. 2 pressure.” Assume that the distribution of W is N(μw, σw2). We shall test the null hypothesis H0: μw = 0 against the alternative hypothesis HA: μw < 0 using 20 pairs of observations.

• Give the test statistic and a critical region that has a significance level of α = 0.05.

Terminal	Test #1	Test #2
1	2.5	3.8
2	4.0	3.9
3	5.2	4.7
4	4.9	6.0
5	5.2	5.7
6	6.0	5.7
7	5.2	5.0
8	6.6	6.2
9	6.7	7.3
10	6.6	6.5
11	7.3	8.2
12	7.2	6.6
13	5.9	6.8
14	7.5	6.6
15	7.1	7.5
16	7.2	7.5
17	6.1	7.3
18	6.3	7.1
19	6.5	7.2
20	6.5	6.7

• Verify by using a SAS.
• What is the approximate p-value of this test?

 Thanks,

Joe

---

[Reeza]

Scratch that, this is identical to your previous question. Review the answer there. 

Good Luck. 

https://communities.sas.com/t5/SAS-Statistical-Procedures/Help-me-verify-answers-by-using-SAS-output...

[ballardw]

Hint: Proc TTest, look at Paired comparisons.