Exhibit 16-7

question 13

Short Answer

Exhibit 16-7.It is believed that the sales volume of one liter Pepsi bottles depends on the price of the bottle and the price of one liter bottle of Coca Cola.The following data has been collected for a certain sales region. Using Excel's regression,the linear model PepsiSales = β₀ + β₁PepsiPrice + β₂ColaPrice + ε and the log-log model ln(PepsiSales)= β₀ + β₁ln(PepsiPrice)+ β₂ln(ColaPrice)+ ε have been estimated as follows: (Use Excel. )Refer to Exhibit 16.7.What is the percentage of variations in the sales of Pepsi explained by the estimated log-log model?

---

Definitions:

Managerial Accounting

The field of accounting focused on providing financial and nonfinancial information to help managers make decisions to fulfill the objectives of an organization.

Financial Accounting

The field of accounting focused on the preparation of financial statements for external users, such as investors and creditors.

Merchandising Businesses

Companies that purchase goods in a finished state and sell them without changing their form, typically involving retail and wholesale entities.

Delta Air Lines

A major American airline known for its extensive domestic and international network.