Bundle contains 4 documents
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.