Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Elizabeth Burke has received several questions from other PLE managers regarding quality, customer satisfaction, and operational performance. She would like you to summarize some data

Elizabeth Burke has received several questions from other PLE managers regarding quality, customer satisfaction, and operational performance. She would like you to summarize some data from the Performance Lawn Equipment Database using statistical tools and analysis:

  1. Frequency distributions and histograms for the data in the Customer Survey worksheet
  2. A frequency distribution and histogram for the blade weight samples in the worksheet Blade Weight
  3. Correlations among the satisfaction survey variables in the worksheet Purchasing Survey

Customer Survey

Region

Quality

Ease of Use

Price

Service

NA

4

1

3

4

NA

4

4

4

5

NA

4

5

4

3

NA

5

4

4

4

NA

5

4

5

4

NA

5

5

3

5

NA

5

4

4

2

NA

5

5

4

5

NA

4

4

4

5

NA

4

5

4

5

NA

4

5

1

4

NA

5

5

4

4

NA

5

4

3

3

NA

4

5

4

4

NA

5

4

3

5

NA

5

5

2

5

NA

5

4

2

5

NA

5

4

2

5

NA

4

5

4

4

NA

4

4

5

4

NA

4

4

2

4

NA

4

3

3

4

NA

5

5

2

5

NA

5

3

4

3

NA

5

4

4

5

NA

5

5

2

5

NA

5

5

5

3

NA

4

4

5

4

NA

5

4

4

4

NA

5

1

5

5

NA

5

4

3

5

NA

4

5

1

4

NA

4

4

3

5

NA

5

3

4

4

NA

5

5

2

4

NA

5

4

4

4

NA

5

5

4

4

NA

5

5

4

5

NA

4

3

3

5

NA

5

4

4

3

NA

5

4

3

4

NA

5

5

1

5

NA

5

4

5

4

NA

3

4

3

4

NA

5

4

2

4

NA

5

5

4

5

NA

5

5

3

4

NA

5

4

4

4

NA

5

4

4

4

NA

5

4

4

5

NA

5

4

1

4

NA

5

4

5

5

NA

5

5

3

4

NA

5

4

4

5

NA

4

3

5

5

NA

5

4

4

4

NA

5

5

5

5

NA

5

5

4

5

NA

4

4

4

4

NA

5

4

5

5

NA

4

5

5

4

NA

5

5

5

4

NA

5

5

3

5

NA

5

4

4

4

NA

5

4

5

2

NA

4

4

5

5

NA

4

4

4

5

NA

5

4

4

4

NA

5

4

3

5

NA

5

4

5

4

NA

5

5

4

5

NA

5

4

4

4

NA

5

4

5

2

NA

5

3

4

5

NA

5

4

5

5

NA

5

4

1

5

NA

4

5

3

5

NA

3

5

2

5

NA

5

5

4

4

NA

4

4

3

5

NA

3

2

4

5

NA

1

4

3

4

NA

4

5

3

5

NA

5

5

4

4

NA

4

5

5

5

NA

5

5

4

5

NA

5

5

4

4

NA

4

2

4

5

NA

5

4

5

4

NA

5

4

5

4

NA

5

5

4

3

NA

5

5

5

5

NA

4

5

5

3

NA

5

5

4

5

NA

4

4

5

5

NA

5

5

3

4

NA

4

5

2

4

NA

5

5

5

4

NA

4

5

4

3

NA

4

5

5

4

SA

5

4

3

5

SA

5

4

2

4

SA

5

4

5

5

SA

4

2

4

5

SA

5

4

4

5

SA

4

5

2

5

SA

5

4

4

4

SA

4

5

3

5

SA

4

4

4

3

SA

4

4

2

4

SA

5

4

3

4

SA

3

3

5

5

SA

5

4

3

4

SA

5

4

2

5

SA

4

4

3

4

SA

4

4

3

5

SA

1

5

3

4

SA

5

4

2

4

SA

4

4

4

4

SA

4

4

5

5

SA

5

4

2

4

SA

4

4

5

5

SA

4

4

4

3

SA

3

3

4

5

SA

5

4

4

4

SA

4

4

4

1

SA

4

5

5

5

SA

4

1

4

5

SA

4

5

4

4

SA

4

4

4

5

SA

5

4

3

4

SA

4

4

4

5

SA

5

5

4

3

SA

5

5

4

4

SA

4

4

2

4

SA

4

4

4

5

SA

5

4

4

5

SA

5

4

4

4

SA

5

4

1

4

SA

3

4

4

5

SA

4

3

5

4

SA

4

4

2

3

SA

5

4

3

3

SA

4

3

4

5

SA

5

3

5

5

SA

5

4

4

4

SA

5

4

4

4

SA

3

4

3

4

SA

4

4

1

4

SA

4

3

4

3

Eur

4

5

5

3

Eur

4

4

4

2

Eur

3

4

5

4

Eur

3

4

1

3

Eur

4

4

5

5

Eur

5

5

5

5

Eur

5

5

5

1

Eur

4

5

5

4

Eur

3

4

4

4

Eur

3

5

3

3

Eur

4

4

5

4

Eur

5

4

5

5

Eur

5

3

4

4

Eur

5

5

4

5

Eur

3

4

4

4

Eur

4

5

4

5

Eur

4

5

4

4

Eur

5

4

4

5

Eur

4

5

4

4

Eur

3

5

3

4

Eur

4

4

4

2

Eur

5

5

3

4

Eur

5

3

4

5

Eur

4

5

2

4

Eur

4

3

4

4

Eur

5

4

3

3

Eur

2

4

4

4

Eur

5

4

5

4

Eur

4

5

4

3

Eur

5

4

1

5

Pac

5

4

4

5

Pac

5

5

5

5

Pac

4

4

4

4

Pac

4

3

4

4

Pac

5

4

5

4

Pac

4

4

4

4

Pac

5

5

4

5

Pac

4

2

3

3

Pac

3

4

4

4

Pac

5

4

4

5

China

5

5

4

4

China

5

5

4

3

China

4

4

3

3

China

4

4

3

3

China

4

4

3

2

China

4

4

3

3

China

4

4

3

2

China

3

4

3

3

China

3

4

2

2

China

2

3

2

1

Blade Weight

Sample

Weight

1

4.88

2

4.92

3

5.02

4

4.97

5

5.00

6

4.99

7

4.86

8

5.07

9

5.04

10

4.87

11

4.77

12

5.14

13

5.04

14

5.00

15

4.88

16

4.91

17

5.09

18

4.97

19

4.98

20

5.07

21

5.03

22

5.12

23

5.08

24

4.86

25

5.11

26

4.92

27

5.18

28

4.93

29

5.12

30

5.08

31

4.75

32

4.99

33

5.00

34

4.91

35

5.18

36

4.95

37

4.63

38

4.89

39

5.11

40

5.05

41

5.03

42

5.02

43

4.96

44

5.04

45

4.93

46

5.06

47

5.07

48

5.00

49

5.03

50

5.00

51

4.95

52

4.99

53

5.02

54

4.90

55

5.10

56

5.01

57

4.84

58

5.01

59

4.88

60

4.97

61

4.97

62

5.06

63

5.06

64

5.04

65

4.87

66

5.00

67

5.03

68

5.02

69

5.02

70

5.06

71

5.21

72

5.09

73

4.97

74

5.01

75

4.90

76

4.89

77

4.93

78

5.16

79

5.02

80

5.01

81

5.10

82

5.03

83

5.07

84

4.92

85

5.08

86

4.96

87

4.74

88

4.91

89

5.12

90

5.00

91

4.93

92

4.88

93

4.88

94

4.81

95

5.16

96

5.03

97

4.87

98

5.09

99

