Question

In: Math

If you were given a large data set, such as the sales over the last year...

If you were given a large data set, such as the sales over the last year of our top 100 customers, what might you be able to do with these data? What might be the benefits of describing the data?

Solutions

Expert Solution

It is given that we are given a large data set, such as the sales over the last year of our top 100 customers.

We might be able to do the following with this data :-

a) We could say that which group of people would buy which product. From the given data, we could say that kids prefer product 1 or the old generation prefer product 2. We could also say that the males and females would prefer different products. From this, we could say that which group of people prefer which product.

b) We could also say that which type of products are sold the most. From this, we could say that which products are preferred the most accordingly which the marketing department could arrange items.

The benefits of describing the data are :-

a) The marketing would be helped on targeting sales due to the description of the data.

b) We could understand that which category of customers are very active or which category of items are sold at which rate. From this, the list of future products can be shown.


Related Solutions

Given these sales figures over the last 7 weeks, your boss needs you to test two...
Given these sales figures over the last 7 weeks, your boss needs you to test two different forecasting methods (parts a and b below) to determine which method is best. For your measure of “best”, recommend to your boss that the company should use the method with the lowest mean absolute deviation (MAD). Then use that method to provide your forecast for week 8 in part c. Week                        Unit Sold 1                                 9,040 2                                 11,150 3 9,420 4                                 10,310 5                                 11,950...
QUESTION E The sales of a factory, manufacturing bicyles, over the last 24 months were as...
QUESTION E The sales of a factory, manufacturing bicyles, over the last 24 months were as follows: MONTH UNITS SOLD 1 1140 2 1180 3 1130 4 1180 5 1110 6 1200 7 1280 8 1340 9 1340 10 1240 11 1140 12 1230 13 1440 14 1530 15 1560 16 1350 17 1350 18 1420 19 1530 20 1530 21 1430 22 1430 23 1490 24 1570 It is obvious that the monthly sales are increasing, but it is...
The returns for AhhChocolate.com over the last 5 years are given below. Assuming no dividends were...
The returns for AhhChocolate.com over the last 5 years are given below. Assuming no dividends were paid, what is the 5-year “average” Holding Period (Geometric) Return for AhhChocolate? Year 1 return = 5.3% Year 2 return = - 4.6% Year 3 return = - 3.2% Year 4 return = 1.2% Year 5 return = 3.5% A) 0.368% B) 3.550% C) 8.400% D) 2.200% E) 0.440%
The sales of vacuum cleaners at Lowenthal’s Industrial Supply over the last thirteen months are given...
The sales of vacuum cleaners at Lowenthal’s Industrial Supply over the last thirteen months are given below. Month Sales Month Sales 1 12 8 14 2 14 9 17 3 16 10 12 4 10 11 14 5 15 12 16 6 17 13 11 7 11 a) Use a weighted moving average for three periods to forecast sales for next month. Use a weight of 3 for the most recent period, 2 for the middle period, and 1 for...
A large data set is separated into a training set and a test set. (a) Is...
A large data set is separated into a training set and a test set. (a) Is it necessary to do this randomly? Why or why not? (b) In R how might this separation be done in a reproducible way? (c) The statistician chooses 20% of the data for training and 80% for testing. Comment briefly on this—2 or 3 lines would be plenty.
71. Last year Dania Corporation's sales were $525 million. If sales grow at 9.8% per year,...
71. Last year Dania Corporation's sales were $525 million. If sales grow at 9.8% per year, how large (in millions) will they be 8 years later?             a.         $1,142.39             b.         $1,109.12             c.         $1,364.22             d.         $1,131.30             e.         $842.93 72. How much would $1, growing at 13.7% per year, be worth after 75 years?             a.         $18,248.03             b.         $15,206.70             c.         $15,358.76             d.         $13,533.96             e.        ...
Han Corp's sales last year were $315,000, and its year-end receivables were $52,500. The firm sells...
Han Corp's sales last year were $315,000, and its year-end receivables were $52,500. The firm sells on terms that call for customers to pay 30 days after the purchase, but some delay payment beyond Day 30. On average, how many days late do customers pay? Base your answer on this equation: DSO – Allowed credit period = Average days late, and use a 365-day year when calculating the DSO. Assume all sales to be on credit. Do not round your...
Characteristic Line You are given the following set of data: Historical Rates of Return Year NYSE...
Characteristic Line You are given the following set of data: Historical Rates of Return Year NYSE Stock Y 1 4.0 % 3.5 % 2 14.3 17.7 3 19.0 9.2 4 - 14.7 - 9.0 5 - 26.5 - 12.2 6 37.2 32.1 7 23.8 6.7 8 - 7.2 3.5 9 6.6 13.9 10 20.5 22.7 11 30.6 17.0 Mean = 9.8 % 9.6 % σ = 19.6 % 13.1 % Use a spreadsheet or a calculator with a linear regression...
You are given the following set of data: HISTORICAL RATES OF RETURN Year      NYSE         Stock X...
You are given the following set of data: HISTORICAL RATES OF RETURN Year      NYSE         Stock X 1 - 26.5% - 19.0% 2 37.2    16.0    3 23.8    15.5    4 - 7.2    3.0    5 6.6    9.1    6 20.5    19.4    7 30.6    19.5    The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Use a spreadsheet (or a calculator with a linear regression function) to determine...
You are given the following set of data: HISTORICAL RATES OF RETURN Year      NYSE         Stock X...
You are given the following set of data: HISTORICAL RATES OF RETURN Year      NYSE         Stock X 1 - 26.5% - 10.0% 2 37.2    21.0    3 23.8    18.5    4 - 7.2    2.0    5 6.6    8.9    6 20.5    19.9    7 30.6    18.8    Use a spreadsheet (or a calculator with a linear regression function) to determine Stock X's beta coefficient. Round your answer to two decimal places. Beta = Determine the arithmetic average rates of return for Stock X and the NYSE over...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT