Solved by verified expert:HEYin the word file that I attached you will see 4 quotations that you need to be solved by following the steps

computer_project_2_fall_2019_1.docx_zahir_said.docx

Unformatted Attachment Preview

Computer Project Two

Fall 2019

Due Date: October 17th (at 1:45 PM)

Points Possible: 30

Self-selected groups of two students will work together to collect, enter, and

analyze stock prices from data collected from the Excel spreadsheet that I provided

in Canvas. As a group, 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 “S” column

(stocks that begin with “S”).

Randomly select 25 stocks from the NASDAQ “R” column (stocks that begin

with “R”).

For each stock, record the Company name as shown in the paper (create a

variable called NAME with the ticker symbol of the company), the most recent

closing stock price (create a variable 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 should be printed and filled out and handed in during class

on the due date listed above. Attach the specified printouts to the back of the

project that you turn in. Please note, only one project per group should be

handed in. Each group member will get the same grade for the project.

Projects can be turned in to QMB 2100 Lab in CIS 1036 anytime they are open.

The project is due by 1:45 PM on Thursday, October 17th.

Group Member Name

Student

Number

Section (TR 11, TR 12:30,

M Night, or T Night)

Directions: Fill in the answer to the questions posed below. Attach the specified

printouts where indicated and turn in during class (or to the stat lab in CIS 2004)

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.

Copy and paste a printout for a 94% confidence interval for the mean low price of all stocks on

both the NYSE and NASDAQ exchanges (you will show one confidence interval for all 65 stocks)

in the space provided below. Answer the following questions regarding this printout:

a. In the words of the problem, give a practical

interpretation of this interval.

Variable

Low

N

65

Lo 94% CI

14.451

Up 94% CI

73.136

b. Give a theoretical interpretation of the interval (i.e., explain what we mean when we say we are

“94% confident.”

2.

Copy and paste a 98% confidence interval for the mean high price of all stocks on the NASDAQ

exchange in the space provided. Answer the following questions regarding this printout:

a. What assumptions are necessary for this

confidence interval to be valid? Make sure

you use the words of the problem when

stating this assumption.

Descriptive Statistics of High by

Exchange

Exchange

0

1

N

40

25

Lo 98% CI

11.714

7.5888

Up 98% CI

146.56

67.781

b. Suppose I claim that the mean high price of all NASDAQ stocks was $25. Based on the interval

you created, make a statement regarding my claim.

Create a normal probability plot and stem-and-leaf plot for the 65 closing prices observed in your

data set.

Normal Probability Plot of Close

1200

Ordered Data

3.

800

400

0

-3

-2

-1

0

1

Rankits

Shapiro-Wilk W 0.3720 P(W) 0.0000 65 cases

2

3

Stem and Leaf Plot of Close

Leaf Digit Unit = 10

10 0 represents 1000

Minimum

Median

Maximum

0.0200

20.270

1004.5

Depth

(59)

Stem Leaves

0

000000000000000000000001111111112222222222333444

45555667999

6

1 055

3

2 6

2

3

2

4

2

5 3

1

6

1

7

1

8

1

9

1

10 0

65 cases included

0 missing cases

a. Do the plots indicate that the closing prices are normally distributed? Why or why not?

b. Find the mean and standard deviation for the 65 low prices in your sample and provide the

printout below. Use these values as estimates of the mean and standard deviation found in the

population of all low prices. Suppose that the low prices were normally distributed (regardless of

what your data may indicate). Find the proportion of all low prices that would be between $20 and

$50 in the population. I want you to show your work. To receive full credit, you should include

pictures of the normal curve (labeled with both x and z-values) with the pertinent probabilities

shaded in the picture.

Variable

N

Mean

SD

X

Low

65

43.794

123.55

z

4.

Use the values found in the last problem as the mean and standard deviation of the population of

all low prices. Find the probability that in a sample of 100 stocks, the average low price in the

sample would be more than $32.00. To receive full credit, you should include pictures of the

normal curve (labeled with both 𝑥̅ and z-values) with the pertinent probabilities shaded in the

picture.

𝑥̅

z

…

Purchase answer to see full

attachment

The price is based on these factors:

Academic level

Number of pages

Urgency

Basic features

- Free title page and bibliography
- Unlimited revisions
- Plagiarism-free guarantee
- Money-back guarantee
- 24/7 support

On-demand options

- Writer’s samples
- Part-by-part delivery
- Overnight delivery
- Copies of used sources
- Expert Proofreading

Paper format

- 275 words per page
- 12 pt Arial/Times New Roman
- Double line spacing
- Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Delivering a high-quality product at a reasonable price is not enough anymore.

That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more