Dataset代写 数据集代写 Econometric model代写

Question 1

Dataset代写 Through the above analysis, an econometric model can be established to explain the value of the team. The expression of the model is as follows.

a) This dataset contains 13 variables, each with 400 observations.Specific variable names and descriptions are given in Table 1.

Table 1 Variable Names and Descriptions          Dataset代写

Table 2 below is a statistical description of 13 variables. The mean, median, standard deviation, minimum and maximum values of each variable are listed in the table. Each variable in the dataset is a continuous numerical variable.

Table 2 Summary Statistics, using the observations 1 – 400          Dataset代写

Table 3 is the correlation coefficient between the variables. As can be seen, all the correlation coefficients are less than 0.8, so there is no strong correlation between the variables.

Table 3 Correlation coefficients, using the observations 1 – 400          Dataset代写

5% critical value (two-tailed) = 0.0981 for n = 400

b) Table 4 shows the regression results with tsales as dependent variable and nown,          Dataset代写

nfull, npart, and ssizeas independent variables.It can be seen from the results that the p value of nown is greater than 0.05, so the variable is not significant at the confidence level of 5%, and the p values of nfull, npart and ssize are all less than 0.05, so the three variables are significant at the confidence level of 5%.

The coefficients of these four variables are all positive,so their impacts on tsales are all For each additional person in number of owners, annual sales can be increased by 59,314.4 guilders. For each additional person in number of full-timers, annual sales can be increased by 230,689 guilders. For each additional person in number of part-timers, annual sales can be increased by 123,353 guilders. For each additional square meter in sales floorspace of the store, annual sales can be increased by 1,725.27 guilders.

Table 4 Model 1: OLS, using observations 1-400

Dependent variable: tsales            Dataset代写

Question 2          Dataset代写

a) The factors that affect the happiness of team fans can be divided into performanceson the fieldand off-field factors of The better a player does on the field,

the happier the fans will be when he is brought in. At the same time, the off- field factors of a player, such as the appearance and life behavior of the player, the frequency of communication with the fans through the Internet social platform, will affect the happiness of the fans.

The better a player’s appearance,          Dataset代写

the more positive his life behavior is, and the more frequently he communicates with fans through the Internet social platform, the happier the team’s fans are.

Therefore,these five variables in Table 5 can be selected to measure the happiness of fans. The data of Score, Top3 and Fansonline can be easily got from the Internet. The data of Appearance can be got from a network questionnaire, in which 0 can be set to indicate satisfaction, and 1 can be set to indicate dissatisfaction.

The data of Livebe can be got by judging whether the player had scandals in the past five years, in which 0 can be set to indicate no scandal, and 1 can be set to indicate having scandals.

Table 5 Variable Names and Descriptions

b) The factors that affect the value of the team are the performance of the team on the fieldand the influence of the team off-field.

The performance of the team can be measured by two variables,

one is the team’s ranking in the league in the last three years, the other is the team’s winning rate in the last three years.

The off-field influence of the team can be measured by two variables, one is the total value of all players, the other is the number of fans on the team’s online social platform. The specific variable description is shown in Table 6.

Table 6 Variable Names and Descriptions          Dataset代写

c) Through the above analysis,    Dataset代写

an econometric modelcan be establishedto explain the value of the team. The expression of the model is as follows.

The regression analysis of this model can be done by importing the data collected online into Gretl. is a constant term are the coefficients of these four variables, and  is a residual term.

更多其他:Essay代写 研究论文代写 期末论文代写 毕业论文代写 论文代写 prensentation代写 Case study代写 Academic代写 Review代写

合作平台：天才代写 幽灵代写  写手招聘