{"id":8410,"date":"2023-09-29T14:51:20","date_gmt":"2023-09-29T14:51:20","guid":{"rendered":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/?post_type=chapter&#038;p=8410"},"modified":"2024-10-18T20:57:18","modified_gmt":"2024-10-18T20:57:18","slug":"modeling-basics-apply-it-1","status":"web-only","type":"chapter","link":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/chapter\/modeling-basics-apply-it-1\/","title":{"raw":"Modeling Basics: Apply It 1","rendered":"Modeling Basics: Apply It 1"},"content":{"raw":"<section class=\"textbox learningGoals\">\r\n<ul>\r\n\t<li>Use a spreadsheet to create a scatterplot<\/li>\r\n\t<li>Use a spreadsheet to generate a trendline for a scatterplot<\/li>\r\n\t<li>Analyze a trendline for appropriateness and fit<\/li>\r\n<\/ul>\r\n<\/section>\r\n<h2>Data Visualization and Analysis Using Spreadsheets<\/h2>\r\n<p>In today's data-driven world, the ability to visualize and analyze trends is an invaluable skill. In this 'Apply It' activity, you'll embark on a journey through various data sets, using spreadsheets to create scatterplots and generate trendlines. These tools are not just mathematical functions but powerful lenses through which we can interpret the world. From a local business's sales figures to the ebb and flow of visitors in a city park, and even customer ratings for an online store, each scenario will challenge you to apply your knowledge in new and insightful ways.<\/p>\r\n<h3>Scenario 1: Local Business Sales Data<\/h3>\r\n<p>You have been given monthly sales data for a local business for the past two years below. Your task is to visualize this data and analyze sales trends.<\/p>\r\n<table style=\"margin-left: auto; margin-right: auto; text-align: center; width: 50%; height: 550px;\" border=\"1\">\r\n<tbody>\r\n<tr style=\"height: 22px;\">\r\n<th style=\"text-align: center; height: 22px;\">Month<\/th>\r\n<th style=\"text-align: center; height: 22px;\">Sales (in thousands of dollars)<\/th>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">1<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]50[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">2<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]55[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">3<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]53[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">4<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]58[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">5<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]60[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">6<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]63[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">7<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]65[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">8<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]68[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">9<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]70[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">10<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]75[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">11<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]73[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">12<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]78[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">13<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]80[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">14<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]85[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">15<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]83[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">16<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]88[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">17<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]90[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">18<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]95[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">19<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]93[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">20<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]98[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">21<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]100[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">22<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]105[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">23<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]103[\/latex]<\/td>\r\n<\/tr>\r\n<tr style=\"height: 22px;\">\r\n<td style=\"text-align: center; height: 22px;\">24<\/td>\r\n<td style=\"text-align: center; height: 22px;\">[latex]108[\/latex]<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<section class=\"textbox tryIt\">\r\n<p>Using a spreadsheet, create a scatterplot of the monthly sales data. Ensure that the [latex]x[\/latex]-axis represents the months (from [latex]1[\/latex] to [latex]24[\/latex]), and the [latex]y[\/latex]-axis represents the sales figures.<\/p>\r\n<p><br \/>\r\n[reveal-answer q=\"51448\"]Sample Solution[\/reveal-answer]<br \/>\r\n[hidden-answer a=\"51448\"]<\/p>\r\n<center><img class=\"aligncenter size-full wp-image-11992\" src=\"https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203819\/Local-Business-Sales.png\" alt=\"Scatterplot of given local business sales data\" width=\"835\" height=\"517\" \/><\/center>\r\n<p>[\/hidden-answer]<\/p>\r\n<\/section>\r\n<section class=\"textbox tryIt\">\r\n<p>Add a trendline to your scatterplot. Choose a trendline type that you believe best fits the data.<\/p>\r\n<p><br \/>\r\n[reveal-answer q=\"996776\"]Sample Solution[\/reveal-answer]<br \/>\r\n[hidden-answer a=\"996776\"]<\/p>\r\n<center><img class=\"aligncenter size-full wp-image-11993\" src=\"https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203840\/Local-Business-Sales-1.png\" alt=\"Scatterplot of given local business sales data with trendline\" width=\"835\" height=\"517\" \/><\/center>\r\n<p>[\/hidden-answer]<\/p>\r\n<\/section>\r\n<p>After dissecting the sales trends of a local business, let's shift our focus to the digital world. In the next scenario, you'll analyze customer review ratings for an online store. This transition from physical sales data to digital consumer feedback will test your adaptability and analytical skills, showcasing how different types of data require unique approaches to interpretation.<\/p>\r\n<h3>Scenario 2: Online Store Review Ratings (Over Six Months)<\/h3>\r\n<p>An online store has been collecting customer review ratings for various products over the last six months. The ratings are on a scale from 1 to 5.<\/p>\r\n<table style=\"margin-left: auto; margin-right: auto; text-align: center; width: 50%;\" border=\"1\">\r\n<tbody>\r\n<tr>\r\n<th>Month<\/th>\r\n<th>Average Rating<\/th>\r\n<\/tr>\r\n<tr>\r\n<td>1<\/td>\r\n<td>[latex]4.5[\/latex]<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>2<\/td>\r\n<td>[latex]4.3[\/latex]<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>3<\/td>\r\n<td>[latex]4.2[\/latex]<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>4<\/td>\r\n<td>[latex]4.0[\/latex]<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>5<\/td>\r\n<td>[latex]3.9[\/latex]<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>6<\/td>\r\n<td>[latex]3.8[\/latex]<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<section class=\"textbox tryIt\">\r\n<p>Create a scatterplot using the ratings data. Then, generate a trendline to analyze the pattern of customer ratings over time. Discuss your choice of trendline and its appropriateness.<\/p>\r\n<p><br \/>\r\n[reveal-answer q=\"946227\"]Sample Solution[\/reveal-answer]<br \/>\r\n[hidden-answer a=\"946227\"]<img class=\"aligncenter size-full wp-image-11990\" src=\"https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203450\/Online-Store-Review-Ratings.png\" alt=\"Scatterplot of store ratings based on data given\" width=\"835\" height=\"517\" \/><\/p>\r\n<p>Adding a trendline:<\/p>\r\n<p><img class=\"aligncenter size-full wp-image-11991\" src=\"https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203556\/Online-Store-Review-Ratings-1.png\" alt=\"Scatterplot with added trendline\" width=\"835\" height=\"517\" \/>[\/hidden-answer]<\/p>\r\n<\/section>","rendered":"<section class=\"textbox learningGoals\">\n<ul>\n<li>Use a spreadsheet to create a scatterplot<\/li>\n<li>Use a spreadsheet to generate a trendline for a scatterplot<\/li>\n<li>Analyze a trendline for appropriateness and fit<\/li>\n<\/ul>\n<\/section>\n<h2>Data Visualization and Analysis Using Spreadsheets<\/h2>\n<p>In today&#8217;s data-driven world, the ability to visualize and analyze trends is an invaluable skill. In this &#8216;Apply It&#8217; activity, you&#8217;ll embark on a journey through various data sets, using spreadsheets to create scatterplots and generate trendlines. These tools are not just mathematical functions but powerful lenses through which we can interpret the world. From a local business&#8217;s sales figures to the ebb and flow of visitors in a city park, and even customer ratings for an online store, each scenario will challenge you to apply your knowledge in new and insightful ways.<\/p>\n<h3>Scenario 1: Local Business Sales Data<\/h3>\n<p>You have been given monthly sales data for a local business for the past two years below. Your task is to visualize this data and analyze sales trends.<\/p>\n<table style=\"margin-left: auto; margin-right: auto; text-align: center; width: 50%; height: 550px;\">\n<tbody>\n<tr style=\"height: 22px;\">\n<th style=\"text-align: center; height: 22px;\">Month<\/th>\n<th style=\"text-align: center; height: 22px;\">Sales (in thousands of dollars)<\/th>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">1<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]50[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">2<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]55[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">3<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]53[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">4<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]58[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">5<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]60[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">6<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]63[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">7<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]65[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">8<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]68[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">9<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]70[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">10<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]75[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">11<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]73[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">12<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]78[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">13<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]80[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">14<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]85[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">15<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]83[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">16<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]88[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">17<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]90[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">18<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]95[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">19<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]93[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">20<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]98[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">21<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]100[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">22<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]105[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">23<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]103[\/latex]<\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"text-align: center; height: 22px;\">24<\/td>\n<td style=\"text-align: center; height: 22px;\">[latex]108[\/latex]<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<section class=\"textbox tryIt\">\n<p>Using a spreadsheet, create a scatterplot of the monthly sales data. Ensure that the [latex]x[\/latex]-axis represents the months (from [latex]1[\/latex] to [latex]24[\/latex]), and the [latex]y[\/latex]-axis represents the sales figures.<\/p>\n<div class=\"wp-nocaption \"><\/div>\n<div class=\"qa-wrapper\" style=\"display: block\"><button class=\"show-answer show-answer-button collapsed\" data-target=\"q51448\">Sample Solution<\/button><\/p>\n<div id=\"q51448\" class=\"hidden-answer\" style=\"display: none\">\n<div style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11992\" src=\"https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203819\/Local-Business-Sales.png\" alt=\"Scatterplot of given local business sales data\" width=\"835\" height=\"517\" srcset=\"https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203819\/Local-Business-Sales.png 835w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203819\/Local-Business-Sales-300x186.png 300w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203819\/Local-Business-Sales-768x476.png 768w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203819\/Local-Business-Sales-65x40.png 65w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203819\/Local-Business-Sales-225x139.png 225w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203819\/Local-Business-Sales-350x217.png 350w\" sizes=\"(max-width: 835px) 100vw, 835px\" \/><\/div>\n<\/div>\n<\/div>\n<\/section>\n<section class=\"textbox tryIt\">\n<p>Add a trendline to your scatterplot. Choose a trendline type that you believe best fits the data.<\/p>\n<div class=\"wp-nocaption \"><\/div>\n<div class=\"qa-wrapper\" style=\"display: block\"><button class=\"show-answer show-answer-button collapsed\" data-target=\"q996776\">Sample Solution<\/button><\/p>\n<div id=\"q996776\" class=\"hidden-answer\" style=\"display: none\">\n<div style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11993\" src=\"https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203840\/Local-Business-Sales-1.png\" alt=\"Scatterplot of given local business sales data with trendline\" width=\"835\" height=\"517\" srcset=\"https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203840\/Local-Business-Sales-1.png 835w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203840\/Local-Business-Sales-1-300x186.png 300w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203840\/Local-Business-Sales-1-768x476.png 768w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203840\/Local-Business-Sales-1-65x40.png 65w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203840\/Local-Business-Sales-1-225x139.png 225w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203840\/Local-Business-Sales-1-350x217.png 350w\" sizes=\"(max-width: 835px) 100vw, 835px\" \/><\/div>\n<\/div>\n<\/div>\n<\/section>\n<p>After dissecting the sales trends of a local business, let&#8217;s shift our focus to the digital world. In the next scenario, you&#8217;ll analyze customer review ratings for an online store. This transition from physical sales data to digital consumer feedback will test your adaptability and analytical skills, showcasing how different types of data require unique approaches to interpretation.<\/p>\n<h3>Scenario 2: Online Store Review Ratings (Over Six Months)<\/h3>\n<p>An online store has been collecting customer review ratings for various products over the last six months. The ratings are on a scale from 1 to 5.<\/p>\n<table style=\"margin-left: auto; margin-right: auto; text-align: center; width: 50%;\">\n<tbody>\n<tr>\n<th>Month<\/th>\n<th>Average Rating<\/th>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>[latex]4.5[\/latex]<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>[latex]4.3[\/latex]<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>[latex]4.2[\/latex]<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>[latex]4.0[\/latex]<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>[latex]3.9[\/latex]<\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>[latex]3.8[\/latex]<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<section class=\"textbox tryIt\">\n<p>Create a scatterplot using the ratings data. Then, generate a trendline to analyze the pattern of customer ratings over time. Discuss your choice of trendline and its appropriateness.<\/p>\n<div class=\"wp-nocaption \"><\/div>\n<div class=\"qa-wrapper\" style=\"display: block\"><button class=\"show-answer show-answer-button collapsed\" data-target=\"q946227\">Sample Solution<\/button><\/p>\n<div id=\"q946227\" class=\"hidden-answer\" style=\"display: none\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11990\" src=\"https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203450\/Online-Store-Review-Ratings.png\" alt=\"Scatterplot of store ratings based on data given\" width=\"835\" height=\"517\" srcset=\"https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203450\/Online-Store-Review-Ratings.png 835w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203450\/Online-Store-Review-Ratings-300x186.png 300w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203450\/Online-Store-Review-Ratings-768x476.png 768w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203450\/Online-Store-Review-Ratings-65x40.png 65w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203450\/Online-Store-Review-Ratings-225x139.png 225w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203450\/Online-Store-Review-Ratings-350x217.png 350w\" sizes=\"(max-width: 835px) 100vw, 835px\" \/><\/p>\n<p>Adding a trendline:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11991\" src=\"https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203556\/Online-Store-Review-Ratings-1.png\" alt=\"Scatterplot with added trendline\" width=\"835\" height=\"517\" srcset=\"https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203556\/Online-Store-Review-Ratings-1.png 835w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203556\/Online-Store-Review-Ratings-1-300x186.png 300w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203556\/Online-Store-Review-Ratings-1-768x476.png 768w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203556\/Online-Store-Review-Ratings-1-65x40.png 65w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203556\/Online-Store-Review-Ratings-1-225x139.png 225w, https:\/\/content-cdn.one.lumenlearning.com\/wp-content\/uploads\/sites\/18\/2023\/09\/29203556\/Online-Store-Review-Ratings-1-350x217.png 350w\" sizes=\"(max-width: 835px) 100vw, 835px\" \/><\/div>\n<\/div>\n<\/section>\n","protected":false},"author":15,"menu_order":15,"template":"","meta":{"_candela_citation":"[]","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"part":87,"module-header":"apply_it","content_attributions":[],"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\/8410"}],"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":16,"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/pressbooks\/v2\/chapters\/8410\/revisions"}],"predecessor-version":[{"id":12775,"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/pressbooks\/v2\/chapters\/8410\/revisions\/12775"}],"part":[{"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/pressbooks\/v2\/parts\/87"}],"metadata":[{"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/pressbooks\/v2\/chapters\/8410\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/wp\/v2\/media?parent=8410"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/pressbooks\/v2\/chapter-type?post=8410"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/wp\/v2\/contributor?post=8410"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/content.one.lumenlearning.com\/quantitativereasoning\/wp-json\/wp\/v2\/license?post=8410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}