#1 Exercise

Data Collection Practice

A maker of energy drinks is considering abandoning can containers and going exclusively to bottles because the sales manager believes customers prefer drinking from bottles. However, the vice president in charge of marketing is not convinced the sales manager is correct. Investigate this issue using statistical analysis.

1. Explain which data collection method you would use and what procedures you would follow to apply this method to this situation.

2. Propose which level of data measurement applies to the data collected. Justify your answer.

3. Determine whether the data is qualitative or quantitative.

4. Submit your work in a Word document

# 2 Exercise

1. Scatter Diagram Analysis

The regional sales manager for American Toys, Inc., recently collected data on weekly sales (in dollars) for the 15 stores in his region. He also collected data on the number of salesclerk work hours during the week for each of the stores. The data are as follows:

 

Store

Sales

Hours

 

1

23,300

120

 

2

25,600

135

 

3

19,200

96

 

4

10,211

102

 

5

19,330

240

 

6

35,789

190

 

7

12,540

108

 

8

43,150

234

 

9

27,886

140

 

10

54,156

300

 

11

34,080

254

 

12

25,900

180

 

13

36,400

270

 

14

25,760

175

 

15

31,500

256

 

To complete this assignment:

1. Use Excel to develop a scatter diagram of the data, including dependent and independent variables on their correct axis.

2. In a Word document, analyze the relationship between sales and number of clerk hours worked.

3. Conclude, based on the scatter diagram, what adjustments the sales manager might make to address the relationship between sales and number of clerk hours worked.

4. Submit your work in a Word document with your Excel file attached.

# 3 exercise

1. Data Description Methods

Japolli Bakery makes a variety of bread types that it sells to supermarket chains in the area. One of the problems is that the number of loaves of each type of bread sold each day by the chain stores varies considerably, making it difficult to know how many loaves to bake. A sample of daily demand data is contained in the file, Japolli Bakery.

1. Develop a frequency distribution for each bread type using& appropriate intervals.

2. Select which bread type has the greatest and lowest relative variability.

3. Assuming that these sample data are representative of demand during the year, determine how many loaves of each type of bread should be made such that demand would be met on at least 75% of the days during the year.

4. Submit your work in a Word document and attach your Excel file.