User Account

All Pages

esk jewellery, Basic Statistics

Assignment Help:
You are working for the management of ESK Jewellery as a marketing consultant. The main business of ESK Jewellery is the retailing of diamond jewellery. They opened their first shop on the 1st June 2011. Since then, they have opened ten (10) shops across the city in the locations of the city central district, town centres and housing estates. Most of their shops are located in shopping malls, whereas some of their shops are located in neighbourhood centres. (Neighbourhood centres are the blocks typically located in the centre of the housing estates. Shops can only occupy the ground floors of these blocks.) Although a few members of ESK Jewellery management have good understanding on statistical models and methods, most of the members only have very basic understanding of statistics. It is quite likely that they only know what "mean" means. ESK Jewellery management would like you to study their sales patterns. They are particularly interested in identifying what variables drive "sales value" (i.e. revenue per sale or average price per sale). A market research paper, recently purchased by the management, identified ''caratage'' and ''location'' as two of the variables (reported as factors) affecting the price. Caratage refers to the size of the diamonds measured in carats. According to the market research paper, the caratage per sale figure was found to be higher in the city shops. Also, the items purchased in the city shops were comparatively more expensive. ESK Jewellery would like to check if this is true in the local market. Your past studies on similar businesses, like watch and cosmetic distribution, indicated that the size of the shop and the wealth of the area influenced purchases. Shop size data were readily available. However, the data for the wealth of the area were not. The average housing rental data were available. Therefore, the rental data of the area have been used in the past studies as a proxy for the wealth. You informed ESK Jewellery that they needed to collect data on price per sale, locations and the sizes of the shops, ''caratage'' and the average housing rental of the area that each shop locates. ESK Jewellery randomly selected 1000 transactions from their 10 shops.

Part I

1. Organise and present the data by using appropriately chosen charts. Explain why you have chosen the charts you used.

2. Calculate and interpret the measures of location and dispersion for the data. Are all the variables equally suited for being described by the mean and standard deviation? Explain.

3. Compute the probability that the mean caratage is at most 0.23. Compute the probability of a random transaction with a diamond of at most 0.23 carats. What is the difference between the two probabilities you have computed?

Part II

Use a suitable hypothesis-testing approach to analyse the sales patterns. You must do the followings:

1. First, state your hypothesis. Then, explain which test(s) you will use to test your hypothesis.

2. Identify and fit a suitable linear regression model to the data.

3. Interpret the relevant statistics from the output generated by your software.

4. Describe the relationship implied by the model you have estimated.

5. Analyse if the assumptions of the models used are valid for the data.

Part III

1. Apply an Analysis of Variance (ANOVA), and give an appropriate assessment of your model.

2. Identify any statistical limitations (if any) and give explanations on how they could affect this analysis.

3. Describe possible improvements which you would recommend in terms of how data may be collected and analysed in any follow-up work.

Part IV

1. Write a 500-word executive summary for ESK Jewellery management. Summarize your analysis with the following:

a. Define the business problem/issue that ESK Jewellery wants to be addressed in your study.

b. Briefly elaborate the analysis/analyses that were found significant in your study.

c. List your findings and explain why these findings were significant.

d. Based on your findings, provide ESK Jewellery management your recommendation(s).

Part V

1. Consider the company you are working for, or one you have worked at in the past. Identify a situation in which you believe a linear regression model could be applied. Identify the dependent and explanatory variables of interest for this model.

Related Discussions:- esk jewellery

DATA fREQUENCY, Table 2: Mathematics Score/Jadual 2: Skor Matematik 27 37 3...

Table 2: Mathematics Score/Jadual 2: Skor Matematik 27 37 30 28 39 25 45 28 32 28 26 38 31 30 47 41 a) Based on Table 2, organize the data into a frequency distribution by taking

Regression analysis, Regression line drawn as y=c+1075x, when x was 2, and ...

Regression line drawn as y=c+1075x, when x was 2, and y was 239, given that y intercept was 11. Caculate the residual

Treatment of cst and vat, Treatment of CST and VAT in Sales Book A suppl...

Treatment of CST and VAT in Sales Book A supplier who expenses the CST for inter declares purchase by him, is responsible to first deposit the gathered CST from bought to Got Co

Define how to make a histogram and a frequency distribution, 1. Describe tw...

1. Describe two graphs/tables and how they are used to examine data. 2. Why are graphs and tables useful when examining data? 3. Describe how to make a histogram and a freque

Marginal and absorption costing, difference of them for covering the follo...

difference of them for covering the following: 1.purpose of reporting 2.FORMAT OF INCOME STATEMENT

Combination and permuations, Alarm units are to be connected at four fixed ...

Alarm units are to be connected at four fixed positions along a pipeline. In how many ways can the four available alarm unites be connected to the four positions along the line?

Determine probability of coding state at the last nucleotide, For the zero ...

For the zero order hidden Markov model defined in homework 2 determine probability of coding state at the last nucleotide of the sequence AGTAG. Use parameters provided in the home

Variables, what is variable mean

what is variable mean

Surveys through schedules, Under this methods the enumerators are appointed...

Under this methods the enumerators are appointed and given training. They are provided with schedules containing relevant questions. These enumerators go to respondents with the

Examine group profiles and report the descriptive statistic, Use your data ...

Use your data to perform the following tasks. 1.  Based on the variables, construct a design that consists only main effects of one categorical IV and at least two continuous DV

Write Your Message!

Captcha
Order Assignment

Featured Services

Order Now

Popular Subjects

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd