Questions from Business Analytics

Q: Use the data in the Excel file Canned Food to find a

Use the data in the Excel file Canned Food to find a multiple regression model to predict the total sales as a function of all the other given variables. State the model and explain R2, Significance F...

Q: Use the data in the Excel file Neighborhoods to find a multiple

Use the data in the Excel file Neighborhoods to find a multiple regression model to predict the total sales as a function of all the other given variables. State the model and explain R2, Significance...

Q: Using the data in the Excel file Credit Card Spending, develop

Using the data in the Excel file Credit Card Spending, develop a multiple linear regression model for estimating the average credit card expenditure as a function of both the income and family size. P...

Q: Use the data in the Excel file EU Cost of Living Adjustments

Use the data in the Excel file EU Cost of Living Adjustments to find the best multiple regression model to predict the salary as a function of the adjusted cost of living rates. What would the compara...

Q: Use the data in the Excel file Job Satisfaction to find the

Use the data in the Excel file Job Satisfaction to find the best multiple regression model to predict the overall satisfaction as a function of the other variables. What managerial implications does y...

Q: The Excel file Breakfast Foods provides a variety of nutritional information about

The Excel file Breakfast Foods provides a variety of nutritional information about 67 breakfast food items in supermarkets in different parts of the world. Use regression analysis to find the best mod...

Q: The Excel file Credit Approval Decisions provides information on credit history for

The Excel file Credit Approval Decisions provides information on credit history for a sample of banking customers. Use regression analysis to identify the best model for predicting the credit score as...

Q: An insurance company is estimating the risk model based on customer age

An insurance company is estimating the risk model based on customer age is define as R = aebx where a is a fixed constant and b is a constant that depends on the customer age. They categorize the age...

Q: Each worksheet in the Excel file LineFit Data contains a set of

Each worksheet in the Excel file LineFit Data contains a set of data that describes a functional relationship between the dependent variable y and the independent variable x. Construct a line chart of...

Q: The Excel file Women Height Data provides information on women’s height,

The Excel file Women Height Data provides information on women’s height, their mother’s height, their father’s height, amount of protein intake (per day), and the hours of exercise (per day) for a sel...