Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Statistics and Probability Expert

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.

Statistics and Probability, Statistics

  • Category:- Statistics and Probability
  • Reference No.:- M9526480

Have any Question?


Related Questions in Statistics and Probability

In a single season an average ofnbsp24nbsphome runs were

In a single? season, an average of 2.4 home runs were hit per game. Assume the number of home runs per game follows the Poisson distribution. ?a) What is the probability that 6 home runs will be hit in a randomly selecte ...

What do we mean by financial intelligence how to assess a

What do we mean by financial intelligence? How to assess a company's health? Use the plain language to define operating experience, capital expenditure, accruals, depreciation, and goodwill. Describe differences between ...

Heightnbspinnbspinchesnbsp69nbsp67nbsp69nbsp71nbsp70nbsp72nb

Height in inches  69  67  69  71  70  72  Weight in lbs  164  161  189  192  184  198  a) Find the equation of the regression line with height as the explanatory variable and use the regression line to find the predicted ...

Tossing a fair coin three times whats the probability that

Tossing a fair coin three times, what's the probability that at least one head will occur?

How do i figure a cusomers expected return when borrowing

How do I figure a cusomer's expected return when borrowing money? Example, the customer wants an investment that costs $100 and considers borrowing $80 for one year at 4.6% to help pay for the investment. What is the cus ...

Calculate the rate of return available to shareholders for

Calculate the rate of return available to shareholders for a company financing $1 million of assets with the following three arrangements: i. all equity ii. 50 percent equity and 50 percent debt at an interest rate of 12 ...

The following are amounts of time minutes spent on hygiene

The following are amounts of time (minutes) spent on hygiene and grooming in the morning by survey respondents (based on data from an SCA survey). 15, 16, 18, 25, 26, 30, 32, 41, 45, 55, 63. Does the number 63 appear unu ...

You are promised 80 a year for the next 4 years you are

You are promised $80 a year for the next 4 years. You are also promised a one-time payment of $2000 in 6 years. The interest rate is 6%. What is the total PV?

A single person with a monthly taxable income of 2800 in

A single person with a monthly taxable income of $2800 in the 15% federal marginal bracket, has a state tax rate of 7.95% and social security taxes at 6.2%. This person forgoes consumption and instead places $230 into a ...

In a certain state pickup trucks account for 21 of the

In a certain? state, pickup trucks account for 21?% of the? state's registered vehicles. If 100 registered vehicles are selected at? random, what is the expected number of pickup? trucks?

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As