Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Negotiating Power Dataset You will be examining the data-set labelled PriceNegPow.csv. It has has a record (row) for each of 677 customers who purchased an

Negotiating Power Dataset

You will be examining the data-set labelled PriceNegPow.csv. It has has a record (row) for each of 677 customers who purchased an automobile in the EasternAlptz Township. Several variables are available including a categor- ical variable (Sex) and three quantitative variables including annual Income (in Thousands CN $/year), customer Age ( in years), as well as a variable la- belled Discount which is a proxy for the customer's comparative negotiating power. Specifically Discount represents the difference between their new car's sticker price (advertised price) and the price they actually paid. Discount is expressed in Canadian $ (CN$).

Please answer the following questions, by taking advantage of a statistics pack- age such as Minitab or R or etc.

Caution: The Data-set is for your individual use only; do not share. 3. Examine the variable Discount

(a) (2 points) Examine the distribution of Discount using an appropriate graphical display, being sure to: label carefully (attention to units as well!); and to describe what the display reveals.

(b) (2 points) Provide a quantitative summary of the distribution for Discount being sure to restrict yourself to descriptive statistics that have been covered in ADM2303.

Cust.ID

Age

Sex

Income

Discount

1

59.1

1

76.6

1779.5

2

56.8

0

235.5

2576.2

3

48.8

1

65.2

1779.5

4

64.5

1

71

1606.8

5

60.2

1

63.1

1658.1

6

57.8

1

73.1

1800.4

7

59.2

1

110.4

1995.2

8

54.8

1

63.7

1587

9

55.1

1

62.2

1749

10

47.2

0

63.6

2068.1

11

63.2

1

99.4

1629.7

12

41

1

63.5

1300.7

13

60.8

0

106.5

2415.7

14

56.7

1

55.2

1458

15

49

0

71

2017.6

16

61

0

77.4

2129

17

51.2

1

64.9

1907.1

18

51.5

0

59.4

1850.4

19

58.7

1

50.4

1500.9

20

34.5

0

86.6

1465.8

21

58.5

0

147.3

2517.4

22

59.2

1

63.2

1812.3

23

58.3

0

120.5

2093.2

24

60.8

1

85.1

1619

25

56

1

75.6

1953.8

26

39.5

1

47.5

1614.4

27

55.7

0

92.1

2028.4

28

44.6

0

72.9

1885.3

29

51.9

1

65.8

1743

30

59.8

0

89.9

1932.8

31

54.6

1

58.7

1886.3

32

55.4

0

88.8

2300.7

33

54.6

1

62

1871.2

34

57.3

1

68.3

1715.2

35

60.1

0

146

2170

36

47.2

0

69.9

1936.4

37

57.1

0

75.4

1754.6

38

59.6

0

82.5

1929.6

39

47.4

1

73.7

1349.5

40

63

1

85.3

1829.6

41

53.1

1

102.7

2072.7

42

59.8

0

100.1

2243.4

43

48.4

1

60.4

1534.8

44

60.6

1

72.5

1672

45

59.8

0

115

2545.8

46

59.4

0

117.5

2457.6

47

57.6

0

102

2116.8

48

51.7

0

84.5

1932.9

49

47.1

0

144.4

1949.4

50

39.7

1

64.4

1640.9

51

45.7

1

76.9

1630.9

52

55

0

86.2

1691.6

53

62.1

1

82.6

1984.4

54

48.7

1

72.6

1834.4

55

46.5

1

90.5

1594.3

56

46.8

1

58.5

1844.6

57

41.5

0

104

1792.8

58

47.7

0

146.3

2270

59

46

0

92.3

2196.6

60

37.4

0

104.8

1972.8

61

53

1

107.3

1925.5

62

39

1

46

1751.2

63

57.3

1

78.1

1749.7

64

44.1

0

54.9

1966.4

65

60

1

75.6

1484.8

66

55.6

1

42.6

1738.1

67

59.4

1

69.6

1536.8

68

61.6

0

105.9

2238.2

69

56.6

1

60

1805.6

70

47.4

0

104.4

1940

71

58.8

1

73.5

1679.6

72

56.3

1

77.8

1777.7

73

61.1

1

94.1

1692.2

74

50

0

56.5

1932.2

75

61.5

0

77.6

2042.7

76

45.8

1

56.8

1450.6

77

49.3

