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�,