Questions from Business Analytics

Q: Construct an influence diagram for the portfolio allocation model in Example 11

Construct an influence diagram for the portfolio allocation model in Example 11.15. Data from Example 11.15:

Q: Economists believe that housing starts depend on interest rates and demographic factors

Economists believe that housing starts depend on interest rates and demographic factors such as population size, family income, and the age of the home buying population. In addition, interest rates d...

Q: The People’s Choice Bank is a small community bank that has three

The People’s Choice Bank is a small community bank that has three local branches, in Blue Ash, Delhi, and Anderson Hills. The Excel file People’s Choice Bank is a database of major account transaction...

Q: In the Factvalue database, you need to find the country with

In the Factvalue database, you need to find the country with a birth rate of 29.43 and identify the country’s death rate. Write functions for a left table lookup to answer these queries.

Q: The monthly demand for a digital camera is sensitive to price:

The monthly demand for a digital camera is sensitive to price: Find the most appropriate trendline to explain the relationship between demand and price, and develop a model for the monthly revenue.

Q: Develop a spreadsheet for calculating the total revenue for the Intel scenario

Develop a spreadsheet for calculating the total revenue for the Intel scenario. Design it such that the price-demand function parameters are easy to change.

Q: A famous fashion boutique in Shanghai, China, is planning its

A famous fashion boutique in Shanghai, China, is planning its pricing for a dress that can be worn on Christmas day as well as the Chinese New Year. The product will be sold for ¥100 in the boutique a...

Q: Develop a spreadsheet model to determine how much a person or a

Develop a spreadsheet model to determine how much a person or a couple can afford to spend on a house.11 Lender guidelines suggest that the allowable monthly housing expenditure should be no more than...

Q: Intel, the largest semiconductor manufacturing company in the world, sells

Intel, the largest semiconductor manufacturing company in the world, sells two major types of computer chips, type A and type B. The sales of these two chips are dependent of each other (in economics,...

Q: A bi-monthly Sunday bazaar is held at a local maretplace

A bi-monthly Sunday bazaar is held at a local maretplace in London, England. The expected crowd is 4,500. The average expenditure estimate is £25 per person. Entry coupons sell for £10 each, and the b...