Aims and Objective
The aim of this assessment is to develop and evaluate data-driven models based on simple and multiple regression models. It allows students to develop
and demonstrate the application of the methods of ordinary least squares using Excel. The assessment will consist of statistical analysis, graphs, analysis
and written report explaining your results and findings. This should be no more than 1500 words and should be typed, using ICP house style.
Advice about writing the report:
Use an introduction to set the aim of the report explaining the problem you are examining.
Structure the main body which should comprise of a discussion of your results.
Summarise the main regression results including the estimated regression line, estimated regression coefficients, standard errors, t-ratios, coefficient of
determination and present regression summary analysis.
Carry out hypothesis tests on regression coefficients and interpret your findings.
Explain your graphs of regression line and statistical results clearly in the report.
Summarise your findings/conclusion at the end of the report.
Answer all the questions.
Use references based on all the literature you have used in compiling this report. Use APA referencing system.
Pay attention to the overall presentation, structure and ensure logical development of ideas.
Demonstrating competence in the production and presentation of results from Microsoft EXCEL
Understanding of methods employed,
Providing appropriate analysis, explanation and interpretation of results,
Structuring and presenting the report clearly,
Examine a time series data of demand for coffee in United Kingdom
from 1990 to 2016. As part of this assignment you will examine the market demand of
coffee model and evaluate the significance of variables influencing consumer behaviour.
In section A, use a simple two variable model to investigate the relationship between
demand and real price of coffee and real disposable income separately. You are expected to
analyse the regression results and comment on your findings.
In section B, you are expected to use multiple regression analysis and comment on your
The following data is provided in an excel file and can be downloaded. The table show a
time series data of demand for coffee, the real price of coffee, and the real personal
disposable income of the consumer over the years (1990 to 2016) in the United Kingdom.
Download the data from M.S Excel file in module and answer the following questions in part
A and B. Remember you are expected to conduct descriptive statistics and inference
statisitics for the both sections
Section (A) Simple Linear Regression Model [40 marks]
1). Plot a separate scatter diagrams of demand for coffee, Y, against, ?1, real price of coffee
and for demand for coffee Y, and real personal disposable income, ?2. Comment on kind of
relationship that exit?
2). Assuming that the demand for coffee, ?, and real price of coffee, ?1, are linked by a
linear relationship, estimate this regression by Ordinary Least Squares (OLS) method, clearly
showing all your calculations (Excel can used for all the computations). [10 marks]
?? = ?(?? ) + ?? = ?? + ???1? + ?? 
3). Estimate the coefficient of determination – ?2 and comment on its value. Carry out an
appropriate test at 5% significance level for the explanatory power of the model.
4). Assuming that annual demand for coffee, ?, and real personal disposable income level,
?2 are linked by a linear relationship, estimate this regression by Ordinary Least Squares
(OLS) method using Excel:
?? = ?(?? ) + ?? = ?2 + ?2?2? + ?? 
5). Carry out an appropriate test at 5% significance level for the explanatory power of the
model, using the information in the regression summary output. [4 marks]
Section (B) Multiple Regression Analysis
It is reasonable to assume that demand for coffee depends on both the real price of coffee
and real disposable income. Use multiple regression analysis to investigate the relationship
between ? ??? ?1 ??? ?2 .
6). Estimate the following linear regression model using the data set:
?? = ?(?? ) + ? = ?3 + ?3?1 + ?4?2 ?? 
7). Compare the estimated coefficient for the real price of coffee, ?1, from the regression
equation (1) in section A and multiple regression equation (3) in section (B). Are they
different? If so, why? Explain your answer.
8). Tabulate the value of the coefficient of multiple determination, ?2 for the multiple
regression model? Explain the difference between the co-efficient of determination from
the first estimated linear regression (1) in section A and in section B – regression equation
9). Provide a conclusion based on all your findings in this assignments and hence comment
on the validity of the above regression models used in section (A and B). [10 marks]
10). What other variable(s) in your opinion could influence the demand for coffee in United
Kingdom. Provide a clear thought explanation for your reason.
1.1. Foundation synopsis (close to one page) History: Briefly condense the organization's history and build up a concise course of events of the organization that incorporates the date of the establishing and major corporate occasions including IPOs, M&A's, CEO advances, other significant occasions (e.g., insolvency filings), and so forth.; Objectives: Briefly abridge the organization's vision and mission. Items/Services: What are the organization's specialty units? Abridge its item offerings as well as administrations? 2.2. Execution Summary (close to one and a half pages) Monetary Performance: Select any two execution measures/proportions of the accompanying: Earnings per Share, Price-Earnings Ratio, Debt-Equity Ratio or Return on Equity. At that point, in partitioned diagrams, plot the organization's execution measure over a five-year time span looking at the measure against those of the organization's best 2 or 3 contenders and the business normal. In a short passage, translate the plots and express your fundamental decisions from these plots. In view of your discoveries, talk about whether the organization is getting a charge out of upper hand or enduring focused disservice. Financial specialist Performance: In a solitary diagram, plot the organization's stock cost against the stock costs of its best three rivals and the S&P 500 file for as far back as five years. Make note of any stock parts, stock buybacks, and so forth. At that point, in one table, condense the stock experts' purchase/offer proposals of stock examiners (see Yahoo! Fund or LexisNexis Scholastic). Contrast this data with the organization's best three rivals. At long last, in a short section, compress the data and evaluate the organization's speculator execution. Whatever degree is the organization meeting financial specialist desires? Representative Performance: Find any data on the organization's execution in setting of its workforce. Search for rankings of the "best organizations to work for," Glassdoor surveys, news reports of work inconveniences (e.g., claims) and so forth. At that point, in a short section, survey the organization's worker execution. What exactly degree is the organization prepared to do fulfilling its workers' needs? Is the organization evaluated a decent boss? Manageability and CSR Performance: Find data concerning the organization's natural execution (e.g., rankings of "green organizations" and friends natural projects) and CSR giving record. Condense your key discoveries in one section. Execution Summary: In a short section, compress what the execution appraisal uncovers about the organization. A decent money related investigation goes past the numbers and makes guesses about developing patterns and likely key ramifications of the numbers, regularly by joining bits of knowledge from different components of the budgetary proclamations. Think about some of these inquiries in your exchange: How does the execution of the organization contrast and its rivals? In the course of recent years, has the organization's execution enhanced or decay? In view of your investigation, does it show up that the company's execution measurements are going the correct way? 2. SWOT Analysis (close to two pages) 2.1 Opportunities and Threats Summary Openings: Based on the outer investigation you had directed in SAP Part 1, unmistakably distinguish and abridge the best three open doors recognized by the outer ecological investigations. Dangers: Based on the outer investigation you had directed in SAP Part 1, unmistakably distinguish and abridge the best three dangers recognized by the outer natural investigation. 2.2 Strength and Weaknesses 2.2.1 Company Resources: Consider the organization's asset base in the following four classifications. Quantitatively/Qualitatively survey the organization's assets over every one of these classifications concerning its essential contenders. Money related Resources: Consider the organization's present resources, getting limit, and its capacity to create supports rapidly either inside (e.g., move cash starting with one business then onto the next) or remotely (e.g., extra getting or stock deal). Physical Resources: Consider the organization's physical assets including building and property resources (claimed or rented), its business areas, and geographic access to item advertises, geographic access to supply markets, and additionally plants and gear. HR: Consider the administration aptitude and experience of the organization's best administration group. Look at the aptitude and experience of your organization's best administration group (i.e., Chairman, President, and COO, if relevant) to those of its main three opponents. Authoritative Resources: Consider the organization's way of life, notoriety, mark personality, trademarks, copyrights, licenses, exchange privileged insights, other protected innovation, and so on. 2.2.2 Company Capabilities: Consider the organization's capacities in the following four classifications. Quantitative/Qualitatively survey the organization's assets over every one of these classes concerning its essential contenders. Activities and Distribution Capabilities: Consider the organization's utilization and administration of production network, appropriation channels, and general coordinations. For instance, you may search for data on stock costs/turnover proportions, inventory network bottlenecks, and productivity. Human Resource Capabilities: Consider the organization's capacity to draw in, hold, engage, spur and prepare representatives. For instance, you may search for data on worker turnover, workforce preparing programs, compensation correlations, and training benefits. Showcasing Capabilities: Consider the organization's capacity to construct and advance its brand(s), client benefit capacities, promoting, and so on. For illustration, check whether you can compute a yearly Advertising Intensity proportion (promoting uses/separated by add up to deals). Item/Technology Development: Consider the organization's capacity to "see the future" of the market or potentially grow new innovation or items rapidly. For instance, check whether you can compute a R&D Intensity proportion (Research and development consumptions/partitioned by add up to deals). 2.3 Strengths and Weaknesses Summary Utilizing the data you have accumulated above and considering the VRIS system, recognize the organization's (1) qualities and (2) shortcomings. Qualities: In a solitary section, plainly distinguish and abridge the best three asset qualities and the best three capacity qualities and altogether survey them utilizing the VRIS system. Shortcomings: In a solitary passage, in view of the VRIS appraisal, plainly recognize and abridge the best three asset shortcomings and the main three ability shortcomings. Allude to the accompanying; References: Bodden, V. (2008). The Story of Coca-Cola. The Creative Company. Gillespie, K., and Hennessey, H. D. (2010). Worldwide promoting. Cengage Learning. Y. H., and O. Z. (2017, August). Refreshment Industry Trends 2017: Google Data Reveals Consumer Habits. Recovered February 27, 2018, from https://www.thinkwithgoogle.com/shopper bits of knowledge/2017-drink industry-purchaser propensities/ Morrison, J. (2008). Global business: challenges in an evolving world. Palgrave Macmillan. Bundling, E. (2017, January 02). Four Key Beverage Industry Trends for 2017 are Changing What Consumers Buy. Recovered February 27, 2018, from https://www.prnewswire.com/news-discharges/four-key-refreshment industry-patterns for-2017-are-evolving what-shoppers purchase 300384417.html Doorman's Five Forces In Action: Sample Analysis of Coca-Cola. (n.d.). Recovered February 26, 2018, from http://valuationacademy.com/doormen five-powers in real life test investigation of-coca-cola/ Volume Grown(2014). US Liquid Refreshment Beverage Market Research .Beverage Market Corporation. Recovered from https://mr-uploads.s3.amazonaws.com/transfers/2016/03/US-LRB-Market.png Morningstar Rating:The arrangement of Coca-Cola. Recovered February 23, 2018, from http://financials.morningstar.com/contenders/industry-peer.action?t=KO Garlita Raluca.(2011) : America 's Culture Changes Through Coca-Cola Slogans And Titles. Vasile Alecsandri " University of Bacău" PESTLE Analysis of Coca Cola. (2016, November 21). Recovered February 27, 2018, from http://pestleanalysis.com/pestle-examination of-coca-cola/ Stavroudi, A. (2017, April 07). Nuisance Analysis for the Coca-Cola Company. Recovered February 27, 2018, from https://toughnickel.com/ventures/PEST-Analysis-Coca-Cola Outside Environment Analysis Of Coca-Cola. (n.d.). Recovered February 28, 2018, from https://myassignmenthelp.com/free. Read the contextual investigation and do the task beneath; 1 Identify the key criteria and contemplations that should be considered in assessing BFSI section in the proposed outside business sectors. 2 Of the nations under thought, which five would be most appropriate for the quick foundation of a BFSI auxiliary? Feature the key issues for every one of the chose nations and examine the thinking behind your proposal. 3 Which nations would be inadmissible for a BFSI backup as of now, and what are the essential inadequacies for each situation? 4 What is the suggested method of section in the chosen nations and what are the key contemplations in help of this proposal? Assessing Markets to Invest Abroad E. N. Roussakis and Anastasios Moysidis Conceptual: This case manages the key contemplations when arranging a universal extension through direct interest in outside business sectors. These contemplations must be tended to by a back organization trying to set up remote backups to help the global offers of its parent firm, a U.S.- based multinational undertaking (MNE). The organization as of now works three outside auxiliaries - in Canada, Mexico (both NAFTA individuals), and the United Kingdom- - however wishes to expand this system encourage through passage into extra markets. Ten applicant nations are being considered to decide the five most appropriate for passage. Subsequently the requirement for a sane choice of where to contribute. Watchwords: Subsidiaries; multinational venture; transnational exercises; outside direct speculation; g r e n f I e l d I n v e s t m e n t ; l e v e r a g e d I n s t I t u t I o n ; w h o l e s a l e f I n a n c I n g ; c a p t I v e back organization; retail portion contract 1 Introduction Victoria Pernarella is a current college graduate in business organization and another contract in Bertos Financial Services, Inc., a noteworthy fund organization in Nashville, Tennessee. Following a month long rotational t r an I n I ng to pick up experiences into the organization's extension of exercises, she was put in the universal division where she has been doled out to chip away at an undertaking. Bill Pappas, her supervisor, had requested that her break down a select number of remote nations to decide the best prospects for the nearby foundation of auxiliary fund organizations. He went ahead to illuminate that the method of section into the remote markets- - obtaining of a current organization or a greenfield venture (from the beginning up, that is, from a green field)- - was not an essential thought at this stage. The hopeful nations were Au s t r a l I a , Bulgaria, Qatar, Serbia, Argentina, Malaysia, Botswana, Kenya, Uruguay, and Costa Rica. With fund organizations very utilized foundations, the firm was set up to give the underlying measure of value capital required for the foundation of five such organizations. At this stage accordingly, the examination should to restrict its suggestion to a relating number of remote nations. With this data nearby, Victoria began thinking about the way to deal with use for her examination. Detecting the need to demonstrate her abilities by conveying a top notch think about for her first organization task, she thought suitable to first acquaint herself with the correlated writing on the universal extension of multinational undertakings (MNE) when all is said in done and banks specifically, a n d at that point audit foundation I n f o rma t I o n o n her manager, and the extent of exercises of its money related backup. Thus the grouping of the accompanying areas which address the internationalization procedure (writing survey on the improvement of MNEs), the methods of bank section into outside markets, foundation of parent organization, monetary backup and extent of exercises, and creating criteria for nation suggestion. 2 Internationalization Process- - A Theoretical Perspective Late decades have seen the internationalization of activities of numerous organizations around the globe, and particularly U.S. companies. In spite of the fact that the degree, shape and example of their transnational a c t ivi t I e s fluctuate agreeing t o the attributes o f the organizations, the items t h ey p roduce, a n d the business sectors I n which they work, t h e y a l reflect t h e flow of a changing and progressively aggressive worldwide condition. Of the speculations that have looked to clarify the transnational exercises of ventures, the mixed worldview (Dunning, 1988) appreciates an overwhelming position. This idea gives a wide structure to the substitute channels of worldwide monetary association of undertakings and spotlights on the parameters that impact individual MNE outside speculation choices (Buckley and Casson, 1976; Dunning, 1977). In particular, the diverse worldview distinguishes three critical determinants in the transnational exercises of firms- - possession, area and disguise (OLI). The main state of the OLI arrangement expresses that a firm should have certain proprietor particular upper hand in its home market that can be exchanged abroad if the association's outside direct venture (FDI) is to be effective. This preferred standpoint must be firm particular, not effortlessly replicated, transferable, and sufficiently capable to repay the firm for the potential hindrances what's more, dangers of working abroad. Certain possession particular upper hands appreciated in the home market, for example, money related quality and economies of scale, are not really firm particular since they can be additionally accomplished by different firms. Thus, c e r t an in types of innovation don't guarantee a firm - particular preferred standpoint since they can be bought, authorized or replicated. Creation and advertising of separated items, as well, can lose their focused edge to adjusted adaptations of such items advanced by bring down evaluating furthermore, forceful promoting. >GET ANSWER