Elizabeth Burke wants some detailed statistical information about much of the data in the PLE database.

Jun 13th, 2016
KateS
Category:
Other
Price: $5 USD

Question description

Elizabeth Burke wants some detailed statistical information about much of the data in the PLE database.

In particular, she wants to know the following:

a. the mean satisfaction ratings and standard deviations by year and region in the worksheets Dealer

Satisfaction and End-User Satisfaction

b. a descriptive statistical summary for the 2012customer survey data

c. how the response times differ in each quarter of the worksheet Response Time

d. how defects after delivery (worksheet Defects after Delivery) have changed over these 5 years

e. how sales of mowers and tractors compare with industry totals and how strongly monthly product sales are correlated with industry sales. Perform these analyses and summarize your results in a written report to Ms. Burke.


Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Purdue University
PREMIUM TUTOR

Hi, i have completed the project for you but it was not worth 5 USDs so please review your payment

Dealer Satisfaction
a)
Survey Scale:
0
North America
2010
1
2011
0
2012
1
2013
1
2014
2

1

2

3

4

0
0
1
2
3

2
2
1
6
5

14
14
8
12
15

22
20
34
34
44

5 Sample
Size
11
50
14
50
15
60
45
100
56
125

0
0
0
0
1

0
0
0
1
1

0
0
1
1
2

2
2
4
3
4

6
6
11
12
22

2010
2011
2012
2013
2014

0
0
0
0
0

0
0
0
0
0

1
1
1
1
1

3
2
2
2
4

Pacific Rim
2010
2011
2012
2013
2014

0
0
0
0
0

0
0
0
0
0

1
1
1
0
1

0
0
0

0
0
0

0
1
1

South America
2010
2011
2012
2013
2014

Mean

Standard Deviation

8.333333
8.333333
10
16.66667
20.83333

8.824209
8.710147
13.02306
18.43547
23.37021

12.83333 Mean Satisfaction Rating for North America
15.0667 Standard Deviation

2
2
14
33
60

10 1.666667 2.33809
10 1.666667 2.33809
30
5
6.0663
50 8.333333 12.86338
90
15 23.47765

6.333333 Mean Satisfaction Rating
tingfor
forSouth
South
America
America
12.34054 Standard Deviation

7
8
15
21
17

4
4
7
6
8

15
2.5 2.738613
15
2.5 3.082207
25 4.166667 5.913262
30
5 8.14862
30
5 6.63325

3.833333 Mean Satisfaction Rating for Europe
5.323428 Standard Deviation

2
1
1
2
2

2
3
3
5
7

0
0
1
3
2

5 0.833333 0.983192
5 0.833333 1.169045
6
1 1.095445
10 1.666667 2.065591
12
2 2.607681

1.266667 Mean Satisfaction Rating for Pacific Rim
1.631632 Standard Deviation

1
4
5

0
2
8

0
0
2

1 0.166667 0.408248
7 1.166667 1.602082
16 2.666667 3.204164

1.333333 Mean Satisfaction Rating for China
2.160247 Standard Deviation

Europe

China
2012
2013
2014

End-User Satisfaction
North America
2010
2011
2012
2013
2014

0
1
1
1
0
0

1
3
2
2
2
2

2
6
4
5
4
3

3
15
18
17
15
15

4
37
35
34
33
31

Sample Mean
Standard Deviation
5 Size
38
100 16.66667 16.83647
40
100 16.66667 17.33974
41
100 16.66667 17.25881
46
100 16.66667 18.88562
49
100 16.66667 19.66384

South America
2010
2011
2012
2013
2014

1
1
0
0
0

2
3
2
2
2

5
6
6
5
5

18
17
19
20
19

36
36
37
37
37

38
37
36
36
37

100
100
100
100
100

16.66667
16.66667
16.66667
16.66667
16.66667

16.89576
16.32993
16.72922
16.89576
17.09581

16.66667 Mean End-User Satisafaction for South America
15.32826 Standard Deviation

2010
2011
2012
2013
2014

1
1
1
1
0

2
2
1
1
1

4
5
4
3
2

21
21
26
17
19

36
34
37
41
45

36
37
31
37
33

100
100
100
100
100

16.66667
16.66667
16.66667
16.66667
16.66667

16.65733
16.30542
16.47625
18.34848
19.04381

16.66667 Mean End-User Satisfaction for South America
15.8857 Standard Devaition

2010
2011
2012
2013
2014

2
1
1
0
0

3
2
2
2
1

5
7
5
4
3

15
15
16
17
19

41
41
40
40
42

34
34
36
37
35

100
100
100
100
100

16.66667
16.66667
16.66667
16.66667
16.66667

16.93123
17.02547
17.40881
17.95179
18.4029

16.66667 Mean End-User Satisfaction for Pacific Rim
16.02359 Standard Deviation

2012
2013
2014

0
1
0

3
2
1

3
2
1

6
4
3

28
30
31

10
11
14

50 8.333333 10.21111
50 8.333333 11.21903
50 8.333333 12.25833

8.333333 Mean End-User Satisfaction for Pacific Rim
10.27943 Standard Deviation

16.66667 Mean End-User Satisfaction for North america
16.4587 Standard Deviation

Europe

Pacific Rim

China

2014 Customer Survey
Region
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA

Quality
4
4
4
5
5
5
5
5
4
4
4
5
5
4
5
5
5
5
4
4
4
4
5
5
5
5
5
4
5
5
5
4
4
5
5
5
5
5
4
5
5
5
5
3
5
5
5
5
5
5
5
5
5
5
4
5
5
5
4
5
4
5
5
5
5
4
4
5
5
5
5

Ease of Use Price Service
1
3
4
4
4
5
5
4
3
4
4
4
4
5
4
5
3
5
4
4
2
5
4
5
4
4
5
5
4
5
5
1
4
5
4
4
4
3
3
5
4
4
4
3
5
5
2
5
4
2
5
4
2
5
5
4
4
4
5
4
4
2
4
3
3
4
5
2
5
3
4
3
4
4
5
5
2
5
5
5
3
4
5
4
4
4
4
1
5
5
4
3
5
5
1
4
4
3
5
3
4
4
5
2
4
4
4
4
5
4
4
5
4
5
3
3
5
4
4
3
4
3
4
5
1
5
4
5
4
4
3
4
4
2
4
5
4
5
5
3
4
4
4
4
4
4
4
4
4
5
4
1
4
4
5
5
5
3
4
4
4
5
3
5
5
4
4
4
5
5
5
5
4
5
4
4
4
4
5
5
5
5
4
5
5
4
5
3
5
4
4
4
4
5
2
4
5
5
4
4
5
4
4
4
4
3
5
4
5
4
5
4
5

4.395
4.396985
4.39899
4.401015
5
4
4
4
5
4
4
4
4

Mean of Quality
Mean of Ease of Use
Mean Price
Mean service
Quality Mode
Mode of Ease of Use
Price Mode
Service Mode
Service Median
Median of Quality
Median Ease of Use
Median Price
Median Service

0.762813
0.764219
0.765632
0.76705

Standard Deviation of Quality
Standard Deviation of Ease of Lease
Standard Deviation of Price
Standard Deviation of Service

Scatter plot for the 2014 customer survey
6
5
4

3
2
1
0

0

1

2

Series1

Series2
3

Series3
4

5

6

NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA

5
5
5
5
5
4
3
5
4
3
1
4
5
4
5
5
4
5
5
5
5
4
5
4
5
4
5
4
4
5
5
5
4
5
4
5
4
4
4
5
3
5
5
4
4
1
5
4
4
5
4
4
3
5
4
4
4
4
4
5
4
5
5
4
4
5
5
5
3
4
4
5
4
5

4
4
3
4
4
5
5
5
4
2
4
5
5
5
5
5
2
4
4
5
5
5
5
4
5
5
5
5
5
4
4
4
2
4
5
4
5
4
4
4
3
4
4
4
4
5
4
4
4
4
4
4
3
4
4
5
1
5
4
4
4
5
5
4
4
4
4
4
4
3
4
4
3
3

4
5
4
5
1
3
2
4
3
4
3
3
4
5
4
4
4
5
5
4
5
5
4
5
3
2
5
4
5
3
2
5
4
4
2
4
3
4
2
3
5
3
2
3
3
3
2
4
5
2
5
4
4
4
4
5
4
4
4
3
4
4
4
2
4
4
4
1
4
5
2
3
4
5

4
2
5
5
5
5
5
4
5
5
4
5
4
5
5
4
5
4
4
3
5
3
5
5
4
4
4
3
4
5
4
5
5
5
5
4
5
3
4
4
5
4
5
4
5
4
4
4
5
4
5
3
5
4
1
5
5
4
5
4
5
3
4
4
5
5
4
4
5
4
3
3
5
5

SA
SA
SA
SA
SA
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Pac
Pac
Pac
Pac
Pac
Pac
Pac
Pac
Pac
Pac
China
China
China
China
China
China
China
China
China
China

5
5
3
4
4
4
4
3
3
4
5
5
4
3
3
4
5
5
5
3
4
4
5
4
3
4
5
5
4
4
5
2
5
4
5
5
5
4
4
5
4
5
4
3
5
5
5
4
4
4
4
4
3
3
2

4
4
4
4
3
5
4
4
4
4
5
5
5
4
5
4
4
3
5
4
5
5
4
5
5
4
5
3
5
3
4
4
4
5
4
4
5
4
3
4
4
5
2
4
4
5
5
4
4
4
4
4
4
4
3

4
4
3
1
4
5
4
5
1
5
5
5
5
4
3
5
5
4
4
4
4
4
4
4
3
4
3
4
2
4
3
4
5
4
1
4
5
4
4
5
4
4
3
4
4
4
4
3
3
3
3
3
3
2
2

4
4
4
4
3
3
2
4
3
5
5
1
4
4
3
4
5
4
5
4
5
4
5
4
4
2
4
5
4
4
3
4
4
3
5
5
5
4
4
4
4
5
3
4
5
4
3
3
3
2
3
2
3
2
1

6

Complaints
Month
World NA SA Eur Pac
China
Jan-10
169 102
12
52
3
Feb-10
187 115
13
55
4
Mar-10
210 128
15
61
6
Apr-10
226 136
16
67
7
May-10
232 137
17
73
5
Jun-10
261 151
19
82
9
Jul-10
245 140
18
80
7
Aug-10
223 128
16
76
3
Sep-10
195 103
15
73
4
Oct-10
174
96
14
62
2
Nov-10
154
84
11
59
0
Dec-10
163
99
9
54
1
Jan-11
195 123
10
59
3
Feb-11
221 141
13
62
5
Mar-11
240 152
16
66
6
Apr-11
264 163
20
70
11
May-11
283 178
22
75
8
Jun-11
296 170
28
86
12
Jul-11
269 153
25
81
10
Aug-11
256 146
23
79
8
Sep-11
231 131
20
73
7
Oct-11
214 125
16
68
5
Nov-11
201 118
13
66
4
Dec-11
171
96
11
61
3
Jan-12
200 112
15
66
4
3
Feb-12
216 117
18
71
6
4
Mar-12
234 126
20
76
9
3
Apr-12
253 138
23
79
11
2
May-12
282 152
26
85
14
5
Jun-12
305 163
30
91
15
6
Jul-12
296 156
28
89
18
5
Aug-12
279 148
26
86
15
4
Sep-12
266 143
24
82
13
4
Oct-12
243 131
21
76
12
3
Nov-12
232 128
18
73
10
3
Dec-12
203 107
15
70
7
4
Jan-13
216 110
19
74
8
5
Feb-13
239 123
23
79
10
4
Mar-13
266 138
26
83
13
6
Apr-13
284 150
30
88
11
5
May-13
315 169
33
91
15
7
Jun-13
340 181
37
95
19
8
Jul-13
319 169
34
92
17
7
Aug-13
304 160
32
90
15
7
Sep-13
277 141
29
87
14
6
Oct-13
250 123
26
83
12
6
Nov-13
228 112
24
77
10
5
Dec-13
213 105
23
74
7
4
Jan-14
240 121
26
80
8
5
Feb-14
251 126
28
82
10
5
Mar-14
281 148
31
85
12
5
Apr-14
298 155
35
89
13
6
May-14
322 168
39
95
12
8
Jun-14
350 183
43
98
15
11
Jul-14
330 170
41
95
14
10
Aug-14
311 158
38
93
13
9
Sep-14
289 149
33
89
11
7
Oct-14
265 136
30
85
8
6
Nov-14
239 121
26
80
7
5
Dec-14
219 108
23
76
7
5

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84

A
B
Mower Unit Sales
e)
Month
NA
Jan-10 6000
Feb-10 7950
Mar-10 8100
Apr-10 9050
May-10 9900
Jun-10 10200
Jul-10 8730
Aug-10 8140
Sep-10 6480
Oct-10 5990
Nov-10 5320
Dec-10 4640
Jan-11 5980
Feb-11 7620
Mar-11 8370
Apr-11 8830
May-11 9310
Jun-11 10230
Jul-11 8720
Aug-11 7710
Sep-11 6320
Oct-11 5840
Nov-11 4960
Dec-11 4350
Jan-12 6020
Feb-12 7920
Mar-12 8430
Apr-12 9040
May-12 9820
Jun-12 10370
Jul-12 9050
Aug-12 7620
Sep-12 6420
Oct-12 5890
Nov-12 5340
Dec-12 4430
Jan-13 6100
Feb-13 8010
Mar-13 8430
Apr-13 9110
May-13 9730
Jun-13 10120
Jul-13 9080
Aug-13 7820
Sep-13 6540
Oct-13 6010
Nov-13 5270
Dec-13 5380
Jan-14 6210
Feb-14 8030
Mar-14 8540
Apr-14 9120
May-14 9570
Jun-14 10230
Jul-14 9580
Aug-14 7680
Sep-14 6870
Oct-14 5930
Nov-14 5260
Dec-14 4830

C

D

E

F

G

H

I

J

