Homework answers / question archive / Strategy, Operations and Entrepreneurship Group Essex Business School MODULE: BE279 Applied Statistics and Forecasting Individual report (100% of the total mark) You are expected to analyse and discuss the two topics

Strategy, Operations and Entrepreneurship Group Essex Business School MODULE: BE279 Applied Statistics and Forecasting Individual report (100% of the total mark) You are expected to analyse and discuss the two topics

Statistics

Share With

---

Strategy, Operations and Entrepreneurship Group

Essex Business School

MODULE:

BE279 Applied Statistics and Forecasting

Individual report (100% of the total mark)

You are expected to analyse and discuss the two topics.

Date of Submission: End second term (see Moodle)

You are required to prepare a report, which will focus on the analysis and discussion of two statistical topics.

All submissions must be presented in typescript (MS Word format), 12pt, 1.5 line spacing

BE279 Questions:

Topic 1:

Context: In the USA, an empirical study has been conducted on university faculty salaries. For that, they have interviewed 787 people. In the empirical study, they have raised questions about professional characteristics (job position, PhD year, gender, university), and publication issues (ranking, size), in order to analyse what is the salary faculty profile.

Questions:

•            Could you determine the causal factors (publication, position, university) that have effect on the likelihood of faculty salary? Please explain the results.

Suggestions: Dependent variable Salary. Independent variables (Publications, Position, Universities, State, Male/Female, etc.).

 

•            Could you check the autocorrelation (Durbin-Watson test, residual analysis), collinearity (VIF), and error distribution?  Please explain the results.

Suggestions: Testing in the regression analysis: Durbin-Watson test, VIF, and you should analyse the distribution of the errors.

Please: See annexe 1

Topic 2:

Context: The UK innovation survey analysis the patterns of innovation in UK companies. The database contains information about the innovation of companies, establishing a relationship with size and the establishment of cooperation agreements for innovative development. You should first analyse how innovation is affected by size and cooperation agreements to develop innovation. Moreover, you must classify the innovation developed by the companies according to their size and the execution of cooperation agreements.

Questions:

•            Could you determine the causal factors (size and cooperation) that have effect on the likelihood of innovation in UK companies? Please explain the results.

Suggestions: Dependent variables (Innovation). Independent variables (Size and Cooperation). Previously to run a regression analysis, you should get a factor analysis with all innovation variables. Moreover, I recommend, you should recode the size variable in function of this classification (0 to 9 employee: micro-companies; 10 to 49 small; 50 to 249 medium; >250 large companies)

•            Could you classify the innovation in UK companies in function of the Size and cooperation agreements?  Please explain the results.

Suggestions: You should develop two analyses. Firstly, ANOVA analysis (variables: innovations) and control variables (size and cooperation). Secondly, Cluster analysis (variables: innovations) and control variables (size and cooperation). In the cluster analysis, you should include in your report, line and dispersion diagrams.

Please: See annexe 2

 

Report Structure

1. Introduction
2. Methodology and data
3. Analysis and results (including robustness analysis)
4. Discussion y conclusions
5. References.

 

Materials and Documents:

1. The data is contained in an attached file named: DATABASE (I) and (II).

2. Questionnaires.

Essential Reading:

1. Joseph F. Hair, William C. Black, Barry J. Babin, Rolph E. Anderson. Multivariate Data Analysis: Pearson New International Edition, 7/E. ISBN-10: 129202190X • ISBN-13: 9781292021904. ©2013 • Pearson • Paper, 744 pp.

2. Sabine, Landau; Brian S. Everitt 2004. A handbook of statistical analyses using SPSS. Chapman & Hall/ CRC Press.

3. IBM SPSS Guide 21 Edition.

 

Annexe 1.  (TOPIC 1)

File: Database (I)

Variables

id	person identifier
salary	annual salary, $
pubindx	publication index (publication impact in the academia)
totpge	standardized total article pages
assist	=1 if assistant professor
assoc	=1 if associate professor
prof	=1 if full professor
chair	=1 if department chair
top20phd	=1 if Ph.D. from top 20 dept.
yearphd	year Ph.D. obtained
female	=1 if female
osu	=1 if Ohio State U.
iowa	=1 if U. Iowa
indiana	=1 if Indiana U.
purdue	=1 if Purdue U.
msu	=1 if Michigan State U.
minn	=1 if U. Minnesota
mich	=1 if U. Michigan
wisc	=1 if U. Wisconsin
illinois	=1 if U. Illinois
y92	=1 if year == 92 (employed year)
y95	=1 if year == 95 (employed year)
y99	=1 if year == 99 (employed year)
lsalary	log(salary)
exper	years since first teaching job
Annexe 2. (TOPIC 2) File: Database (II)
Variables Description Innovationgoods Product Innovation develops for your company (1, yes; 0 no) Innovationservice Service Innovation develops for your company (1, yes; 0 no) Innovationmanufacturing Manufacturing Innovation develops for your company (1, yes; 0 no) Innovationlogistics Logistics Innovation develops for your company (1, yes; 0 no) Innovation support Support Innovation develops for your company (1, yes; 0 no) Size Size of the companies (employees) Cooperation Cooperation agreements establishes for your company to develop innovation (1, yes; 0 no)

 

 

 

LEARNING OUTCOMES for report MODULE BE279

• Obtain a critical understanding of principal theoretical approaches to applied statistics and forecasting (A9, B2, B4).

• Examine key statistics models (e.g. factor analysis, cluster, regression model, etc,), (A8, A9, A10, B2, B4).

• Demonstrate skills of critical thinking, analysis and problem solving with reference to data analysis (B1, D2);

• Develop key skills in written communication, use of IT, and improving own learning & performance (B1, B4, C2, D1, D5).