4.94

100

5.08

101

4.97

102

5.23

103

5.12

104

5.09

105

5.12

106

4.93

107

4.79

108

5.10

109

5.12

110

4.86

111

5.00

112

4.94

113

4.95

114

4.95

115

4.87

116

5.09

117

4.94

118

5.01

119

5.04

120

5.05

121

5.05

122

4.97

123

4.96

124

4.96

125

4.99

126

5.04

127

4.91

128

5.19

129

5.03

130

4.99

131

5.12

132

4.97

133

4.88

134

5.07

135

5.01

136

4.89

137

4.95

138

5.09

139

5.09

140

4.89

141

4.93

142

4.85

143

5.03

144

4.92

145

5.09

146

4.99

147

4.92

148

4.87

149

4.90

150

5.02

151

5.21

152

5.02

153

4.9

154

5

155

5.16

156

5.03

157

4.96

158

5.04

159

4.98

160

5.07

161

5.02

162

5.08

163

4.85

164

4.9

165

4.97

166

5.09

167

4.89

168

4.87

169

5.01

170

4.97

171

5.87

172

5.33

173

5.11

174

5.07

175

4.93

176

4.99

177

5.04

178

5.14

179

5.09

180

5.06

181

4.85

182

4.93

183

5.04

184

5.09

185

5.07

186

4.99

187

5.01

188

4.88

189

4.93

190

5.1

191

4.94

192

4.88

193

4.89

194

4.89

195

4.85

196

4.82

197

5.02

198

4.9

199

4.73

200

5.04

201

5.07

202

4.81

203

5.04

204

5.03

205

5.01

206

5.14

207

5.12

208

4.89

209

4.91

210

4.97

211

4.98

212

5.01

213

5.01

214

5.09

215

4.93

216

5.04

217

5.11

218

5.07

219

4.95

220

4.86

221

5.13

222

4.95

223

5.22

224

4.81

225

4.91

226

4.95

227

4.94

228

4.81

229

5.11

230

4.81

231

4.97

232

5.07

233

5.03

234

4.81

235

4.95

236

4.89

237

5.08

238

4.93

239

4.99

240

4.94

241

5.13

242

5.02

243

5.07

244

4.82

245

5.03

246

4.85

247

4.89

248

4.82

249

5.18

250

5.02

251

5.05

252

4.88

253

5.08

254

4.98

255

5.02

256

4.99

257

5.02

258

5.03

259

5.02

260

5.07

261

4.95

262

4.95

263

4.94

264

5.12

265

5.08

266

4.91

267

4.96

268

4.96

269

4.94

270

5.19

271

4.91

272

5.01

273

4.93

274

5.05

275

4.96

276

4.92

277

4.95

278

5.08

279

4.97

280

5.04

281

4.94

282

4.98

283

5.03

284

5.05

285

4.91

286

5.09

287

5.21

288

4.87

289

5.02

290

4.81

291

4.96

292

5.06

293

4.86

294

4.96

295

4.99

296

4.94

297

5.06

298

4.95

299

5.02

300

5.01

301

5.04

302

5.01

303

5.02

304

5.03

305

5.18

306

5.08

307

5.14

308

4.92

309

4.97

310

4.92

311

5.14

312

4.92

313

5.03

314

4.98

315

4.76

316

4.94

317

4.92

318

4.91

319

4.96

320

5.02

321

5.13

322

5.13

323

4.92

324

4.98

325

4.89

326

4.88

327

5.11

328

5.11

329

5.08

330

5.03

331

4.94

332

4.88

333

4.91

334

4.86

335

4.89

336

4.91

337

4.87

338

4.93

339

5.14

340

4.87

341

4.98

342

4.88

343

4.88

344

5.01

345

4.93

346

4.93

347

4.99

348

4.91

349

4.96

350

4.78

Purchasing Survey

Delivery speed

Price level

Price flexibility

Manufacturing image

