MATH 201 Project 3 Instructions Based on Larson & Farber: Sections 5.2-5.3

A project focusing on statistical methods and probability.

Isabella White
Contributor
5.0
30
6 months ago
Preview (2 of 3 Pages)
100%
Purchase to unlock

Page 1

MATH 201 Project 3 Instructions Based on Larson & Farber: Sections 5.2-5.3 - Page 1 preview image

Loading page ...

MATH 201PROJECT3INSTRUCTIONSBasedon Larson & Farber: sections 5.2-5.3Go tothis website.First,setthe date range tobe for exactly1 yearending with the Monday that this classstarted.For example, if the current term started on 04/01/2014, then use 04/01/201303/31/2014.Your dateswillgoing back exactly1year.Next, clickthe link on the right that saysDownload to Spreadsheetand thensave the file to your computer.This project willonly use the Closing Values.Assume that the closing prices of the stock form a normallydistributed data set.This means that you need to use Excel to find the mean and standard deviation and then usethose numbers and the methods you learned in sections 5.2 and 5.3 of our text book for Normal distributions toanswer the questions.Complete this assignment within a single Excel file.Show your workor explain how you obtained each of youranswers.Answers with no work and no explanation will receive no credit.1.If a person bought1share of Google stock within the last year, what is the probability that the stock onthat day closed at less than the mean for that year?Hint:You do not wantto calculate the mean toanswer this one. Theprobabilitywould be the same for any normal distribution.(4 points)The normal distribution is symmetric about the mean so,P(X < mean) = P(X> Mean) = 0.5, implying that the probability that the stock on that day closed at lessthan the mean for that year is 0.52.If a person boughtoneshare of Google stock within the last year, what isthe probabilitythat the stockonthat day closed at more than $400?(6 points)From the collected closing prices for a year,Mean =550.5616Standard Deviation =23.8304Sample Size =251Now,Z score for $400 =ସ଴଴ହହ଴.ହ616ଶ3.83଴ସ=6.318Required probability = P(X > $400) = P(Z >-6.318) = 1-P(Z <-6.318)= 1-0.0000= 13.If a person bought1share of Google stock within the last year, what isthe probabilitythat the stock onthat day closed within $45 of the mean for that year?(6 points)Z score for upper value =ହହ଴.ହ616ସହହହ଴.ହ616ଶ3.83଴ସ=1.89

Page 2

Preview Mode

This document has 3 pages. Sign in to access the full document!

Study Now!

XY-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat

Document Details

Related Documents

View all