Assume once again that you are a consultant who works for the Diligent Consulting Group. You collected only the "Age" of customers. However, you realized that you need more customer information and collected the following additional variable: "Annual Amount Spent on Organic Food." You want to conduct additional analysis on this customer database.

Assignment Expectations

1. Calculate mean, median, mode, range, standard deviation, and skewness for both variables using the Descriptive Statistics tool in Excel.
2. What are the characteristics of the "average" customer?
3. What are the characteristics of the "typical" customer?
4. Comment on the skewness of the variables: Which variable is most skewed? Which variable is least skewed?
5. Given your answers to question 4 above, which measure of central tendency best describes customers?
6. Comment on additional variables that would be useful to collect to analyze customers in greater detail. Please list at leasttwoadditional variables and explain why they are important for this analysis.

Annual Amount Spent :

7348

11598

9224

12991

16556

11515

10469

17933

18173

12305

9080

9113

6185

6470

6000

6760

8579

7393

8161

10800

6160

10800

8543

17666

12644

14308

9737

13301

18106

11468

9547

7812

15521

7598

7783

17737

7824

6552

11232

6540

4200

7225

5370

4476

2800

7839

3472

8854

8900

12791

12712

13321

8802

14369

7908

17840

15107

12070

6389

6606

6291

7425

11436

7612

7515

13115

11870

8540

16324

9331

3184

16803

10709

11486

16634

1227

13476

14554

9393

14594

6628

11240

13101

14034

17837

7849

10578

11325

7105

16460

8390

14956

10903

12054

11697

12781

17456

12835

13403

15051

14225

11196

11475

5605

9890

13227

11200

9600

15703

6486

9430

7755

8100

14821

10650

12589

11600

13000

17065

8600

11900

16723

16759

AGE:

77

47

23

38

58

44

34

75

32

39

65

48

48

49

57

71

47

47

28

63

24

66

24

38

54

28

58

27

48

26

52

29

75

45

74

56

30

57

41

23

28

23

45

33

42

39

60

57

41

67

73

57

64

24

25

34

78

34

34

41

62

57

23

78

36

44

75

70

38

35

65

68

48

24

46

43

58

66

68

74

32

61

42

60

64

53

62

78

44

58

27

68

21

70

38

25

30

70

37

40

29

54

52

65

72

40

36

43

38

73

41

35

21

59

56

42

46

34

70

38

51

66

43