Multiple Regression: Survey Data SetDirections: Constructing A MR Model A. Selecting Your X-variables* • Y-variable: Starting Salary• X-variables: Select 3 (no more, no less), one of which must be nominal-level data. See the short video, “Generating a Dummy Variable in Excel” in the Assignment area to code your nominal-level data for Excel.Upfront Planning on Selection of Variables• Have an overarching idea\theme\theory\hypothesis for your model.● Support your idea\theme\theory\hypothesis with the X-variables you select.• Not doing the above will leave you with a statement that is a sterile, grocery-style list of statistical terms, because you will have no personal and specific context through which to interpret your results.• For a complete explanation of variables, see the Survey Questions sheet in the Class Survey Data File. B. Running Multiple Regression in Excel• Copy & Paste your variables (with column headings) from the Survey Data Set onto a new sheet. Place the X-variables in adjacent columns with the Y-variable (Starting Salary) in a column before or after. ● Click on the Data Tab from the ribbon bar, Click on Data Analysis, Select Regression, complete the Popup Box: ○ Input Y Range: the range of cells containing the data of your Y-variable○ Input X Range: the range of cells containing the data all of your X-variables ○ Click on Labels (so Excel will recognize labels as your column headings)○ Output Range: input any cell that is not already occupied or click on New Worksheet Ply○ Note: Excel auto-sets alpha at .05 (95% confidence level). You can use this setting.C. Creating a Collinearity Matrix 1.Return to your X-variables. Clickon the Data Tab from the ribbon bar, SelectData Analysis, SelectCorrelation, complete the Popup Box:○ Input Range: Highlight (Select) the cell range for all the X-variables: data and column headings○ Grouped By: Columns (Default Setting)○ Click on Labels in First Row○ Click on Output Range and input a cell outside the range of your data. Click OK2. Copy and Paste the correlation matrix below your multiple regression output tables.D. FormattingOutput Tables Set cells to 3 - 4 decimals (except whole numbers) and clean up tables, including but not limited to specifically identifying your output, widening/shortening column widths and/or merging cells so all words are fully legible, etc.  Delete the second set of upper and lower 95% boundaries (the last 2 columns) in the Anova table.C 13_Directions_MR©KShaulE. Complete Assignment Submission Form: Interpreting Your Results: I am not looking for one “correct” model, significant model, or useful model. If you get a “good” model, great. If not, great. The data is unique to your class, and as such, the output is unknown until the data is run. So, there is no reason to run multiple models.What is important is your demonstration of creating a model, the articulation of your reasoning for your model/X-variables, your statement of how the results support and/or do not support your thinking, and any specific explanation and conclusion regarding your particular outcome. Your writing should display critical thinking, creativity, insight, and a synthesis of your understanding of multiple regression within the context you created by the selection of your X-variables.1 Possible Structure: ○ Intro: What is the idea\theme\theory\hypothesis underlying your model, your model, and specifically how your X-variables support said model\idea\theme\theory\hypothesis.○ Body: Analyze the data within the context of you created.○ Conclusion: Summary\Possible Changes\Possible Next Step\Issues to Explore\Etc.General Writing Tips(That you know but may forget while focused on the statistics):○Let the reader know your dummy variable code, either in the statement or tables.○Specificity is better than generalities.○ Conciseness is better than verbosity.○ Paragraphs show organization of thought. Use them (or write as well as Jose Saramago).○There is a written rubric under located in Core Course Documents.• You are not getting a degree in data entry or Excel, so whether a score moves upwards or downwards is determined to the degree to which the statement is a well-executed, blended expression of subject matter context and statistics. • Use 11pt/12pt font and do not exceed 1 page.F. Submitting Your Work:• By submitting the work you agree that the work is solely and wholly your work and in your words.●Do NOT turn in the raw data. ●Do NOT turn in any residuals. ●Do NOT turn in any graphs.• IMPORTANT: Submission Forms must be kept as a Word document (.doc or .docx) or PDF (.pdf) or if needed try as an image (jpeg, jpg, or png). Other formats do not open on my end.●Upload and Submit your Assignment Submission Form via the appropriate link.Submission Form: Order of Materials• Page 1: Written Statement● Page 2: Attach a second page containing your Multiple Regression Output (in this order):○ Summary Output Table○ Anova Table○ Coefficient Table ○ Collinearity Matrix.