Questions from Business Analytics


Q: Suppose that the average height of all professional basketball players is 6

Suppose that the average height of all professional basketball players is 6 feet with standard deviation of 5 feet. A player of interest to you is 5.5 feet. Would you consider this player as the outli...

See Answer

Q: Use the following approaches to analyze the survey data in the Excel

Use the following approaches to analyze the survey data in the Excel file Insurance Survey. ■ Frequency distributions and histograms for the ratio variables (age, years employed, and satisfaction) ■ D...

See Answer

Q: Use the COUNTIF function to construct frequency distributions for gender, preferred

Use the COUNTIF function to construct frequency distributions for gender, preferred genre, and influence, develop column charts to express the results visually, and compute the relative frequencies ba...

See Answer

Q: One of PLE’s manufacturing facilities produces metal engine housings from sheet metal

One of PLE’s manufacturing facilities produces metal engine housings from sheet metal for both mowers and tractors. Production of each product consists of five steps: stamping, drill...

See Answer

Q: The Excel file Auto Survey contains a sample of data about vehicles

The Excel file Auto Survey contains a sample of data about vehicles owned, whether they were purchased new or used, and other types of data. Use the appropriate statistical tools to analyze these data...

See Answer

Q: The Excel file Employee Selection contains role of employees in an organization

The Excel file Employee Selection contains role of employees in an organization, along with other specifics—gender, salary, years of education, date of birth, and whether they are citizens of the coun...

See Answer

Q: Use the Manufacturing Measurements Data Excel file to compute sample means,

Use the Manufacturing Measurements Data Excel file to compute sample means, assuming that each row in the data file represents a sample from the manufacturing process. Plot the sample means on a line...

See Answer

Q: Airbnb is an online marketplace for arranging or offering lodging, primarily

Airbnb is an online marketplace for arranging or offering lodging, primarily homestays, or tourism experiences. Airbnb provides a platform for hosts to accommodate guests with short term lodging and t...

See Answer

Q: A community health status survey obtained the following demographic information from the

A community health status survey obtained the following demographic information from the respondents: Compute the relative frequencies and cumulative relative frequencies of the age groups.

See Answer

Q: Use the Histogram tool to construct frequency distributions and histograms for weekly

Use the Histogram tool to construct frequency distributions and histograms for weekly usage and waiting time in the Excel file Car Sharing Report. Do not group the data into bins.

See Answer