Colorado State University Global Springdale Shopping Survey Paper

Part 1 and 

Part 2

are separate. I’m supplying the essays turned in for part 2, so it’s just rewriting to avoid all plagiarism and supplying the excel document, should be quick.

Part 1 – 200 words.

A binomial random variable X is defined as the number of successes achieved in the n trials of a Bernoulli process. Describe an event in your life that fits the properties of a Bernoulli process, being sure to explain how each property is met by your event. Finally, state the number of trials and the number of successes for your event. Be specific. Respond with thoughtful substantive responses to at least two classmates’ postings.

Draw upon lecture material and required readings as you construct your post. Ensure that your post is well-written and formatted according to the 

CSU Global Writing Center

. Your initial post must be supported by at least one credible, scholarly source

Part 2 

Instructions

The major shopping areas in the community of Springdale include Springdale Mall, West Mall, and the downtown area on Main Street. A telephone survey has been conducted to identify strengths and weaknesses of these areas and to find out how they fit into the shopping activities of local residents. The 150 respondents were also asked to provide information about themselves and their shopping habits. The data are provided in the file 

SHOPPING

Download SHOPPING

. The variables in the survey can be found in the file 

CODING

Download CODING

.

We will concentrate on variables 18–25, which reflect how important each of eight different attributes is in the respondent’s selection of a shopping area. Each of these variables has been measured on a scale of 1 (the attribute is not very important in choosing a shopping area) to 7 (the attribute is very important in choosing a shopping area). The attributes being rated for importance are listed below. Examining the relative importance customers place on these attributes can help a manager “fine-tune” his or her shopping area to make it a more attractive place to shop.

18 Easy to return/exchange goods

19 High quality of goods

20 Low prices

21 Good variety of sizes/styles

22 Sales staff helpful/friendly

23 Convenient shopping hours

24 Clean stores and surroundings

25 A lot of bargain sales

Perform the following operations for variables 18–25:

Compute descriptive statistics for each variable along with an explanation of what the descriptive statistics tell us about the variable. This will include the mean, mode, range, standard deviation, and the five-number summary (minimum, first quartile (Q1),  median (Q2), third quartile (Q3), and maximum). Be sure to show each calculation in your spreadsheet.

Are there any data points for any of the variables that can be considered outliers? If there are any outliers in any variable, list them and state for which variable they are an outlier. Use the z-score method to determine any outliers for this question. Be sure to show each z-score calculation in your spreadsheet for each variable.

Based on the results for question 1, which attributes seem to be the most important and the least important in respondents’ choice of a shopping area? Which items from #1 did you use to decide on the least and most important attributes, and why?

Determine the correlation coefficient between variable 19 and variables 21 – 25. Provide an explanation of these relationships. Show your calculations for each correlation coefficient within the spreadsheet.

