Project 3 | Mathematics homework help

Don't use plagiarized sources. Get Your Assignment on
Project 3 | Mathematics homework help
Just from $13/Page
Order Now


Project 3 instructions


Based on Larson & Farber: sections 5.1–5.3




Go to


Click the link on the right that says Download to Spreadsheet.  Set the date range to end on 11/19/13 (the beginning of Module/Week 5) and going back exactly 1 year (11/20/12).  Then, click the link on the right that says, “Download to Spreadsheet.” Assume that the closing prices of the stock form a normally distributed data set. (Now will be a good idea to review the definition and properties of a normal distribution on p. 236


Do not manually count values in the data set, but use the ideas found in sections 5.2–5 .3. (You may want to review how to find mean and standard deviation given a data set. It will also help to review how to use Excel to find those quantities. Please refer to the Excel file I posted on DB>>Useful files) Complete this assignment within a single Excel file. Show your work where possible.


Answer the following:




  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: Use the Empirical Rule, do not calculate the mean. The answer is easy.


Hint: use property #2 on p. 236- the normal curve is bell-shaped and is symmetric about the mean.


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 $500?  Hint: Use Excel to find the mean and standard deviation. Then find the z score.


Hint: To find that, you will need to find: a) the mean, b) find z score (let’s call it z1) that corresponds to x = 500, c) find P(z< z1), and recall that P(z > z1) = 1 – P(z<z1)


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? Hint: Find two z scores and use the Standard Normal Table. 


Hint: Find the z-scores that correspond to adding and subtracting $45 from the mean.   Find the corresponding probabilities and then subtract.


4. Suppose a person within the last year claimed to have bought Google stock at closing at $700 per share. Would such a price be considered unusual?  Explain by using the Empirical Rule, do not find the max or min values of the daily closing prices


Hint: find the z score. What z score do we say that the corresponding data point x is unusual?


5. At what price would Google have to close at in order for it to be considered statistically unusual? You should have a low and high value. Use the Empirical Rule.


Hint: You will have an upper bound and a lower bound. You will need to find the standard deviation of the data set before you proceed.


6. What are Q1, Q2, and Q3 in this data set? Use Excel to find these values.


Hint: use = quartile(array, 1) to find Q1, =quartile(array, 2) to find Q2, and =quartile(array, 3) to find Q3. The array is your data set. 


7. Is the assumption that was made at the beginning valid? Why or why not?  Hint: Construct a histogram.


Hint: Does the data set have the properties of a normal distribution? Is the mean and median almost the same? Is the difference between Q1 and Q2 and the difference between Q2 and Q3 approximately the same?


Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
good job
Customer 456821, October 24th, 2022
Business Studies
Although my order was not delivered at my requested time due to issues with email, the material received was great.
Customer 454605, June 19th, 2020
excellent job
Customer 456821, August 3rd, 2022
Film & Theater studies
Good work.
Customer 462687, July 4th, 2022
Human Resources Management (HRM)
Good work
Customer 463059, June 9th, 2022
Customer 459155, May 31st, 2022
Business and administrative studies
Thank you!
Customer 453187, February 21st, 2022
Customer 463813, March 8th, 2023
Business Studies
I got a B on the paper. Which is okay. But would of preferred an A paper since I paid a bit more for better writing.
Customer 454445, June 2nd, 2020
Be keen on plagiarism.
Customer 454463, March 28th, 2022
Social Work and Human Services
Good work.
Customer 462793, July 8th, 2022
Business Studies
Thoroughly satisfied
Customer 453947, March 24th, 2020
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat