MATH 2610 Survey of Statistics Lab Assignment #1: Data Visualization Statistical concepts used in this lab: · Using the Introductory to Statistics Excel Lab Manual · Creating Frequency Distributions ·...

Question 2-10


MATH 2610 Survey of Statistics Lab Assignment #1: Data Visualization Statistical concepts used in this lab: · Using the Introductory to Statistics Excel Lab Manual · Creating Frequency Distributions · Graphing Frequency Histograms · Graphing Box-n-whisker Plots · Identifying the shape of distributions LAB INSTRUCTIONS · Use the Introductory to Statistics Excel Lab Manual to help you understand how to create and interpret the graphs in this lab assignment. · The data set for this course has already been formatted, entered into an Excel worksheet and posted in Blackboard. · The names of each variable are in the first row of the Worksheet. This row has a background color of gray to identify it as the variable names. All other rows of the Worksheet represent a brand of cereal. Therefore, the rows are called observations and the columns are called variables. · Follow the directions below and then paste the graphs from Excel in the gray areas for question 1 through 5. Type your answers to questions 6 through 10 where noted in the gray areas. When asked for explanations, please give thorough, multi-sentence or paragraph length explanations. · This completed Lab Word Document with your responses to the 10 questions will be the ONLY document you will upload in Blackboard. Creating Graphs 1. Create a frequency distribution to indicate Average Sodium content for each manufacturer. (10 points) Manufacturer Number of Brands Average Sodium Content 2. Use the Introductory to Statistics Excel Lab Manual (pages 5-8) to create a Grouped Histogram with 6 classes for the variable Sodium from the Cereal Data. Copy and paste the graph below. (15 points) 3. Use the Introductory to Statistics Excel Lab Manual (pages 5-8) to create a Grouped Histogram with 6 classes for the variable Sodium using only manufacturers K and G. Copy and paste the graph below. (15 points) 4. Use the Introductory to Statistics Excel Lab Manual (pages 17-19) to create a Box-and-Whisker plot (Box Plot) for the Sodium content of the population. (15 points) 5. Create a box-and-whisker plot of the Sodium content for a sample. Use either the Cluster or Stratified technique. (15 points) Short Answer Writing Assignment All answers should be complete sentences. 6. What is your interpretation of the histogram created for the Sodium content (include the shape)? What does this tell you about the data? (6 points) 7. How do the histograms in #2 and #3 compare? Is this what you expected? Explain. (6 points) 8. Are there any outliers present in the Sodium content population data? Can you tell from the Histogram? Is it more/less obvious from the Box-and Whiskers Plot? (6 points) 9. Are there any outliers present in the Sodium content sample data used to create the Box-and Whiskers plot? (6 points) 10. Use the Introductory to Statistics Excel Lab Manual (pages 14-16) to calculate the Descriptive Statistics for the Sodium content of the population. What is the Mean, Median and Skewness? How does this information relate to the shape of the distribution? (6 points) Mean: __________ Median: _________ Skewness: __________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ 6