# Regression/Correlation

Not what you're looking for?

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.