USA: +1(585)6662225, IN: +91-7503070001, IN:+91-9519066910

Research Project Starbucks Assignment

Rating:

# Question 1

Based on the given case study, it has been found that, Missy Walters bought a mail order business which is related to selling linen, clothing and furniture. At beginning she had decided to offer discount on delivery charges related to delivery of furniture based on furniture that are ordered in dollar amount. Missy wants to generate discount policy in order to distribute the furniture orders effectively.

The following scenario will be used in order to achieve the below answers using different statistical methods.

a. Construction of the table of frequency distribution and percentage frequency distribution along with relative frequency distribution using the class width of \$50

On the basis of the given data by considering the class width of \$50, it can be said that the frequency of the class 99.5 to 149.5 is 3, which has been known as class frequency. With respect to the class of 149.5 to 199.5, the class frequency has been found as 15. Class frequency of the class limit 199.5 to 249.5 has been seen to be 14. In accordance with the class of 249.5 to 299.5, the class frequency has been found as 6. It has been that the class frequency of the class limit of 299.5 to 349.5 is 4. By considering the class of 349.5 to 399.5, the class frequency has been found as 3. The respective class frequency of the relative class limi8t of 399.5 to 449.5 has been found to be 3. The class limit of 449.5 to 499.5 has been found with the class frequency of 2. Therefore, from the above constructed table of frequency distribution, it can be seen that the total class frequency has been found 50.

Relative frequency can be calculated on the basis of frequency of each class and the total class frequency. This can be mathematically expressed as follows:

Relative Frequency = Class Frequency/ Total class frequency

Therefore, with the appli8cation of the aforementioned formula, it has been found that the relative frequency of the class frequency 3 is 0.06. Respective relative frequency for the class frequency 15 has been found to be 0.3. With respect to the class frequency of 14, it has been seen that the relative frequency is 0.28. In accordance with the formula of relative frequency, it has been found that the relative frequency of the class frequency 6 is 0.12. The class frequency of 4 has been found with the relative frequency of 0.08. In accordance with the class frequency of 2, it has been seen that the relative frequency of the respective class is 0.04.

In order to find the percentage distribution, the relative frequency needs to be multiplied by 100. Therefore, the mathematical expression of the formula for calculating the percentage frequency can be demonstrated as follows:

Percentage Frequency = (Class Frequency/ Total Class Frequency) * 100

This implements Percentage Frequency = Relative Frequency * 100

Therefore, the percentage frequency for the class frequency of 3 has been found as 6. For the class frequency of 15, the percentage frequency has been found as 30. The percentage frequency of the class frequency 14 has been found to be 28. For the class frequency of 6 the percentage frequency has been found as 12. With respect to the class frequency of 4 has been found with the percentage frequency of 8 and the class frequency of 2 has been determined with the percentage frequency of 4.

b. Construction of histogram that can help to illustrate the percentage frequency distribution related to the order value of the furniture

The above graph of hi8stogram illustrated the percentage frequency distribution that can help to determine the order value related to the furniture.

c. The distribution shape related to part b, measurement of the location that can be suitable in order to measure the location which is appropriate to the set of data.

The above table demonstrated that, if the furniture order found to be in the range between 100 to 149, then the frequency will be 3. On the other hand, the cumulative frequency will be 3 and cumulative frequency percentage will be 6. If the range of the order of the furniture will be 150 to 199, then the frequency will be counted 15, cumulative frequency will be 18 and cumulative frequency percentage will be 36. If the furniture order found to be in the range between 200 to 249, then the frequency will be 14. On the other hand, the cumulative frequency will be 32 and cumulative frequency percentage will be 64. If the range of the order of the furniture will be 250 to 299, then the frequency will be counted 6, cumulative frequency will be 38 and cumulative frequency percentage will be 76. If the furniture order found to be in the range between 300 to 349, then the frequency will be 4. On the other hand, the cumulative frequency will be 42 and cumulative frequency percentage will be 84. If the range of the order of the furniture will be 350 to 399, then the frequency will be counted 3, cumulative frequency will be 45 and cumulative frequency percentage will be 90. If the furniture order found to be in the range between 400 and 449, then the frequency will be 3. On the other hand, the cumulative frequency will be 48 and cumulative frequency percentage will be 96. If the range of the order of the furniture will be 450 to 499, then the frequency will be counted 2, cumulative frequency will be 50 and cumulative frequency percentage will be 100. Hence, the above analysis help to take effective step for the measurement of the location that can be suitable in order to measure the location which is appropriate to the set of data.

## Question 2

b. the coefficient relate to the determination and interpretation of its meaning

R2 = 0.617; 61.7% of the variability related to in demand that can be explained in order to highlight the variability in the price

c. The coefficient of correlation

It has been found that R= -0.786, as the slope is observed to be negative. On the other hand, the coefficient of correlation can also be negative that include the unit price that will increase as demand decreases.

### Our Top Experts

Holding a PhD degree in Finance, Dr. John Adams is experienced in assisting students who are in dire need...

55 - Completed Orders

Canada, Toronto I have acquired my degree from Campion College at the University of Regina Occuption/Desi...

52 - Completed Orders

Even since I was a student in Italy I had a passion for languages, in fact I love teaching Italian, and I...

102 - Completed Orders

To work with an organization where I can optimally utilize my knowledge and skills for meeting challenges...

109 - Completed Orders

JOB OBJECTIVE Seeking entry level assignments in Marketing & Business Development with an organization...

202 - Completed Orders

Current work profile Project manager- The Researchers Hub (2nd Jan 2016 to presently working) Researc...

20 - Completed Orders

Sales Assistant, Mito Marina Assigned to the Stationery dept – assisted in merchandising, stock taking...

100 - Completed Orders

Personal Profile Dedicated and highly experienced private chauffeur. High energy, hardworking, punctua...

200 - Completed Orders

I'm Lizzy, full time education specialist in English, Essay Writing, Economics and Maths. Having Assi...

109 - Completed Orders

HSC PREPARATION I specialise in English coaching programs for HSC students. My personalised and results-...

202 - Completed Orders