Go to this website. Set the date range to be 10/1/2013 to 10/1/2014. Click the link on the right that says Download to Spreadsheet

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. (4 points)

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

4.      Suppose a person within the last year claimed to have bought Google stock at closing at $362.5 per share. Would such a price be considered unusual? Be sure to use the definition of unusual from our textbook.  (6 points)

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

Design tests of controls, substantive tests of transactions, and analytical procedures for the following Apollo Shoes cycles:

• Inventory and warehousing cycle
• Cash cycle

I just need a summary on how to link the above topics. Willing to negotiate price

1        Experimental Methods

1.1       Peanut oil viscosity measurement

a.     The small ball diameter and weight were measured and recorded.

b.     The mass of the peanut oil was measured by weighing both the empty graduated cylinder and the same cylinder with peanut oil then subtracting the mass of empty cylinder from the mass of cylinder with the oil.

c.     The volume of the peanut oil used was noted. Density of the oil was calculated using the obtained mass and volume.

d.     Two marks; one near the top of the cylinder and another one near the bottom of the cylinder were made and the distance between them measured.

e.     The small ball was dropped into the oil and the stop watch was started when the bottom of the ball reached the top mark on the cylinder and stopped when the ball. reached the mark at the bottom of the cylinder.

f.      Velocity of the small ball was calculated.

g.     The experimental results were used to calculate the oil viscosity using Stokes’ equation.

h.     The above steps were repeated but this time using a bigger ball.

1.2       Flash point testing

a.     40 ml of the peanut oil was measured using a measuring cylinder and poured into the test flask.

b.     The burner was lit and put under the flask so that the flask was heated directly by the burner.

c.     The temperature was increased at equal interval and temperature reading was made with the help of a thermometer inserted into the sample peanut oil in the flask.

d.     When the sample temperature approached the theoretical flash point, a test flame was inserted momentarily into the vapor space.

e.     Temperature was raised gradually and every time testing the flash point using a test flame.

f.      The minimum temperature at which the vapor caught fire momentarily was recorded. This temperature was the flash point of the peanut oil.

g.     The above procedure was repeated for the corn oil.

1.3       Thermocouple

a.     The thermocouple that was prepared in the lab was used to take temperature readings in the cold water; the reference junction was left exposed to the atmosphere while the measuring junction inserted in cold water and temperature readings were taken after every 20 seconds.

b.     The above process was repeated for the hot water and the data collected were noted.

c.     The graph of temperature versus time was plotted.

d.     The above procedure was repeated for the hot water and the data collected were recorded.

Due in Week 7 – The Final Comprehensive Submission (70 points)

This final piece of the assignment will allow you to combine all of the elements in the training process. While there is no new research that needs to be conducted for this week’s assignment, you should apply feedback from the previous week’s assignments and update your work to present a clean, final draft.  This project should be submitted as a single, cohesive Word document (not multiple files). Use section breaks or page breaks to separate the different elements. You will provide a single reference list (at least 16 sources total.) 

Appendixes will be formatted at the end of the overall document – not the end of the section. You can’t simply cut/paste the different elements from your prior work into a single document and consider it to be complete. There must be unity, flow, and cohesiveness including the use of an Abstract,  Introduction and Conclusion. Finally, be sure that you are using uniform formatting for this document. Check margins, font, etc. prior to submitting. Anticipated length of body of this assignment: 12-16 pages, including title and reference pages, as well as your Appendixes. Include headings and a table of contents.

Sources/Formatting

A note on sources: You will be expected to conduct research outside of our classroom and beyond your own experiences to complete this assignment. For Weeks 2-5, you will be expected to use at least four unique documented sources outside of our classroom (the textbook does not count as an outside source). You are not required to conduct additional research for Week 7 but may add to your list if you’ve found additional sources on your journey. If you do use the textbook, you will need to give credit to this source. While sources may be used from week to week, you will be expected to find at least four new sources for each of the Week 2 through 5 assignments. I would urge you to use the DeVry Online library to seek out scholarly and current journal articles. Additionally, you might seek information from reputable organizations such as the Society for Human Resources Management or interview a Human Resources Professional.

A note on formatting: You will be expected to complete each assignment using APA formatting. This will include the use of appropriate font, margins, section headers, etc. You will be expected to provide a complete APA formatted reference list for each weeks’ assignment. Additionally, per APA you will be expected to give credit to these sources in-text. This project should be written in the third person.

Grading Rubrics

The following rubric will be used for Week 7:

For Weeks 1 through 5, the emphasis is placed on content as you develop your training program. For Week 7, the emphasis is placed on your ability to present a reasonable and thoughtful program, a key need in any organization.