HOME OF WRITERS: DataPro is a small but rapidly growing firm that provides electronic data- processing services to commercial firms, hospitals, and other organizations.

Friday, April 22, 2016

DataPro is a small but rapidly growing firm that provides electronic data- processing services to commercial firms, hospitals, and other organizations.

DataPro is a small but rapidly growing firm that provides electronic data- processing services to commercial firms, hospitals, and other organizations. For each of the past 12 months, DataPro has tracked the number of contracts sold, the average contract price, advertising expenditures, and personal selling expenditures. These data are provided in P10_ 17. xlsx. Using the number of contracts sold as the dependent variable, estimate a multiple regression equation with three explanatory variables. Interpret each of the estimated regression coefficients, the standard error of estimate, and R2.

Document Preview:

Data
Source
Month
Advertising Expenditures
Contracts Sold
Average ContractPrice
Personal Selling Expenditures
1.00
2000.00
$2,600.00
$19,800.00
$34,000.00
2.00
2000.00
$2,700.00
$20,300.00
$32,000.00
3.00
3000.00
$2,700.00
$29,800.00
$45,000.00
4.00
1250.00
$2,900.00
$12,300.00
$26,000.00
5.00
1750.00
$3,000.00
$17,400.00
$33,000.00
6.00
2750.00
$3,200.00
$28,200.00
$40,000.00
7.00
2500.00
$3,200.00
$18,400.00
$41,000.00
8.00
1000.00
$3,200.00
$10,400.00
$26,000.00
9.00
1500.00
$3,500.00
$15,300.00
$34,000.00
10.00
1750.00
$3,600.00
$17,400.00
$35,000.00
11.00
2250.00
$3,700.00
$23,500.00
$39,000.00
12.00
2500.00
$3,800.00
$26,800.00
$43,000.00
This is fictitious data.
Data
Source
Month
Advertising Expenditures
Contracts Sold
Average ContractPrice
Personal Selling Expenditures
1.00
2000.00
$2,600.00
$19,800.00
$34,000.00
2.00
2000.00
$2,700.00
$20,300.00
$32,000.00
3.00
3000.00
$2,700.00
$29,800.00
$45,000.00
4.00
1250.00
$2,900.00
$12,300.00
$26,000.00
5.00
1750.00
$3,000.00
$17,400.00
$33,000.00
6.00
2750.00
$3,200.00
$28,200.00
$40,000.00
7.00
2500.00
$3,200.00
$18,400.00
$41,000.00
8.00
1000.00
$3,200.00
$10,400.00
$26,000.00
9.00
1500.00
$3,500.00
$15,300.00
$34,000.00
10.00
1750.00
$3,600.00
$17,400.00
$35,000.00
11.00
2250.00
$3,700.00
$23,500.00
$39,000.00
12.00
2500.00
$3,800.00
$26,800.00
$43,000.00
This is fictitious data.

Attachments:

558_problem_1….xls