SA Europe Pacific China World Mean Mower Unit Sales
200
720
100
0 7020
2340
220
990
120
0 9280
3093.33
250
1320
110
0 9780
3260
280
1650
120
0 11100
3700
310
1590
130
0 11930
3976.67
300
1620
120
0 12240
4080
280
1590
140
0 10740
3580
250
1560
130
0 10080
3360
230
1590
130
0 8430
2810
220
1320
120
0 7650
2550
210
990
130
0 6650
2216.67
180
660
140
0 5620
1873.33
210
690
140
0 7020
2340
240
1020
150
0 9030
3010
250
1290
140
0 10050
3350
290
1620
150
0 10890
3630
330
1650
130
0 11420
3806.67
310
1590
140
0 12270
4090
290
1560
150
0 10720
3573.33
270
1530
140
0 9650
3216.67
250
1590
150
0 8310
2770
250
1260
160
0 7510
2503.33
240
900
150
0 6250
2083.33
210
660
150
0 5370
1790
220
570
160
0 6970
2323.33
250
840
150
0 9160
3053.33
270
1110
160
0 9970
3323.33
310
1500
170
0 11020
3673.33
360
1440
160
0 11780
3926.67
330
1410
170
0 12280
4093.33
310
1440
160
0 10960
3653.33
300
1410
170
0 9500
3166.67
280
1350
180
0 8230
2743.33
270
1080
180
0 7420
2473.33
260
840
190
0 6630
2210
230
510
180
0 5350
1783.33
250
480
200
0 7030
2343.33
270
750
190
0 9220
3073.33
280
1140
200
0 10050
3350
320
1410
210
0 11050
3683.33
380
1340
190
0 11640
3880
360
1360
200
0 12040
4013.33
320
1410
200
0 11010
3670
310
1490
210
0 9830
3276.67
300
1310
220
0 8370
2790
290
980
210
0 7490
2496.67
270
770
220
0 6530
2176.67
260
430
230
0 6300
2100
270
400
200
0 7080
2360
280
750
190
0 9250
3083.33
300
970
210
0 10020
3340
340
1310
220
5 10995
3665
390
1260
200
16 11436
3812
380
1240
210
22 12082
4027.33
350
1300
230
26 11486
3828.67
340
1250
220
14 9504
3168
320
1210
220
15 8635
2878.33
310
970
230
11 7451
2483.67
300
650
240
3 6453
2151
290
300
230
1 5651
1883.67

K

L

M

N

5000

4000
3000
2000
1000
0
500

1000

1500
Series1

2000

2500

Series2

3000

3500

4000

P

Q

R

S

T

U

Mean Industry Mower Total Sales
2365
3049.35 Mean Mower Unit Sales
3123
3093 Mean Industry Mower Total Sales
3288
3730
The mean of industry mower total sales is slightly greater than the mean mower unit sales
4009
4110
3615
3393
2843
2580
2249
1908
2375
3048
3385
3668
3839
4125
3611
3252
2808
2543
2121
1828
2363
3091
3363
3716
3967
4136
3693
3209
2788
2518
2258
1828
2393
3121
3400
3736
3928
4063
3720
3329
2845
2549
2232
2158
2410
3131
3393
3721
3866
4085
3893
3227
2937
2544
2212
1941

A graph of Mean Monthly Product Sales
and Mean Industry Sales

0

O

4500

Series3

There is a strong correlation between monthly product sales and industry sales as shown by the straight line in the scatter plot

V

Tractor Unit Sales
Month
NA
SA
Eur
Jan-10
570
250
Feb-10
611
270
Mar-10
630
260
Apr-10
684
270
May-10
650
280
Jun-10
600
270
Jul-10
512
264
Aug-10
500
280
Sep-10
478
290
Oct-10
455
280
Nov-10
407
290
Dec-10
360
280
Jan-11
571
320
Feb-11
650
350
Mar-11
740
390
Apr-11
840
440
May-11
830
470
Jun-11
760
490
Jul-11
681
481
Aug-11
670
460
Sep-11
640
460
Oct-11
620
440
Nov-11
570
436
Dec-11
533
420
Jan-12
620
510
Feb-12
792
590
Mar-12
890
610
Apr-12
960
600
May-12
1040
620
Jun-12
1032
640
Jul-12
1006
590
Aug-12
910
600
Sep-12
803
670...

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
Five Star Tutor
Dec 4th, 2016
" Outstanding Job!!!! "
SjSurvivor143
Nov 19th, 2016
" Thanks for the help. "
Joemoe
Nov 5th, 2016
" <3 it, thanks for saving me time. "
tinytim47
Oct 27th, 2016
" Wow this is really good.... didn't expect it. Sweet!!!! "
pmallory
Oct 23rd, 2016
" Totally impressed with results!! :-) "
mixedballz
Oct 14th, 2016
" excellent work as always thanks for the help "
kiln82
Sep 30th, 2016
" awesome work thanks "
darnay
Sep 21st, 2016
" The best tutor out there!!!! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1821 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors