Chapter 05 Weekly Data Discussion Board Exercise – Airport Service Times Chapter 05 Weekly Data Discussion Board Exercise – Airport Service Times

July 4, 2023July 4, 2023 Discipline: Other
  1. Open the file and save your working file as a .xlsx file in another folder.
  2. Use the Data Analysis toolkit to prepare the descriptive statistics of the passenger counts. Place the out at C1.
  3. In cell F1, create a BIN column starting with 35 and adding 2.5 to each until you get to 60.
  4. Use the Data Analysis toolkit to prepare a histogram using the Passenger Data as Input and the BIN range you created starting in F1. Does the histogram look generally normal? Visually, perhaps, but we will use a Chi-Squared Goodness of Fit test to determine if the data is normal or not.
  5. Reference the example 5.41 on page 208 for instructions on constructing a model to test the Chi-Square goodness of fit. The model is shown on page 208, figure 5.28. Build this model and test the passenger data.
  6. Your spreadsheet should look something like the image shown below (click on the image to open it in a new tab):
See the Airport Service Times – Normal Distribution – 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