0

103.8

2158.1

78

44.1

0

91.2

1497.3

79

56.4

1

77.2

1535.4

80

38.8

0

92.6

1701.6

81

49

1

53.3

1681.7

82

61.2

1

80.5

1825.4

83

55.4

0

109.1

2022.2

84

51.3

1

108

2026.2

85

61.6

0

68

2236.5

86

54.6

1

103.7

1761.2

87

60.4

0

99.2

2022.3

88

60.9

1

53.1

1560.4

89

55.8

0

93.9

1690.1

90

57.1

1

76

1614.6

91

50.5

0

220.4

2596

92

62.6

1

83

1681.1

93

55.9

0

78.9

2060.7

94

61.7

0

90.2

2556.9

95

63.2

0

153.1

2584

96

54.8

1

53.4

1785

97

58.5

1

71.4

1672.6

98

46.9

0

76.6

1899.7

99

50.5

0

123.2

2141.4

100

53.3

0

113.9

1917.9

101

60.3

0

99.9

1912.9

102

62.3

1

87.2

1965.1

103

29.3

1

49.6

1675.1

104

58.8

1

96.9

2019.6

105

42.3

0

68.8

2090.9

106

63.1

1

66.6

1692.3

107

56.4

1

123

1683.5

108

59.4

0

86.5

1850.9

109

61.5

1

55.5

1798.6

110

58.8

1

53.8

1595.5

111

49.2

1

58.5

1595.4

112

48.8

1

60.2

1902

113

51

1

50.4

1633.3

114

60.9

1

61.2

1806.9

115

57.3

0

84.2

2290.3

116

51

1

46.6

1379.1

117

47.7

1

53.5

1589.4

118

43.7

1

80

1447.3

119

43.5

1

51.9

1368.1

120

51

1

62.2

1860.3

121

48

1

61.1

1528.7

122

57.3

1

113.1

1797.5

123

46.1

0

57.9

1994.3

124

46.8

1

41.8

1563.9

125

57.2

1

81.4

1643.3

126

57.2

0

84.9

2426.1

127

53.6

1

67.3

2013.7

128

55.1

0

89.6

2283.5

129

59.9

1

58

1875.2

130

53.1

0

81.8

1898.8

131

41.7

1

83.6

1758.3

132

57.6

0

171.2

2257.1

133

53.2

0

64.7

1819.3

134

48.7

1

91.5

2018.1

135

52.8

1

55.2

1876.8

136

56.8

0

75

2210.9

137

53.6

0

103

2146.2

138

50

1

55.2

1867.9

139

46.7

0

95.9

2194.5

140

56.3

0

99.5

2295.8

141

54.9

1

75.3

1436.4

142

59.1

1

123.7

1973.3

143

63.1

1

79.3

1973.4

144

48.9

1

51.4

1751.6

145

61.8

0

79.7

2079

146

52.1

1

63.1

1589.9

147

63.5

0

144.6

2407.9

148

58.4

0

120.3

1838.7

149

58.8

1

71.6

1524.3

150

45.1

1

75.9

1941.4

151

55.1

0

256.6

2696

152

56.3

1

49.8

1917.1

153

61.2

0

71.1

1910.6

154

61.6

1

100.8

1805.6

155

54.5

0

93.3

2145.8

156

48.5

0

127.8

1956

157

55.6

1

64.7

1912.4

158

63.5

1

73.8

1884.7

159

56

0

108.8

2177

160

45.6

0

63

1741.5

161

58.9

1

68.9

1836.4

162

57.7

0

94.5

2211

163

39.6

0

82.2

1617.2

164

54.1

0

86.2

2063.1

165

58.3

1

106

1761.6

166

54.4

0

95.1

2051.5

167

42.2

1

44.7

1395.9

168

46.4

0

69.8

1731.6

169

57.7

0

82.8

1944.4

170

58.1

1

76.9

1367.5

171

43.6

0

77.2

1833.7

172

47.1

1

52.3

1912.5

173

47.2

1

74.7

1815.1

174

54.2

1

74

1354.1

175

52.4

0

87.9

1797.7

176

61.2

1

83.5

2150.4

177

42

1

48.2

1623.8

178

39.9

1

47

1644.2

179

37.3

0

65.5

1492.9

180

62

1

54.7

1855

181

50.2

0

65.7

2172.5

182

