Statistics project

What is the population of interest? What is the representative sample? If this is not apparent from the data, give your best idea of what the population and sample should be. Use Excel to: [login to view URL] a histogram of the data with 5 to 10 bins (classes) and comment on its shape(symmetry, skewness, modes, etc.). [login to view URL] a frequency table that uses the same bins from your histogram in #2. Include a column that gives the relative frequency. This is the only numerical portion of this project that can be typed in “by hand” by copying information from your histogram! [login to view URL] a pie chart from the frequency table using the actual frequency. Include a key and the percentage from each category [login to view URL] the mean, median, and mode of the data. [login to view URL] the five-number summary of the data. [login to view URL] the range and the standard deviation of the data using Excel equations, commands, or features. Do NOT use the “long” method to calculate standard deviation [login to view URL] a boxplot of the data (use the full set of data, not the five-number summary). Use the Excel Box and Whisker feature to create the boxplot! [login to view URL] the largest column from your histogram. Find the probability that your data falls in that bin. Do the same for the smallest column in your histogram. Find the probability that your data falls in both the largest bin or the smallest bin.