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.

1. Construct appropriate charts for the data in the worksheet, Dealer Satisfaction and summarize your conclusions from analysis of these charts.

Dealer Satisfaction
Survey Scale:	0	1	2	3	4	5	Sample Size
North America
2010	1	0	2	14	22	11	50
2011	0	0	2	14	20	14	50
2012	1	1	1	8	34	15	60
2013	1	2	6	12	34	45	100
2014	2	3	5	15	44	56	125
South America
2010	0	0	0	2	6	2	10
2011	0	0	0	2	6	2	10
2012	0	0	1	4	11	14	30
2013	0	1	1	3	12	33	50
2014	1	1	2	4	22	60	90
Europe
2010	0	0	1	3	7	4	15
2011	0	0	1	2	8	4	15
2012	0	0	1	2	15	7	25
2013	0	0	1	2	21	6	30
2014	0	0	1	4	17	8	30
Pacific Rim
2010	0	0	1	2	2	0	5
2011	0	0	1	1	3	0	5
2012	0	0	1	1	3	1	6
2013	0	0	0	2	5	3	10
2014	0	0	1	2	7	2	12
China
2012	0	0	0	1	0	0	1
2013	0	0	1	4	2	0	7
2014	0	0	1	5	8	2	16

Answer 1

data Customes ave tress to homm Cla gouq manage, os douf Sola Posen ustomexs ane peope who Most com panies a dtssa-ts ied ertanal Cutmes could be because Cus tomes Hou nae Suse +owas dus-tome del