I need help with a Business Statistics projectThis is the assignment info:Hi everyone, the guidelines for this project are contained in the following file: Statistic Project Guidelines.docxActionsAn e

Statistic Project Guidelines


For this data analysis project, you will address some question that interests you with the statistical methodology that you have learned in this MGMT 3345. The best questions are ones that are important (and interesting) to you (because you care about finding the “right” answer). The questions can be something from work, school, or other aspect of your life. And they can be drawn from medicine, public policy, sport, economics, etc.


So, you will choose the question, you decide how to collect data, and you will clean the data and do the analysis. (The questions can address almost any topic, although I have veto power).


NOTE: I am fine if you are piggy-backing off of another project you have done this semester (or prior semesters), but it can’t already be done. There will have to be a significant component that is added to it. We can normally work this out—just see me.


You should work in groups of two to three people on the project. Please see me to approve a larger or smaller group. [NOTE: Please enter the members of your on the Google Doc here ]



Things to include in your data analysis:

  • A data table that tells me how each variable is defined and where you got the data. (See attached).

  • A table of descriptive statistics for each variable (n, mean, median, sd, min, max).

  • Please include an appendix table that includes a scatterplot of each X-variable against the Y-variable. (See attached).

  • Check for outliers. (The scatterplots will help you with that). You can either include a dummy variable for them or run the regression with and without the outliers and see how things change.



Logistics: Project should be 12-pt font, single-spaced, with 1-inch margins all the way around. Use section headers. Put two rows between paragraphs. (See the sample report I have loaded to Canvas. Note that that report doesn’t have any charts, but I find that charts can be very useful. I assume paper will be between 4-6 pages before tables and charts are added. (If it’s going to be a lot longer or shorter than that, come see me). Tables and charts can either be incorporated into the body of the report or put together at the end.

  • Please put page numbers in the bottom right of your document. Also, include slide numbers on your slides.

  • PLEASE have someone read your slides and report out loud to catch typos and things that don’t make sense. [I hate to have to deduct points for lack of page numbers or for typos in the reports. Nobody should be losing points for things like this (but every semester there are several groups that do—just don’t let it be your group .]

  • Be sure to list all members of your group on the front page.



Other Logistics:

Day

What is turned in

11/5/2019

A one page summary of your project idea

11/19/2019

Please bring some print outs of some of your slides or charts or tables. I won’t be grading these, but obviously the further along you are in the process, the better the feedback I can give you.

12/3/2019

(Last day of class)

Please bring a hard copy of your written report and your slides.

Please upload to Canvas (See the screenshot below)

  • An electronic copy of your report

  • Your slides

  • A cleaned-up version of the spreadsheet you used to do your calculations. Please clearly label what the data are and the calculations that you make.

    • If there are multiple tabs, please label your 1st tab “Read me” and put in a table that lists the name of each tab and what is in it.


I need help with a Business Statistics projectThis is the assignment info:Hi everyone, the guidelines for this project are contained in the following file: Statistic Project Guidelines.docxActionsAn e 1

Canvas should allow you to upload multiple files (as shown). If not, please combine the files into a single Zip file and upload the zip file.



Appendix A. Project Grading Rubric



Part

Assigned

Earned

Part 1: Introduction

  • What is your research question? Why do you care? Why should others care?

  • Is the background clear and meaningful?

10 pts

Part 2: Data

Cohesive write-up of the data section from your proposal. Review instructions for proposal.

10 pts

Part 3: Exploratory data analysis

  • Perform relevant descriptive statistics, including summary statistics and visualization of the data.

  • Check for outliers.

  • Also address what the exploratory data analysis suggests about your research question.

15 pts

Part 4: Statistical analysis and inference

  • Use appropriate statistical methods to perform a hypothesis test and construct a confidence interval.

  • Control for appropriate confounding variables. Have you thought about possible biases in your results or data collection? How will they influence your results?

  • Appropriate interpretation of results

25 pts

Part 5: Conclusion

Write a brief summary of your findings without repeating your statements from earlier. Also include a discussion of what you have learned about your research question and the data you collected. You should also acknowledge limitations of your study and include ideas for possible future research.

10 pts

Overall writing quality

Overall writing quality and clarity, including grammar, spelling and organization

10 pts

Overall quality of charts and tables

  • Were the charts helpful to the analysis? Did they provide further understanding?

  • Were the tables and charts well done or were they distracting?

10 pts


NOTE: I will subtract points if there are no page numbers!




Appendix B. Examples of Tables that Describe the Variables Used in the Study


NOTE: This is from a table I created for a journal article. (CVC = Corporate venture capital, when large firms make equity investments in startups.) I anticipate that you will only have 4-5 variables in your regressions.


I need help with a Business Statistics projectThis is the assignment info:Hi everyone, the guidelines for this project are contained in the following file: Statistic Project Guidelines.docxActionsAn e 2







I need help with a Business Statistics projectThis is the assignment info:Hi everyone, the guidelines for this project are contained in the following file: Statistic Project Guidelines.docxActionsAn e 3


Appendix C. Some tables of Descriptive Statistics

NOTE: These are tables of descriptive statistics from real journal articles, so are overkill for this project. However, I show them to give you an idea of what they can look like

Bottom Quartile is 25th percentile. Top Quartile is 75th percentile. (Use Percentile() or Percentile.EXC function in Excel).




I need help with a Business Statistics projectThis is the assignment info:Hi everyone, the guidelines for this project are contained in the following file: Statistic Project Guidelines.docxActionsAn e 4

NOTE: Labels that dollar values are in millions

NOTE: Percent shown as percent.



I need help with a Business Statistics projectThis is the assignment info:Hi everyone, the guidelines for this project are contained in the following file: Statistic Project Guidelines.docxActionsAn e 5



I like how this table indicates whether the variable is a percentage (%), that Education is measured in years, and that GDP per capita is in constant 2005 US dollars.


I need help with a Business Statistics projectThis is the assignment info:Hi everyone, the guidelines for this project are contained in the following file: Statistic Project Guidelines.docxActionsAn e 6






2