Final Exam

Final Exam - Final Exam This final exam is comprised of...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Name: PID: Final Exam This final exam is comprised of eight worksheets covering various key topics of the Harvard fully online eLearning course on Quantitative Methods. Complete the exam as if you were submitting this workbook to a lay person not familiar with quantitative methods such that they could easily understand your arguments, graphs, and conclusions. Please show all of your work. It is not enough to simply get right answers on this test; you must show your work to demonstrate that YOU know how to arrive at correct answers using Excel. There is a deadline for the submission of this exam. You are responsible for submitting this completed workbook to your coach before the deadline. Use Lastname.Firstname.FinalExam.xlsx as the fiilename of your document. Good Luck! Prof. Ellis
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Day # Calls 1 45 2 30 3 53 4 69 5 67 6 45 7 17 8 46 9 46 10 33 11 59 12 74 13 42 14 35 15 38 16 18 17 41 18 63 19 72 20 44 21 45 22 44 23 40 24 48 25 67 26 72 27 39 28 52 29 45 30 40 31 34 32 75 33 88 34 63 35 38 36 48 37 42 38 50 39 74 40 61 41 28 42 37 43 27 44 44 45 49 46 70 47 75 48 42 49 23 50 38 51 11 52 71 53 80 54 70 55 41 56 47 57 33 58 38 59 29 60 83 61 60 62 54 63 35 64 46 65 51 66 58 67 72 68 86 69 48 70 57 71 51 72 62 73 62 74 70 75 76 76 46 77 31 78 26 79 60 80 59 81 83 82 71 83 49 84 51 85 150 86 56 87 49 88 94 89 73 90 42 Help Desk Calls Q-1a. You run a small Internet business and are concerned about customer support service levels on the Help Desk. You want to know how many calls per day are handled by your help desk staff. You collect the data at left over a 90-day period. Use appropriate descriptive statistics to make sense of this data. Use an appropriate graph also. Explain your findings so that your non-quantitative partner will understand them.
Background image of page 2
Sales Age Growth Income Sales HS College ### 33.16 0.8299 $26,748.51 ### 73.5949 17.8350 ### 32.67 0.6619 $53,063.79 ### 88.4557 31.9439 ### 35.66 0.9688 $36,090.14 ### 73.5362 18.6198 $529,215.46 33.07 0.0821 $32,058.07 $529,215.46 79.1780 20.6284 $663,686.65 35.76 0.4646 $47,843.42 $663,686.65 84.1838 35.2032 ### 33.81 2.1796 $50,180.97 ### 93.4996 41.7057 ### 30.98 1.8048 $30,710.08 ### 78.0234 28.0250 $612,696.05 30.78 -0.0569 $29,141.70 $612,696.05 70.2949 15.0882 $891,822.03 32.32 -0.1577 $25,980.15 $891,822.03 70.6674 10.9829 ### 32.53 0.3664 $18,730.88 ### 63.7395 13.2458 $909,500.98 31.44 2.2256 $31,109.23 $909,500.98 76.9059 19.5500 ### 33.16 1.5158 $35,614.12 ### 82.9452 20.8135 $882,972.65 31.87 0.1413 $23,038.43 $882,972.65 65.2127 16.9796 ### 33.41 -1.0400 $34,531.72 ### 73.4944 32.9920 $844,320.19 34.05 1.6836 $30,350.36 $844,320.19 80.2201 22.3185 ### 28.89 2.3596 $38,964.94 ### 87.5973 24.5670 ### 36.11 0.7840 $49,392.77 ### 85.3041 30.8790 $826,573.88 32.81 0.1164 $25,595.69 $826,573.88 65.5884 17.4545
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 9

Final Exam - Final Exam This final exam is comprised of...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online