{br} STUCK with your assignment? {br} When is it due? {br} Get FREE assistance. Page Title: {title}{br} Page URL: {url}
UK: +44 748 007-0908, USA: +1 917 810-5386 [email protected]
Select Page
1. QUESTION

Make it 3 pages, 3 charts and 3 sources
The assignment is both and excel sheet and a 2 page essay

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. The variables in the survey can be found in the file 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
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 5-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, please 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. Please provide an explanation of the relationships. Show your calculations for each correlation coefficient within the spreadsheet.
Write a report. Items that should be included, at a minimum, are a title page, an introduction, a body which answers the questions posed in the problem, and a conclusion paragraph that addresses your findings and what you have determined from the data and your analysis. As with all written assignments, you should have in-text citations and a reference page. Please include any tables of calculations, calculated values, and graphs associated with this problem in the body of your assignment response.
Note: You must submit your Excel file with your report. This will aid in grading with partial credit if errors are found in the report.

Subject Pages Style Essay Writing 9 APA

Shopping Data Analytics

There are various factors that influence individual and communal shopping behaviors. Both internet and in-store shopping attitudes are influenced by certain attributes, as argued out by Hsin Chang and Wang (2011). Therefore, it necessitates that management of stores ascertain the influencing factors for shoppers in their market scope. Such kind of assessment is a leverage in the increasingly competitive environment (Berry, et al., 2010). 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 study is intended to find out the customers’ rating of certain influential shopping attributes, a phenomenon that can aid managerial strategies in improving sales.

Descriptive Statistics

1. Easy to return/exchange goods

The mean of customer’s rating for importance of this attribute is 4.97 (SD = 2.00). This means that customers generally rate this attribute of shopping as moderately important (5). The mode was 7 (highest number of customers rated the attribute as very important among their shopping influences) and the Median was 5. With the moderate negative sleekness (-0.68), it is evident that a majority of the shoppers included in the dataset rated the attribute above the median.

Fig 1: Bar graph for “Easy to return/exchange goods”

1. High quality of goods

The mean of customer’s rating for importance of this attribute is 5.51 (SD = 2.03). This means that customers generally rate this attribute of shopping as important (6). The mode was 7 (highest number of customers rated the attribute as very important among their shopping influences) and the Median was 7. The data is highly skewed to the left (-1.13), evidencing that a majority of the shoppers included in the dataset rated the attribute above the median.

1. Low prices

The mean of customer’s rating for importance of this attribute is 5.65 (SD = 1.86). This means that customers generally rate this attribute of shopping as important (6). The mode was 7 (highest number of customers rated the attribute as very important among their shopping influences) and the Median was 7. The data is highly skewed to the left (-1.25), pointing out that a majority of the shoppers included in the dataset rated the attribute above the median (54% of the respondents rated the attribute as very important).

Fig 2: Bar graph for “Low prices” frequencies.

1. Good Variety of Sizes/Styles

The mean of customer’s rating for importance of this attribute is 5.26 (SD = 1.72). This means that customers generally rate this attribute of shopping as moderately important (5). The mode was 7 (highest number of customers rated the attribute as very important among their shopping influences) and the Median was 6. The data is highly skewed to the left (-1.04), it is evident that a majority of the shoppers included in the dataset rated the attribute above 6 (with a total of 52% of the respondents rating the attribute as important and very important).

The mean of customer’s rating for importance of this attribute is 4.87 (SD = 1.80). This means that customers generally rate this attribute of shopping as moderately important (5). The mode was 7 (highest number of customers rated the attribute as very important among their shopping influences) and the Median was 5. The data is moderately skewed to the left (-0.55), indicating that a majority of the shoppers included in the dataset rated the attribute above the median (a total of 60.67% of the participant customers rates the attribute of helpful/friendly staff as between moderately important to very important).

1. Convenient Shopping Hours

The mean of customer’s rating for importance of this attribute is 4.92 (SD = 1.92). This means that customers generally rate this attribute of shopping as moderately important (5). The mode was 6 (highest number of customers rated the attribute as important) and the Median was 6. The data is moderately skewed to the left (-0.74), indicating that a majority of the shoppers included in the dataset rated the attribute above the median (a total of 51% of the participant customers rates the attribute as between important to very important).

1. Clean Stores and Surroundings

The mean of customer’s rating for importance of this attribute is 4.68 (SD = 1.94). This means that customers generally rate this attribute of shopping as moderately important (5). The mode was 6 and 7 (highest number of customers rated the attribute as important and very important) and the Median was 5. There is a weak negative skewness for customers attributing cleanliness of the stores and surrounding as important (-0.48), indicating that not as much customers rated this attribute above the median of important as those that rated it below it.

