LEARN MORE...

Ans Proj 3 Spring 2020 2

Content type

User Generated

Subject

Statistics

School

The University of South Florida

Course

CIS 1036

Type

Homework

Uploaded By

zvpunrynerara984

Pages

Showing Page:

1/7

Computer Project Three

Spring 2020

Due Date: April 22nd (at midnight)

Points Possible: 40

Each student will work individually to collect, enter, and analyze stock prices from

the Excel spreadsheet found on the Project Data Information link page in Canvas.

Use the physical mixing techniques discussed in class to generate a simple

random sample of 65 stocks with the following constraints:

1. Randomly select 40 stocks from the New York Stock Exchange “R” column

(left-hand column in the spreadsheet).

2. Randomly select 25 stocks from the NASDAQ “T” column (right-hand

column in the spreadsheet).

For each stock, you will need to google or search for the stock data that I am

requiring. You will need to record the Company name or Ticker Symbol in a

variable column you create called NAME (with at least 15 spaces for the company

name or the ticker symbol), the current stock price (which will be the closing price

the for stock on the day you collect the data) in a variable column you create called

CLOSE, the previous 52-week high price (create a variable called HIGH), the

previous 52-week low price (create a variable called LOW), and the exchange that

the stock is traded on (create a variable called EXCHANGE that is 0 if NYSE and

1 if NASDAQ). Enter the stock prices that you collect to two decimal places. Enter

the stocks selected from both exchanges into a single data set.

The following two pages (do not print this page) should be printed and filled out

and handed in during class (or in the Stat Lab in CIS 1036) before the due date

listed above. Attach the specified printouts to the back of the project that you turn

in.

Projects can be submitted in Canvas by midnight on April 22

Showing Page:

2/7

Name: _______________________________

Student Number: ____________________________

Directions: Fill in the answer to the questions posed below. Attach the specified printouts where indicated and

upload it in Canvas on or before the due date posted at the top of this project. Please give specific interpretations

as generic answers will not receive full credit.

1. Create the printout for testing whether the mean low stock price of all NYSE stocks differs from $35

and attach it here. Answer the following questions regarding this printout:

a. In the words of the problem, give a practical conclusion for this test. Make sure to include your

choice of α in this conclusion.

Using an alpha level of 0.05, there is insufficient evidence to reject the null hypothesis as the p

value (0.077) is greater than the alpha level. There is therefore insufficient evidence that the mean

low stock price of all NYSE stocks differs from $35

b. In the words of the problem, state what a Type I error would be.

Type 1 error occurs when one rejects a true Null hypothesis. For the above case, a type 1 error

would be concluding that the mean low stock price of all NYSE stocks differs from $35 while the

mean low stock price of all NYSE stocks is actually $35

c. Use your knowledge of p-values and the printout above to state what the p-value would have

been if you were conducting a one-tailed test instead of the two-tailed test I asked for.

The p value = 0.0771/2 = 0.03855

One-Sample T Test

Null Hypothesis: μ = 35

Alternative Hyp: μ ≠ 35

Lower Upper

Variable Mean SE T DF P 95% C.I. 95% C.I.

LOW 48.459 7.4113 1.82 39 0.0771 33.468 63.449

Cases Included 40 Missing Cases 0

Showing Page:

3/7

End of Preview - Want to read all 7 pages?

Access Now

Unformatted Attachment Preview

Computer Project Three Spring 2020 Due Date: April 22nd (at midnight) Points Possible: 40 Each student will work individually to collect, enter, and analyze stock prices from the Excel spreadsheet found on the Project Data Information link page in Canvas. Use the physical mixing techniques discussed in class to generate a simple random sample of 65 stocks with the following constraints: 1. 2. Randomly select 40 stocks from the New York Stock Exchange “R” column (left-hand column in the spreadsheet). Randomly select 25 stocks from the NASDAQ “T” column (right-hand column in the spreadsheet). For each stock, you will need to google or search for the stock data that I am requiring. You will need to record the Company name or Ticker Symbol in a variable column you create called NAME (with at least 15 spaces for the company name or the ticker symbol), the current stock price (which will be the closing price the for stock on the day you collect the data) in a variable column you create called CLOSE, the previous 52-week high price (create a variable called HIGH), the previous 52-week low price (create a variable called LOW), and the exchange that the stock is traded on (create a variable called EXCHANGE that is 0 if NYSE and 1 if NASDAQ). Enter the stock prices that you collect to two decimal places. Enter the stocks selected from both exchanges into a single data set. The following two pages (do not print this page) should be printed and filled out and handed in during c ...
Purchase document to see full attachment

Tags: null hypothesis NASDAQ type 1 error Simple Random Sample analyze stock prices