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.
Data
Source
Month
Advertising Expenditures
Contracts Sold
Average ContractPrice
Personal Selling Expenditures
1.00
2000.00
$2600.00
$19800.00
$34000.00
2.00
2000.00
$2700.00
$20300.00
$32000.00
3.00
3000.00
$2700.00
$29800.00
$45000.00
4.00
1250.00
$2900.00
$12300.00
$26000.00
5.00
1750.00
$3000.00
$17400.00
$33000.00
6.00
2750.00
$3200.00
$28200.00
$40000.00
7.00
2500.00
$3200.00
$18400.00
$41000.00
8.00
1000.00
$3200.00
$10400.00
$26000.00
9.00
1500.00
$3500.00
$15300.00
$34000.00
10.00
1750.00
$3600.00
$17400.00
$35000.00
11.00
2250.00
$3700.00
$23500.00
$39000.00
12.00
2500.00
$3800.00
$26800.00
$43000.00
This is fictitious data.
Data
Source
Month
Advertising Expenditures
Contracts Sold
Average ContractPrice
Personal Selling Expenditures
1.00
2000.00
$2600.00
$19800.00
$34000.00
2.00
2000.00
$2700.00
$20300.00
$32000.00
3.00
3000.00
$2700.00
$29800.00
$45000.00
4.00
1250.00
$2900.00
$12300.00
$26000.00
5.00
1750.00
$3000.00
$17400.00
$33000.00
6.00
2750.00
$3200.00
$28200.00
$40000.00
7.00
2500.00
$3200.00
$18400.00
$41000.00
8.00
1000.00
$3200.00
$10400.00
$26000.00
9.00
1500.00
$3500.00
$15300.00
$34000.00
10.00
1750.00
$3600.00
$17400.00
$35000.00
11.00
2250.00
$3700.00
$23500.00
$39000.00
12.00
2500.00
$3800.00
$26800.00
$43000.00
This is fictitious data.

Attachments: