MGMT 414: Management Analytics Final Project Information. Create your own regression model based on an observation or research question that you individually develop. Please see blackboard for possible data sources
MGMT 414: Management Analytics Final Project Information.
Create your own regression model based on an observation or research question that you individually develop. Please see blackboard for possible data sources and research ideas. Include at least 20 observations and at least 1 independent variable but no more than 4. Run the regression function using the data analysis tab to get your output tables. Create Scatter plots for every independent variable. Interpret your results.
There will be 100 Points total.
Key Dates and Deadlines:
● (10/100 Points) By Sunday, May 4th: Submit your project topic and preliminary abstract for written feedback. In addition, describe the dataset you wish to use.
● (60/100 Points) By Monday, May 19th: You will be required to submit a Zoom video recording of your final project that discusses your regression project.
● (30/100 Points) By Monday, May 19th: Submission of your corresponding excel file, PowerPoint file, and link to data sources.
Abstracts should be no more than 200 words to describe: the research problem and motivation, background and related work, independent/dependent variables, results, and contributions to your field of choice.
Include in your Slideshow:
● Identify and Justify the variables that you want to include in your analysis.
● Include your instrument measurement or link to where data was obtained.
● Show the raw data that you entered into excel: X|Y
● Prepare scatter plots showing the relationship between the dependent variable (must be continuous) and the independent variable(s). What sort of relationship does your plot suggest? Show the 𝑅2 statistic and equation on the scatter plot.
● (If more than one Independent Variable)What set of independent variables results in the highest value for the adjusted-𝑅2statistic? Feel free to include other independent variables in your results to demonstrate how you selected the variables that provide the highest adjusted-𝑅2.
● In a paragraph format, describe your research question and regression model that you developed. Were you able to examine a relationship or develop a model to make future predictions? What is the final regression function for your model?
This should include an interpretation of the adjusted 𝑅2 statistic for the model you obtained. Given the results of your model, describe the impact that it could have in the subject matter that you chose.
Mandatory Slides and Presentation Components:
● Title Slide with professional picture, brief introduction on the researcher, and the project title.
● Introduction that includes your abstract (Research Problem, Question, and/or Opportunity and motivation)
● Background of subject matter (Bring in at least 3 academic and current event sources to explain the relevancy) and Explanation of the Independent, Dependent
Variable selected and considered.
● Describe the dataset source and explain how data was obtained
● Excel Demonstration of your Regression outputs, and scatter plots. Run your model in real time.
● Results: Use the prompts listed above to interpret your regression results. Display your Regression Equation
● Conclusion: Explain how your model can be used or built upon for research or managerial insights.
● Reference Slide