Overall service

Salesforce image

Product quality

Usage Level

Satisfaction Level

Size of firm

Purchasing Structure

Industry

Buying Type

4.1

0.6

6.9

4.7

2.4

2.3

5.2

32

4.2

0

0

1

1

1.8

3

6.3

6.6

2.5

4

8.4

43

4.3

1

1

0

1

3.4

5.2

5.7

6

4.3

2.7

8.2

48

5.2

1

1

1

2

2.7

1

7.1

5.9

1.8

2.3

7.8

32

3.9

1

1

1

1

6

0.9

9.6

7.8

3.4

4.6

4.5

58

6.8

0

0

1

3

1.9

3.3

7.9

4.8

2.6

1.9

9.7

45

4.4

1

1

1

2

4.6

2.4

9.5

6.6

3.5

4.5

7.6

46

5.8

0

0

1

1

1.3

4.2

6.2

5.1

2.8

2.2

6.9

44

4.3

1

1

0

2

5.5

1.6

9.4

4.7

3.5

3

7.6

63

5.4

0

0

1

3

4

3.5

6.5

6

3.7

3.2

8.7

54

5.4

1

1

0

2

2.4

1.6

8.8

4.8

2

2.8

5.8

32

4.3

0

0

0

1

3.9

2.2

9.1

4.6

3

2.5

8.3

47

5

0

0

1

2

2.8

1.4

8.1

3.8

2.1

1.4

6.6

39

4.4

1

1

0

1

3.7

1.5

8.6

5.7

2.7

3.7

6.7

38

5

0

0

1

1

4.7

1.3

9.9

6.7

3

2.6

6.8

54

5.9

0

0

0

3

3.4

2

9.7

4.7

2.7

1.7

4.8

49

4.7

0

0

0

3

3.2

4.1

5.7

5.1

3.6

2.9

6.2

38

4.4

0

1

1

2

4.9

1.8

7.7

4.3

3.4

1.5

5.9

40

5.6

0

0

0

2

5.3

1.4

9.7

6.1

3.3

3.9

6.8

54

5.9

0

0

1

3

4.7

1.3

9.9

6.7

3

2.6

6.8

55

6

0

0

0

3

3.3

0.9

8.6

4

2.1

1.8

6.3

41

4.5

0

0

0

2

3.4

0.4

8.3

2.5

1.2

1.7

5.2

35

3.3

0

0

0

1

3

4

9.1

7.1

3.5

3.4

8.4

55

5.2

0

1

0

3

2.4

1.5

6.7

4.8

1.9

2.5

7.2

36

3.7

1

1

0

1

5.1

1.4

8.7

4.8

3.3

2.6

3.8

49

4.9

0

0

0

2

4.6

2.1

7.9

5.8

3.4

2.8

4.7

49

5.9

0

0

1

3

2.4

1.5

6.6

4.8

1.9

2.5

7.2

36

3.7

1

1

0

1

5.2

1.3

9.7

6.1

3.2

3.9

6.7

54

5.8

0

0

1

3

3.5

2.8

9.9

3.5

3.1

1.7

5.4

49

5.4

0

0

1

3

4.1

3.7

5.9

5.5

3.9

3

8.4

46

5.1

1

1

0

2

3

3.2

6

5.3

3.1

3

8

43

3.3

1

1

0

1

2.8

3.8

8.9

6.9

3.3

3.2

8.2

53

5

0

1

0

3

5.2

2

9.3

5.9

3.7

2.4

4.6

60

6.1

0

0

0

3

3.4

3.7

6.4

5.7

3.5

3.4

8.4

47

3.8

1

1

0

1

2.4

1

7.7

3.4

1.7

1.1

6.2

35

4.1

1

1

0

1

1.8

3.3

7.5

4.5

2.5

2.4

7.6

39

3.6

1

1

1

1

3.6

4

5.8

5.8

3.7

2.5

9.3

44

4.8

1

1

1

2

4

0.9

9.1

5.4

2.4

2.6

7.3

46

5.1

0

0

1

3

0

2.1

6.9

5.4

1.1

2.6

8.9

29

3.9

1

1

1

1

2.4

2

6.4

4.5

2.1

2.2

8.8

28

3.3

1

1

1

1

1.9

3.4

7.6

4.6

2.6

2.5

7.7

40

3.7

1

1

1

1

5.9

0.9

9.6

7.8

3.4

4.6

4.5

58

6.7

0

0

1

3

4.9

2.3

9.3

4.5

3.6

1.3

6.2

53

5.9

0

0

0

3

5

1.3

8.6

4.7

3.1

2.5

3.7

48

4.8

0

0

0

2

2

2.6

6.5

3.7

2.4

1.7

8.5

38

3.2

1

1

1

1

5

2.5

9.4

4.6

3.7

1.4

6.3

54

6

0

0

0

3

3.1

1.9

10

4.5

2.6

3.2

3.8

55

4.9

0

0

1

3

3.4

3.9

5.6

5.6

3.6

2.3

9.1

43

4.7

1

1

1

2

5.8

0.2

8.8

4.5

3

2.4

6.7

57

4.9

0

0

1

3

5.4

2.1

8

3

3.8

1.4

5.2

53

3.8

0

0

1

3

3.7

0.7

8.2

6

2.1

2.5

5.2

41

5

0

0

0

2

2.6

4.8

8.2

5

3.6

2.5

9

53

5.2

1

1

1

2

4.5

4.1

6.3

5.9

4.3

3.4

8.8

50

5.5

1

1

0

2

2.8

2.4

6.7

4.9

2.5

2.6

9.2

32

3.7

1

1

1

1

3.8

0.8

8.7

2.9

1.6

2.1

5.6

39

3.7

0

0

0

1

2.9

2.6

7.7

7

2.8

3.6

7.7

47

4.2

0

1

1

2

4.9

4.4

7.4

6.9

4.6

4

9.6

62

6.2

1

1

0

2

5.4

2.5

9.6

5.5

4

3

7.7

65

6

0

0

0

3

4.3

1.8

7.6

5.4

3.1

2.5

4.4

46

5.6

0

0

1

3

2.3

4.5

8

4.7

3.3

2.2

8.7

50

5

1

1

1

2

3.1

1.9

9.9

4.5

2.6

3.1

3.8

54

4.8

0

0

1

3

5.1

1.9

9.2

5.8

3.6

2.3

4.5

60

6.1

0

0

0

3

4.1

1.1

9.3

5.5

2.5

2.7

7.4

47

5.3

0

0

1

3

3

3.8

5.5

4.9

3.4

2.6

6

36

4.2

0

1

1

2

1.1

2

7.2

4.7

1.6

3.2

10

40

3.4

1

1

1

1

3.7

1.4

9

4.5

2.6

2.3

6.8

45

4.9

0

0

0

2

4.2

2.5

9.2

6.2

3.3

3.9

7.3

59

6

0

0

0

3

1.6

4.5

6.4

5.3

3

2.5

7.1

46

4.5

1

1

0

2

5.3

1.7

8.5

3.7

3.5

1.9

4.8

58

4.3

0

0

0

3

2.3

3.7

8.3

5.2

3

2.3

9.1

49

4.8

1

1

1

2

3.6

5.4

5.9

6.2

4.5

2.9

8.4

50

5.4

1

1

1

2

5.6

2.2

8.2

3.1

4

1.6

5.3

55

3.9

0

0

1

3

<

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

Doing Data Analysis With SPSS Version 18.0

Authors: Dennis Coon, Robert H Carver, Jane Gradwohl Nash

5th Edition

1133171281, 9781133171287

More Books

Students also viewed these Mathematics questions

Question

1. To gain knowledge about the way information is stored in memory.

Answered: 1 week ago