{"id":22982,"date":"2023-07-04T23:49:37","date_gmt":"2023-07-04T23:49:37","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/chapter-05-weekly-data-discussion-board-exercise-airport-service-times-chapter-05-weekly-data-discussion-board-exercise-airport-service-times\/"},"modified":"2023-07-04T23:49:37","modified_gmt":"2023-07-04T23:49:37","slug":"chapter-05-weekly-data-discussion-board-exercise-airport-service-times-chapter-05-weekly-data-discussion-board-exercise-airport-service-times","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/chapter-05-weekly-data-discussion-board-exercise-airport-service-times-chapter-05-weekly-data-discussion-board-exercise-airport-service-times\/","title":{"rendered":"Chapter 05 Weekly Data Discussion Board Exercise \u2013 Airport Service Times Chapter 05 Weekly Data Discussion Board Exercise \u2013 Airport Service Times"},"content":{"rendered":"
    \n
  1. Open the file and save your working file as a .xlsx file in another folder.<\/li>\n
  2. Use the Data Analysis toolkit to prepare the descriptive statistics of the passenger counts. Place the out at C1.<\/li>\n
  3. In cell F1, create a BIN column starting with 35 and adding 2.5 to each until you get to 60.<\/li>\n
  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.<\/li>\n
  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.<\/li>\n
  6. Your spreadsheet should look something like the image shown below (click on the image to open it in a new tab):<\/li>\n<\/ol>\n
    <\/a><\/div>\n
    See the Airport Service Times – Normal Distribution – Guided Practice video below for more information on how to use Excel for this exercise.<\/div>\n","protected":false},"excerpt":{"rendered":"

    Open the file and save your working file as a .xlsx file in another folder. Use the Data Analysis toolkit to prepare the descriptive statistics of the passenger counts. Place the out at C1. In cell F1, create a BIN column starting with 35 and adding 2.5 to each until you get to 60. Use […]<\/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\/22982"}],"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=22982"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/22982\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=22982"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=22982"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=22982"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=22982"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}