MGMT 650 Fall 2017 Week 2 Homework

MGMT 650 Fall 2017 Week 2 Homework

(Last updated 7/3 /2017)

1. Basic Excel Operation:

Create an Excel spreadsheet that can be used to apportion your space in this dispose. The spreadsheet should include the powers of each spaced assignment, your space in each assignment, and your conclusive space. To use this for your boon you may omission to contemplation it so that it can be used to apportion your interspace space anteriorly you enjoy all the spaces.
Use a new sheet designated "Grade Calculator" in the selfselfsame Excel polish that you are submitting for this assignment.
After this week you achieve hold the disconnection from your confessor and you achieve be powerful to use your disconnection or our disconnection for coming disposees.

2. Basic Descriptive statistics

A kind diagnosis of profit for a tea-bag-filling way is the power of the tea in the personal bags. If the bags are inferior assiduous, two examples commence. First, customers may not be powerful to hatch the tea to be as sound as they endeavor. Second, the posse may be in permutation of the truth-in-labeling laws. In this illustration, the write power on the package indicates that, on mediocre, tclose are 5.5 grams of tea in a bag. If the mediocre totality of tea in a bag exceeds the write power, the posse is giving afar result. Getting an correct totality of tea in a bag is exampleatic owing of exception in the latitude and humidity internally the factory, contrarietys in the dullness of the tea, and the greatly pay filling influence of the document (almost 170 bags a specific). The forthcoming tpowerful provides the power in grams of a scantling of 50 bags manufactured in one hour by a uncombined document:

5.85

5.74

5.42

5.44

5.53

5.37

5.54

5.45

5.52

5.41

5.57

5.5

5.53

5.54

5.55

5.61

5.66

5.48

5.64

5.51

5.67

5.42

5.49

5.61

5.53

5.42

5.56

5.3

5.49

5.55

5.67

5.53

5.42

5.58

5.59

5.5

5.38

5.5

5.53

5.58

5.69

5.47

5.43

5.25

5.56

5.62

5.5

5.56

5.61

5.38

a. Compute the arithmetic balance and median.

b. Compute the pristine quartile and third quartile.

c. Compute the rank, interquartile rank, estrangement, model dissolution, and coefficient of exception.

Parts d and e are your hazard to illusion your inferiorstanding. You are a consultant brought in by the posse and given the scantling. What are your recommendations to the posse, fixed on your balbutiation for this week?

d. Interpret the measures of mediate proclivity amid the treatment of this example.  Why should the posse submissive the tea bags be solicitous environing the mediate proclivity?

e. Interpret the measures of exception amid the treatment of this example.  Why should the posse submissive the tea bags be solicitous environing exception?

3. Built In Excel Functions

Review Excel acceleration polishs (and other sources if you endeavor) and teach in your own words:

a. The contrariety betwixt the exercises QUARTILE.INC() and QUARTILE.EXC(). Which of the two achieve you get if you use QUARTILE()?

b. The contrariety betwixt STDEV.P() and STDEV.S() and the contrariety betwixt VAR.P() and VAR.S().

c. What is the Excel exercise COVARIANCE (This has two forms: COVARIANCE.P() and COVARIANCE.S())?

d. How achieve you apportion Coefficient of Exception of one scantling using Excel?

4.  Frequency Distribution

According to Zillow.com, close is a schedule of the values of the quality sold (in thousands) in Washington, DC June 29 – 30, 2016. Use Excel’s aptitude (=FREQUENCY()) to originate a number arrangement using 5 bins.

316

680

292

440

1860

2333

1775

844

843

785

265

1315

765

368

763

536

466

1261

1875

1113

299

205

830

1618

1451

625

1473

2093

449

1879

869

920

1700

2450

1460

1562

1380

888

1750

495

240

2250

1420

785

1556

949

1435

1475

945

645

Hint: To score the generous points for this topic, set it up so that Excel apportion the bins for you. This way if you shift the postulates the bins are shiftd automatically.

5.  Histogram, bar chart, and pie chart

Use the house value postulates and the bins postulates from example 4 to originate:

a. A histogram using the postulates dissection instrument.

b. A bar chart

c. A pie chart

8 t8D6�,