Steps are given in the file.
MGMT 2262 Final exam Winter 2022 Contents General Information2 Rules2 Outside sources3 Scenario4 What you need to do4 Part 1 - Exploratory data analysis5 Table 15 Part 2 - Training and testing set (sample)5 Table 27 Part 3a - Simple linear regression9 Table 310 Part 3b - Choosing between models12 Table 412 Part 4 - Multiple linear regression13 Table 513 Submission Guidelines14 Breakdown of marks15 Notes on plagiarism and cheating (and how to avoid it)17 Two very important notes: 1. This is a statistics course and the goal of this final exam is to demonstrate your understanding of the whole course. When you are reviewing your work, ask yourselves “are we demonstrating our understanding of relevant topics?” 2. Related to 1, though the rubric is in the middle of the document, it is the most important part of the exam as it specifically tells you what you are being grade on. As you complete each step, ensure that you have checked your work against the rubric to make sure you are maximizing your grade. Also it indicates where to put most of your effort (i.e. the portion of the exam that is worth the most should be where you put most of your work). General Information · This exam has four parts, which involve utilizing multiple analysis techniques to explore a human resources problem. · The overall goal of this exam is to demonstrate your understanding of the key topics in this course and that you can apply them in a real-world situation. · Worth: 25% of total mark for the course. · Due: Wednesday, April 20th by 11:59pm · Late submissions will not be accepted. Extensions will not be granted except in extreme circumstances. If you submit late, expect to receive 0% on the exam. · Though you do not need to do additional research for this exam, if you directly use any sources outside of the course (i.e. not from course notes or from the textbook), it is expected that you properly cite them. Both in-text citations and the reference list need to be done in APA style: https://library.mtroyal.ca/citations Rules 1. Most important rule: This is an individual exam. It must be completed by you and only you. The work you submit must be your own work. The normal expectations of students completing an exam apply. · You are not allowed to ask for help from another human, show your work to another human (other than when you submit to your instructor), or in any way gain any form of assistance from another human. · You cannot pay someone to do this exam for you. You cannot go to a website and share the document, get possible answers and use them in any way. You cannot go to a website, look for the exam, get possible answers and use them in any way. · Communication about any portion of the exam in any way with any person other than Your instructor is strictly prohibited. · Asking for any kind of help for this exam is strictly prohibited. Think like you are writing an in-person exam. You couldn’t lean over to your buddy and ask them how to make a histogram. So you can’t do it on this exam. · Note: If two people submit work that is strangely similar, there is a very good chance that both students will receive 0 and will be sanctioned with academic misconduct. Further to this, I will pay special attention to students who have worked together in the past to see if their answers are similar. 2. It is “open” book. This means you can use any resource (other than a human) you want to complete the submission. This includes the textbook, course notes, course videos, and internet sites (excluding homework help sites like Chegg and CourseHero). 3. You can ask the course coordinator Collette Lemieux (
[email protected]) for help that involves clarification. For example, if you do not understand what an instruction means, you can ask for clarification. · Similar to assignments 1 and 3, a FAQ document has been created. Please check there for questions and answers. 4. You cannot ask your instructor for help doing the exam because it is expected that you know how to do it. For example, if you do not know how to make a histogram, you need to figure it out on your own. Or if you are not sure what model to use in Step 3 of a hypothesis test, you need to figure it out on your own. · This relates to the majority of Excel issues as well. For example, if you don’t have the Data Analysis Toolpak properly installed prior to the final exam, that suggests you aren’t prepared to write the final and need to figure out the problem yourself. As another example, it is expected that you have actually used Excel to do a similar analysis prior to the final exam. Therefore, if you are having problems with doing the analysis, you need to figure it out on your own. 5. You cannot ask your instructor for feedback. 6. For all parts, you can work as much or as little on it as you want. As long as it is completed by April 20th end of day. · You have been given over ten days to complete this exam. It is expected that you work on the exam throughout this period. If you choose to wait until late on Wednesday to start the exam and run into problems, then you need to accept the consequences. · If you studied for the final exam prior to writing it, it will take 3 to 4 hours to complete. But most of you will study as you are writing it (because it is an open book exam). Therefore, plan to spend at least 12 hours working on the exam. Therefore, starting this exam three hours before it is due is like showing up to an exam two hours after it has started. · This is a final exam. It is worth 25% of your mark. Behave accordingly. 7. This is not a complete list of rules as that is hard to do. Instead, please keep in mind the spirit of the rules which is an open book, individual exam. Outside sources NOTE: If you directly use an outside source (e.g., paraphrase or quote), you still need to do a proper APA citation. What is described below is only for outside sources that you looked at for help and not for directly writing your final work. As I am absolutely convinced that most of you are using outside sources and failing to cite them, let us make it easy. If you look at a website outside of the class (i.e. not our textbook or from BB), insert the URL in the table below, state which part of the exam you used it for (1, 2, 3 ,4), and very briefly how you used it. In the first row, I’ve provided an example of what I’m expecting. Please delete it before submitting. URL Part How used https://www.statisticshowto.com/probability-and-statistics/correlation-coefficient-formula/ 2 Read about r and how to interpret it. If you claim you used no outside sources OR you directly used all outside sources, instead of submitting the above table, include the following sentence in your final work (see submission guidelines for where): “I, [insert full name], solemnly swear that I did not use any outside source (except those properly cited using APA referencing) to complete this exam. I understand that failure to indicate outside sources is an act of academic misconduct and could result in getting 0 on this exam.” Scenario The Craybill Instrumentation Company produces highly technical industrial instrumentation devices. The company has 45 sales regions, each headed by a sales manager. The human resources (HR) director has the business objective of improving recruiting decisions concerning sales managers. The HR director determined that the primary method of evaluating the effectiveness of recruitment is the hire’s resulting “sales index” score, which is the ratio of the regions’ actual sales divided by the target sales. The target values are constructed each year by upper management, in consultation with the sales managers, and are based on past performance and market potential within each region. At the time of their application, candidates are asked to take the Strong-Campbell Interest Inventory Test and the Wonderlic Personnel Test. The former test measures the applicant’s perceived interest in sales, while the latter measures their perceived ability to manage. For both tests, the higher the score the better. Due to the time and money involved with the testing, some discussion has taken place about dropping one or both of the tests. The HR director decided to use regression modelling to predict the sales index (Sales) of the sales managers. To start, the HR director gathered information on each of the 45 current sales managers, including years of selling experience (Experience), and the scores from both the Strong-Campbell Interest Inventory Test (SCIIT) and the Wonderlic Personnel Test (Wonder). The attached Excel file contacted information on the 45 current sales managers. Your goal is to perform analysis to determine: Can the sales index be predicted by the variables chosen by the HR director? If so, which variable or combination of variables is the most effective predictor. What you need to do To answer the above question, follow the instructions below. You will submit all of the tables in each of the parts and your Excel file with your completed work. See Submission Guidelines for more details. Part 1 - Exploratory data analysis Prior to doing the regression analysis, the HR director wants to get a sense of the quality of sales managers Craybill currently has. To do this, run an exploratory data analysis of the sales index and determine what story you want to tell about the sales managers. · Goal: Answer the HR director’s question: “What is the quality of the current sales managers at Craybill?” · How: Perform exploratory data analysis. · Step 1: Run an exploratory data analysis (i.e., create visualizations and numerical summaries) for the sales index. · Step 2: Choose one other variable (i.e., Wonder, SCIIT or Experience) to drill down into the sales index data. Run an exploratory data analysis (i.e., create visualizations and numerical summaries) for the sales index and your chosen variable. · Step 3: Review your work and decide what story you want to tell about the quality of the current sales managers at Craybill. · Step 4: Choose one visualization or set of numerical summaries (or both) from Step 1 and one visualization or set of numerical summaries (or both) from Step 2. Insert them in Table 1