User Account

All Pages

What is the probability that the stock closed

Assignment Help Basic Statistics
Reference no: EM131038310

Go to this website. https://www.google.com/finance/historical?q=NASDAQ:GOOG

First, set the date range to begin exactly 1 year before the start of the term and to end with the day before the Monday that this course started. For example, if the current term started on 04/01/2014, then use 04/01/2013-03/31/2014. Next, click the link on the right that says Download to Spreadsheet, and save the file to your computer.

This project will only use the Closing 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 and then use those numbers and the methods you learned in sections 5.2 and 5.3 of our text book for Normal distributions to answer the questions.

Complete this 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. 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.

2. If a person bought one share of Google stock within the last year, what is the probability that the stock on that day closed at more than $400?

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 $45 of the mean for that year?

4. Suppose a person within the last year claimed to have bought Google stock at closing at $362.50 per share. What is the probability that the stock closed at $362.50 or less on a randomly selected business day?

5. At what prices would Google have to close at in order for it to be considered statistically unusual? You should have a low and high value. Be sure to use the definition of unusual from the textbook.

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 should answer without using anything about the Normal distribution.

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 our textbook? It does not need to be perfect. Real data sets are never perfect. However, it should be close. One option would be to construct a histogram like we did in Project 1 and see if it has the right shape. If you go this route, something in the range of 10 to 12 classes would be a good number.

Reference no: EM131038310

Questions Cloud

Management practices-organisation behavior outcomes : Write an essay of no more than 2000 words in which you critically reflect on the role of individual differences in your own management practices and Organisation Behavior outcomes. This assignment focuses on the Big Five Model of Personality.
Describe the most important permanent exhibit in the museum : Describe the most important permanent exhibit in the museum. Explain how the group's importance to the city could be represented in this exhibit.
Discuss how internet telephony has impacted your life : Discuss how Internet Telephony (VoIP) has impacted your life and your views of any social, ethical, and political issues involved in the application of this technology.
Model that assumes conditional independence : Refer to the previous exercise. Table 7.22 shows the fit of the model that assumes conditional independence between E/I and T/F and between E/I and J/P but has the other pairwise associations.
What is the probability that the stock closed : Suppose a person within the last year claimed to have bought Google stock at closing at $362.50 per share. What is the probability that the stock closed at $362.50 or less on a randomly selected business day
Name the recruitment process : A number of the employment process have been costly and hence a company have to choose the best and uncostly process for the profit of the to be maintained and never make unnecessary losses on recruitment process.
Write a short paper on kim ball group : Write a short paper on kim ball group.
Describe the windows phone application publishing process : Describe the Windows Phone application publishing process. What is the Azure cloud and do many people use this? If so, what is their experience when using it?
How will knowing the amount of seed needed : Mr. and Mrs. Quigley just moved into a new home with a lot of land. They need to plant grass seed. How will knowing the amount of seed needed from their old house help them with buying seed for the new lawn

Reviews

Write a Review

Basic Statistics Questions & Answers

  Formulate a linear program to determine production plan

Formulate a linear program to determine the production plan for the next three months that will minimize the total cost. Develop an EXCEL spreadsheet to find the optimal solution for Contois Carpets.

  Numbers of arbitrarily large absolute value

If S exists, then S(x, y) = 0 ∈ R. Then by Problem 4 there must be neighborhoods U of x and V of y in K such that S(u, v) ∈ R and |S(u, v)| 1 for all u ∈ U and v ∈ V . Show, however, that each of U and V contains real numbers of arbitrarily l..

  Would you in fact buy the advertising

Suppose now that your company has decided to value each hit at 1 cent. You are being offered a contract for an initial ten weeks of advertising space at $2,000 per week. Using your regression model, can you prove that buying the advertising would ..

  One of your companys products a flux capacitor is known to

one of your companys products a flux capacitor is known to have an exponential failure time distribution with a mean of

  Two histograms represent the distribution of acceptance rate

The accompanying two histograms represent the distribution of acceptance rates (percent accepted) among 25 business schools in 1995. The histograms use different class intervals, but are based on the same data. In each class interval, the left endpoi..

  A random sample of 81 children with working mothers showed

a random sample of 81 children with working mothers showed that they were absent from school an average of 6 days per

  Allocating assets among different investment choices

An issue that faces individuals investing for retirement is allocating assets among different investment choices. A study conducted 10 years ago showed that 65% of investors preferred stocks to real estate as an investment.

  Illustrate the decision rule graphically

An advisory group decided to investigate this claim, believing it was too large. A sample of 200 traffic accidents this year showed 74 persons were also involved in another accident within the last five years. Use the 0.01 significance level. Show..

  Describe steps of hypothesis testing

The American Bar Association conducted a survey in 1986 showed that the average income of lawyers in 1986 was $ 120,000. An investigator took a sample of 64 lawyers in 1990, produced a median income of $ 140,000 with a standard deviation of $ 24.5..

  Use either the critical-value approach or the p-value

use either the critical-value approach or the p-value approach to perform the required hypothesis test.independent

  Correlation between the two variablesa store manager wishes

correlation between the two variables.a store manager wishes to find out whether there is a relationship between the

  Create a mock spss data set

Create a mock SPSS data set. Create a data file in SPSS and enter the data presented in the table located in section 3.5 of chapter 3 in your textbook. Save this SPSS data file

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd