Questions from Business Analytics

Q: Find the mean, median, and midrange for the data in

Find the mean, median, and midrange for the data in the Excel file Automobile Quality using the appropriate Excel functions or formulas.

Q: Compute the mean, median, midrange, and mode for each

Compute the mean, median, midrange, and mode for each of the importance factors in the Excel file Coffee Shop Preferences using the appropriate Excel functions.

Q: Considering the data in the Excel file House Market Value as a

Considering the data in the Excel file House Market Value as a population of homeowners on this street, compute the mean, variance, and standard deviation for each of the variables using a spreadsheet...

Q: In one of PLE’s manufacturing facilities, a drill press that has

In one of PLE’s manufacturing facilities, a drill press that has three drill bits is used to fabricate metal parts. Drill bits break occasionally and need to be replaced. The present policy is to repl...

Q: Use the Excel file Course Marks to calculate the mean, variance

Use the Excel file Course Marks to calculate the mean, variance and standard deviation for each variable using formulas (4.5), (4.8), and (4.10). Verify your calculations using the appropriate Excel f...

Q: In the Excel file Facebook Survey, find the range, variance

In the Excel file Facebook Survey, find the range, variance, standard deviation, and interquartile range for hours online/week and number of friends in the sample using the appropriate Excel functions...

Q: Use the Descriptive Statistics tool to summarize the mean, median,

Use the Descriptive Statistics tool to summarize the mean, median, variance, and standard deviation of the prices of shares in the Coffee Shares Excel file.

Q: Use the Excel file Land to find the mean, standard deviation

Use the Excel file Land to find the mean, standard deviation, and interquartile range of the land size. Show that Chebyshev’s theorem holds for the data and determine how accurate the empirical rules...

Q: The Excel file Atlanta Airline Data provides arrival and taxi-in

The Excel file Atlanta Airline Data provides arrival and taxi-in time statistics for one day at Atlanta Hartsfield International Airport. Find the mean and standard deviation of the difference between...

Q: Compute the mean and standard deviation of the data in the Cost

Compute the mean and standard deviation of the data in the Cost of Living Adjustments Excel file. Then compute the z-scores for the comparative salaries and housing adjustments and interpret your resu...