{"id":23907,"date":"2023-07-12T23:46:52","date_gmt":"2023-07-12T23:46:52","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/chapter-07-weekly-data-discussion-board-exercise-hypothesis-testing-on-purchase-order-lead-time\/"},"modified":"2023-07-12T23:46:52","modified_gmt":"2023-07-12T23:46:52","slug":"chapter-07-weekly-data-discussion-board-exercise-hypothesis-testing-on-purchase-order-lead-time","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/chapter-07-weekly-data-discussion-board-exercise-hypothesis-testing-on-purchase-order-lead-time\/","title":{"rendered":"Chapter 07 Weekly Data Discussion Board Exercise \u2013 Hypothesis Testing on Purchase Order Lead Time"},"content":{"rendered":"<ol style=\"margin-top: 1em; margin-right: 0px; margin-left: 0px; padding: 0px 0px 5px 40px; font-size: 14px; cursor: auto; color: inherit;\">\n<li style=\"padding: 0px 0px 5px; font-weight: initial; cursor: auto; color: inherit;\">Open the file and save your working file as a .xlsx file in another folder.<\/li>\n<li style=\"padding: 0px 0px 5px; font-weight: initial; cursor: auto; color: inherit;\">Freeze the \u201ctop row\u201d for convenience.<\/li>\n<li style=\"padding: 0px 0px 5px; font-weight: initial; cursor: auto; color: inherit;\">Calculate the LeadTime in column K as Arrival Date minus Order Date; format the field as an integer.<\/li>\n<li style=\"padding: 0px 0px 5px; font-weight: initial; cursor: auto; color: inherit;\">Create a pivot table to examine the average lead time by Supplier. Place pivot table output at cell N1. The question is: \u201cdoes a significant difference exist between the lead time for Aluminum Sheeting and Durrable Products?&#8221;<\/li>\n<li style=\"padding: 0px 0px 5px; font-weight: initial; cursor: auto; color: inherit;\">Sort the data by Supplier to allow for easier selection of lead time data.<\/li>\n<li style=\"padding: 0px 0px 5px; font-weight: initial; cursor: auto; color: inherit;\">Use the Data Analysis toolkit to prepare a Two-Sample t-test, assuming unequal variances. Place your output at cell N14. Following the selection settings from page 263, Figure 7.10 for this test.<\/li>\n<div style=\"margin-bottom: 1em; cursor: auto; color: inherit;\">See the Hypothesis Testing on Purchasing Lead Times &#8211; Guided Practice video below for more information on how to use Excel for this exercise.<\/div>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Open the file and save your working file as a .xlsx file in another folder. Freeze the \u201ctop row\u201d for convenience. Calculate the LeadTime in column K as Arrival Date minus Order Date; format the field as an integer. Create a pivot table to examine the average lead time by Supplier. Place pivot table output [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[706],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/23907"}],"collection":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/comments?post=23907"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/23907\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=23907"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=23907"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=23907"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=23907"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}