 # Statistics Concepts and Descriptive Measures, statistics homework help 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 only do one of the three datasets.

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

Choose one of the following datasets to complete this assignment:

• Consumer Food ( This is the one I chose)
• Financial
• Hospital

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

### Unformatted Attachment Preview

Purchase answer to see full attachment

FinAccGuru
School: UCLA  Central location measures including mean, medina, mode etc., and dispersion measures
including variance, standard deviation, range etc. cane be used to understand the data properties
and take decision. This paper aims at reviewing the data type, level of measurement, central
location & dispersion measures of food data of 200 customers.
Descriptive Measures of Consumer Food Data
Data Type
The data represented the first three columns namely- annual food spending, annual
household income, and non-mortgage household debt are quantitative data in nature. Numerical
values based on which each customers can be analyzed and assessed quantitatively has been
assigned for each of these variables. The data represented in the fourth and fifth column namelyregion and location are qualitative data. The location and state of the consumers can be known
from these data. No quantitative analysis can be made with these data.
Level of Measurement
The data represented in the first three columns are ratio level data. Besides on these data
categorization and ordering of the customers can be made. Beside these, each of these data has
equal interval and zero values of these are meaningful. The data represented in the last two
columns namely customer region, and customer location are nominal level data. With these data,
customers can be categorized but cannot be ordered. Nominal level data contains data based on
which only categorization can be made only.
Measures of Location
The mean of the annual food spending, annual household income, and non-mortgage
household debt of the consumers are 8966.1, 55552.4, and 15604.2 respectively. These means

value represent the expected value or typical value (average) of annual food spending, annual
household income, and non-mortgage household debt of the consumers.
The median value of the annual food spending, annual household income, and nonmortgage household debt of the consumers are 8932.0, 54957.5, and 16100.2 respectively. These
median value represent medium values when the annual food spending, annual household
income, and non-mortgage household debt data of t...

flag Report DMCA Review Anonymous
The tutor was pretty knowledgeable, efficient and polite. Great service! Anonymous
Heard about Studypool for a while and finally tried it. Glad I did caus this was really helpful. Anonymous
Just what I needed… fantastic! 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