Asnswer the following questions

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 4. above, which measure of central tendency is best to use to describe customers?

Transcribed Image Text:

Annual Amount Spent on Organic Food 7348 11598 9224 12991 16556 11515 10469 17933 18173 12305 9080 12712 13321 8802 14369 7908 17840 15107 12070 6389 6606 6291 7425 11436 7612 7515 13115 11870 8450 16324 9331 9184 16803 10709 1456 14456 16634 12227 13476 14554 9393 14594 6628 11240 13101 14034 7849 10578 11325 7105 16460 8390 14956 10903 12054 11697 12781 17456 12835 13403 15051 14225 11196 11475 5605 9890 Age 77 58 Annual Amount Spent on Organic Food 7348 11598 9224 12991 16556 11515 10469 17933 18173 12305 9080 12712 13321 8802 14369 7908 17840 15107 12070 6389 6606 6291 7425 11436 7612 7515 13115 11870 8450 16324 9331 9184 16803 10709 1456 14456 16634 12227 13476 14554 9393 14594 6628 11240 13101 14034 7849 10578 11325 7105 16460 8390 14956 10903 12054 11697 12781 17456 12835 13403 15051 14225 11196 11475 5605 9890 Age 77 58

Answer rating: 100% (QA)

1 Annual Amount Spent on Organic Food Age Mean 1104648387 Mean 4823387097 Standard Error 3348136933 ... View the full answer