Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

(3 points) Produce a correlation table (i.e., matrix) that that would be suitable for summarizing this dataset. Provide up to three sentences (maximum) to help

(3 points) Produce a correlation table (i.e., matrix) that that would be suitable for summarizing this dataset. Provide up to three sentences (maximum) to help guide a reader's (like a client) interpretation of the table. Provide supporting display(s) if required

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

50.3

1

71.9

1733.4

493

63.1

1

90.2

2040.7

494

50.7

0

94.3

1926.8

495

63

1

66.2

1701.3

496

54.9

1

73.7

1803.6

497

54.3

1

87.2

1829.1

498

51.7

0

81.7

2032

499

57.2

1

83.1

1789.9

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

9781285586618

Students also viewed these Mathematics questions