Chapter 07 Weekly Data Discussion Board Exercise – Hypothesis Testing on Purchase Order Lead Time

July 12, 2023July 12, 2023 Discipline: Other
  1. Open the file and save your working file as a .xlsx file in another folder.
  2. Freeze the “top row” for convenience.
  3. Calculate the LeadTime in column K as Arrival Date minus Order Date; format the field as an integer.
  4. Create a pivot table to examine the average lead time by Supplier. Place pivot table output at cell N1. The question is: “does a significant difference exist between the lead time for Aluminum Sheeting and Durrable Products?”
  5. Sort the data by Supplier to allow for easier selection of lead time data.
  6. 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.
    7. See the Hypothesis Testing on Purchasing Lead Times – Guided Practice video below for more information on how to use Excel for this exercise.

Are you struggling with your paper? Let us handle it - WE ARE EXPERTS!

Whatever paper you need - we will help you write it

Get started

Starts at $9 /page

Login Register Reset

How our paper writing service works

It's very simple!

  • Fill out the order form

    Complete the order form by providing as much information as possible, and then click the submit button.

  • Choose writer

    Select your preferred writer for the project, or let us assign the best writer for you.

  • Add funds

    Allocate funds to your wallet. You can release these funds to the writer incrementally, after each section is completed and meets your expected quality.

  • Ready

    Download the finished work. Review the paper and request free edits if needed. Optionally, rate the writer and leave a review.

Place order now