MGMT

• Q1) Make columns labeled Name of Assignment, Grade, Weight, Points. List the 12 names of assignments under Name of Assignment. The Weights are given in the Syllabus, Points = weight x grade. Sum the Points by label Overall Grade
• 5) Use function VAR.S for the given "sample data".
• 6) Use function STDEV.S for the given "sample data".
• 7) Use the CV when there is no history for comparison, or datasets have different physical units
• 8) See the announcement Office 365 and Data Analysis for access to Data Analysis, Descriptive Statistics in Office 365.
• 9) Update your assessment of measures of central tendency to match your computations in 1). Based on your analysis, "Should the company producing the coffee be concerned about the central tendency?"
• 10) There is no prior history for comparison with variance or standard deviation. Where there is no prior history, or data sets have different units, use the CV. In industry rule, a < 5% is not significant. Is the CV of the data significant? Based on the CV, should the company producing the coffee be concerned about variation?
• 11) That is not a pivot table. It is a facsimile of a pivot table. You must insert a Pivot Table for credit. See the Word file attached to Feedback in the Assignments folder.
• 14-16) Fill in the yellow cells as instructed.
• 18) Use the =FREQUENCY() array function.
  
  • 1: Select D53:D62
  • 2: Type =FREQUENCY(
  • 3: Click tab Pivot Table Data and cell B2.
  • 4: Hold down Ctrl and Shift and hit the downward pointing arrow next to the numeric keypad. All the data will be selected (B2:B201)
  • 5: Type ,
  • 6: Select the range of the bin values on tab Q4 - Frequency
  • 7: Type )
  • 8: Hold down Ctrl and Shift, and hit Enter
• Complete tab Q5 - Charts

There is a typo in the" Q3 - Pivot Table” question for HW2.  It reads,  “…columns D and I from the…”  it should read, "“…columns B and D from  the…”