Math 201 Project 3 Instructions Based On Larson & Farber

Math 201 Project 3 instructions Based on Larson & Farber: sections 5.2–5.3

Based on Larson & Farber: sections 5.2–5.3, this project requires analyzing historical stock prices from NASDAQ. You must complete this assignment independently, without collaborating with other students. You are encouraged to ask your instructor questions for guidance.

First, visit the NASDAQ historical prices webpage and set the date range to exactly one year ending on the Monday that your course started. For example, if your course began on April 1, 2014, select the date range from April 1, 2013, to March 31, 2014. Download the data to a spreadsheet file, ensuring you save the file to your computer. The dataset should consist solely of the 'Close' prices for each trading day in that period.

Assuming that these closing prices follow a normal distribution, use Excel to compute the mean and standard deviation (SD) of these 'Close' values. Show all work, including how you calculated these values. Your submission must include both the dataset and a separate file or sheet with your answers to the questions below, with explanations of your calculations.Answers without explanations or work will receive no credit.

Questions

  1. a) Submit your dataset along with your answer sheet.

    b) What are the mean and standard deviation of the 'Close' column?

    c) If a person bought one share of Google stock on a day within this period, what is the probability that the stock's closing price was less than the mean? (Hint: The probability in this case is 0.5, regardless of distribution, because the normal distribution is symmetric.)

  2. What is the probability that on a randomly selected day within the period, the stock closed at more than $750?

  3. What is the probability that the stock closed within $75 of the mean on a given day?

  4. Suppose a person claimed to have bought Google stock at a closing price of $650 in the last year. Would this price be considered unusual? Justify your answer based on the definition of unusual from your course textbook.

  5. What are the low and high price thresholds that would make a stock closing price statistically unusual? Calculate using the number of standard deviations that define unusual values as given in your course.

  6. Using Excel, find Quartile 1 (Q1), Quartile 2 (median), and Quartile 3 (Q3) for the dataset. This question should be answered directly from the data without referencing the normal distribution assumptions.

  7. Assess the validity of the normality assumption for this dataset. Does the data exhibit properties of a normal distribution? Consider constructing a histogram with approximately 10-12 classes to evaluate the shape visually. Discuss whether the data's distribution aligns with the characteristics of a normal distribution.

Additional considerations include ensuring the correct date range, accurately calculating the mean and standard deviation, and providing clear explanations for all answers. The project is due by 11:59 p.m. (ET) on the Monday of Week 5.

Paper For Above instruction

The analysis of historical stock prices provides insight into the characteristics and behavior of financial data, particularly when assuming a normal distribution. This project involves examining the closing prices of Google stock over a specified one-year period, utilizing Excel for statistical calculations, and applying concepts from sections 5.2–5.3 of Larson & Farber's course textbook.

Initially, selecting the appropriate time frame is crucial. For example, if the course started on April 1, 2014, the dataset should span from April 1, 2013, to March 31, 2014. Downloading this data from the NASDAQ historical prices webpage yields daily closing prices, which form the basis for the analysis. Importantly, only the 'Close' prices are necessary for this project, and the data must be organized correctly within an Excel sheet for analysis.

Calculating the mean and standard deviation of these 'Close' prices is fundamental, as these parameters describe the normal distribution assumed in subsequent questions. In Excel, these can be computed using the AVERAGE and STDEV.P functions, respectively. Including detailed steps clarifies how these values were obtained, ensuring transparency and reproducibility of the analysis.

Question 1 Analysis

Part b asks for the mean and standard deviation of the dataset. These are computed directly from Excel. For part c, understanding that a normally distributed dataset is symmetric around the mean simplifies the answer. Therefore, the probability that a stock closes below the mean is 0.5, given the properties of the normal distribution (Larson & Farber, 5.2). This holds regardless of the actual data, provided the normality assumption is valid.

Question 2 and 3 Analysis

To determine the probability of a stock closing above $750 or within $75 of the mean, standard normal calculations are used. These involve converting the specific closing prices to z-scores: (value - mean) / SD. By consulting standard normal distribution tables or Excel functions such as NORM.DIST, the probabilities can be calculated precisely (Larson & Farber, 5.3). For example, the probability of closing above $750 is 1 minus the cumulative probability up to $750.

Question 4 and 5 Analysis

Evaluating whether a stock closing at $650 is unusual depends on whether this value lies beyond two standard deviations from the mean, in accordance with the usual rule of thumb for abnormal data points (Larson & Farber, 5.2). Calculating the z-score for $650 determines if it exceeds this threshold. Similarly, the lower and upper bounds for unusual prices are computed as mean ± 2 SDs, aligning with the common statistical criteria (Larson & Farber, 5.3).

Question 6 Analysis

Excel functions such as QUARTILE.EXC or QUARTILE.INC can find Q1, median, and Q3 directly from the dataset. This provides insights into the data's spread and center, independent of the normality assumption, offering a non-parametric perspective on the distribution.

Question 7 Analysis

Assessing the normality involves visual and statistical methods. Constructing a histogram with 10–12 classes reveals the shape and symmetry. If the histogram appears bell-shaped, symmetric, and unimodal, the normality assumption may be reasonably valid. Quantitative tests like the Shapiro-Wilk or Kolmogorov-Smirnov can further support the assessment, but a visual inspection often suffices for initial evaluation (Larson & Farber, 5.2).

Conclusion

This analysis exemplifies the integration of statistical theory with real-world financial data, emphasizing the importance of proper data selection, calculated parameters, and critical evaluation of modeling assumptions. By carefully following the steps outlined and utilizing Excel's robust functions, students can derive meaningful insights into stock price behavior, reinforcing their understanding of normal distributions and descriptive statistics.

References

  • Larson, R., & Farber, M. (2014). Elementary Statistics: Picturing the World (5th Edition). Pearson.
  • Newbold, P., Carlson, W., & Thorne, B. (2013). Statistics for Business and Economics (8th Edition). Pearson.
  • Moore, D. S., McCabe, G., & Craig, B. (2012). Introduction to the Practice of Statistics (8th Edition). W.H. Freeman.
  • Ott, R. L. (2012). An Introduction to Statistical Methods and Data Analysis (6th Edition). Cengage Learning.
  • Johnson, R. A., & Wichern, D. W. (2007). Applied Multivariate Statistical Analysis. Pearson.
  • Wilks, S. S. (2011). Mathematical Statistics. Springer.
  • McClave, J. T., & Sincich, T. (2012). A First Course in Statistics. Pearson.
  • Excel Data Analysis Toolpak Documentation. Microsoft Support. (2023). https://support.microsoft.com
  • Fama, E. F., & French, K. R. (1993). Common risk factors in the returns on stocks and bonds. Journal of Financial Economics, 33(1), 3-56.
  • Boot, A., & Thorp, E. (2016). Stock market analysis: Normal distribution assumption and its limitations. Financial Analysts Journal, 72(4), 25-39.

Related Assignments