topic Re: please help for a example using SAS in SAS Programming

please help for a example using SAS

JaeGonKim — Fri, 13 Oct 2017 02:11:36 GMT

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

help the data import from Excel by using SAS

JaeGonKim — Tue, 10 Oct 2017 15:10:54 GMT

Hi everyone,

The new question is quite complex data with 3 columns:

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?

Re: help the data import from Excel by using SAS

ChrisNZ — Thu, 12 Oct 2017 05:36:26 GMT

Q1- Use proc import

Q2- Change the title so statisticians can chime in

Re: please help for a example using SAS

Reeza — Fri, 13 Oct 2017 02:46:09 GMT

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

Re: please help for a example using SAS

Reeza — Fri, 13 Oct 2017 02:47:23 GMT

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/m-p/402719#M20995

Re: help the data import from Excel by using SAS

Reeza — Fri, 13 Oct 2017 02:48:57 GMT

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

Re: help the data import from Excel by using SAS

JaeGonKim — Fri, 13 Oct 2017 08:50:09 GMT

Please help me make this example using SAS.

Thanks,

Joe

Re: help the data import from Excel by using SAS

error_prone — Fri, 13 Oct 2017 14:12:17 GMT

Please post the code you already have.

Re: help the data import from Excel by using SAS

Reeza — Fri, 13 Oct 2017 14:40:41 GMT

@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.

Re: please help for a example using SAS

ballardw — Fri, 13 Oct 2017 16:41:38 GMT

Hint: Proc TTest, look at Paired comparisons.