In this activity we will be exploring a data set and collecting some descriptive statistics from it. As you follow the directions open up a Word or Google document to write your report. You will copy all of your tables and graphs into this document as you write your report. Report Requirements - This is a computer assignment. You must type your report. Handwritten work or scans will not be accepted. - Your tables and graphs must be labeled appropriately. - Answer any analysis questions in this report. Analysis questions must be answered in complete sentences. - When you finish the directions go through your report from beginning to end to make sure it is formatted nicely. When you are done submit a PDF of your report to this assignment. Press the" submit assignment" button and upload your PDF. Example Here is an example of the report I want you to submit. This report is based on data summarizing some health care telated statistics 3 for a collection of 46 countries. This example is based on a completely different data set than is assigned. However it gives you an idea of what I would like you to submit. The Data This goosle sheet E contains data describing nutrition content for 77 cereals. Most of the columnsare self explanatory. Sugar, means sugar in one serving of cereal. Here are some that need more explanation. - Target - Target audience for cereal (adult, child) - Shelf - Display shelf at the grocery store. - CRRating - Consumer Reports rating The Data This google sheet contains data describing nutrition content for 77 cereals. Most of the columns are self explanatory. Sugar, means sugar in one serving of cereal. Here are some that need more explanation. - Target-Target audience for cereal (adult, child) - Shelf-Display shelf at the grocery store. - CRRating - Consumer Reports rating Notice that there are three worksheets in this google sheet. You can navigate the worksheets on the bottom of the screen. In these instructions I will ask you to make calculations from different worksheets so pay attention to which worksheet you are using. - All Cereals has all 77 cereals - Adult Cereals has just the cereals marketed to adults, - Child Cereals has just the cereals marketed to children. Introduction to Google Sheets Many of you are unfamiliar with google sheets. The assignment below has instructional videos that are specific to this assignment. However you might want to watch this video for an introduction to the site and some basic navigation. Computer Assignment Begin this assignment by loading the cereals data set B. Note: When you load the data set, copy it to your personal google account. To do this press Make A Copy. Step 1: Context of Data 1. Describe the individuals in this study. 2. List the variables. Which are quantitative? Which are Categorical. Step 2: Study A Categorical Variable Create a frequency and relative frequency table for the Target variable. Copy the table into your report. Example Video: Here is a video that demonstrates creating a frequency and relative frequency table for a different variable Comparison of Quantitative Variables Watch the following viueo paying attention to how you compute, the quartiles, the mean, the standard deviation, and the IQR of data in google sheets. Also pay attention to how you create histograms in google sheets. Step 3: Summarize the distribution of sugar content in adult cereals 1. Navigate to the Adult Cereals worksheet. 2. Create a histogram for the sugar column in this worksheet. - Pick an appropriate number of bins. - Pick an appropriate title for this graph. - Describe the shape of this distribution using vocabulary from chapter 2. 3. Use formulas to compute the following descriptive statistics for sugar content in adult cereals: - The five number summary - minimum, Q1, median, Q3, and maximum - Measures of Center: Mean and Median - Measures of Spread: Standard Deviation and IQR. Step 4: Summarize the distribution of sugar content in children's cereals 1. Navigate to the Child Cereals worksheet. 2. Create a histogram for the sugar column in this worksheet. - Pick an appropriate number of bins. - Pick an appropriate title for this graph. - Describe the shape of this distribution using vocabulary from chapter 2 . 3. Use formulas to compute the following descriptive statistics for sugar content in adult cereals: - The five number summary - minimum, Q1, median, Q3, and maximum - Measures of Center: Mean and Median - Measures of Spread: Standard Deviation and IQR. Step 5: Analyze The Data Do you think cereals marketed to children are sweeter than cereals market to adults? This should not just be an opinion now. Support your conclusion by citing the statistics and graphs above. Write at least a paragraph stating your conclusion and justifying it with data. Grading Rubric Please see the grading rubric for guidance on what is expected for full credit. Click the snowman icon (3 vertical dots), then select "Show Rubric." In this activity we will be exploring a data set and collecting some descriptive statistics from it. As you follow the directions open up a Word or Google document to write your report. You will copy all of your tables and graphs into this document as you write your report. Report Requirements - This is a computer assignment. You must type your report. Handwritten work or scans will not be accepted. - Your tables and graphs must be labeled appropriately. - Answer any analysis questions in this report. Analysis questions must be answered in complete sentences. - When you finish the directions go through your report from beginning to end to make sure it is formatted nicely. When you are done submit a PDF of your report to this assignment. Press the" submit assignment" button and upload your PDF. Example Here is an example of the report I want you to submit. This report is based on data summarizing some health care telated statistics 3 for a collection of 46 countries. This example is based on a completely different data set than is assigned. However it gives you an idea of what I would like you to submit. The Data This goosle sheet E contains data describing nutrition content for 77 cereals. Most of the columnsare self explanatory. Sugar, means sugar in one serving of cereal. Here are some that need more explanation. - Target - Target audience for cereal (adult, child) - Shelf - Display shelf at the grocery store. - CRRating - Consumer Reports rating The Data This google sheet contains data describing nutrition content for 77 cereals. Most of the columns are self explanatory. Sugar, means sugar in one serving of cereal. Here are some that need more explanation. - Target-Target audience for cereal (adult, child) - Shelf-Display shelf at the grocery store. - CRRating - Consumer Reports rating Notice that there are three worksheets in this google sheet. You can navigate the worksheets on the bottom of the screen. In these instructions I will ask you to make calculations from different worksheets so pay attention to which worksheet you are using. - All Cereals has all 77 cereals - Adult Cereals has just the cereals marketed to adults, - Child Cereals has just the cereals marketed to children. Introduction to Google Sheets Many of you are unfamiliar with google sheets. The assignment below has instructional videos that are specific to this assignment. However you might want to watch this video for an introduction to the site and some basic navigation. Computer Assignment Begin this assignment by loading the cereals data set B. Note: When you load the data set, copy it to your personal google account. To do this press Make A Copy. Step 1: Context of Data 1. Describe the individuals in this study. 2. List the variables. Which are quantitative? Which are Categorical. Step 2: Study A Categorical Variable Create a frequency and relative frequency table for the Target variable. Copy the table into your report. Example Video: Here is a video that demonstrates creating a frequency and relative frequency table for a different variable Comparison of Quantitative Variables Watch the following viueo paying attention to how you compute, the quartiles, the mean, the standard deviation, and the IQR of data in google sheets. Also pay attention to how you create histograms in google sheets. Step 3: Summarize the distribution of sugar content in adult cereals 1. Navigate to the Adult Cereals worksheet. 2. Create a histogram for the sugar column in this worksheet. - Pick an appropriate number of bins. - Pick an appropriate title for this graph. - Describe the shape of this distribution using vocabulary from chapter 2. 3. Use formulas to compute the following descriptive statistics for sugar content in adult cereals: - The five number summary - minimum, Q1, median, Q3, and maximum - Measures of Center: Mean and Median - Measures of Spread: Standard Deviation and IQR. Step 4: Summarize the distribution of sugar content in children's cereals 1. Navigate to the Child Cereals worksheet. 2. Create a histogram for the sugar column in this worksheet. - Pick an appropriate number of bins. - Pick an appropriate title for this graph. - Describe the shape of this distribution using vocabulary from chapter 2 . 3. Use formulas to compute the following descriptive statistics for sugar content in adult cereals: - The five number summary - minimum, Q1, median, Q3, and maximum - Measures of Center: Mean and Median - Measures of Spread: Standard Deviation and IQR. Step 5: Analyze The Data Do you think cereals marketed to children are sweeter than cereals market to adults? This should not just be an opinion now. Support your conclusion by citing the statistics and graphs above. Write at least a paragraph stating your conclusion and justifying it with data. Grading Rubric Please see the grading rubric for guidance on what is expected for full credit. Click the snowman icon (3 vertical dots), then select "Show Rubric