{"id":90091,"date":"2022-08-23T09:20:40","date_gmt":"2022-08-23T09:20:40","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/statistics-week-2-accounting-homework-help\/"},"modified":"2022-08-23T09:20:40","modified_gmt":"2022-08-23T09:20:40","slug":"statistics-week-2-accounting-homework-help","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/statistics-week-2-accounting-homework-help\/","title":{"rendered":"Statistics week 2 | Accounting homework help"},"content":{"rendered":"<div>\n<p>\u00a0<\/p>\n<h3>Scatter Diagram Analysis<\/h3>\n<p>The regional sales manager for American Toys, Inc., recently \u00a0collected data on weekly sales (in dollars) for the 15 stores in his \u00a0region. He also collected data on the number of salesclerk work hours \u00a0during the week for each of the stores. The data are as follows:<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0<strong>Store<\/strong> <strong>Sales<\/strong> <strong>Hours<\/strong> \u00a0\u00a01 23,300 120 \u00a0\u00a02 25,600 135 \u00a0\u00a03 19,200 96 \u00a0\u00a04 10,211 102 \u00a0\u00a05 19,330 240 \u00a0\u00a06 35,789 190 \u00a0\u00a07 12,540 108 \u00a0\u00a08 43,150 234 \u00a0\u00a09 27,886 140 \u00a0\u00a010 54,156 300 \u00a0\u00a011 34,080 254 \u00a0\u00a012 25,900 180 \u00a0\u00a013 36,400 270 \u00a0\u00a014 25,760 175 \u00a0\u00a015 31,500 256 \u00a0\u00a0\u00a0<br \/>\u00a0<\/p>\n<p>To complete this assignment:<\/p>\n<ol>\n<li>Use Excel to develop a scatter diagram of the data, including dependent and independent variables on their correct axis.<\/li>\n<li>In a Word document, analyze the relationship between sales and number of clerk hours worked.<\/li>\n<li>Conclude, based on the scatter diagram, what adjustments the \u00a0sales manager might make to address the relationship between sales and \u00a0number of clerk hours worked.\u00a0<\/li>\n<li>Submit your work in a Word document with your Excel file attached.\u00a0<\/li>\n<\/ol>\n<p>How to insert an Excel spreadsheet into Microsoft Word? There are several ways to do it. Choose the one that works for you.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 Scatter Diagram Analysis The regional sales manager for American Toys, Inc., recently \u00a0collected data on weekly sales (in dollars) for the 15 stores in his \u00a0region. He also collected data on the number of salesclerk work hours \u00a0during the week for each of the stores. The data are as follows: \u00a0\u00a0\u00a0\u00a0\u00a0Store Sales Hours \u00a0\u00a01 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-90091","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/90091","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=90091"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/90091\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=90091"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=90091"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=90091"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}