Statistics Concepts and Descriptive Measures, statistics homework help

User Generated

pbyrznaofzvgu

Mathematics

Description

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

Download the Statistics Concepts and Descriptive Measures Data Set.

Choose one of the following datasets to complete this assignment:

  • Consumer Food
  • 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

Click the Assignment Files tab to submit your assignment.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

kindly find the attached answer, thank you

Surname 1

Name
Supervisor
Course
Data
Dataset: Consumer food
Identification
Annual food spending, annual household income, and non-mortgage household debt are
all quantitative data as they can be quantified and measured. The data in the three columns also
can be manipulated using mathematical methods to yield desired results. However, the region
and location are qualitative data as they are subjective in nature. For instance, region 1 and
region 4 have no difference in terms distance or any other quantifiable measure, the number are
merely assigned for identification (Weiss). The qualitative datasets are not amenable to
mathematical manipulations as they cannot be measured.
Level of measurement
The consumer food dataset employs two levels of measurement; nominal scales and
interval scales. For instance, the region and location are merely categorized for identification and
therefore embody the nominal level of measurement. The data does not imply any ordering and
as such a location 2 does not in any way come ahead of location 1 and so applies to regions. In
addition, the columns; Annual food spending, annual household income and non-mortgage
household debt have numerical scales that embody the same interpretation and as such, they have
an interval level of measurement. Mean and median
The mean and the median for the quantitative data are as follows;

Surname 2

Annual
Household
Non mortgage
Annual Food
Income
household
Spending ($)
($)
debt ($)
8,918
55,454
15,542
Mean
8,932
54,957
15,922
Median
Both the mean and the median are indicative of where the center of the data. The typical
amount of money sound on food per year is $8,918, while the typical household income per year
is $55,454 and an average debt of $15,542 per year. Typically the data is centered on the mean
and the median. The means for annual food spending and non-mortgage household debt are
slightly less than the median values which imply that the data is skewed to the left, however, in
annual household income column the mean is slightly greater than the median implying that the
data is skewed to the right.
Standard deviation and the range
The standard deviation and the range for the quantitative data elements are shown below;

Standard deviation
Range

Annual
Food
Spending
($)
3094.006
15,153

Annual
Household
Income
($)
14788.79
81,471

Non
mortgage
household
debt ($)
8697.584
36,374

The standard deviation measures the extent to which the data is spread from the mean
from the mean. The range measure how the data is spread out by considering the maximum value
and the minimum value (Samuels et al). The standard deviation for; annual food spending is
3094, annual household income is $14,788.79 and household debt is $8,697.58. The values show
the mean distance between the data point and the mean of the data. The range for annual for;

Surname 3

annual food spending is 15,153, annual household income is 81,471 and the household debt is
36,374.

Surname 4

Work cited
Weiss, Neil A. Introductory statistics. Pearson, 2015.
Samuels, Myra L., Jeffrey A. Witmer, and Andrew Schaffner. Statistics for the life sciences.
Pearson education, 2012.


Region: 1 Location:
Annual
Annual
Non
= NE 2 = 1 = Metro
Food
Househol mortgage MW 3 =
2=
Spending d Income househol S
4 = Outside
($)
($)
d debt ($)
W
Metro
8909
56697
23180
1
1
5684
35945
7052
1
1
10706
52687
16149
1
1
14112
74041
21839
1
1
13855
63182
18866
1
1
15619
79064
21899
1
1
2694
25981
8774
1
1
9127
57424
15766
1
1
13514
72045
27685
1
1
6314
38046
8545
1
1
7622
52408
28057
1
1
4322
41405
6998
1
1
3805
29684
4806
1
1
6674
49246
13592
1
1
7347
41491
4088
1
1
2911
26703
15876
1
1
8026
48753
16714
1
1
8567
55555
16783
1
1
10345
71483
21407
1
1
8694
50980
19114
1
1
8821
46403
7817
1
1
8678
51927
14415
1
1
14331
84769
17295
1
1
9619
59062
16687
1
1
9286
57952
14161
1
1
8206
58355
19538
1
1
16408
81694
15187
1
1
12757
69522
14651
1
1
17740
96132
0
1
1
7739
57796
22057
1
1
15383
88276
1896
1
1
4579
32264
7979
1
1
11679
65928
0
1
1
12877
69924
27330
1
1
16232
91108
9876
1
1
9621
54070
19908
1
1
8171
47238
17819
1
1
12128
77427
31340
1
1
8642
59805
4963
1
1
12400
60334
6632
1
1
9185
54114
18593
1
2

7862
9775
6771
3059
13211
7408
11581
14233
3352
2630
9093
12652
9559
6112
10431
12630
4578
9551
10262
9551
10143
8955
10197
11234
9320
9089
12300
11484
11215
7204
5579
11723
9353
7761
4261
9830
12386
8673
10944
9910
9928
4264
7971
8290
12669
7272...


Anonymous
Goes above and beyond expectations!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags