GuptaAyush.xlsx - Instructions 1 This exam has 4 questions...

This preview shows page 1 - 5 out of 38 pages.

Your Name : Instructions 1. This exam has 4 questions and a bonus. You have 2. For full credit, SHOW ALL YOUR WORK and clearl 3. Cell phones should be silenced and put away. Yo 4. You may use the laptop only to download, to wor open any other file or application. 5. For all the problems, enter your answers in this E 6. Make sure to save your work frequently and pace problems. To submit your exam 1. Name this Excel file with your name, last name fi 2. Upload the exam file to Blackboard . Check with your Excel file before you leave. I understand evidence of any academic dishonesty or communicating with others during the exam wil exam.
Image of page 1

Subscribe to view the full document.

Ayush Gupta e 80 minutes to complete the exam. ly indicate your final solution. ou may use your 2 sheets of notes. rk on, and to upload this exam file. Do not Excel file. e yourself so you will get to attempt all the first (e.g., SmithJohn.xlsx). the instructor to confirm that he received y including using any unauthorized material ill result in my receiving a score of 0 on this
Image of page 2
Person Gender Marital Status Children Salary Region State 1 0 0 1 $ 26,909 South Texas 2 0 0 0 $ 33,600 West Washington 3 1 0 0 $ 54,700 Midwest Indiana 4 0 1 2 $ 33,200 West Utah 5 1 0 3 $ 29,600 South Florida 6 1 0 0 $ 50,500 West Washington 7 0 1 0 $ 38,200 Midwest Indiana 8 0 1 0 $ 68,600 West California 9 1 0 3 $ 31,500 East Ohio 10 1 0 0 $ 43,700 West Arizona 11 1 0 3 $ 55,100 South Texas 12 1 0 1 $ 43,100 South Texas 13 0 0 0 $ 17,300 Midwest Kentucky 14 1 1 0 $ 66,200 South Tennessee 15 0 0 2 $ 31,300 West Washington 16 1 1 2 $ 107,300 West Washington 17 0 0 0 $ 28,300 Midwest Missouri 18 0 1 2 $ 84,800 South Texas 19 0 0 3 $ 16,794 Midwest Indiana 20 1 1 0 $ 139,900 West Utah 21 0 0 0 $ 32,700 East Ohio 22 0 0 0 $ 46,600 South Texas 23 0 1 0 $ 62,600 South Texas 24 0 0 2 $ 23,935 Midwest Missouri 25 0 1 3 $ 97,400 East Ohio 26 0 1 2 $ 40,033 East New York 27 0 0 0 $ 47,500 Midwest Kansas 28 0 0 2 $ 18,364 East Pennsylvania 29 1 1 0 $ 41,600 East Pennsylvania 30 1 1 1 $ 64,000 East Pennsylvania 31 0 0 1 $ 23,185 East Pennsylvania 32 1 0 0 $ 20,900 South Louisiana 33 1 0 0 $ 63,700 South Florida 34 0 1 0 $ 82,000 West California 35 1 1 0 $ 32,391 Midwest Indiana 36 0 0 0 $ 43,700 East New York 37 1 0 3 $ 58,600 Midwest Missouri 38 1 0 1 $ 76,800 East Ohio 39 0 1 0 $ 76,400 South Florida 40 1 0 3 $ 59,600 Midwest Missouri 41 0 1 0 $ 84,800 Midwest Indiana 42 1 0 0 $ 45,600 West Utah 43 0 1 0 $ 69,400 West California 44 1 1 0 $ 102,700 East Pennsylvania 45 1 1 0 $ 83,700 East Pennsylvania 46 0 0 2 $ 64,100 Midwest Ohio 47 1 1 2 $ 83,000 South Florida
Image of page 3

Subscribe to view the full document.

48 1 1 2 $ 54,200 South Louisiana 49 1 0 2 $ 32,400 East Massachusetts 50 1 1 0 $ 41,300 West Colorado 51 1 1 0 $ 36,900 South Florida 52 1 0 0 $ 25,800 East Massachusetts 53 0 1 3 $ 79,900 South Louisiana 54 1 0 1 $ 55,900 West California 55 0 1 0 $ 50,500 Midwest Indiana 56 1 1 3 $ 113,400 Midwest Kentucky 57 0 1 1 $ 92,400 South Texas 58 0 0 2 $ 27,036 Midwest Missouri 59 1 1 4 $ 95,800 Midwest Missouri 60 0 1 1 $ 63,500 West California 61 0 0 0 $ 39,900 East New York 62 0 1 0 $ 31,392 East Ohio 63 1 1 1 $ 60,300 Midwest Ohio 64 0 1 0 $ 95,900 Midwest Kansas 65 1 0 2 $ 23,200 South Louisiana 66 0 0 0 $ 35,200 West Utah 67 1 0 0 $ 60,300 Midwest Illinois 68 1 1 2 $ 83,100 West Utah 69 1 1 2 $ 84,300 East Ohio 70 1 1 3 $ 88,000 East Ohio 71 0 1 3 $ 65,400 West California 72 0 1 0 $ 51,900 Midwest Kansas 73 0 1 0 $ 79,300 East Massachusetts 74 1 1 1 $ 105,300 West Colorado 75 0 0 1 $
Image of page 4
Image of page 5
  • Fall '17
  • London Plan

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern