Go through the lesson and take notes of all important information. Summarize the lesson and submit as a PDF file. Take Quiz 2 after going through this material. In your report include the following: 1) What are the measures of dispersion? Why is standard deviation preferred to range? 2) Creating your own data in Excel of 20 rows and 20 columns, find the Mean, Median, Mode, Standard deviation, Max, Min, Range and Variance. 3) What are the types of data? Provide examples of each. 4) What is skewness and kurtosis of a distribution. For the data created by you, what are these? (Use the Descriptive Statistics function under Data Analysis in Excel) 5) For the data created, create a box and whisker plot for the entire data and then for each column of the data. What can you conclude from these? 6) Find some examples of concentration charts on the web. How can they be useful? 7) Explore the use of NORM.DIST and NORM.INV in Excel. Can you create the Empirical Rule using these? 8) What is the central limit theorem? Conduct a simulation of the CLT based on the URL provided in the slide. 9) How can 2 data sets be compared using z-scores? 10) What is coefficient of variation? How can it be useful?
Go through the lesson and take notes of all important information. Summarize the
Important - Read this before proceeding
These instructions reflect a task our writers previously completed for another student. Should you require assistance with the same assignment, please submit your homework details to our writers’ platform. This will ensure you receive an original paper, you can submit as your own. For further guidance, visit our ‘How It Works’ page.
