Data entry and analysis-descriptive statistics

Reference no: EM13933459

You are the Assistant Director of Strategy of a company of your aspirations, and have been charged with producing a forecast of the company's operational targets:
1. Sales/Turnover forecast of 5 years
2. Net profit forecast of 5 years
3. Total Asset Values forecast of 5 years
4. Long term liabilities forecast of 5 years
Using historical data from the company of your choice e.g. Deutsche Bank, RBS, BNP Paribas, Coca-Cola.

Task 2: Data Entry and Analysis
Input the primary data collected in any statistical software (say SPSS; Excel; Minitab and so on) and analyze the data in the context of the following:

i. Descriptive statistics of your variables [use the mean and standard deviation]You may support your presentation with a graphical analysis;

ii. A regression analysis at the 95% level of confidence noting factors that
have significant impact on the dependent variable = Sales Revenue

Task 3: Report Writing or Presentation
Write your report using the following contents:

1.0 Introduction
[the objective of the report; the key highlights to be captured; and so on]

2.0 Factors influencing the choice of an company:
[a brief introduction to the sector; the factors used for the analysis and the relevant literature supporting their inclusion; also the providers used in your analysis and a justification for their inclusion]

3.0 Sample characteristics:
[the response rate; demographic characteristics; the choice of sample and justification: Support your discussion in this section with some relevant graphs]

4.0 Data Analysis and Findings:
[Descriptive statistics and regression analysis]
FOR THE FORECAST YEARS NOT HISTORICAL DATA

5.0 Conclusion and recommendation (s):
[provide a suitable conclusion and recommendation that can used by an airline service providers to enhance their market share or performance.

Reference no: EM13933459

Questions Cloud

What is the amount of net cash flow from operating activitie : What is the amount of net cash flow from operating activities for 2014?

Responsible for the degree of elasticity : Is demand for these courses elastic or inelastic? What factors do you think are responsible for this degree of elasticity?

What do you understand by risk analysis : What do you understand by risk analysis? How can risk assessment be measured mathematically ?

Relationship between bondholders and stockholders : Which one of these best describes the relationship between bondholders and stockholders at a time when it appears the firm may be facing increased financial distress?

Data entry and analysis-descriptive statistics : You are the Assistant Director of Strategy of a company of your aspirations, and have been charged with producing a forecast of the company's operational targets:

Find a confidence interval for the true mean difference : Find a 99% confidence interval for the true mean difference in growth time (given that these times are approximately normally distributed and the variances are approximately equal).

Expected net cash inflows-What is the projects IRR : A project has an initial cost of $45,000, expected net cash inflows of $12,550 per year for 8 years, and a cost of capital of 10.85%. What is the project's IRR?

Determine the density of a plastic piece : A student wants to determine the density of a plastic piece. Preliminary experiments indicate that the density of the plastic is greater than 0.85 g/ml, but less dense than water. In order to determine the density of the plastic piece, the student wi..

Can you separate attribution from social cognition : Can you separate attribution from social cognition? Why or why not? [300 word count. In-text citation and sources needed. Write in 3rd person scholarly writing and no quotes.] This is a personally developed question not an assignment or home work.

User Account

All Pages