44.8

1

52.2

1519.8

183

54.1

1

65.6

1618.7

184

43

1

53.1

1584.6

185

62.2

1

84.3

1428

186

61.4

1

156.7

1814.8

187

38.1

0

78.9

1420.9

188

53.5

1

93.2

1597.3

189

60.7

1

73.9

1624.9

190

61.5

0

151

2492.8

191

57.8

1

126.1

1803

192

52.6

1

49.1

1500.2

193

49.8

1

62.2

1842.3

194

58.3

1

65.8

1584.9

195

52.3

1

79.5

1650.6

196

57.9

1

72.3

1527.7

197

56.4

1

72

1523.5

198

44.5

0

112.4

2147.6

199

41.1

1

50.2

1876.9

200

43.1

1

63.9

1306.1

201

32.5

1

48

1284

202

50.9

1

67.3

1686.1

203

52.9

1

82.3

1713.8

204

43.9

0

160.8

2391

205

51.4

1

72.3

1862

206

60

1

92.4

1674.5

207

54.8

1

83.2

2030.4

208

59.5

0

230.6

2267.5

209

62.8

1

60

1742.2

210

61.5

1

104.9

1877.6

211

53.6

1

56.9

1575.3

212

46

0

65.8

1749.4

213

55.5

1

80.3

1746.9

214

44.2

1

53.2

1321.4

215

55

1

68.5

1819.9

216

38.6

1

71.9

1716.7

217

57.1

0

125.1

2238.1

218

57.9

0

82.6

2101.4

219

52

1

71

1759.3

220

51.6

1

81.5

1524.3

221

52.8

1

152.1

1733.9

222

57.1

0

82.4

2222

223

45.9

1

57.8

1457.6

224

62.8

1

85.6

1654.7

225

51.5

1

87.9

1324.3

226

57.2

1

144.9

1858.5

227

49.8

0

66.6

2069.6

228

59.1

0

90.5

2128.5

229

52.1

1

67.4

1604.3

230

39.9

0

73.8

1789.5

231

51.4

0

73.2

1801.4

232

35.3

1

57.3

1660.5

233

45

0

60

1368.1

234

59.5

0

86.1

1993.3

235

58.6

1

69.8

2014.3

236

44.8

0

85.2

1546.4

237

64

1

86.5

1864.9

238

42

0

81.8

1714

239

50.2

1

50.1

1621.5

240

51.8

1

61.2

1550.9

241

58.6

0

82.4

1819.2

242

55.1

1

83.4

1512.4

243

59.9

1

57.9

1740

244

53.2

1

56.3

2173.2

245

51.6

1

66.5

1794.3

246

59.9

1

78.5

1949.4

247

54

1

74.8

1637.1

248

56.1

0

101.7

2325.9

249

53

1

65.9

1513.1

250

51.4

1

63.2

1726.2

251

46

0

56.8

1484.8

252

58.9

1

49.9

1520.5

253

59.6

1

59.1

1852

254

58.2

1

61.6

1337.7

255

59.5

1

66.8

1767.6

256

55.2

1

78.5

2168.7

257

57.2

0

67

1675

258

63.8

1

81.1

1959

259

42.3

0

103.3

2090.4

260

53.1

1

64.5

1504.1

261

47

1

85.5

2027.5

262

52.8

0

88.1

1778.3

263

48.4

1

43.7

1389.7

264

55.2

0

80.5

1883.3

265

56.8

1

77.3

1830.3

266

57.5

1

66.7

1508.8

267

57.1

1

102.6

1593.3

268

57.2

1

90.6

1818.7

269

54.1

1

72.7

1595.9

270

41.5

0

55.9

1620

271

44.8

0

61

1714.3

272

62.4

1

86.8

1627.6

273

52.6

1

76.3

1883.9

274

45.1

0

122.5

2019.9

275

40.7

0

78.1

1488

276

60.3

1

84

1594.8

277

59.8

0

96.9

2080.2

278

46.9

0

79.7

2083.8

279

51.7

0

75.1

1923.1

280

59.7

1

93.4

1865.5

281

60.3

1

66.6

1924.8

282

46.1

1

65.1

1447.5

283

55.4

0

79.7

1916.4

284

57.5

0

87.7

1987

285

45.3

1

107.1

1777

286

59.2

0

92.9

2440.2

287

33.1

1

50.6

1349.6

288

56.5

0

147.8

2361.2

289

61.1

1

124.6

2144

290

52.2

0

75.4

2040.1

291

57.4

1

121.2

1600.4

292

60

0

228.5

2844.8

293

60.2

0

158.2

2509.1

294

46.3

0

83.9

1764.3

295

50

1

88.1

2016.9

296

46.6

1

92.3

1698.5

297

56.2

1

67

1267.2

298

55.4

1

58.1

1554

299

45.2

0

66.8

1790.8

300

61.9

0

110.5

2364

301

42.9

1

66.2

1796.2

302

63.4

1

61.8

1805.4

303

62.6

1

63.2

1667.2

304

51

1

62.5

1361

305

60

1

64.9

1625.9

306

58.3

0

134.1

2190.1

307

58.3

1

94.6

1613.2

308

63.2

1

65.6

1707.1

309

52.8

1

130

1828.6

310

50.8

1

65

1567.6

311

43.8

0

71

1830.8

312

50.2

0

88.2

1807.7

313

60.4

1

63.5

1936.6

314

37.3

0

66.5

1500.6

315

50.8

0

117

2171.5

316

49.7

0

67.4

1608.3

317

51.5

1

75.9

1586.2

318

53.7

1

107

1857

319

44.2

1

66.7

1867.7

320

56.7

1

90.1

1857.4

321

30.4

1

52.9

1638.6

322

54.4

0

101

2244.3

323

43.1

0

105.6

1866.1

324

47.1

0

78.1

2055.3

325

63.7

1

96.3

1781.7

326

45.2

0

69.8

1636.8

327

61.1

1

59.2

1564.6

328

49.2

1

86.3

1549.9

329

56.3

1

104.6

2072.9

330

60.8

1

74

2018.6

331

54.6

1

138.4

1496.6

332

59.5

1

63.2

1737.6

333

48.3

1

59.3

1900.7

334

52.8

1

86.7

1550.3

335

47.5

0

175.3

2211.6

336

49.5

0

78.4

2005.5

337

51.5

0

112.2

1850.5

338

55.5

0

74.9

2146.5

339

61

1

85.2

1464.2

340

48.3

0

69.6

1866.4

341

59.4

0

85.2

2273.8

342

39.3

1

90.7

1702.7

343

51.3

0

93.7

1828.3

344

48.6

0

120

1901.6

345

60.7

0

115.1

2061.8

346

56.7

0

83.4

1812.7

347

53.9

1

56.2

1815.8

348

59.5

0

113.4

2008.7

349

58.3

0

116.9

2516.7

350

34.1

0

69.1

1604.3

351

62.3

0

89.4

2114.4

352

55

1

62.2

1710.8

353

57.3

1

77.3

1695.7

354

62.5

1

78.1

1801.9

355

57.5

1

63.2

1687.2

356

58.9

1

116.5

1999

357

59

1

76.5

1879.5

358

53.2

1

89.3

1762.8

359

49

1

59.9

1692.5

360

61.1

1

81

1719

361

59.3

1

62.8

1567.8

362

61.9

1

57.1

1617.6

363

42.2

0

75.7

2045.4

364

58.6

1

112

2199.4

365

55.2

1

52.8

1467.1

366

54.1

1

71.2

1705.3

367

46.5

1

61.3

1586.6

368

60.4

1

58

1695.2

369

45.6

0

110.1

1632.4

370

41.8

0

88.4

1743.1

371

43.7

0

78.4

1924.4

372

64

0

104.5

2008.3

373

50.3

0

115.7

2160.9

374

46.8

1

78.6

1495.4

375

60.1

0

135.7

2622.3

376

53.4

0

163.1

2304.6

377

54.7

1

84.4

1874.2

378

54.8

1

77.4

1568.7

379

41.1

0

88

1882.5

380

53.6

0

102.3

1746.6

381

50.1

1

49.2

1708.3

382

36.1

0

82.5

1687.9

383

36.7

0

128.5

1860.3

384

51.9

0

77.3

1929.2

385

56.1

1

67

1631.4

386

43.8

0

69.3

1789

387

48.3

0

113.8

1795

388

46.8

1

46

1410

389

59.6

1

61.2

1457.3

390

52.6

1

87.3

1550.1

391

58.1

0

65.2

1798.2

392

57.4

1

67.7

2180.4

393

58.5

1

89.2

2071.2

394

53.6

1

79.1

1467.9

395

44

0

79.2

1881.2

396

53.4

1

71.7

1936

397

64

1

68.8

2027.3

398

55.6

0

148.6

2328.4

399

51.4

0

75

1834.1

400

57.2

1

56.3

1941.4

401

45.2

0

97.6

1784.3

402

52.3

1

65.2

1760.1

403

55.8

1

163.6

2105.6

404

54.3

0

92.8

2213.7

405

62.3

0

117.6

2080.8

406

44.9

1

80.9

1726.3

407

49

0

71.7

2135.3

408

52.5

1

65.3

1889.9

409

57.3

1

75.1

1655.6

410

46

1

55.8

1642.2

411

57.6

1

52.4

1228.3

412

48.2

1

57.7

1840.3

413

64

1

68.2

2049.6

414

47.6

0

85.5

1977.1

415

41.7

0

63.7

1696

416

45.4

1

59.6

1580.9

417

61.3

0

76.2

1934.7

418

59.1

1

86

2183.9

419

39.4

0

90.3

1773.7

420

53.5

1

87.8

1801.7

421

58.4

1

72.3

1592.1

422

31.4

0

156.5

2194.8

423

49.1

1

48.4

1906.4

424

45.6

1

72.2

1484.4

425

42.4

1

52.8

1790.1

426

58.9

1

82.4

2030.3

427

54.9

0

83.8

1921.7

428

58.6

1

60.7

1935.9

429

61.5

0

131.1

2516.1

430

61.3

0

119.6

2109.2

431

55.3

0

89.6

2342.6

432

50.9

1

93

1859.2

433

56.1

1

70.8

1993

434

49.3

1

70.7

1600.1

435

53.7

1

99.6

1623

436

51.9

1

67.7

2010.6

437

56.7

0

162.3

2356.6

438

56.4

1

112.7

2137.7

439

49

0

86.1

1911.6

440

55.1

0

105.3

2376.6

441

39

0

56

1913

442

59.2

0

65.2

1819.7

443

64.4

1

63.4

1715.7

444

48.1

0

68.4

1756.4

445

59.9

1

56

1923.8

446

61.3

1

93

2122.2

447

53.8

0

126

2112.6

448

59.7

1

118.2

2197.4

449

59.3

1

73

1639.7

450

59.4

0

164.3

2204.7

451

49

0

90.2

2172.9

452

59.3

0

85.6

2098.4

453

47.6

1

161.9

1804.3

454

52.7

1

51.2

1901.9

455

58.6

1

121.1

1822.6

456

61

1

60.6

1531

457

58.4

1

95.4

1691.3

458

58.9

0

174.6

2737.9

459

55.4

1

84.2

1963.3

460

48.8

0

58.7

2004

461

55.1

0

67.3

1886

462

46.8

1

63.1

1642.6

463

41.8

1

60.3

1510.6

464

54.1

0

107.2

2188

465

58.3

0

67.4

2340.3

466

42.4

1

63.4

1493.1

467

42.8

0

68.1

1773.7

468

62.3

1

71.7

1572.1

469

48

1

72.1

1173

470

58

1

88.6

1831

471

39.5

0

58.2

1760.2

472

58.7

1

69.3

1459.3

473

62.9

0

91.5

2004.1

474

35

1

93.3

1502.8

475

53.9

1

77.5

1496.1

476

44.6

0

107.1

1927.5

477

48.9

1

65.2

1522.7

478

47.7

1

61.5

1566.8

479

53.2

1

105

1743.9

480

60.9

1

57.3

1604.8

481

61

1

58.1

1620

482

47.1

1

55.5

1698.3

483

56

1

62.6

1813.5

484

59.3

1

51.7

1438.3

485

62

1

97.5

1626.4

486

59.6

0

69.4

2372.6

487

47

1

87

1563.1

488

55.2

0

52.7

1885.8

489

50.1

1

92

1882.6

490

63.9

1

61.5

1580.1

491

46.4

1

61.4

1599.3

492

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elementary Linear Algebra with Applications

Authors: Bernard Kolman, David Hill

9th edition

132296543, 978-0132296540

More Books

Students also viewed these Mathematics questions

Question

LO14.3 Organize and gather content for a preview, view, and review.

Answered: 1 week ago