Question

PLEASE SHOW FORMULAS IN EXCEL
Case: Performance Lawn Equipment

PLE sells small tractors worldwide, with sales regions including North America, South America, Europe, and the Pacific Rim. Three years ago a new region was opened to serve China, where a booming market for small tractors has been established. PLE has always emphasized quality and considers the quality it builds into its products as its primary selling point. In the past 2 years, PLE has also emphasized the ease of use of their products.

Before digging into the details of operations, Elizabeth Burke wants to gain an overview of PLE’s overall business performance and market position by examining the information provided in the database.

2. Ms. Burke would also like a quantitative summary of the average responses for each of the customer attributes (i.e., Quality, Ease of Use, Price, Service) in the worksheet 2014 Customer Survey for each market region as a cross-tabulation (use PivotTables as appropriate), along with frequency distributions, and column chart. Please summarize your conclusions from analysis of these charts.

2014 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
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	4	3	4	3
Eur	4	5	5	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

Answer 1

Quantitative summary of the average responses for each of the customer attributes are below pasted

Region	Average of Quality	Average of Ease of Use	Average of Price	Average of Service
China	3.8	4.1	3	2.6
Eur	4.23	4.28	3.8	4.04
NA	4.55	4.3	3.45	4.25
Pac	4.4	3.9	4.1	4.3
SA	4.25	3.95	3.375	4.33

Dotplot of Quality Eur NA Pac SA 4 Quality

c Eur NA Pac SA 4 Price

Dotplot of Ease of Use Eur NA Pac SA 4 Ease of Use Each symbol represents up to 2 observations.