Questions from Business Analytics

Q: A researcher is analyzing the body fat percentage based on the measurements

A researcher is analyzing the body fat percentage based on the measurements of triceps, thigh, and mid-arm of a person (in inches). The data is recorded in the Excel file Body Fat Percentage. a. Use t...

Q: A leading car manufacturer tracks the data of its used cars for

A leading car manufacturer tracks the data of its used cars for resale. The Excel file Car Sales contains information on the selling price of the car, fuel type (diesel or petrol), horsepower (HP), an...

Q: For the Car Sales data described in Problem 35, develop a

For the Car Sales data described in Problem 35, develop a regression model for selling price as a function of horsepower and manufacture year, incorporating an interaction term. What would be the pre...

Q: For the Excel file Job Satisfaction, develop a regression model for

For the Excel file Job Satisfaction, develop a regression model for overall satisfaction as a function of years of service and department that has the largest R2. Which department, if any, has the hig...

Q: A product manufacturer wishes to determine the relationship between the shelf space

A product manufacturer wishes to determine the relationship between the shelf space of the product and its sales. Past data indicates the following sales and shelf space in its stores: Using these dat...

Q: Using the data in the Excel file Kidney, determine the relationship

Using the data in the Excel file Kidney, determine the relationship between frailty rates in people with chronic kidney disease and the age of a person by constructing a scatter chart for the data. Fi...

Q: Use the data in the Excel file MBA Motivation and Salary Expectations

Use the data in the Excel file MBA Motivation and Salary Expectations to determine how well a linear function models the relationship between pre- and post-MBA salaries. Compare it to a third-order po...

Q: Using the results of fitting the Home Market Value regression line in

Using the results of fitting the Home Market Value regression line in Example 8.4, compute the errors associated with each observation using formula) and construct a frequency distribution and histogr...

Q: Enhance the Sales Transactions database file to perform a database query that

Enhance the Sales Transactions database file to perform a database query that finds the transaction code and amount associated with any customer ID input. Apply your results to customer ID 10029.

Q: The managing director of a consulting group has the following monthly data

The managing director of a consulting group has the following monthly data on total overhead costs and professional labor hours to bill to clients: a. Develop a simple linear regression model between...