Questions from Business Analytics

Q: In each chapter of this book, we use a a fictitious

In each chapter of this book, we use a a fictitious company, Performance Lawn Equipment (PLE), within a case exercise for applying the tools and techniques introduced in the chapter.31 To put the case...

Q: Elizabeth Burke wants to develop a model to more effectively plan production

Elizabeth Burke wants to develop a model to more effectively plan production for the next year. Currently, PLE has a planned capacity of producing 9,100 mowers each month, which is approximately the a...

Q: The Data worksheet in the Excel file Airport Service Times lists a

The Data worksheet in the Excel file Airport Service Times lists a large sample of the time in seconds to process customers at a ticket counter. The second worksheet shows a frequency distribution and...

Q: Construct a frequency distribution for education in the Excel file Voter.

Construct a frequency distribution for education in the Excel file Voter. Develop a table to estimate the sample mean and sample variance using formulas. Check your results using Excel functions with...

Q: we asked you to use the Histogram tool to construct frequency distributions

we asked you to use the Histogram tool to construct frequency distributions and histograms for weekly usage and waiting time in the Excel file Car Sharing Report without grouping the data into bins....

Q: The amount of time it took 25 respondents to solve a particular

The amount of time it took 25 respondents to solve a particular task has been recorded in the following table: Develop a table to estimate the sample mean and sample standard deviation of the time usi...

Q: A teacher recorded the amount of time taken by 21 students to

A teacher recorded the amount of time taken by 21 students to complete a sprint race, to the nearest second, as follows: ■ Two students: between 51 and less than 56 seconds ■ Seven students: between 5...

Q: In the Excel file Postal Services, find the proportion of the

In the Excel file Postal Services, find the proportion of the number of items delivered to Portland, New York, and Chicago for six days in four consecutive weeks.

Q: Create a PivotTable to find the mean and standard deviation of the

Create a PivotTable to find the mean and standard deviation of the amount of travel expenses for each sales representative in the Excel file Travel Expenses.

Q: The Excel file Sample Sales provides sample data on the sales representatives’

The Excel file Sample Sales provides sample data on the sales representatives’ record. Create a PivotTable to find the following: a. Cross-tabulation of region versus item. b. Mean units, unit cost, a...