DNSC 2001 Heavenly Chocolates - Weight of a Parcel - Sale - Online Shopping - Business Analytics Assessment Answer

Assessment Task:

DNSC 2001 - Heavenly Chocolates Business Analytics Assessment Answer

Question 1

Heavenly Chocolates manufactures and sells quality chocolate products at its plant and retail store located in Saratoga Springs, New York. Two years ago, the company developed a Web site and began selling its products over the Internet. Web site sales have exceeded the company’s expectations, and management is now considering strategies to increase sales even further. To learn more about the Web site customers, a sample of 45 Heavenly Chocolate transactions was selected from the previous month’s sales. Data showing the day of the week each transaction was made, the type of browser the customer used, the time spent on the Web site, the number of Web site pages viewed, and the amount spent by each of the 45 customers are contained in the file named HeavenlyChocolates45.xlsx

Heavenly Chocolates would like to use the sample data to determine whether online shoppers who spend more time and view more pages also spend more money during their visit to the Web site. The company would also like to investigate the effect that the day of the week and the type of browser have on sales.

Use the methods of descriptive statistics to learn about the customers who visit the Heavenly Chocolates Web site. Include the following in your report.

a. Graphical and numerical summaries for the length of time the shopper spends on the Web site, the number of pages viewed, and the mean amount spent per transaction. Discuss what you learn about Heavenly Chocolates’ online shoppers from these numerical summaries.

b. Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each day of the week. What observations can you make about Heavenly Chocolates’ business based on the day of the week? Discuss

c. Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each type of browser. What observations can you make about Heavenly Chocolate’s business based on the type of browser? Discuss.

Question 2

In a certain city, three newspapers A, B and C are published. Suppose that 60 per cent of the families in the city subscribe to newspaper A, 40 percent of the families subscribe to newspaper B, and 30 per cent subscribe to newspaper C. Suppose also that 20 per cent of the families subscribe to both A and B, 10 per cent subscribe to both A and C, 20 percent subscribe to both B and C, and 4 per cent subscribe to all three newspapers.

1) What percentage of the families in the city subscribe to at least one of the three newspapers?

2) What percentage of the families in the city subscribe to exactly one of the three newspapers?

3) If two families are chosen at random, what is the probability that at least one family subscribes to a newspaper?

Question 3

The weight of parcels received at a warehouse loading dock is normally distributed with a mean of 300 lbs. and a standard deviation of 40 lbs. The weight of a parcel is independent of the weight of any other parcel.

a) What are the 25th and 75th percentile values of the parcel weight distribution?

b) What is the probability that a parcel will weigh more than 400 lbs?

c) Consider three parcels selected randomly at the dock. What is the probability that exactly two of the three parcels weigh more than 400 lbs. each?

d) Parcels that weigh less than 400 lbs. do not get damaged; those weighing more than 400 lbs have a probability of 0.1 of getting damaged in handling at the dock. Whether a package is damaged or not is independent of any other package. What is the probability that none of three randomly selected parcels will be damaged?

Question 4

The size of the price discount offered by an industrial marketing manager varies according to order size. During the last quarter, the manager offered price discounts of 20% to one half of his customers and 30% to one-third of his customers and no discount to the rest. He estimates that the probability of receiving a reorder this quarter is 0.85 if the customer received a 20% discount, 0.92 if the customer received a 30% discount, and 0.70 if the customer received no discount.

a) If a customer is selected at random and is observed not to have reordered, what is the probability that this customer was offered no discount last quarter?

b) If a customer is selected at random and is observed to have reordered, what is the probability that this customer was offered a 30% discount last quarter?

Question 5

Demand for systems analysts in the consulting industry is greater than ever. Graduates with a combination of business and computer knowledge—some even from liberal arts programs—are getting great offers from consulting companies. Once these people are hired, they frequently switch from one company to another as competing companies lure them away with even better offers. One consulting company, D&Y, has collected data on a sample of systems analysts with undergraduate degrees they hired several years ago.

D&Y is trying to learn everything it can about the retention of these valuable employees. You can help by solving the following problems and then, based on your analysis, presenting a report to D&Y. (Note: You can benefit from using Pivot Tables in answering some of the questions)

a. Although starting salaries are in a fairly narrow band, D&Y wonders whether they have anything to do with retention. Find a 95% confidence interval for the mean starting salary of all employees who stay at least three years with D&Y. Do the same for those who leave before three years.

b. Among all employees whose starting salary is below the median ($37,750), what proportion stay with D&Y for at least three years? Do the same for the proportion of employees which their starting salary is above median ($37,750) and stay for at least three years.

c. D&Y wonders whether the percentage of time on the road might influence who stays and who leaves. Find a 95% confidence interval for the percentage of time on road of all employees who stay at least three years with D&Y. Do the same for those who leave before three years

d. Among all employees whose percentage of time on the road is below the median (%54), what proportion stay with D&Y for at least 3 years. Do the same for all employees whose percentage of time on the road is above the median (%54) and who stay with D&Y for at least 3 years.

e. What proportion of employees with CIS degree leave before three years? Find the same proportion for employees without CIS degree.

f. Write a short report about employees’ retention at D&Y based on your findings.

This DNSC 2001: Business Analytics Assessment has been solved by our Business Analytics Assessment Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.