Questions from Business Analytics

Q: Using the Excel file Weddings, apply the Regression tool using the

Using the Excel file Weddings, apply the Regression tool using the wedding cost as the dependent variable and attendance as the independent variable. a. What is the regression model? b. Interpret all...

Q: Using the Excel file Weddings, apply the Excel Regression tool using

Using the Excel file Weddings, apply the Excel Regression tool using the wedding cost as the dependent variable and the couple’s income as the independent variable, only for those weddings paid for by...

Q: Use the results for Problem 10 (Demographics) to analyze the

Use the results for Problem 10 (Demographics) to analyze the residuals to determine if the assumptions underlying the regression analysis are valid. In addition, use the standard residuals to determin...

Q: Use the results (Horsepower versus Gasoline) to analyze the residuals

Use the results (Horsepower versus Gasoline) to analyze the residuals to determine if the assumptions underlying the regression analysis are valid. In addition, use the standard residuals to determine...

Q: Use the results (Student Grades) to analyze the residuals to

Use the results (Student Grades) to analyze the residuals to determine if the assumptions underlying the regression analysis are valid. In addition, use the standard residuals to determine if any poss...

Q: Use the results (Weddings) to analyze the residuals to determine

Use the results (Weddings) to analyze the residuals to determine if the assumptions underlying the regression analysis are valid. In addition, use the standard residuals to determine if any possible o...

Q: In a toy manufacturing company, the manufacturer needs to pay rent

In a toy manufacturing company, the manufacturer needs to pay rent (p) each month and monthly electricity (q). To produce each toy, the company incurs costs for plastic (r) and for cloth (s). The vari...

Q: A consumer products company has collected some data relating to the advertising

A consumer products company has collected some data relating to the advertising costs and sales of one of its products: What type of model would best represent the data? Use the Trendline tool to find...

Q: The Excel file World Tour Sales provides data on sales (£) and

The Excel file World Tour Sales provides data on sales (£) and the number of radio, TV, and newspaper ads promoting the world tour for a group of countries. Develop simple linear regression models for...

Q: Using the data in the Excel file Home Market Value, develop

Using the data in the Excel file Home Market Value, develop a multiple linear regression model for estimating the market value as a function of both the age and size of the house. State the model and...