{"id":2056,"date":"2023-04-24T19:24:38","date_gmt":"2023-04-24T19:24:38","guid":{"rendered":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/?post_type=chapter&#038;p=2056"},"modified":"2025-08-27T00:07:23","modified_gmt":"2025-08-27T00:07:23","slug":"data-exploration-apply-it-1","status":"web-only","type":"chapter","link":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/chapter\/data-exploration-apply-it-1\/","title":{"raw":"Data Exploration: Apply It 1","rendered":"Data Exploration: Apply It 1"},"content":{"raw":"<section class=\"textbox learningGoals\">\r\n<ul>\r\n\t<li>Use a spreadsheet to calculate the mean, median, and mode for a data set<\/li>\r\n\t<li>Use a spreadsheet to calculate the range and standard deviation for a data set<\/li>\r\n\t<li>Create graphical comparisons between two data sets to identify differences in their characteristics<\/li>\r\n<\/ul>\r\n<\/section>\r\n<h2>Data Exploration: Menu Prices<\/h2>\r\n<center>\r\n[caption id=\"attachment_6759\" align=\"aligncenter\" width=\"375\"]<img class=\"wp-image-6759\" src=\"https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/04\/13163753\/pexels-flo-dahm-541216_50-225x300.jpg\" alt=\"A dinner table with plates of food\" width=\"375\" height=\"500\" \/> Figure 1. Explore the data for menu prices[\/caption]\r\n<\/center>\r\n<p>&nbsp;<\/p>\r\n<p>A downtown historic district has taken a census of the average dinner plate price at all the main-street restaurants. They are displayed in the table below, rounded to the nearest dollar.<\/p>\r\n<table style=\"border-collapse: collapse; width: 100%;\" border=\"1\">\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 16.6667%;\">[latex]$7[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$7[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$7[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$8[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$8[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$8[\/latex]<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 16.6667%;\">[latex]$8[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$8[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$8[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$12[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$12[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$12[\/latex]<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 16.6667%;\">[latex]$13[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$13[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$14[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$17[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$17[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$18[\/latex]<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 16.6667%;\">[latex]$22[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$23[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$25[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$27[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$32[\/latex]<\/td>\r\n<td style=\"width: 16.6667%;\">[latex]$47[\/latex]<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<h3>Hands-on Spreadsheet: Explore the Data<\/h3>\r\n<p>Store the data in a new sheet named Menu Prices. You can use a <a href=\"https:\/\/products.office.com\/en-us\/excel-c\">Microsoft Excel<\/a> spreadsheet, a <a href=\"https:\/\/www.openoffice.org\/product\/calc.html\">Apache OpenOffice Calc spreadhseet<\/a> or a\u00a0<a href=\"https:\/\/www.google.com\/sheets\/about\/\">Google Sheets<\/a> spreadsheet.<\/p>\r\n<p>Using your spreadsheet, obtain the descriptive statistics. What are the mean, median, and mode? What is the range, minimum and maximum? What is the standard deviation? What is the skewness?<\/p>\r\n<section class=\"textbox tryIt\">[ohm2_question hide_question_numbers=1]9591[\/ohm2_question][reveal-answer q=\"499040\"]Solution[\/reveal-answer]<br \/>\r\n[hidden-answer a=\"499040\"]<center><img class=\"aligncenter wp-image-4401 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/13105410\/MenuPrices_01.jpg\" alt=\"Data and summary statistics in Excel\" width=\"316\" height=\"511\" \/><\/center>\u00a0[\/hidden-answer]<\/section>\r\n<p>Now, using your spreadsheet, create a frequency table and histogram. Use [latex]6[\/latex] intervals beginning with [latex]0-7[\/latex].<\/p>\r\n<section class=\"textbox tryIt\">[ohm2_question hide_question_numbers=1]9592[\/ohm2_question][reveal-answer q=\"987047\"]Solution[\/reveal-answer]<br \/>\r\n[hidden-answer a=\"987047\"]<center><img class=\"aligncenter wp-image-4402 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/13105500\/MenuPrices_02.jpg\" alt=\"Data, summary statistics, frequency table, and a histogram in excel\" width=\"978\" height=\"408\" \/><\/center>[\/hidden-answer]<\/section>","rendered":"<section class=\"textbox learningGoals\">\n<ul>\n<li>Use a spreadsheet to calculate the mean, median, and mode for a data set<\/li>\n<li>Use a spreadsheet to calculate the range and standard deviation for a data set<\/li>\n<li>Create graphical comparisons between two data sets to identify differences in their characteristics<\/li>\n<\/ul>\n<\/section>\n<h2>Data Exploration: Menu Prices<\/h2>\n<div style=\"text-align: center;\">\n<figure id=\"attachment_6759\" aria-describedby=\"caption-attachment-6759\" style=\"width: 375px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6759\" src=\"https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/04\/13163753\/pexels-flo-dahm-541216_50-225x300.jpg\" alt=\"A dinner table with plates of food\" width=\"375\" height=\"500\" srcset=\"https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/04\/13163753\/pexels-flo-dahm-541216_50-225x300.jpg 225w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/04\/13163753\/pexels-flo-dahm-541216_50-768x1024.jpg 768w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/04\/13163753\/pexels-flo-dahm-541216_50-1152x1536.jpg 1152w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/04\/13163753\/pexels-flo-dahm-541216_50-1200x1600.jpg 1200w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/04\/13163753\/pexels-flo-dahm-541216_50-65x87.jpg 65w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/04\/13163753\/pexels-flo-dahm-541216_50-350x467.jpg 350w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/04\/13163753\/pexels-flo-dahm-541216_50.jpg 1512w\" sizes=\"(max-width: 375px) 100vw, 375px\" \/><figcaption id=\"caption-attachment-6759\" class=\"wp-caption-text\">Figure 1. Explore the data for menu prices<\/figcaption><\/figure>\n<\/div>\n<p>&nbsp;<\/p>\n<p>A downtown historic district has taken a census of the average dinner plate price at all the main-street restaurants. They are displayed in the table below, rounded to the nearest dollar.<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 16.6667%;\">[latex]$7[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$7[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$7[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$8[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$8[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$8[\/latex]<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 16.6667%;\">[latex]$8[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$8[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$8[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$12[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$12[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$12[\/latex]<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 16.6667%;\">[latex]$13[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$13[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$14[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$17[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$17[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$18[\/latex]<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 16.6667%;\">[latex]$22[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$23[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$25[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$27[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$32[\/latex]<\/td>\n<td style=\"width: 16.6667%;\">[latex]$47[\/latex]<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Hands-on Spreadsheet: Explore the Data<\/h3>\n<p>Store the data in a new sheet named Menu Prices. You can use a <a href=\"https:\/\/products.office.com\/en-us\/excel-c\">Microsoft Excel<\/a> spreadsheet, a <a href=\"https:\/\/www.openoffice.org\/product\/calc.html\">Apache OpenOffice Calc spreadhseet<\/a> or a\u00a0<a href=\"https:\/\/www.google.com\/sheets\/about\/\">Google Sheets<\/a> spreadsheet.<\/p>\n<p>Using your spreadsheet, obtain the descriptive statistics. What are the mean, median, and mode? What is the range, minimum and maximum? What is the standard deviation? What is the skewness?<\/p>\n<section class=\"textbox tryIt\"><iframe loading=\"lazy\" id=\"ohm9591\" class=\"resizable\" src=\"https:\/\/ohm.one.lumenlearning.com\/multiembedq.php?id=9591&theme=lumen&iframe_resize_id=ohm9591&source=tnh\" width=\"100%\" height=\"150\"><\/iframe><\/p>\n<div class=\"qa-wrapper\" style=\"display: block\"><button class=\"show-answer show-answer-button collapsed\" data-target=\"q499040\">Solution<\/button><\/p>\n<div id=\"q499040\" class=\"hidden-answer\" style=\"display: none\">\n<div style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4401 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/13105410\/MenuPrices_01.jpg\" alt=\"Data and summary statistics in Excel\" width=\"316\" height=\"511\" \/><\/div>\n<p>\u00a0<\/p><\/div>\n<\/div>\n<\/section>\n<p>Now, using your spreadsheet, create a frequency table and histogram. Use [latex]6[\/latex] intervals beginning with [latex]0-7[\/latex].<\/p>\n<section class=\"textbox tryIt\"><iframe loading=\"lazy\" id=\"ohm9592\" class=\"resizable\" src=\"https:\/\/ohm.one.lumenlearning.com\/multiembedq.php?id=9592&theme=lumen&iframe_resize_id=ohm9592&source=tnh\" width=\"100%\" height=\"150\"><\/iframe><\/p>\n<div class=\"qa-wrapper\" style=\"display: block\"><button class=\"show-answer show-answer-button collapsed\" data-target=\"q987047\">Solution<\/button><\/p>\n<div id=\"q987047\" class=\"hidden-answer\" style=\"display: none\">\n<div style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4402 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/4685\/2020\/04\/13105500\/MenuPrices_02.jpg\" alt=\"Data, summary statistics, frequency table, and a histogram in excel\" width=\"978\" height=\"408\" \/><\/div>\n<\/div>\n<\/div>\n<\/section>\n","protected":false},"author":15,"menu_order":20,"template":"","meta":{"_candela_citation":"[{\"type\":\"copyrighted_video\",\"description\":\"Dinnerware on Table\",\"author\":\"Flo Dahm\",\"organization\":\"Pexels\",\"url\":\"https:\/\/www.pexels.com\/photo\/dinnerware-on-table-541216\/\",\"project\":\"\",\"license\":\"arr\",\"license_terms\":\"\"}]","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"part":1572,"module-header":"apply_it","content_attributions":[{"type":"copyrighted_video","description":"Dinnerware on Table","author":"Flo Dahm","organization":"Pexels","url":"https:\/\/www.pexels.com\/photo\/dinnerware-on-table-541216\/","project":"","license":"arr","license_terms":""}],"internal_book_links":[],"video_content":null,"cc_video_embed_content":{"cc_scripts":"","media_targets":[]},"try_it_collection":null,"_links":{"self":[{"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/pressbooks\/v2\/chapters\/2056"}],"collection":[{"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/wp\/v2\/users\/15"}],"version-history":[{"count":19,"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/pressbooks\/v2\/chapters\/2056\/revisions"}],"predecessor-version":[{"id":15714,"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/pressbooks\/v2\/chapters\/2056\/revisions\/15714"}],"part":[{"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/pressbooks\/v2\/parts\/1572"}],"metadata":[{"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/pressbooks\/v2\/chapters\/2056\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/wp\/v2\/media?parent=2056"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/pressbooks\/v2\/chapter-type?post=2056"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/wp\/v2\/contributor?post=2056"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/wp\/v2\/license?post=2056"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}