Questions from Analytics

Q: A recent MBA graduate, Dara, has gained control over custodial

A recent MBA graduate, Dara, has gained control over custodial accounts that her parents had established. Currently, her money is invested in four funds, but she has identified several other funds as...

Q: For the new-product model in Problem 9 of Chapter 11,

For the new-product model in Problem 9 of Chapter 11, suppose that the first-year sales volume is normally distributed with a mean of 100,000 units and a standard deviation of 10,000. Use the NORM.INV...

Q: Set up an Excel worksheet to apply formulas (8.5) and

Set up an Excel worksheet to apply formulas (8.5) and (8.6) to compute the values of b0 and b1 for the data in the Excel file Home Market Value and verify that you obtain the same values as in Example...

Q: Develop a multiple regression model with categorical variables that incorporate

Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting the temperature in Washington, D.C., using the data for years 1999 and 2000 in the Excel fil...

Q: Develop a multiple regression model with categorical variables that incorporate

Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting sales using the last three years of data in the Excel file New Car Sales

Q: Develop a multiple regression model with categorical variables that incorporate

Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting housing starts beginning in June 2006 using the data in the Excel file Housing Starts

Q: In the Purchase Orders database, conduct a Pareto analysis of

In the Purchase Orders database, conduct a Pareto analysis of the Cost per order data. What conclusions can you reach?

Q: Create an Excel workbook with worksheet templates (similar to the

Create an Excel workbook with worksheet templates (similar to the Excel workbook Confidence Intervals) for one-sample hypothesis tests for means and proportions. Apply your templates to the example pr...

Q: Use the Holt-Winters no-trend model to find the best model

Use the Holt-Winters no-trend model to find the best model to forecast the next year of electricity usage in the Excel file Gas & Electric

Q: Use the Holt-Winters no-trend model to find the best model

Use the Holt-Winters no-trend model to find the best model to find forecasts for the next 12 months in the Excel file Housing Starts