Project 3 instructions

Based on Brase & Brase: sections 6.1-6.3

Visit the NASDAQ historical prices weblink. First, set the date range to be for exactly 1 year ending on the Monday that this course started. For example, if the current term started on April 1, 2018, then use April 1, 2017 – March 31, 2018. (Do NOT use these dates. Use the dates that match up with the current term.) Do this by clicking on the blue dates after “Time Period”. Next, click the “Apply” button. Next, click the link on the right side of the page that says “Download Data” to save the file to your computer. NOTE THIS CLASS BEGAN ON 1/20/2020 please use this date to help me answer these questions... PLEASE ONLY HELP ME WITH QUESTIONS 5-7!! I have the first four completed with help!

This project will only use the Close values. Assume that the closing prices of the stock form a normally distributed data set. This means that you need to use Excel to find the mean and standard deviation. Then, use those numbers and the methods you learned in sections 6.1-6.3 of the course textbook for normal distributions to answer the questions. Do NOT count the number of data points.

Complete this portion of the assignment within a single Excel file. Show your work or explain how you obtained each of your answers. Answers with no work and no explanation will receive no credit.

1. a) Submit a copy of your dataset along with a file that contains your answers to all of the following questions.

b) What the mean and Standard Deviation (SD) of the Close column in your data set?

c) If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at less than the mean for that year? Hint: You do not want to calculate the mean to answer this one. The probability would be the same for any normal distribution. (5 points)

2. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at more than $1150? (5 points)
3. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed within $50 of the mean for that year? (between 50 below and 50 above the mean) (5 points)
4. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at less than $950 per share. Would this be considered unusal? Use the definition of unusual from the course textbook that is measured as a number of standard deviations (5 points)
5. At what prices would Google have to close in order for it to be considered statistically unusual? You will have a low and high value. Use the definition of unusual from the course textbook that is measured as a number of standard deviations. (5 points)
6. What are Quartile 1, Quartile 2, and Quartile 3 in this data set? Use Excel to find these values. This is the only question that you must answer without using anything about the normal distribution. (5 points)
7. Is the normality assumption that was made at the beginning valid? Why or why not? Hint: Does this distribution have the properties of a normal distribution as described in the course textbook? Real data sets are never perfect, however, it should be close. One option would be to construct a histogram like you did in Project 1 to see if it has the right shape. Something in the range of 10 to 12 classes is a good number. (5 points)

There are also 5 points for miscellaneous items like correct date range, correct mean, correct SD, etc.

Project 3 is due by 11:59 p.m. (ET) on Monday of Module/Week 5.

1. A study of a disease reveals that there is an average of 1 case every 22 square miles. Residents of a town that has an area of 10 square miles are concerned because there are two cases in their area. The state’s Department of Health has decided to investigate further if the probability of getting two or more cases in this town is less than 0.05. Does the Department of Health investigate further?   (3)

2. A lottery is carried out by choosing five balls, without replacement, from a box of 35 balls. The lottery ticket has five numbers on it. Find the probability that exactly four of the balls that come out of the box match the numbers on the lottery ticket. (3)

3. A neighborhood has 32 households – 27 white, and 5 nonwhite. A subset of 9 of these households move to an adjacent neighborhood. What is the probability that less than two of the households in the new neighborhood are nonwhite? (3)

1. Suppose a pool of insurance policyholders can be classified into groups 1, 2, and 3. For a person from group i, the number of accidents that the person will have in a year follows a Poisson distribution with parameter i, for i=1, 2, 3. Suppose 20% of the policyholders are in group 1, 40% in group 2 and 40% in group 3.
   1. For a policyholder in group 3, what is the probability that the person will have at least one accident in a year?
   2. Find the probability that a randomly selected person from the pool will have exactly two accidents in a year.

According to an​ article, 34​% of adults have experienced a breakup at least once during the last 10 years. Of 9 randomly selected​ adults, find the probability that the​ number, X, who have experienced a breakup at least once during the last 10 years is

a. exactly​ five; at most​ five; at least five.

b. at least​ one; at most one.

c. between 5 and 7 inclusive.

d. Determine the probability distribution of the random variable X.

Dice Game

Rules:

2 - 4 players

Each player has 5 Dice. The dice have 6 sides.

Each player rolls their dice, and the dice statistics are reported:

Sum, number of pairs (and of what), and "straights" - (all dice in order - e.g. 1,2,3,4,5 or 2,3,4,5,6)

Player 1 might roll 2,2,3,4,4 so the results would be:
Sum: 15, 1 pair (2), 1 pair (4)

Player 2 might roll 1, 1, 4, 6, 6 so the results would be:

Sum: 18, 1 pair (1), 1 pair (6)

Player 3 might roll 3, 3, 3, 5, 6 so the results would be:

Sum: 20, 1 triple (3)

Player 4 might roll 1, 2, 3, 5, 6

Sum: 17

Only one player wins per turn. Points are awarded as follows (only the highest possible point, not a sum of possibles):

The higher pairs beat the lower pairs. (If no other winner, then player 2 beats player 1 because a pair of 6 beats a pair of 4).

Ties re-roll between themselves.

First player to 50 points wins.

If you have built your program properly, you should be able to change the number of players, the number of dice sides, the number of dice, and the win point condition (50 points to something higher) and no changes should be needed to any of the rest of your code.

PS: NetBeans/Java Pls.

Scenario 1:
A researcher wants to determine if different forms of regular exercise alter HDL levels in obese middle aged males between the ages of 35 and 45.  Participants in the study are randomly assigned to one of four exercise groups – No Exercise, Resistance Training, Aerobic Exercise or Stretching/Yoga – and instructed to follow the program for 8 weeks.  Their HDL levels are measured after 8 weeks and are summarized below.

1. What is the null hypothesis equation for this experiment?

2. Specify the ν_nnumerator degrees of freedom? Please paste your data output file in the space below.

3. Specify the ν_ddenominator degrees of freedom?  

4. Identify the F-critical value at P<0.05 from the F distribution table 3-1 from the Primer of Biostatistics 7^thEd.

5. Identify the F-critical value at P<0.01 from the F distribution table 3-1 from the Primer of Biostatistics 7^thEd.

6. Specify whether you accept or reject the null hypothesis at P<0.05?

7. Specify whether you accept or reject the alternate hypothesis at P<0.05?

1. The following is the frequency distribution table of the marks scored by candidates in an examination.
Marks 0-9 10-19 20-29 30-39 40-49 50-59 60-69 70-79 80-89 90-99
frequency 2 7 8 13 24 30 6 5 3 2

A. Make a cumulative frequency table and use it to draw the cumulative frequency curve for the distribution
B. Use your graph to estimate
I. The median mark
II. The lower quartile
III. The upper quartile
IV. The inter quartile range
V. The pass mark if the 60 percent of students passed
VI. The 40th percentile
VII. The 20th percentile
C. Calculate the following
I. Mode
II. Median
III. Standard deviation
IV. Co efficient of variation
V. Skewness

Step 1:

Enter a negative estimate as a negative number in the regression model. round your answers to 4 decimal places, if necassary

yi=________+(_____________)xi

Step 2: Interpret the coefficient of the first test grade in the model.

Psychopaths tend to be cold and calculated, often not worrying about others or consequences so they are typically not anxious. You are curious whether anxiety scores for people are associated with psychopathy scores. To test this you survey 12 undergraduate students on their anxiety level (0 to 100, higher mean more anxious) and their score on a standard psychopathy measure (0 to 40, higher score indicated a higher level of psychopathy). The data is as follows:

1) If you consider both variables to be interval, what is the correlation between anxiety and psychopathy scores?