Fig 2: Bar graph for “Clean Stores and Surroundings” frequencies.

1. A lot of bargain sales

The mean of customer’s rating for importance of this attribute is 5.25 (SD = 1.68). This means that customers generally rate this attribute of shopping as moderately important (5). The mode was 6 (highest number of customers rated the attribute as important) and the Median was 6. There is a negative skewness for customers attributing bargain sales as important (-1.02), indicating that a majority of the shoppers rated this attribute above its median (moderately important).

Outliers

There is no outlier in the dataset. The variables of concern do not have any outlier entry recorded.

 Quartile IMPEXCH IMPQUALI IMPPRICE IMPVARIE IMPHELP IMPHOURS IMPCLEAN IMPBARGN Lower Quartile 3.25 4 5 5 4 4 3 4 Upper Quartile 7 7 7 7 6 6 6 7

The quartiles for the specific variables are reported in the table below

Table 1: Table for variable quartiles (First and Third Quartiles)

The attribute that seems to be the most important in respondents’ choice of a shopping area is “Low prices”. While the least important seems to be “Clean stores and surroundings”.

The mean, quartiles, frequency distribution and skewness of the data were used to determine respondents’ rating of importance in deciding the least and most important attributes in their view. The “Low prices” attribute had the highest mean, lower quartile of 5 and upper quartile of 7, a strong negative skewness and it also posted the highest proportion of respondents (54%) who rated it as very important. Relatively contrariwise can be reported of the “Clean stores and surroundings” attribute generally.

Correlation

 IMPQUALI IMPVARIE IMPHELP IMPHOURS IMPCLEAN IMPBARGN IMPQUALI 1 IMPVARIE 0.3777034 1 IMPHELP 0.2130774 0.2777826 1 IMPHOURS 0.2661119 0.3921029 0.388927 1 IMPCLEAN 0.4383898 0.2837171 0.331478 0.2698217 1 IMPBARGN 0.2956454 0.299904 0.163589 0.191478 0.2535452 1

Table 2: Correlation table

There is a moderate positive correlation between “High quality of goods” and “Good variety of sizes/styles” attributes (0.4). This indicates that as shopper’s influence by “High quality of goods”, the influence by “Good variety of sizes/styles” also increases.

Further, the correlation between “High quality of goods” and “Sales staff helpful/friendly” is 0.2. This indicates that there is a weak positive linear relationship between the attributes – as one increases in influence of shopping, so does the other in a considerable degree.

The correlation coefficient between “High quality of goods” and “Convenient shopping hours” is 0.3. This is a moderate positive linear association. Therefore, as one the influence of one attribute increases, so does the other’s in the case of shopping.

There is a moderately strong positive correlation between “High quality of goods” and “Clean stores and surroundings” (0.4). The kind of linear relationship between the attributes point out that a customer who is influenced to shopping by high quality of goods is also likely to be influenced by the cleanliness of the environment of the shop from which they are to obtain the goods.

The degree of linear association between “High quality of goods” and “A lot of bargain sales” attributes is 0.3, indicating a moderate positive linear correlation between the two attributes. This means that a shopper who is appealed by high quality of goods will also most likely like that a bargaining space be attached to the good in the shopping process. Both attributes moderately influence an individual’s shopping characters positively.

The linear relationship between “High quality of goods” and other attributes indicate that a shopper would be more influenced to shop in a store when the attributes are collectively impressing their impression. This is consistent with previous research expeditions on customer shopping attitude and behaviors that indicate that the attributes enhance each other (Kacen, Hess, & Walker, 2012).

Conclusion

The highlighted attributes were rated as important by the participant shoppers in the survey. Further, the attributes indicated a likelihood of collective influence on shopping on the progressive phase – this is based on the correlation between “High quality of goods” and the other attributes examined. The positive linear relationship indicate that a collective influence of the attributes on shopping is highly probable, and can be plausibly argued to enhance shopping. Therefore, a strategy that is inclusive of all the strategies examined in this report has high odds of enhancing shopping in the stores. Nevertheless, the nature of these association are subject to more conclusive assessments as correlation coefficient alone is not sufficient for explaining the relationships.

### References

 Berry, L. L., Bolton, R. N., Bridges, C. H., Meyer, J., Parasuraman, A., & Seiders, K. (2010). Opportunities for innovation in the delivery of interactive retail services. Journal of Interactive Marketing, 24(2), 155-167. Hsin Chang, H., & Wang, H. W. (2011). The moderating effect of customer perceived value on online shopping behaviour. Online Information Review, 35(3), 333-359. Kacen, J. J., Hess, J. D., & Walker, D. (2012). Spontaneous selection: The influence of product and retailing factors on consumer impulse purchases. Journal of Retailing and Consumer Services, 19(6), 578-588.