Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions