Statistics Concepts and Descriptive Measures

University of Phoenix Material

Consumer Food Worksheet

Complete the following table.

· Review the steps of the communication model on in Ch. 1 of Business Communication. (See Figure 1.3).

· Identify one personal or business communication scenario.

· Describe each step of that communication using your personal or business scenario. Use detailed paragraphs in the boxes provided.

	Annual Food Spending ($)	Annual Household Income ($)	Non mortgage household debt ($)	Region: 1 = NE 2 = MW 3 = S 4 = W	Location: 1 = Metro 2 = Outside Metro
Identify Qualitative or Quantiative
Level of Measurement
For quantative column, evaluate the mean
Interpret the mean in plain non-technical terms
For quantative column, evaluate the median
Interpret the median in plain non-technical terms.
For quantitative columns, evaluate the standard deviation and range
Interpret the standard deviation and range in plain non-technical terms

Additional Insight

Use the Excel =AVERAGE function to find the mean

Use the Excel =AVERAGE function to find the median

Use the Excel =STDEV.S function to find the standard deviation

For range (maximum value minus the minimum value), find the maximum value using the Excel =MAX function and find the minimum value using the Excel’s =MIN functrion