Questions from Analytics

Q: In the Sales Transactions database, use Excel’s filtering capability to

In the Sales Transactions database, use Excel’s filtering capability to extract all orders that used PayPal, all orders under $100, and all orders that were over $100 and used a credit card

Q: A business school has a goal that the average number

A business school has a goal that the average number of years of work experience of MBA applicants is at least 3 years. Based on last year’s applicants, it was found that among a sample of 47, the ave...

Q: Construct frequency distributions and histograms using the Excel Histogram tool

Construct frequency distributions and histograms using the Excel Histogram tool for the Gross Sales and Gross Profit data in the Excel file Sales Data. First let Excel automatically determine the numb...

Q: The Excel file Major League Baseball provides data on the

The Excel file Major League Baseball provides data on the 2010 season.a. Construct and examine the correlation matrix. Is multicollinearity a potential problem?b. Suggest an appropriate set of indepen...

Q: The director of human resources for a large bank has

The director of human resources for a large bank has compiled data on about 70 former employees at one of the bank’s call centers (see the Excel file Call Center Data). For each of the following, assu...

Q: A producer of computer-aided design software for the aerospace industry

A producer of computer-aided design software for the aerospace industry receives numerous calls for technical support. Tracking software is used to monitor response and resolution times. In addition,...

Q: The State of Ohio Department of Education has a mandated

The State of Ohio Department of Education has a mandated ninth-grade proficiency test that covers writing, reading, mathematics, citizenship (social studies), and science. The Excel file Ohio Educatio...

Q: The Excel file Unions and Labor Law Data reports the

The Excel file Unions and Labor Law Data reports the percent of public- and private-sector employees in unions in 1982 for each state, along with indicators whether the states had a bargaining law tha...

Q: For the Excel file Auto Survey,

For the Excel file Auto Survey,a. Find the best regression model to predict miles/gallon as a function of vehicle age and mileage.b. Using your result from part (a), add the categorical variable Purch...

Q: Examine the z-scores you computed in Problem 4 for the

Examine the z-scores you computed in Problem 4 for the Atlanta Airline Data. Do they suggest any outliers in the data?