p. 558 Problem 17
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.
>Source
This is fictitious data. 00
, 00
,000
00
$2,700 ,000
,300
$3,200 ,400
$26,000 $17,400
Data
Month
Contracts Sold
Average ContractPrice
Advertising Expenditures
Personal Selling Expenditures
1
2,000
$2,
6
$1
9
8
$
3
4
2 2,000
$2,
7
$20,300
$32,000
3
3,000
$29,800
$4
5
4
1,250
$2,900
$
12
$26,000
5
1,750
$3,000
$17,400
$33,000
6
2,750
$3,200
$28,200
$40,000
7
2,500
$18,400
$4
1,000
8 1,000 $3,200
$
10
9
1,500
$3,500
$15,300
$34,000
10 1,750
$3,600
$35,000
11
2,250
$3,700
$23,500
$39,000
12 2,500
$3,800
$26,800
$43,000