MM207 Purdue Global Unit 2 Statistics Measure of Center Questions
Unit 2 Discussion Previous Next During this unit, you will investigate different numerical measures for describing data. You will use Excel in this Discussion. Please note that Excel graphs and charts do not paste into the Discussion Board. Therefore, please place your entire main post, all parts, all graphs, and all portions into a single Word Document. Then, attach that document to the Discussion Board as your main post.Choose any Excel dataset from class to work with:1. What is the name of your dataset?2. Choose and write down the name of any quantitative and continuous variable from your dataset and use Excel to calculate the mean, median, mode, min, max, range, variance, and standard deviation for that variable. Paste the results into your main post (or use Add/Remove to attach them).a. Which measure of center (mean, median, or mode) does the best job in describing your variable and why?b. Which measure of center (mean, median, or mode) does the worst job in describing your variable and why?c. Include (type in) the value 50000 into your selected variable data. Now, recalculate the mean, median, and the variance for your variable (now that it includes the extra value of 50000). How did this change the mean, median, and variance from their original values? Is the change what you expected?3. Choose any two quantitative variables from your dataset. Use three numerical measures to compare these two variables. Next, create a bar graph that includes the mean and median for both variables (to visualize their comparison).Please create personalized and substantive responses to at least two other student main posts. In your response, include the following:Which measure of center did the student use to best describe their variable? Include the name and type of the variable chosen by the student and explain why you agree or disagree with their choice for best measure of center.In number 3 above, the student was asked to choose any two quantitative variables and then for each of the two variables to calculate the mean and median. Next, using the mean and median for the first variable and the mean and median for the second variable, the student creates a bar graph (with four bars). Evaluate and critique the student’s graph. What does it tell you about the two variables?Discussion Requirement TEXTBOOKBennett, J., Briggs, W., Triola, M. (2014) Statistical Reasoning: For Everyday Life.Reading and ResourcesRead the assigned chapters from the following textbooks:Bennett, J., Briggs, W.L. & Triola, M.F. (2013) Statistical Reasoning for Everyday Life (4th ed.). Upper Saddle, NJ: Pearson.Chapter 4: “Describing Data”Reading the textbook and reviewing the textbook examples are excellent methods for starting each unit. Reading the textbook offers context and explanations for new concepts and methods. Completing the textbook examples on paper (and with Excel) is a great way to practice and learn the new methods and concepts introduced. Student feedback has suggested that reading the textbook and practicing the textbook examples has been particularly helpful if completed before the unit Seminar. Some students have reported that keeping a notebook handy, and recording new definitions or concepts encountered while reading is helpful, more organized, and stress reducing.This chapter includes a section that offers examples using technologies such as Excel. In addition, at the end of each chapter section, or at the end of the chapter, are review exercises that are very helpful for practicing and preparing.In this course, students may use Excel for any statistical calculations. Excel can be used to evaluate data in many ways. Excel can be used to calculate numerical measures, such as measures of center (such as mean and median) and measures of variation (variance, standard deviation, and range), as well as many other measures such as min, max, and correlation (r-value). Excel can also be used to create visualizations, such as histograms, bar graphs, pie graphs, scatterplots, and others. Excel may also be used to create linear regression equations. Because Excel is a very common tool, the Internet and YouTube both contain considerable support resources and tutorials.