Login

Create Account
Customer Service Chat
+14156709189
info@expertsmind.com
Submit Homework/Assignment
Get quote & make Payment
Get Solution
esk jewellery, Basic Statistics
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 hypothesistesting 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 followup work.
Part IV
1. Write a 500word 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.
Posted Date: 3/13/2013 12:00:36 AM  Location : Singapore
Ask an Expert
Related Discussions:
esk jewellery, Assignment Help, Ask Question on esk jewellery, Get Answer, Expert's Help, esk jewellery Discussions
Write discussion on esk jewellery
Your posts are moderated
Write your message here..
Related Questions
Computing observed probability values , For an alignment shown below derive...
For an alignment shown below derive logodds score for the column 1 only by a) Computing observed probability values b) Expected probability values TAGCTT AAGCTC T
Example of inference, Q. Example of inference? Ans. Thirty student...
Q. Example of inference? Ans. Thirty students from a college were surveyed and classified according to two variables: (1) gender (M/F) and (2) major (liberal arts, busines
Full and restricted models  testing research hypotheses, 1. Suppose you ar...
1. Suppose you are given a dataset that consists of a random sample of tasters, on which the following variables were obtained: (y) Zpref = taste preference for green beans stor
Quartile deviation, find quartile deviation from the student test marks of ...
find quartile deviation from the student test marks of your own
Compute the z scores, 1. Compute the z scores for the following raw scores ...
1. Compute the z scores for the following raw scores where = 78 and the standard deviation = 4. a. 72 b. 82 c. 78 d. 87 e. 71
Explain Bond discount, Explain Bond discount The excess of the countenance...
Explain Bond discount The excess of the countenance worth of a bond over the price for which it is acquire or sold resulting from a disparity between the marketplace rate of inter
International accounting standards committee, IASC: The IASC (Internationa...
IASC: The IASC (International Accounting Standards Committee is an international organization which was set up in 1973 was restructured to form IASB in 2001. It was an agreement b
Introduction to finance and accounting, How can I use a balance sheet to do...
How can I use a balance sheet to do assignment with some adjustment? do I have to make transaction of each adjustment, and after that I change the balance sheet afterward?
Internal rates of return , A consumer product firm finds that its brand of ...
A consumer product firm finds that its brand of laundry detergent is losing market share, so it decides that it needs to "freshen" the product. One strategy is to maintain the curr
Find an equivalent martingale and state prices, It is a sunny Tuesday after...
It is a sunny Tuesday afternoon in the perfectly manicured harbourside city of Sydney. Dressed in your favourite pin stripe Gucci (Black Label thank you very much) and those hand c
Assignment Help
Accounting Assignment Help
Economics Assignment Help
Finance Assignment Help
Statistics Assignment Help
Physics Assignment Help
Chemistry Assignment Help
Math Assignment Help
Biology Assignment Help
English Assignment Help
Management Assignment Help
Engineering Assignment Help
Programming Assignment Help
Computer Science Assignment Help
IT Courses and Help
ExpertsMind Services
Online Tutoring
Projects Assistance
Exam Preparation
Coursework Help
Programming Courses
Engineering Courses
Why Us ?
~Experienced Tutors
~24x7 hrs Support
~Plagiarism Free
~Quality of Work
~Time on Delivery
~Privacy of Work