這是我們2017年為澳洲悉尼大學的客戶寫的一篇商科eviews數據分析範文,這篇essay是Q&A形式的,和大家分享一下其中的部分題目。
Q1
(a)I expect the coefficient is positive and is negative, is negative.
For β1 , the expenditures on alcohol should be positively correlated with total household expenditure.
For β2, young people prefer to drink more than older people.
For β3, families with more children would be less likely to buy wine because they would raise their children.
(b)
c) β1=0.033, means that the expenditures on alcohol is positively correlated with total household expenditure. An increase of one percent of the total household expenditure will increase alcohol expenditure by about 3 percent.
β2=-0.002which means that the age of household head is negatively correlated with total household expenditure. An increase of one age of household head will decrease alcohol expenditure by about 0.2 percent.
β3=-0.015which means that number of children is negatively correlated with total household expenditure. Adding a child to the family will decrease alcohol expenditure by about 1.5 percent.
All of variables make sense because those p values is small.
(d) 95% interval estimate of β2 is (-0.003,-0014)
(e)
H0 is the assumption of walc and nk are independent of each other
The value of p is 0.34, accept the assumption of H0, walc and nk are independent of each other. One reason for this maybe the number of children in the sample is only one or two.
(f)β1=0.033 ,std=0.008,t=4.01,p=0.0001
We can get the probability of , β1≥0 =0.9995
alcohol is a luxury good.
(g) I might exclude variable nk from the equation, because the p value of nk is 0.015, higher than 0.01 and P values for other variables.
(h)
There is a significant relationship between Wacl and age ,ln(totexp) at the 0.05 level of significance
Q2
(a)
(b) The squared term for advertising is capturing nonlinear relationship such as U curve between total revenue and advertising expenditure.
I expect the sign of β3 is positive, the sign of β5 is negative, the interaction term capturing the impact of price on total revenue is affected by advertising and impact of advertising on total revenue is affected by price.
(c)
The R- squared of fit of the model is 87.1%, The fitting effect is good in a economic, but all p values of variables is too large, the model is not significant in a statistical standpoint. The signs match my expectations.
(d) a=40000
(e) If
Then we get the value p=1 a=40
(f) if advertising is set at $40,000 and price is set at $2 and total revenue is $175,000.
Then have the following correlation
Use the sample calculate
(g) To test
We estimate the regression equation
Use above estimation results
Reject original hypothesis
以上為該論文的部分節選,這類作業對作者的學習素養要求很高,必須要專業且學歷符合才能完成的很好,我們展示的範文是一篇標準的高分範文,而這樣的範文對作者的要求可以說是更高,無論是計算、分析還是文字表達,都需要相當高的專業度。