 # Statistics Concepts and Descriptive Measures Anonymous

### Question Description

Purpose of Assignment

The purpose of this assignment to orient students to the key concepts in statistics. This assignment will introduce students to the language of statistics. Students will also get a chance to warm-up on evaluating some basic descriptive statistics using Excel® prior to the course start.

Assignment Steps

This assignment has an Excel® dataset spreadsheet attached. You will be required to use the Consumer Food dataset.

Resource: Microsoft Excel®, Statistics Concepts and Descriptive Measures Data Set

Use the Consumer Food dataset to complete this assignment: Do not use the Financial or Hospital data sets.

Answer each of the following in a total of 90 words:

• For each column, identify whether the data is qualitative or quantitative.
• Identify the level of measurement for the data in each column.
• For each column containing quantitative data:
• Evaluate the mean and median
• Interpret the mean and median in plain non-technical terms
• Use the Excel =AVERAGE function to find the mean
• Use the Excel =MEDIAN function to find the median
• For each column containing quantitative data:
• Evaluate the standard deviation and range
• Interpret the standard deviation and range in plain non-technical terms
• 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 function

Click the Assignment Files tab to submit your assignment. This should be an MS Word document with your results pasted into the document. You may also include your Excel work, if you wish.

### Unformatted Attachment Preview

Purchase answer to see full attachment

jesusale932
School: University of Virginia  Statistics Concepts and Descriptive Measures

Assignment: Statistics Concepts and Descriptive Measures
Author’s Name
University Name
QNT561
10-16-2017

1

Statistics Concepts and Descriptive Measures

2

Assignment: Statistics Concepts and Descriptive Measures
Purpose of Assignment
The purpose of this assignment to orient students to the key concepts in statistics.
This assignment will introduce students to the language of statistics. Students will also get a
chance to warm-up on evaluating some basic descriptive statistics using Excel® prior to the
course start.
Data Set
The dataset chosen was “Consumer Food” and it is compounded by 200 row and 5
columns. The columns from left to right are Annual Food Spending, Annual Household
Income, Non mortgage household debt, Region, and Location.

Descriptive Statistics

For each column, identify whether the data is qualitative or quantitative.

The variables are the concepts that form statements of a particular type called
hypothesis. The variables can be classified into two types: quantitative and qualitative.
Qualitative variables express qualities, attributes, categories or characteristics. In this way
they differ from the quantitative variables are those that adopt numerical values (that is,
figures). In the set of quantitative variables, we can also recognize several types of
variables. Continuous quantitative variables can take any value within a given range. The
discrete quantitative variables, on the other hand, acquire values that are separated from
each other in the scale. The classification for the data set "Consumer Food" as shown
below:

1. Annual Food Spending: Quantitative data
2. Annual Household Income: Quantitative data

Statistics Concepts and Descriptive Measures
3. Non mortgage household debt: Quantitative data
4. Region: Qualitative data. Numbers from 1 to 4 used to identify the Region.
5. Location: Qualitative data. Numbers from 1 to 2 used to identify the Location

Identify the level of measurement for the data in each column.

Measurement levels are used to measure variables or attributes. In general, four scales
or measurement levels are distinguished: nominal, ordinal, intervals and scales of
proportion, quotient or ratio. The first two (nominal and ordinal) are known as categorical
scales, and the last two (interval and reason) as numerical scales. Categorical scales are
commonly used for qualitative variables, while numerical scales are suitable for the
measurement of quantitative variables. They are used to aid in the classification of
variables, the design of questions to measure variables, and even indicate the type of
statistical analysis appropriate for the treatment of the data.
The levels of measurements for each column of “Consumer Food dataset” are:

1. Annual Food Spending: Ratio
2. Annual Household Income: Ratio
3. Non mortgage household debt: Ratio
4. Region: Nominal
5. Location: Nominal

For each column containing quantitative data:
o

Evaluate the mean and median

o

Interpret the mean and median in plain non-technical terms

o

Use the Excel =AVERAGE function to find the mean

o

Use the Excel =MEDIAN function to find the median

3

Statistics Concepts and Descriptive Measures

4

Table 1
Measures of Central Tendencies
Name

Mean

Median

Annual Food Spending

8,966.065

8,932.000

Annual Household Income

55,552.390

54,957.471

Non mortgage household

15,604.158

16,100.248

debt

The column that can be calculated the measures of central tendencies are Annual Food
Spending, Annual Household Income, Non mortgage household debt. Each value, mean
and median, was calculated using the Excel Functions AVERAGE and MEDIAN
respectively. Comparing the values obtained it is observed that in two cases the mean was
higher than the median, which means that the distribution of the variables Annual Food
Spending and Annual Household Income will deviate to the right, in contrast to the variable
Non mortgage household debt that it will deviate to the left.

For each column containing quantitative data:
o

Evaluate the standard deviation and range

o

Interpret the standard deviation and range in plain non-technical terms

o

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

o

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 function

Statistics Concepts and Descriptive Measures

5

Table 2
Measures of Dispersion
Name

Standard deviation

Range

Annual Food Spending

3,125.008

15,153.00

Annual Household Income

14,661.36

74,485.590

Non mortgage household

8,583.539

36,373.940

debt

The quantitative variables for which the dispersion measures can be calculated are:
Annual Food Spending, Annual Household Income, Non mortgage household debt. Values
were obtained using the excel functions STDEV.S and Max and MIN for the range. The
d...

flag Report DMCA Review Anonymous
Top quality work from this tutor! I’ll be back! Anonymous
Heard about Studypool for a while and finally tried it. Glad I did caus this was really helpful. Anonymous
Thank you! Reasonably priced given the quality Studypool 4.7 Trustpilot 4.5 Sitejabber 4.4 Brown University

1271 Tutors California Institute of Technology

2131 Tutors Carnegie Mellon University

982 Tutors Columbia University

1256 Tutors Dartmouth University

2113 Tutors Emory University

2279 Tutors Harvard University

599 Tutors Massachusetts Institute of Technology

2319 Tutors New York University

1645 Tutors Notre Dam University

1911 Tutors Oklahoma University

2122 Tutors Pennsylvania State University

932 Tutors Princeton University

1211 Tutors Stanford University

983 Tutors University of California

1282 Tutors Oxford University

123 Tutors Yale University

2325 Tutors