A data scientist at Sweet Bayou Airlines (SBA) wants to analyze data related to SBAs flight 494,
Question:
A data scientist at Sweet Bayou Airlines (SBA) wants to analyze data related to SBA’s flight 494, which departs daily from Shreveport for Nashville at 8:47 a.m. To facilitate this analysis, the data scientist needs the data to include a dummy variable that is equal to 1 if the passenger has a seat in First Class and 0 otherwise, a dummy variable that is equal to 1 if the passenger has a seat in Business Class and 0 otherwise, and a dummy variable that is equal to 1 if the passenger has a seat in Coach Class and 0 otherwise. Using the file sba494class, create the three dummy variables in new fields and name these fields FCDummy, BCDummy, and CCDummy. Save your results as a file under the name sba494classdummy.xlsx.
Step by Step Answer:
Business Analytics
ISBN: 9780357902219
5th Edition
Authors: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann