1. # Stock Dollar Value 1 CBS 11.46 2 T 17.48 3 NI 27.31 4 MRO 27.64 Part 1 - Mutual Funds (Measures of Center and Spread, Boxplots) (Questions 1-7) The values of individual stocks in the stock market can vary wildly. For that reason, investors usually purchase more than one kind of stock to balance out their risk. Some people are comfortable choosing their own blend of stocks. Other people prefer to invest in pre-bundled combinations of individual stocks called mutual funds. In this portion of the project, you will look at two mutual funds, each identified by its stock exchange abbreviation: LEXCX (composed of 22 stocks) and DIA (composed of 30 stocks). LEXCX Mutual Fund The dataset on the left displays the stock symbol and dollar value of each of the 22 stocks in the LEXCX mutual fund. For your convenience, the stocks are numbered in the order of their ascending value. Use the dataset to complete the EXACT five-number summary of the dollar values of the LEXCX mutual fund. Do not round your results even if they go beyond two decimal places. For any calculated values, show your work in the table along with your answer. Parts 2 and 3 - Height Requirements (Empirical Rule, z-scores, Applications of the Normal Curve) Part 2: Vehicle (Questions 8-11) 5 FL 28.21 A vehicle is designed to fit adults of a specific size range. 6 VIAB 31.96 7 CMCSA 42.94 8 CTVA 56.84 Minimum (2 pt) The heights of adult women in the United States are approximately normally distributed with a mean of (b) 65.18 inches and a standard deviation of (c). 2.67 8. Label the normal curve to 3 standard deviations in each direction to reflect this distribution of heights. inches. (3 pt) 92 DOW 57.67 10 AEE 72.45 1st Quartile (Q1) 11 DD 76.09 12 FBHS 83.28 13 14 15 345 ED 89.28 (3 pt) Median XOM 114.36 (3 pt) CVX 155.59 16 PG 162.21 3rd Quartile (Q3) 9. 17 GE 178.43 (d) According to the Empirical Rule (68-95-99.7 Rule), if a vehicle only accommodates people who are between _59.84 and 70.52 inches tall, what percentage of adult women in the United States will 18 MPC 195.83 (3 pt) fit? (2 pt) 19 HON 204.44 20 UNP 242.78 Maximum 21 BRK-B 415.26 (2 pt) 22 LIN 466.14 DIA Mutual Fund The average dollar values of the 30 stocks in the DIA mutual fund are summarized belo 100 130 200 DIA Mutual Fund Minimum DIA (a) 4.64 First Quartile (Q1) 73.73 Median 131.91 230 10. According to the Empirical Rule (68-95-99.7 Rule), what heights would the vehicle have to accommodate in order to fit the middle 68% of adult women in the United States? State the lowest and highest heights. (4 pt) 11. What percentage of adult women in the United States have a height of less than (e) 65.18 inches? (2 pt) Third Quartile (Q3) 175.87 Maximum 345.99 Answer the following about the DIA mutual fund by referring to the five-number summary and boxplot. If calculations are required, show your work and round results to two decimal places. Use correct units throughout. 2. What is the range in individual stock prices within this mutual fund? (3 pt) 3. An individual stock in the highest 25% of prices had a dollar value of at least how much? (2 pt) 4. If an individual stock price falls in the middle 50% of stock prices for this mutual fund, it must have a value between what two prices? Name them both. (4 pt) 5. Is the shape of the distribution of individual stock prices in this mutual fund approximately symmetric, left-skewed, or right-skewed? How do you know that from the boxplot? (4 pt) 6. Is the mean or the median a more appropriate measure of center for a distribution with this shape? Why? (4 pt) 7. Would you expect the mean of the individual stock prices within this mutual fund to be greater than, less than, or approximately equal to the median? Explain your choice. (4 pt)