logo

STAT 6003- Statistics for Financial Decisions

25 Pages4064 Words95 Views
   

Laureate International Universities

   

Statistics for Financial Decisions (STAT 6003)

   

Added on  2020-04-13

STAT 6003- Statistics for Financial Decisions

   

Laureate International Universities

   

Statistics for Financial Decisions (STAT 6003)

   Added on 2020-04-13

ShareRelated Documents
Running Head: STATISTICS FOR FINANCIAL DECISIONSStatistics for Financial DecisionsName of the StudentName of the UniversityAuthor Note
STAT 6003- Statistics for Financial Decisions_1
1STATISTICS FOR FINANCIAL DECISIONSTable of Contents1.0 Introduction................................................................................................................................22.0 Sales Analysis in Federated Island, Industria and Nokaragua...................................................32.1 Statistical Data Overview......................................................................................................32.2 Correlation Analysis..............................................................................................................62.2.1 Correlation for Federated Islands...................................................................................62.2.2 Correlation for Industria.................................................................................................72.2.3 Correlation for Nokaragua..............................................................................................72.3 Multiple Regression Analysis for prediction of Sales...........................................................82.3.1 Federated Island sales prediction....................................................................................82.3.2 Industria Sales Prediction...............................................................................................92.3.3 Nokaragua Sales Prediction..........................................................................................102.3.4 Forecast of Sales...........................................................................................................112.4 Hypothesis Testing..............................................................................................................123.0 Sweden Market Structure........................................................................................................133.1 Forecasted Sales of Sweden.................................................................................................144.0 Conclusion and Recommendation...........................................................................................14Appendices....................................................................................................................................16
STAT 6003- Statistics for Financial Decisions_2
2STATISTICS FOR FINANCIAL DECISIONS
STAT 6003- Statistics for Financial Decisions_3
3STATISTICS FOR FINANCIAL DECISIONS1.0 IntroductionThe main aim of this report is to evaluate the development the sales of Schmeckt Gut forthe last 25 years over three different countries namely, Federated Island, Industria andNokaragua. The data of the last 25 years has been used to forecast the sales figures of the nextfive years, from 2016 to 2020. There are various factors that are considered as the salesdeterminants. These factors include Gross Domestic product (GDP), Average Price Index,Population, Survey Score, number of advertisements and the number of stores. The relationshipbetween these variables in predicting the sales figures for the countries has to be estimated. Toestablish the association between three variables such as Survey Score, number ofadvertisements and number of stores, a correlation analysis has been made. Using multiple linearregression, the relationship of the variables which are the sales determinants as mentioned abovewith sales has been established. Using this relationship, the sales figures for the future years canbe forecasted for each of the three different countries. The second part of this study includes a business scenario for Sweden. The intention ofSchmeckt Gut is to spread his business in the Swedish market. The business strategy is designedon the basis of the sales trend in a particular market. There is no sales data available for Sweden.Thus, the sales data has to be taken from the country which has a GDP or Price index close toSweden. Suggestions for sales expansion in Sweden is given in the end after the analysis will beperformed.
STAT 6003- Statistics for Financial Decisions_4
4STATISTICS FOR FINANCIAL DECISIONS2.0 Sales Analysis in Federated Island, Industria and Nokaragua2.1 Statistical Data OverviewThe data that has been considered for this analysis contains the following information forthe four countries, Federated Island, Industria, Nokaragua and SwedenSales figures (Not available for Sweden)GDP data Average price indexPopulation of people aged between 15 and 65 yearsSurvey Score (Average customer satisfaction result)Average number of advertisementsNumber of stores19911993199519971999200120032005200720092011201320150500000010000000150000002000000025000000Sales Comparison in three countriesFederated IslandsIndustriaNokaraguaYearSales(inUS$)(Source: As created by author)Figure 1: Comparison of sales in Federated Island, Industria and Nokaragua
STAT 6003- Statistics for Financial Decisions_5
5STATISTICS FOR FINANCIAL DECISIONSIt is clear from the graph in figure 1 that the sales trend of Industria has been risingthroughout the 25 year period from 1995 to 2015. The sales trend also shows an upward growthfor the country Nokaragua for the past 25 years. Industria shows the highest sales growthfollowed by Nokaragua.It can also be seen that there are a lot of fluctuations in the sales trend forIndustria but Nokaragua shows a steady growth. The market of Federated Island has shown thelowest sales with negligible amount of growth for the 25 year period. 1991199319951997199920012003200520072009201120132015050000000000100000000000150000000000200000000000250000000000300000000000GDP Comparison in three countriesFederated IslandsIndustriaNokaraguaYearsGDP(inUS$)(Source: As created by author)Figure 2: Comparison of GDP in Federated Island, Industria and NokaraguaIt can be seen from figure 2 that the GDP of Nakuragua is more than that of Industria.Federated Island has shown almost no growth in GDP. However, both Industria and Nakuraguafollows an increasing trend and the difference between their growth is decreasing gradually withtime.
STAT 6003- Statistics for Financial Decisions_6

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
STAT 6003 : Statistics for Financial Decisions
|19
|2967
|211

Financial Decision Making By Data Analysis
|9
|1138
|141

Financial Statistics Assignment Solution
|12
|2023
|75

STAT 6003: Statistics for Financial Decisions
|9
|1214
|114

Assignment on Statistics for Financial Decisions
|12
|1511
|33

QUANTITIVE REASONING AND ANALYSIS
|19
|1667
|17