{"id":591,"date":"2024-01-03T02:16:42","date_gmt":"2024-01-03T02:16:42","guid":{"rendered":"https:\/\/www.writemyessays.app\/blog\/questions\/creating-a-data-subset-creating-graphical-display-of-data-3-descriptive-statistics-questions\/"},"modified":"2024-01-03T02:16:42","modified_gmt":"2024-01-03T02:16:42","slug":"creating-a-data-subset-creating-graphical-display-of-data-3-descriptive-statistics-questions","status":"publish","type":"questions","link":"https:\/\/www.writemyessays.app\/blog\/questions\/creating-a-data-subset-creating-graphical-display-of-data-3-descriptive-statistics-questions\/","title":{"rendered":"creating a data subset, Creating graphical display of data, 3 descriptive statistics questions"},"content":{"rendered":"<p>&nbsp;<\/p>\n<ol style=\"margin-top: 1em; margin-right: 0px; margin-left: 0px; font-size: 19px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Go to your welcome message from your SME in which you were assigned a random number greater than 50. (My # assigned is 63)<\/li>\n<li style=\"cursor: auto; color: inherit;\">Download the original Excel file titled<span style=\"cursor: auto; color: inherit;\">&nbsp;<\/span><a style=\"cursor: auto;\">BODY DATA. (attached is the exel file).<\/a><\/li>\n<li style=\"cursor: auto; color: inherit;\">Start a new Excel file. Copy\/paste all column names from the original document.<\/li>\n<li style=\"cursor: auto; color: inherit;\">Using the random number provided from your SME, go to that row of the BODY DATA file. (Again my random # is 63 that was assigned)<\/li>\n<li style=\"cursor: auto; color: inherit;\">Copy and paste the number of rows of data equal to your number, including all columns, into your new Excel file.<\/li>\n<li style=\"cursor: auto; color: inherit;\">Save this data set as STData_firstinitial_lastname (e.g., STData_J_Smith).<\/li>\n<li style=\"cursor: auto; color: inherit;\">Create two new columns: one labeled BMI Smokers and one labeled BMI Nonsmokers.<\/li>\n<li style=\"cursor: auto; color: inherit;\">Sort the data by smoking status and copy paste all BMI data for smokers into the appropriate column and all BMI data for nonsmokers in the appropriate column.<\/li>\n<\/ol>\n<p style=\"margin: 0.5em 0px 1em; font-size: 19px; cursor: auto; color: inherit;\"><a style=\"cursor: auto;\">The Creating a data set<\/a><span style=\"cursor: auto; color: inherit;\">&nbsp;<\/span>video will walk you through the process of making your own data set.<\/p>\n<p style=\"margin: 0.5em 0px 1em; font-size: 19px; cursor: auto; color: inherit;\">Data set adapted from:<\/p>\n<p style=\"margin: 0.5em 0px 1em; font-size: 19px; cursor: auto; color: inherit;\">Triola, M. F. (2022). Elementary statistics using Excel (7th ed.). Boston, MA: Pearson.<\/p>\n<ul style=\"margin-top: 1em; margin-right: 0px; margin-left: 0px; font-size: 19px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Appendix B, \u201cData Sets,\u201d Data Set 1: Body Data (pg. 796)<\/li>\n<\/ul>\n<p style=\"margin: 0.5em 0px 1em; font-size: 19px; cursor: auto; color: inherit;\"><strong style=\"font-weight: bold; cursor: auto; color: inherit;\">To submit<\/strong><\/p>\n<p style=\"margin: 0.5em 0px 1em; font-size: 19px; cursor: auto; color: inherit;\">Save the data set as<span style=\"cursor: auto; color: inherit;\">&nbsp;<\/span><strong style=\"font-weight: bold; cursor: auto; color: inherit;\">STData_J_Hinson<\/strong>.<\/p>\n<p style=\"margin-top: 0.5em; margin-right: 0px; margin-left: 0px; font-size: 19px; cursor: auto; color: inherit;\">Creating graphical display of data:<\/p>\n<p style=\"margin-top: 0.5em; margin-right: 0px; margin-left: 0px; font-size: 19px; cursor: auto; color: inherit;\">Then <span style=\"color: inherit; font-size: 18px; background-color: var(--color-6); font-variant-ligatures: inherit; font-variant-caps: inherit;\">Your newly created data set will be used to compare the BMI of smokers to non-smokers. Create the following graphs in Excel:<\/span><\/p>\n<div>\n<p style=\"margin-left: 0.75in; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\"><span style=\"cursor: auto; color: inherit;\">1.<span style=\"font-size: 7pt; line-height: normal; cursor: auto; color: inherit;\">&nbsp;&nbsp;&nbsp;<br \/>\n<\/span><\/span><\/span><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">Using<br \/>\nthe column labeled Smoker (not sorted by smoking status), create an appropriate<br \/>\ngraphical display to clearly show the breakdown of smokers and nonsmokers in<br \/>\nyour data set. <\/span><\/p>\n<p style=\"margin-left: 0.75in; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\"><span style=\"cursor: auto; color: inherit;\">2.<span style=\"font-size: 7pt; line-height: normal; cursor: auto; color: inherit;\">&nbsp;&nbsp;&nbsp;<br \/>\n<\/span><\/span><\/span><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">Copy<br \/>\nand paste your graph from Excel here. Write a one-sentence interpretation of<br \/>\nwhat the graph display. <span style=\"cursor: auto; color: inherit;\">&nbsp;&nbsp;<\/span><\/span><\/p>\n<p style=\"margin-left: 0.75in; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\"><span style=\"cursor: auto; color: inherit;\">3.<span style=\"font-size: 7pt; line-height: normal; cursor: auto; color: inherit;\">&nbsp;&nbsp;&nbsp;<br \/>\n<\/span><\/span><\/span><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">Create<br \/>\na histogram for the column labeled BMI (not broken down by smoking status). Use<br \/>\na bin width of 2. Start the bins at your minimum data point as appropriate for<br \/>\nyour data set. Write a one-sentence interpretation of what the graph display. <span style=\"cursor: auto; color: inherit;\">&nbsp;&nbsp;<\/span><\/span><\/p>\n<p style=\"margin-left: 0.75in; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\"><span style=\"cursor: auto; color: inherit;\">4.<span style=\"font-size: 7pt; line-height: normal; cursor: auto; color: inherit;\">&nbsp;&nbsp;&nbsp;<br \/>\n<\/span><\/span><\/span><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">Create<br \/>\ntwo modified box plots for BMI, one for smokers one for nonsmokers. Write a<br \/>\none-sentence interpretation of what the graph display. <span style=\"cursor: auto; color: inherit;\">&nbsp;&nbsp;<\/span><\/span><\/p>\n<\/div>\n<div>\n<p style=\"margin-right: 0px; margin-bottom: 10px; margin-left: 0px; font-size: 18px; cursor: auto; color: inherit;\"><em style=\"cursor: auto; color: inherit;\"><span style=\"font-weight: 700; cursor: auto; color: inherit;\">Descriptive statistics<\/span><\/em><\/p>\n<p style=\"margin-right: 0px; margin-bottom: 10px; margin-left: 0px; font-size: 18px; cursor: auto; color: inherit;\">Use the data analysis tool pack to create two tables of descriptive statistics, one for smokers and one for nonsmokers, using the columns created in Step 7 in the preparation portion.<\/p>\n<p style=\"margin-right: 0px; margin-bottom: 10px; margin-left: 0px; font-size: 18px; cursor: auto; color: inherit;\">Use these statistics to answer the following questions comparing smokers to nonsmokers. Be sure to provide values from your Excel output to support your reasoning.<\/p>\n<ol style=\"margin-bottom: 10px; padding-left: 16px; font-size: 18px; cursor: auto; color: inherit;\">\n<li style=\"padding-bottom: 10px; cursor: auto; color: inherit;\">Which group has an BMI that is typically higher? Be sure to write at least one sentence justifying your reasoning including values from the excel output.<\/li>\n<li style=\"padding-bottom: 10px; cursor: auto; color: inherit;\">Which group has greater variation in their BMI? Be sure to write at least one sentence justifying your reasoning including values from the excel output.<\/li>\n<li style=\"padding-bottom: 10px; cursor: auto; color: inherit;\">Do you suspect any outliers are present in the BMI for each group? Be sure to justify your reasoning.<\/li>\n<\/ol>\n<\/div>\n<div><span style=\"font-size: 18px;\"><br \/><\/span><\/div>\n<div><span style=\"font-size: 18px;\">First<\/span><span style=\"color: inherit; font-size: 18px; background-color: var(--color-6); font-variant-ligatures: inherit; font-variant-caps: inherit;\">&nbsp;will need comeplted as stated above is the exel document in the instructions 1-8. Then&nbsp;<\/span><\/div>\n<div><span style=\"font-size: 18px; background-color: var(--color-6); color: var(--color-1); font-variant-ligatures: inherit; font-variant-caps: inherit;\">Please see the attached assessment template,&nbsp; Only part 2 on the assessment document will n eed to be completed( Instructions for part 2 instruction 1-4 of creating graphical display of data. ) and answer the 3 questions in descriptive statistics.&nbsp;<\/span><\/div>\n<div><span style=\"font-size: 18px; background-color: var(--color-6); color: var(--color-1); font-variant-ligatures: inherit; font-variant-caps: inherit;\">please note references to be used at stated in bottom of assessment template.<\/span><\/div>\n<div><span style=\"font-size: 18px; background-color: var(--color-6); color: var(--color-1); font-variant-ligatures: inherit; font-variant-caps: inherit;\"><br \/><\/span><\/div>\n<div><span style=\"font-size: 18px;\">NO NEED TO COMPLETE PART 1 on the ASSESSMENT TEMPLATE, IT IS ALREADY COMPLETE.<\/span><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Go to your welcome message from your SME in which you were assigned a random number greater than 50. (My # assigned is 63) Download the original Excel file titled&nbsp;BODY DATA. (attached is the exel file). Start a new Excel file. Copy\/paste all column names from the original document. Using the random number provided [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[8],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions\/591"}],"collection":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/comments?post=591"}],"version-history":[{"count":0,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions\/591\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/media?parent=591"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/disciplines?post=591"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/paper_types?post=591"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/tagged?post=591"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}