1
Critical Thinking Option #1
Springdale Shopping Survey
Cody Hollister
Colorado State University Global
MTH156: Introduction to Statistics
Professor Laura Golnabi
April 3, 2022
This study source was downloaded by 100000818358747 from CourseHero.com on 12-11-2022 20:09:24 GMT -06:00
https://www.coursehero.com/file/146792619/Mod-2-Critical-Thinkingdoc/
2
Springdale Shopping Survey
This paper will evaluate the shopping habits of 150 people in the Springdale area. A
telephone survey was conducted to evaluate the strengths and weaknesses of 3 areas within the
Springdale community. The areas of focus include the Springdale Mall, West Mall and the
downtown area. While the survey was quite extensive, in this paper I will be focusing on 8
attributes. The attributes are rated on a scale of 1 to 7, from not very important when choosing a
shopping area to very important. The attributes that will be focused on are:
18. Easy to return/exchange goods
19. High quality of goods
20. Low Prices
21. Good variety of size/styles
22. Sales staff helpful/friendly
23. Convenient shopping hours
24. Clean stores and surroundings
25. A lot of bargain sales
In this paper I will be determine if there are any outliers within this data, as well as which
attribute is the most important when choosing a shopping area. I will also determine if there is
any correlation between a store having a high quality of goods, attribute #18, and attributes 2125.
Descriptive Statistics
Descriptive Statistics is basically summarizing and organizing the data. (Illowsky & Dean,
2013) I will be finding the mean, mode, range, standard deviation, and the five-number summary, which
includes the minimum, first quartile, median, third quartile and maximum for each variable. The
minimum value for all attributes in this data is 1. The maximum for each is 7. The data shows that the
mean for the best exchange, best quality, best price, best variety, best help, best hours, cleanliness, and
best bargain are 5, 57, 5.7, 5.2, 4.9, 4.9, 4.8 and 5.2. This will tell the average response for each attribute.
This study source was downloaded by 100000818358747 from CourseHero.com on 12-11-2022 20:09:24 GMT -06:00
https://www.coursehero.com/file/146792619/Mod-2-Critical-Thinkingdoc/
3
The modes for each attribute in the same order are 7. This tells us that the most common
score for each attribute was 7, which is also the maximum. The median for the attributes is 5, 7,
7, 6, 5, 5, 5, and 6. This data shows us what was in the middle of the data for each attribute. The
first quartile for each attribute is 3, 5, 5, 4, 4, 4, 3, and 4. Using the minimum value and the first
quartile, we are able to determine what 25% of the data looks like for each attribute. The second
quartile, otherwise known as the median for each attribute are 5, 7, 7, 6, 5, 5, 5 and 6. The 3rd
quartile for each of the attributes are 7, 7, 7, 7, 7, 6, 6 and 7. Using the 2nd and 3rd quartile we can
see what the data looks like at 75%.
The range for each attribute is 6. This was found by subtracting the minimum value or 1
from the maximum value of 7. The standard deviation for each attribute is 2.02, 1.76, 1.87, 1.80,
1.94, 1.81, 1.90, 1.69. The stand deviation tells us how dispersed the data is for each. I calculated
the z-score for each data point. I did not find any outliers within the data. The correlation
between the quality of the products and the variety of products, the help, the hours, the
cleanliness and the bargains are 0.96, 0.92, 0.93, 0.91 and 0.95. Using this information, we can
see the there is a higher correlation between the quality of products and variety than there
between the quality and the other attributes. The lowest correlation is between the quality of
products and the cleanliness of the store/surroundings.
Based on the results from my analysis of the data provided in the survey, we can
conclude that the most important factor when choosing a shopping center is having a high quality
of goods. We can also see that the least important factor is the store and the surrounding areas
being clean. To determine this, I looked at the totals scores for each of the attributes. High
quality of goods had a total score of 860. You can also see from the table below that High
Quality has a higher number for all of the categories than a clean store/surrounding did.
This study source was downloaded by 100000818358747 from CourseHero.com on 12-11-2022 20:09:24 GMT -06:00
https://www.coursehero.com/file/146792619/Mod-2-Critical-Thinkingdoc/
4
High
Clean
Min
Quality
1
store/surroundings
7
1st Quartile
5
3
2nd Quartile
7
5
3rd Quartile
7
6
Max
7
7
Mean
5.7
4.8
Mode
7
7
Range
6
6
Conclusion
In this paper we used descriptive statistics to summarize and organize the data that was
provided in Module 2: Critical Thinking. (CSU Global, 2022) We used this data to determine if
there were any outliers within the survey results. According to my calculation we can see that
there were no clear outliers in the data. We also determined what the most important and least
important attribute is when choosing a shopping location. The most important is the store having
a high quality of goods and the least important was whether the store and its surrounding areas
were clean. Lastly, we determined the correlation between a store having a high quality of goods
and attributes 21-25. We can see that there is a higher correlation between high quality and good
variety, and there is a low correlation between high quality and store cleanliness.
This study source was downloaded by 100000818358747 from CourseHero.com on 12-11-2022 20:09:24 GMT -06:00
https://www.coursehero.com/file/146792619/Mod-2-Critical-Thinkingdoc/
5
References
Colorado State University Global. (2022). Module 2: Critical Thinking, Canvas.
https://portal.csuglobal.edu
Illowsky, B., & Dean, S. L. (2013). Introductory statistics. OpenStax College, Rice University
This study source was downloaded by 100000818358747 from CourseHero.com on 12-11-2022 20:09:24 GMT -06:00
https://www.coursehero.com/file/146792619/Mod-2-Critical-Thinkingdoc/
Powered by TCPDF (www.tcpdf.org)
1
Option #1: Springdale Shopping Survey
Module 2 Critical Thinking
Colorado State University- Global Campus
MTH 156-2
Matthew Riehl
This study source was downloaded by 100000818358747 from CourseHero.com on 12-11-2022 20:09:21 GMT -06:00
https://www.coursehero.com/file/102741637/Mod-2-MTH-152-Critical-Thinkingdocx/
2
Springdale Shopping Survey
Out of one hundred and fifty people in a phone survey that was taken for individuals who
resided in the Springdale community, data was collected and calculated pertaining to each
individuals strengths and weaknesses for the shopping areas. The primary reason the survey was
given was to see if the local stores in the area are providing their customers what they are
looking for during their shopping trips. Areas of focus rest on multiple different qualities that
were given in the survey including exchange, quality, price, variety, helpfulness, the stores hours
of operation, how clean the stores were, and if the stores offered the customers competitive
bargain prices. The individuals were given instructions to rate each category on a scale from 1-7.
Number one being not important and seven being what is most important. We are able to
calculate the data given from the Springdale survey to help figure out exactly what qualities of
the local stores are the least important and what qualities of the stores are most important.
Springdale Survey Statistics
With the data that has been given by the people that participated in the survey,
calculations for a five number summary can be given. Calculations for the mean, the range, the
mode, and the standard deviation can also be provided in the spreadsheet below in table 1.
This study source was downloaded by 100000818358747 from CourseHero.com on 12-11-2022 20:09:21 GMT -06:00
https://www.coursehero.com/file/102741637/Mod-2-MTH-152-Critical-Thinkingdocx/
3
The information that was provided in the variables from 18 through 25 were given to the
people participating in the survey and then rated on a scale from 1-7. The statistical data gives
different options to conclude the data. The average of the data provided is referred to as the
mean. By calculating the different variables, we can see that what is most important to shoppers
is the level of quality they experience and the prices the stores give. The data value that appears
more frequently in the dataset is referred to as the mode. The mode, as we can see based on the
150 participants of the survey, gave a higher rating to seven attributes out of the eight listed. This
tells us that those attributes are of higher importance to the customers.
The amount of variation and its measure of the data in correlation with the mean is
referred to as the standard deviation. What the standard deviation tells us by calculations is that
there no dispersion of the numbers provided between the mean and the scores that were given.
After carefully looking at each specific quality, the data displays that the high quality (19) and
low prices (20) are very important to the customers (most important). Both of these qualities had
the highest mode and mean calculation. Within the median and the Q1 (First Quartile), it
provided a score of 7 and 5. These scores were for the two qualities. For number 24, the stores
cleanliness was the lowest important quality to customers. This is due to it having the lowest
mean, Q1 (First Quartile), and the score of the median.
The Correlation of the Coefficient
What the coefficient correlation does is measure what the relationship is between two
variables in a statistical calculation. The correlation of the variable 19 to the other variables of
21-25 all have a positive relationship. Their relationships are considered to be strong when their
values are either close to -1 or +1, and the variable or number that is closer to 0 is the one that
has a weaker relationship. This means that a number with an absolute zero will have no
This study source was downloaded by 100000818358747 from CourseHero.com on 12-11-2022 20:09:21 GMT -06:00
https://www.coursehero.com/file/102741637/Mod-2-MTH-152-Critical-Thinkingdocx/
4
correlation (Anderson, Sweeney, & Williams, 2016). The variable of 21 has the strongest
relationship. The variable of 21 is Variety which generated a correlation of .96. The variables that
have the weakest relationship in their correlation is cleanliness (24), with a .91 correlation. This
can be seen in the table 2 example below.
Outliers
When we calculate the z-score, in the table 3 figure below, we are able to determine what
outliers are present. What z-scores allow us to do is take the data and standardize it. By
standardizing the data, it will give the dataset similar means and also the same standard
deviations. A z-score is used as a measurement of numerical data to the relationship of the mean.
Considerations of outliers are when any numerical data is outside of either -3 or +3. According to
the dataset and calculations, there are no outliers present.
Conclusion
The statistics that are descriptive are often utilized and used to help understand any
significant patterns in datasets. They can also be used to conclude any data so the information
can then be properly and accurately analyzed. The data that has been collected and calculated for
This study source was downloaded by 100000818358747 from CourseHero.com on 12-11-2022 20:09:21 GMT -06:00
https://www.coursehero.com/file/102741637/Mod-2-MTH-152-Critical-Thinkingdocx/
5
the Springdale survey can be used to provide accurate analysis and strong conclusions of the
customers or shoppers in what qualities and attributes and of upmost importance (highest mean
value). To make the most of their business and provide customer satisfaction, store owners
should consider implementing new ideas or strategies that increase the quality of their goods and
a more competitive and better price for their customers.
This study source was downloaded by 100000818358747 from CourseHero.com on 12-11-2022 20:09:21 GMT -06:00
https://www.coursehero.com/file/102741637/Mod-2-MTH-152-Critical-Thinkingdocx/
6
References
Anderson, D., Sweeney, D., & Williams, T. (2016). Essentials of Modern Business Statistics with
Microsoft Excel (6th Ed.). Boston, MA: Cengage Learning.
This study source was downloaded by 100000818358747 from CourseHero.com on 12-11-2022 20:09:21 GMT -06:00
https://www.coursehero.com/file/102741637/Mod-2-MTH-152-Critical-Thinkingdocx/
Powered by TCPDF (www.tcpdf.org)
1
Module 2-Springdale Shopping Survey
Colorado State University Global
MTH156-1-Introduction to Statistics
This study source was downloaded by 100000818358747 from CourseHero.com on 12-11-2022 20:09:30 GMT -06:00
https://www.coursehero.com/file/109190857/MTH156-Module-2-Springdale-Shopping-Surveydoc/
2
Module 2-Springdale Shopping Survey
For module two the class focused on chapter two in the book of Introductory of Statistics.
Some of the key terms that was gone over was box plot, first quartile, frequency, frequency
polygon, frequency polygon, frequency table, histogram, interquartile range, interval, mean,
median, midpoint, mode, outlier, paired data set, percentile, quartiles, relative frequency, skewed,
standard deviation, and variance. For this assignment we were asked to focus on the variables
from eighteen to twenty-five which could attribute to helping a manager fine-tune their shopping
area to make it a more attractive place to shop. The variable had a measurement scale of one to
seven, with one being not important and seven being very important. There were eight different
variables for this survey of one-hundred-fifty people, they were easy to return/exchange goods,
high quality of goods, low prices, good variety of sizes/styles, sales staff helpful/friendly,
convenient shopping hours, clean stores and surroundings, and a lot of bargain sales.
The first question that was asked was to compute descriptive statistics for each variable
along with an explanation of what the descriptive statistics tell us about the variable. This will
include the mean, mode, range, standard deviation, and the five-number summary (minimum,
first quartile (Q1), median (Q2), third quartile (Q3), and maximum). Be sure to show each
calculation in your spreadsheet.
This study source was downloaded by 100000818358747 from CourseHero.com on 12-11-2022 20:09:30 GMT -06:00
https://www.coursehero.com/file/109190857/MTH156-Module-2-Springdale-Shopping-Surveydoc/
3
For the second part of the first question, it was asked if there are any data points for any of the
variables that can be considered outliers? If there are any outliers in any variable, list them and
state for which variable they are an outlier. Use the z-score method to determine any outliers for
this question. Be sure to show each z-score calculation in your spreadsheet for each variable.
There are not any outliers of the data points, when looking at the z-scores for each variable they
are all positives and between the ranges of 2.2-2.95.
For the second question it was based on the results for question 1, which attributes seem to be the
most important and the least important in respondents’ choice of a shopping area? Which items
from #1 did you use to decide on the least and most important attributes, and why? Using the
items of mean, and median quarter two the attributes that are the most important are quality,
price, quality, and bargain. The attributes that are the least important using the items of mean and
median quarter two are exchange, help, hours, and cleanliness.
For the third question it was asked for us to determine the correlation coefficient between
variable 19 and variables 21 – 25. Provide an explanation of these relationships. Show your
calculations for each correlation coefficient within the spreadsheet. Correlation coefficient is a
measure of the strength of the relationship between the relative movements of two variables.
There are ranges between negative one and positive one. If the value is outside on these numbers,
then there is an error in the measurement. If the correlation is zero then there are no linear
relationships between the two variables (Fernando, 2021). When calculating the variable between
This study source was downloaded by 100000818358747 from CourseHero.com on 12-11-2022 20:09:30 GMT -06:00
https://www.coursehero.com/file/109190857/MTH156-Module-2-Springdale-Shopping-Surveydoc/
4
nineteen and variable 21-25 the values were all a strong positive relationship since there are all
close to positive one.
Conclusion
In conclusion there was a survey done on one-hundred-fifty people asking them the
importance of return/exchanging goods, high quality of goods, low prices, good variety of
sizes/styles, sales staff helpful/friendly, convenient shopping hours, clean stores and
surroundings, and a lot of bargain sales. They had to rate each item on being not very important
to being very important on a scale of one to seven. Using different items to calculate the
variables such as mean, mode, range, standard deviation, and the five-number summary
(minimum, first quartile (Q1), median (Q2), third quartile (Q3), and maximum) it was
determined that the most important item was the price, and the least important was the help they
received at the shopping mall.
This study source was downloaded by 100000818358747 from CourseHero.com on 12-11-2022 20:09:30 GMT -06:00
https://www.coursehero.com/file/109190857/MTH156-Module-2-Springdale-Shopping-Surveydoc/
5
References
Fernando, J., (2021, Aug 29). Correlation coefficient.
https://www.investopedia.com/terms/c/correlationcoefficient.asp
OpenStax. (2019). Introductory statistics. OpenStax College.
https://cnx.org/contents/MBiUQmmY@23.21:kcV4GRqc@17/Preface
This study source was downloaded by 100000818358747 from CourseHero.com on 12-11-2022 20:09:30 GMT -06:00
https://www.coursehero.com/file/109190857/MTH156-Module-2-Springdale-Shopping-Surveydoc/
Powered by TCPDF (www.tcpdf.org)
Springdale Shopping Survey*
The major shopping areas in the community of Springdale include Springdale Mall, West Mall, and the downtown
area on Main Street. A telephone survey has been conducted to identify strengths and weaknesses of these areas
and to find out how they fit into the shopping activities of local residents. The 150 respondents were also asked to
provide information about themselves and their shopping habits. The data are provided in the file SHOPPING. The
variables in the survey were as follows:
A. How Often Respondent Shops at Each Area (Variables 1–3)
1.
Springdale Mall
2.
Downtown
3.
West Mall
(1)
(2)
(3)
(4)
(5)
(6)
(1)
(2)
(3)
(4)
(5)
(6)
(1)
(2)
(3)
(4)
(5)
(6)
6 or more times/wk.
4–5 times/wk.
2–3 times/wk.
1 time/wk.
2–4 times/mo.
0–1 times/mo.
B. How Much the Respondent Spends during a Trip to Each Area (Variables 4–6)
4.
Springdale Mall
5.
Downtown
6.
West Mall
(1)
(2)
(3)
(4)
(5)
(6)
(7)
(1)
(2)
(3)
(4)
(5)
(6)
(7)
(1)
(2)
(3)
(4)
(5)
(6)
(7)
7.
Springdale Mall
8.
Downtown
9.
West Mall
(5)
(4)
(3)
(2)
(1)
(5)
(4)
(3)
(2)
(1)
(5)
(4)
(3)
(2)
(1)
$200 or more
$150–under $200
$100–under $150
$ 50–under $100
$ 25–under $50
$ 15–under $25
less than $15
C. General Attitude toward Each Shopping Area (Variables 7–9)
Like very much
Like
Neutral
Dislike
Dislike very much
D. Which Shopping Area Best Fits Each Description (Variables 10–17)
10. Easy to return/exchange goods
11. High quality of goods
12. Low prices
13. Good variety of sizes/styles
14. Sales staff helpful/friendly
15. Convenient shopping hours
16. Clean stores and surroundings
17. A lot of bargain sales
Springdale
Mall
Downtown
West
Mall
No
Opinion
(1)
(1)
(1)
(1)
(1)
(1)
(1)
(1)
(2)
(2)
(2)
(2)
(2)
(2)
(2)
(2)
(3)
(3)
(3)
(3)
(3)
(3)
(3)
(3)
(4)
(4)
(4)
(4)
(4)
(4)
(4)
(4)
E. Importance of Each Item in Respondent’s Choice of a Shopping Area (Variables 18–25)
Not
Important
18. Easy to return/exchange goods
19. High quality of goods
20. Low prices
21. Good variety of sizes/styles
22. Sales staff helpful/friendly
23. Convenient shopping hours
24. Clean stores and surroundings
25. A lot of bargain sales
(1)
(1)
(1)
(1)
(1)
(1)
(1)
(1)
(2)
(2)
(2)
(2)
(2)
(2)
(2)
(2)
Very
Important
(3)
(3)
(3)
(3)
(3)
(3)
(3)
(3)
(4)
(4)
(4)
(4)
(4)
(4)
(4)
(4)
(5)
(5)
(5)
(5)
(5)
(5)
(5)
(5)
(6)
(6)
(6)
(6)
(6)
(6)
(6)
(6)
(7)
(7)
(7)
(7)
(7)
(7)
(7)
(7)
F. Information aboutt the Respondent (Variables 26–30)
26. Gender: (1) = Male
(2) = Female
27. Number of years of school completed:
(1) = less than 8 years
(3) = 12–under 16 years
(2) = 8–under 12 years
(4) = 16 years or more
28. Marital status: (1) = Married (2) = Single or other
29. Number of people in household:
persons
30. Age:
years
Each respondent in this database is described by 30 variables. As an example of their interpretation, consider row number 1.
This corresponds to respondent number 1 and contains the following information.
Variable number 6 = 7. The
respondent usually spends less
than $15 when she
shops at West Mall.
Variable number 26 = 2. The
respondent is a female.
5556774441131111167765667232421
Variable number 1 = 5.
The respondent shops at Springdale Mall 2–4 times/month.
Variable number 19 = 7.
Respondent believes “high quality
of goods” is very important in
choosing a shopping area.
*Source: Materials for this case have been provided courtesy of The Archimedes Group, Indiana, PA. Data are based on actual responses
obtained to this subset of the questions included in the survey; town and mall identities have been disguised as well as a number of
responses were updated.
A
B
C
D
E
F
SPRIFREQ DOWNFREQ WESTFREQ SPRSPEND DOWSPEND WESSPEND
5
5
5
6
7
7
3
4
6
6
6
7
7
4
6
5
6
7
7
7
5
6
4
6
5
7
7
6
4
6
3
6
7
6
7
5
5
4
7
6
7
8
5
4
5
6
7
7
9
4
5
4
5
7
7
10
3
5
2
4
5
7
11
5
6
6
7
7
7
12
6
4
6
7
6
7
13
5
4
5
7
7
7
14
6
3
5
6
6
7
15
4
6
5
6
7
7
16
4
5
2
5
6
7
17
6
4
6
7
7
7
18
6
5
6
7
7
7
19
6
4
5
7
7
7
20
6
5
6
6
6
7
21
3
5
6
6
7
7
22
5
4
5
7
7
7
23
5
6
5
5
7
7
24
5
5
5
6
7
7
25
6
4
3
7
6
7
26
5
4
6
5
7
6
27
6
5
5
7
7
7
28
5
6
6
4
7
7
29
3
6
5
6
6
7
30
5
3
2
5
7
6
31
6
4
5
6
7
7
32
6
5
6
6
7
7
33
6
4
4
6
7
7
34
6
3
4
7
7
7
35
6
5
5
6
7
7
36
4
5
6
7
7
7
37
5
4
5
7
6
7
38
2
6
4
4
7
5
39
3
4
5
7
6
7
40
3
6
5
5
7
5
41
6
6
5
6
6
7
1
2
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
A
B
C
D
E
F
4
4
6
4
5
5
5
3
3
2
4
4
5
5
3
3
3
1
2
5
6
3
2
6
4
3
5
1
2
2
2
3
4
4
1
5
1
6
1
1
3
6
4
3
6
6
2
2
6
2
6
1
6
4
3
4
5
3
2
5
2
2
4
6
5
5
5
2
5
2
4
3
4
4
1
6
4
2
4
2
4
2
4
4
6
5
6
3
5
5
3
3
2
3
1
3
5
6
6
3
1
1
6
1
4
6
3
1
5
6
3
3
2
5
4
2
2
5
6
3
4
3
6
5
6
7
5
6
6
6
6
2
2
5
2
7
3
4
4
6
1
2
7
6
7
4
7
2
4
6
5
6
2
4
5
7
2
5
1
5
5
2
1
6
7
6
5
5
6
7
6
7
4
7
1
7
3
6
2
3
3
3
2
1
2
7
1
1
6
5
6
1
5
2
4
3
7
1
1
1
2
3
7
5
1
3
3
7
6
7
4
6
7
6
7
4
6
2
3
2
1
1
6
2
2
5
1
6
2
2
7
6
2
4
1
3
7
2
5
7
6
4
2
5
2
4
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
A
B
C
D
E
F
1
5
1
2
4
3
4
2
3
6
5
1
2
5
2
2
6
6
6
2
2
5
5
6
6
4
5
3
3
2
3
4
5
5
6
3
5
4
5
3
3
6
2
2
1
1
5
1
3
2
3
6
6
2
5
1
3
6
5
4
1
5
4
1
6
6
6
5
5
6
4
5
4
5
3
5
5
4
4
3
4
6
4
3
6
4
2
5
2
4
1
6
6
3
2
5
1
3
6
6
6
4
5
5
5
6
6
5
6
4
4
3
4
4
5
4
6
6
6
5
3
6
5
4
1
6
2
5
6
4
5
2
1
7
5
7
2
3
2
7
4
5
4
7
5
3
4
6
5
7
7
7
5
7
7
7
6
6
7
4
4
6
5
6
1
3
1
6
3
7
2
4
3
1
5
4
3
7
3
1
7
6
6
7
6
5
7
5
6
7
7
7
7
6
7
6
6
7
7
7
5
5
7
5
6
6
3
7
1
2
5
2
4
7
4
6
6
6
3
4
6
7
5
5
6
5
5
4
6
6
6
7
7
5
5
7
7
7
7
7
7
7
5
7
7
7
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
A
B
C
D
E
F
1
4
4
5
5
5
4
5
3
5
5
2
5
5
5
5
4
1
5
6
2
5
4
6
3
3
6
6
6
5
6
6
5
3
5
5
4
3
6
6
4
5
6
3
5
5
1
5
4
3
3
5
6
4
6
1
6
6
5
6
2
5
3
1
4
6
4
5
3
3
4
6
3
1
2
5
5
4
5
5
4
4
6
4
6
4
5
5
7
4
5
6
7
7
6
5
4
6
7
7
7
4
5
6
7
5
7
7
6
7
4
7
7
6
7
5
7
4
5
7
7
7
6
7
7
7
7
7
6
6
4
7
7
5
7
7
6
6
5
6
7
7
6
6
7
6
5
7
7
7
7
5
6
6
5
7
7
6
4
6
6
7
7
7
6
7
4
5
G
H
I
J
K
L
M
SPRILIKE DOWNLIKE WESTLIKE BSTEXCHG BSTQUALI BSTPRICE BSTVARIE
4
4
4
1
1
3
1
3
5
4
3
1
1
3
1
4
5
3
4
3
4
4
1
5
2
4
3
4
2
4
1
6
3
3
3
1
1
1
1
7
5
5
3
1
1
3
1
8
4
2
4
1
1
3
1
9
4
3
3
2
2
3
1
10
5
4
4
3
2
3
1
11
4
4
3
1
1
1
1
12
3
3
3
4
4
3
1
13
3
4
3
1
2
3
1
14
3
4
3
4
1
3
2
15
3
2
3
4
1
4
1
16
4
3
4
1
1
3
3
17
4
3
2
1
1
1
1
18
4
4
4
4
1
3
1
19
4
4
3
3
1
3
1
20
4
4
3
1
2
3
1
21
4
3
1
1
1
2
1
22
4
3
2
1
4
4
1
23
4
3
3
4
1
2
1
24
5
3
4
1
1
3
1
25
2
5
4
2
2
2
1
26
4
3
2
1
1
3
1
27
4
4
4
1
1
2
1
28
4
3
3
1
1
3
1
29
4
4
4
1
1
3
1
30
4
4
5
1
1
1
1
31
3
5
3
4
2
3
1
32
4
4
3
1
1
1
1
33
4
4
4
4
2
3
1
34
5
3
3
1
1
3
1
35
3
3
2
1
1
3
1
36
4
4
3
4
1
1
1
37
4
5
4
2
2
2
2
38
5
3
4
1
1
3
1
39
4
3
3
1
2
3
1
40
3
2
1
1
1
4
1
41
4
4
4
3
2
3
1
1
2
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
G
H
I
J
K
L
M
4
5
3
4
4
4
4
5
3
4
4
4
4
2
1
5
1
3
1
3
2
4
3
4
5
5
3
3
2
4
1
3
2
2
5
1
4
5
3
4
5
3
5
5
2
3
4
4
1
2
3
3
1
5
4
4
5
4
5
2
5
2
5
3
4
1
1
3
2
4
1
5
3
5
2
1
5
1
4
3
1
5
4
5
3
4
3
4
3
4
3
5
5
4
1
1
5
4
5
3
3
2
5
4
1
5
5
3
3
4
5
5
5
5
4
3
1
2
4
1
5
2
3
1
1
2
1
2
3
4
4
2
2
4
4
1
1
4
1
1
1
2
3
1
2
2
1
2
4
1
1
2
3
3
1
1
2
3
1
1
3
4
1
4
1
1
2
1
2
1
2
1
3
4
4
4
1
1
3
4
1
4
3
4
3
1
3
2
3
1
4
2
4
1
3
3
3
3
1
2
4
1
1
4
4
3
3
2
3
3
3
4
4
1
1
2
2
2
2
1
3
1
4
2
3
3
3
4
3
3
3
1
1
3
4
3
3
3
1
1
1
4
2
4
2
4
1
1
2
2
2
1
4
1
2
2
1
4
3
4
3
3
2
3
1
4
3
1
1
4
1
1
3
4
1
1
4
4
3
2
4
1
3
3
4
2
3
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
G
H
I
J
K
L
M
4
4
5
5
2
3
1
3
4
2
2
2
4
5
3
4
5
4
5
5
5
4
4
4
4
4
4
5
4
5
4
5
4
5
5
5
5
4
4
4
4
5
3
4
2
4
1
5
2
2
4
3
1
3
4
1
4
4
3
4
3
3
4
3
4
4
2
3
3
3
3
3
4
5
3
4
4
4
4
4
5
3
1
4
5
1
4
4
4
5
1
2
2
4
4
4
1
3
3
3
4
3
3
4
5
4
5
3
1
4
4
1
4
4
3
4
2
2
3
3
2
1
1
2
3
3
4
3
4
4
1
1
2
4
3
3
4
4
2
1
2
3
2
2
4
2
2
1
1
4
4
4
1
1
1
1
3
4
1
1
1
1
1
1
4
1
2
2
4
2
4
1
4
2
4
2
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
2
2
1
1
1
2
1
1
2
1
4
3
4
3
2
3
3
1
3
4
1
1
1
3
2
1
3
3
3
3
3
3
2
3
3
1
3
3
3
3
1
3
3
1
2
2
3
3
1
3
3
4
4
4
2
1
1
2
4
2
3
3
3
1
2
4
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
1
1
1
1
1
1
1
1
2
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
G
H
I
J
K
L
M
4
3
5
4
3
4
4
3
3
5
5
5
5
5
4
3
4
4
4
5
5
5
5
1
4
5
5
3
4
3
2
3
4
3
4
4
3
5
4
3
1
3
3
5
4
3
5
4
4
5
4
5
3
3
2
5
1
3
4
3
5
3
4
4
3
2
5
3
4
4
5
3
2
2
4
4
4
5
2
1
4
4
3
3
1
1
1
4
4
4
3
3
1
2
1
1
3
3
3
2
1
4
3
4
1
1
1
2
1
1
4
2
1
1
1
2
4
2
4
1
4
2
2
1
1
1
2
1
1
2
3
1
1
1
1
2
2
2
1
2
3
1
3
3
3
3
3
1
4
2
2
3
3
3
3
2
3
3
3
3
3
3
3
3
1
1
4
3
1
1
1
1
4
1
1
1
1
1
1
1
1
1
1
2
1
2
1
1
1
1
1
2
1
1
1
2
N
O
P
Q
R
S
T
BSTHELP BSTHOURS BSTCLEAN BSTBARGN IMPEXCH IMPQUALI IMPPRICE
1
1
1
1
6
7
7
3
2
3
1
3
7
7
7
4
1
4
1
1
7
7
7
5
4
1
1
4
6
7
7
6
1
1
1
2
7
7
7
7
1
1
1
3
3
7
7
8
2
1
1
3
4
6
7
9
4
1
1
3
7
7
7
10
1
1
4
1
7
5
5
11
1
1
1
1
7
7
7
12
2
4
4
3
5
7
7
13
1
1
1
3
5
6
6
14
4
1
1
1
7
7
7
15
4
1
1
2
7
7
7
16
1
3
1
3
7
7
7
17
2
1
1
4
1
4
4
18
4
4
1
3
2
7
7
19
3
3
1
3
7
7
7
20
2
2
1
2
7
7
7
21
1
1
1
2
1
1
1
22
4
1
1
4
3
4
5
23
4
1
1
2
6
6
6
24
1
1
1
1
5
6
7
25
2
1
1
2
5
6
1
26
1
1
1
4
5
7
7
27
2
1
1
1
1
1
1
28
1
1
1
1
7
7
7
29
2
1
1
1
7
6
7
30
4
1
1
3
4
7
7
31
2
1
4
4
5
7
7
32
1
1
1
2
5
7
7
33
4
4
3
3
3
7
7
34
4
1
1
1
7
7
7
35
2
1
1
2
5
7
7
36
2
2
1
2
1
1
7
37
2
2
1
2
6
7
7
38
1
1
1
1
7
7
7
39
1
3
1
1
6
6
7
40
4
1
1
1
7
7
7
41
4
3
2
4
7
7
7
1
2
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
N
O
P
Q
R
S
T
4
1
2
1
2
2
4
4
4
1
3
2
1
3
1
4
2
1
1
4
1
2
3
1
3
1
3
4
1
2
1
3
3
2
1
2
1
2
3
3
2
1
1
2
1
1
1
1
1
4
3
3
2
3
3
4
2
2
3
2
4
2
1
1
3
1
1
1
1
2
4
1
1
4
4
3
2
4
2
3
3
2
1
1
2
1
1
1
4
1
4
4
2
1
2
3
3
1
4
1
2
3
3
3
1
1
2
3
3
3
1
3
4
2
1
4
3
1
3
3
2
4
3
3
3
2
1
3
2
4
1
3
3
1
4
2
3
4
2
3
3
1
1
3
3
4
1
2
1
1
4
4
2
4
3
1
2
1
3
2
4
1
2
1
4
7
3
6
7
5
1
6
3
3
6
4
7
7
7
5
6
3
7
3
4
1
4
1
7
6
1
2
7
2
3
2
6
5
3
1
4
3
1
7
2
7
7
7
5
6
7
7
7
2
6
3
6
5
3
6
7
5
4
6
7
5
6
3
3
7
3
6
2
5
1
1
7
4
7
4
6
2
3
4
5
4
7
7
7
7
7
7
7
7
1
2
1
2
5
3
7
7
4
7
4
1
4
6
1
4
7
4
7
2
7
7
4
2
7
4
2
6
5
2
3
4
7
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
N
O
P
Q
R
S
T
4
4
3
2
2
4
4
4
3
4
4
2
1
2
1
4
1
1
1
1
2
1
2
1
1
1
1
4
3
1
4
2
2
2
1
2
2
1
1
2
1
2
1
3
4
2
1
1
4
1
3
4
2
3
4
2
2
1
1
1
1
1
1
1
1
1
1
1
1
4
1
1
1
1
1
1
1
3
1
1
1
4
1
1
2
2
3
4
4
3
4
4
3
1
4
3
1
2
3
1
1
4
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
1
4
3
4
4
1
4
1
4
4
3
4
4
2
4
3
2
1
3
3
2
3
3
1
3
1
1
3
4
4
4
1
1
2
1
2
3
1
3
1
1
2
5
4
4
5
5
6
1
4
6
5
1
6
4
4
7
6
7
6
4
5
6
2
5
3
5
7
3
5
5
7
7
7
6
5
4
7
7
7
7
4
7
5
4
6
7
2
6
6
1
5
6
7
5
6
1
6
4
6
6
7
3
7
7
7
7
5
7
7
6
7
7
5
7
7
7
7
7
7
7
7
7
6
5
6
1
7
6
2
5
6
2
5
4
6
4
5
6
2
7
6
6
4
5
6
7
7
6
7
7
7
7
4
7
7
7
7
7
5
7
7
6
6
7
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
N
O
P
Q
R
S
T
1
1
1
4
4
1
4
1
4
2
1
1
3
3
3
1
1
1
1
1
1
1
1
2
4
1
3
2
1
1
3
4
4
1
3
4
1
1
3
1
1
3
3
1
1
3
2
1
1
1
1
3
1
1
1
3
1
1
1
4
1
1
1
1
4
1
1
1
1
1
3
1
1
1
1
1
1
1
1
2
4
1
1
2
3
1
1
1
3
2
3
1
1
2
2
3
1
3
3
2
3
3
2
3
1
1
2
3
1
1
3
3
7
6
7
7
1
1
7
7
5
6
7
7
6
2
7
3
7
2
7
6
7
7
5
7
7
3
3
7
7
7
7
7
4
1
5
7
3
7
7
7
6
6
6
5
6
7
7
7
7
7
7
7
7
4
7
7
3
7
7
7
5
7
7
7
4
7
7
5
7
7
7
6
7
7
7
7
7
4
7
7
7
5
7
4
U
V
W
X
Y
Z
AA
IMPVARIE IMPHELP IMPHOURS IMPCLEAN IMPBARGN RESPGEND RESPEDUC
6
5
6
6
7
2
3
3
7
7
7
7
6
2
3
4
5
4
5
3
7
1
3
5
6
6
5
6
7
2
3
6
7
7
7
7
7
2
3
7
6
5
6
5
6
2
3
8
5
3
6
4
5
2
1
9
6
7
7
7
7
2
3
10
7
6
7
7
6
1
4
11
7
7
7
7
7
2
4
12
5
5
4
4
5
2
3
13
5
5
6
6
7
2
1
14
6
4
4
6
5
2
3
15
7
7
7
5
6
2
3
16
6
4
6
3
6
1
3
17
6
2
3
4
1
1
3
18
6
4
3
3
6
2
4
19
7
4
4
3
6
2
3
20
7
5
6
6
5
2
3
21
1
1
1
1
1
2
3
22
4
6
4
4
5
1
4
23
6
5
7
6
7
1
4
24
7
2
5
3
6
2
3
25
1
6
1
6
5
1
3
26
6
6
5
6
7
2
3
27
2
3
2
4
3
1
3
28
5
5
4
7
4
1
3
29
6
6
6
5
6
1
3
30
5
5
7
7
7
1
3
31
6
4
2
3
5
2
3
32
5
5
4
4
5
1
3
33
6
7
6
6
6
2
3
34
7
7
7
5
7
2
3
35
7
6
5
5
6
2
3
36
7
6
7
2
7
2
3
37
6
6
3
5
6
1
3
38
7
7
7
7
4
2
3
39
3
5
5
7
4
1
4
40
7
4
7
7
7
2
4
41
7
4
7
7
7
2
2
1
2
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
U
V
W
X
Y
Z
AA
5
5
3
6
6
6
5
6
7
6
1
7
7
7
6
6
4
4
3
4
5
2
7
3
3
7
5
2
3
7
7
4
4
7
5
1
2
5
1
7
2
4
3
1
4
7
5
3
6
7
7
4
1
1
5
1
7
7
2
7
7
3
3
7
7
3
5
3
6
7
7
2
1
5
3
3
5
5
1
3
5
7
6
5
2
6
6
7
3
5
5
4
5
4
3
2
7
4
5
3
4
6
3
3
4
3
5
5
3
4
4
7
7
6
5
6
1
1
1
4
3
6
1
4
5
3
5
7
6
3
7
7
2
5
2
6
4
7
4
2
2
1
5
4
2
6
3
3
4
1
4
1
7
2
2
1
1
4
6
2
3
7
2
2
7
4
7
5
5
7
5
7
6
2
5
3
6
5
5
7
2
5
5
4
6
6
2
7
3
3
1
2
7
7
7
7
2
7
5
3
7
4
3
4
2
2
2
1
2
1
2
1
2
1
2
2
2
1
1
2
1
2
2
2
2
1
1
2
2
1
1
1
2
1
1
1
1
2
2
1
1
2
2
2
1
1
2
4
4
3
3
4
4
2
2
1
2
3
4
2
2
2
4
2
2
4
1
4
1
4
4
4
1
4
1
4
2
1
3
2
3
4
1
2
1
1
2
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
U
V
W
X
Y
Z
AA
3
7
2
2
3
4
1
3
5
3
7
2
7
7
3
1
7
7
7
3
7
7
6
6
5
5
6
4
6
4
5
7
6
7
4
7
4
7
5
7
7
4
7
1
4
4
7
1
1
4
6
6
2
4
3
7
1
7
6
6
1
6
5
4
2
3
6
7
4
7
7
6
7
6
7
3
6
1
6
7
5
7
4
3
2
3
7
5
2
2
2
4
2
2
5
4
3
6
7
6
6
1
6
3
6
5
4
6
5
7
5
6
6
7
6
5
6
7
7
7
6
7
6
2
3
7
4
3
7
6
6
3
4
4
6
1
4
2
2
6
6
7
1
6
6
5
5
5
7
6
6
5
7
6
7
6
5
4
7
2
7
7
6
5
3
2
3
1
5
2
4
6
6
6
4
6
4
5
7
1
7
6
6
4
6
6
7
5
7
5
6
7
6
1
6
5
6
4
6
5
7
4
7
6
6
2
1
1
2
1
1
1
1
1
1
2
2
2
2
1
1
1
2
2
2
2
2
2
2
2
2
1
1
1
1
1
2
1
2
1
1
1
2
2
2
1
2
2
1
3
4
3
1
3
2
3
4
4
3
2
3
2
1
2
2
3
2
2
3
2
2
2
2
4
3
4
3
2
3
3
3
4
2
4
2
3
4
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
U
V
W
X
Y
Z
AA
7
6
7
7
3
6
7
7
4
5
6
6
5
5
5
3
5
6
5
6
6
7
5
1
7
5
7
5
7
4
7
7
5
6
7
7
5
7
5
6
5
4
6
3
4
1
5
6
7
7
5
1
7
4
6
7
7
6
6
7
5
3
4
6
7
1
7
6
6
3
6
7
5
4
5
6
7
7
6
1
6
4
7
6
7
4
7
7
3
6
7
6
7
4
7
6
4
5
5
7
4
1
5
3
7
7
5
7
6
6
2
4
5
7
7
7
5
4
6
6
4
5
7
6
4
6
7
6
6
2
7
5
6
4
7
7
5
5
7
3
1
2
2
2
1
1
2
1
2
2
2
2
2
2
1
1
2
2
2
2
1
2
2
2
2
1
1
2
4
4
1
4
4
4
2
4
3
3
4
2
3
3
2
3
3
3
3
3
2
4
2
4
4
2
3
2
AB
AC
AD
RESPMARI RESPHOUS RESPAGE
2
4
21
3
2
5
21
4
2
5
18
5
2
7
20
6
2
4
19
7
2
2
19
8
2
4
19
9
2
1
20
10
2
2
44
11
2
3
29
12
2
4
20
13
2
6
17
14
2
5
19
15
2
4
20
16
2
4
21
17
1
1
20
18
2
1
23
19
2
5
18
20
2
4
20
21
2
6
17
22
1
1
24
23
2
2
21
24
2
3
19
25
2
1
18
26
2
1
20
27
2
4
19
28
2
2
21
29
2
4
19
30
2
5
21
31
2
4
20
32
2
3
19
33
2
5
21
34
2
3
19
35
2
4
19
36
2
8
18
37
2
3
28
38
1
3
41
39
1
4
37
40
1
2
24
41
1
7
49
1
2
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
AB
AC
AD
1
1
2
1
1
1
1
2
1
1
2
2
1
2
2
1
2
1
2
2
1
2
2
2
1
1
2
1
1
1
2
1
1
1
2
1
1
1
2
2
2
3
2
1
6
3
3
4
1
4
6
1
5
1
7
5
5
6
5
4
3
6
7
7
1
1
3
6
1
2
5
6
2
7
6
1
4
7
2
7
2
5
37
24
22
40
46
32
36
70
21
46
40
66
49
80
38
32
68
64
18
35
66
20
52
27
46
30
25
36
28
64
38
69
44
28
69
55
45
27
66
38
45
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
AB
AC
AD
1
1
1
1
1
2
1
1
2
1
1
2
2
2
1
2
1
1
2
2
1
2
1
2
2
1
2
1
2
2
2
1
2
1
2
1
2
2
1
2
2
3
3
3
4
7
4
2
7
7
3
1
6
4
6
2
7
3
2
3
2
4
2
4
1
1
4
1
3
3
1
1
2
1
4
6
6
3
1
7
5
3
61
38
35
34
59
43
55
41
75
18
66
42
70
24
62
69
35
24
31
26
27
18
29
66
20
27
22
25
19
21
65
66
24
32
20
59
27
27
42
21
28
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
AB
AC
AD
2
2
1
2
1
2
1
1
1
1
1
2
2
2
1
1
1
2
1
2
1
2
1
1
1
1
1
1
1
1
2
1
2
1
5
4
5
2
4
4
1
4
5
4
4
1
6
2
2
1
3
7
3
6
3
6
28
26
36
53
61
25
31
50
35
70
22
25
21
23
39
33
37
18
33
21
65
22
31
53
36
57
33
44