A project help

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.

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.

7

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.

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).

NOTE: Labels that dollar values are in millions

NOTE: Percent shown as percent.

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.

VariableDefinitionData Source

Key independent Variables

CVC IntensityAnnual CVC spending divided by total R&D spending,

(CVC/R&D+CVC)

Compustat,

VentureOne,

VenturXpert

Stability IndexNumber of years firm has made at least 1 CVC investment divided by

total number of years since firm’s initial CVC investment

VentureOne,

VenturXpert

Consecutive years investing in

CVC

Number of consecutive years firm has made CVC investments as of

focal acquisition year

VentureOne,

VenturXpert

Total years investing in CVCTotal number of years firm has made at least 1 CVC investment

(since 1980)

VentureOne,

VenturXpert

Acquirer characteristics

R&D IntensityAnnual R&D spending divided by number of employeesCompustat

Acquisition ExperienceNumber of startups acquired by acquirer as of beginning of the year

of acquisition

SDC, VentureOne

Acquirer size (log assets)Log of book value of total assets ($ millions)

Compustat

Free cash flow (% of total assets)Operating income before extraordinary items+ (depreciation and

amortization)

Compustat

Acquirer has a CVC unit?1 if acquirer’s initial investment in startup was made by a dedicated

corporate venture capital unit (e.g., Intel Capital; Motorola

Ventures)

VentureOne,

VenturXpert

Target and deal characteristics

Acquirer has prior VC

investment in target?

1 if the acquirer provided venture capital to a target prior to

acquisition

VentureOne,

VenturXpert

Target ageAcquisition year minus year target was foundedVentureOne, news

articles

Target is public when acquired?1 if target is publicly held when acquiredSDC

Target size relative to acquirerDeal value divided by equity market capitalization of acquirer at end

of prior fiscal year

SDC, Compustat

Payment included stock?1 for deals at least partially stock-financed

SDC, news articles

Deal terms undisclosed?1 for deals with deals that did not disclose either the method of

payment or the purchase price

SDC, news articles

Boom years (1999-2000)1 if acquisition year is 1999 or 2000SDC

Post-boom years (2001-2003)1 if acquisition year is 2001, 2002, or 2003SDC