Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ln(SalesTrop)=0+1ln(PriceTrop)+2ln(PriceMM)+3Display+ Create the variable ln( PriceTrop) and ln( PriceMM). Estimate the linear regression model above. 2.1) Copy and paste the result tables from Excel here.
ln(SalesTrop)=0+1ln(PriceTrop)+2ln(PriceMM)+3Display+ Create the variable ln( PriceTrop) and ln( PriceMM). Estimate the linear regression model above. 2.1) Copy and paste the result tables from Excel here. 2.2) What is the value of the coefficient of ln (PriceTrop)? How to interpret this value? Is the coefficient of ln (PriceTrop) negative or positive? Why? 2.3) What is the value of the coefficient of ln (PriceMM)? How to interpret it? Is the coefficient of ln( PriceMM) is negative or positive? Why? 2.4) What is value of the coefficient of Display? Is this coefficient positive or negative? How would you interpret this coefficient? SUMMARY OUTPUT \begin{tabular}{|l|r|} \hline \multicolumn{2}{|c|}{ Regression Statistics } \\ \hline Multiple R & 0.890644868 \\ \hline R Square & 0.793248282 \\ \hline Adjusted R Square & 0.787710289 \\ \hline Standard Error & 0.150713754 \\ \hline Observations & 116 \\ \hline \end{tabular} ANOVA \begin{tabular}{|l|r|r|r|r|r|} \hline & \multicolumn{1}{c|}{df} & \multicolumn{1}{c|}{ SS } & MS & F & Significance F \\ \hline Regression & 3 & 9.760763912 & 3.253587971 & 143.2375156 & 3.50982E38 \\ \hline Residual & 112 & 2.544039186 & 0.022714636 & & \\ \hline Total & 115 & 12.3048031 & & & \\ \hline \end{tabular} ln(SalesTrop)=0+1ln(PriceTrop)+2ln(PriceMM)+3Display+ Create the variable ln( PriceTrop) and ln( PriceMM). Estimate the linear regression model above. 2.1) Copy and paste the result tables from Excel here. 2.2) What is the value of the coefficient of ln (PriceTrop)? How to interpret this value? Is the coefficient of ln (PriceTrop) negative or positive? Why? 2.3) What is the value of the coefficient of ln (PriceMM)? How to interpret it? Is the coefficient of ln( PriceMM) is negative or positive? Why? 2.4) What is value of the coefficient of Display? Is this coefficient positive or negative? How would you interpret this coefficient? SUMMARY OUTPUT \begin{tabular}{|l|r|} \hline \multicolumn{2}{|c|}{ Regression Statistics } \\ \hline Multiple R & 0.890644868 \\ \hline R Square & 0.793248282 \\ \hline Adjusted R Square & 0.787710289 \\ \hline Standard Error & 0.150713754 \\ \hline Observations & 116 \\ \hline \end{tabular} ANOVA \begin{tabular}{|l|r|r|r|r|r|} \hline & \multicolumn{1}{c|}{df} & \multicolumn{1}{c|}{ SS } & MS & F & Significance F \\ \hline Regression & 3 & 9.760763912 & 3.253587971 & 143.2375156 & 3.50982E38 \\ \hline Residual & 112 & 2.544039186 & 0.022714636 & & \\ \hline Total & 115 & 12.3048031 & & & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started