Purchase Solution


Not what you're looking for?

Ask Custom Question

Please see attachment.

Purchase this Solution

Solution Summary

A manufacturing plant wants to see whether or not the method in which their customer orders are taken, affect their total sales on an average day. Below shows a table of data they have recorded data from their customer service department:

Service person

Phone Orders Taken

EDI (electronic data info) Orders Taken

Total Sales
1 54 37 $40,250
2 40 51 $47,300
3 52 33 $32,150
4 39 52 $38,000
5 30 61 $41,200
6 39 50 $50,550
7 53 35 $30,050
8 52 37 $28,500
9 54 35 $40,100
10 42 49 $52,600
11 52 38 $39,400
12 40 49 $64,250
13 35 54 $43,400
14 53 35 $27,500
15 52 38 $35,200
16 38 50 $42,450
17 41 48 $60,200
18 52 34 $24,300
19 43 47 $56,150
20 46 45 $51,300

a). Calculate (in Excel) the mean, median, and mode for the categories: Phone orders taken, EDI orders taken, and total sales.

b.) Do you notice any interesting aspects about these calculations.

c). Please develop two scatter plots, one to illustrate the Phone orders taken vs. total sales, and the other to illustrate EDI orders taken vs. total sales. Add a trend line, along with the regression equation and the coefficient of determination.

d). What would you say is the outcome of the analysis? Is the total sales affected by the method in which the orders are taken? Compare the Phone and EDI orders taken. Is there similarities, differences, or both?

e). Would you say there is a close relationship between a higher total sales and EDI orders taken? Why or why not?

Purchase this Solution

Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.