Sym AAPL ABT AGN ALL AMZN AXP BAC BK BRK.B CAT CL CMCSK COP CSCO CVX DIS DVN EMR F FDX FOXA GE GM GOOGL HAL HON IBM JNJ KMI LLY LOW MCD MDT MMM MON MS NKE ORCL High 121.22 45.34 317.04 62.94 630.72 74.28 17.18 42.67 137.87 73.28 68.07 63.48 54.17 29.25 91.98 115.24 42.58 47.51 14.95 156.56 30.77 29.33 35.2 746.31 38.73 104 141.33 102.12 27.49 82.55 74.57 113.29 74.35 158.68 94.07 33.57 131.62 39.04 Low 119.45 44.76 305.63 61.85 625.28 73.06 16.76 41.62 136.02 71.63 66.35 62.71 52.59 28.85 89.41 113.67 40.33 46.93 14.63 154.54 30.19 28.91 34.46 736.53 37.7 102.94 139.9 101.01 26.6 81.57 73.78 112.25 73.55 157.21 92.98 32.93 130.07 38.5 Volume 49,365,203 8,442,300 8,889,000 3,913,400 3,874,300 6,310,100 87,645,695 8,758,800 4,228,200 7,388,700 7,455,100 2,372,200 7,544,500 22,334,000 11,559,200 8,501,600 5,756,500 6,658,400 29,225,799 2,580,600 15,846,200 71,021,297 10,723,801 1,999,100 9,626,200 2,923,200 3,983,900 10,520,300 19,809,201 4,044,200 4,418,800 6,409,400 5,315,800 2,672,100 3,804,400 13,581,000 3,615,400 16,471,500 Unit 3 Lab Assignment Lab Project The goal of this lab is to find descriptive statistics for your quantitative data. Part 1: V2 Quantitative Data Use the list of all 40 numbers from Lab 1, column V2 for this part of the lab. A. Identify the name of the quantitative variable V2 that you are using. __________________ B. Use Microsoft Excel to find Mean ________________________ Median _______________________ Mode _________________________ Standard Deviation _________________________ Minimum Value ________________________ Maximum Value ________________________ Q1 _____________________________ Q3 _____________________________ C. Consider your values for mean, median and mode listed above. Which is the largest? Discuss the similarities and differences among your three measures. Which one of these measures of central tendency is most suitable for your data? Explain your choice. D. data. Using the appropriate numbers from B above, make a box-and-whisker plot for your What does this plot tell you about your data? E. Looking at your list in B, list your lowest, highest and mean data values. List below and then find the z -score for each. 1 Data Value, x z - score Lowest z= xx = s Highest Mean F. How do z -scores indicate a data value is above the mean? _______________________ below the mean? __________________________________ What z -score always corresponds to the mean? ___________________________ Part 2: V3, Quantitative Data A. What is the name of your V3 variable? _________________________________________ B. Fill in the values in the chart below using the frequency distribution in Lab 2, Part 3. You may not need all of the rows below. Data Groups, using V3 frequen cy, f f Class Midpoin t, x xf xX n 2 ( x X )2 ( x X )2 f C. x s D. Use the appropriate values in the table to find the mean x and standard deviation s for your grouped data. Show your computations. ( x f ) n ( x x) 2 f n 1 Use Chebyshev's Theorem to write a statement about the interval from 2 standard deviations below the mean to 2 standard deviations above the mean. List the specific interval you used for your data. Interpret the result in the context of your data. Stat Project Points: 25 Points 3