Question: 1 . Using Excel, regress Trips on Cost. Below, report the results from your regressionCoefficientsStandardErrorIntercept 1 7 . 3 3 Cost 1 8 9 t

1. Using Excel, regress Trips on Cost. Below, report the results from your regressionCoefficientsStandardErrorIntercept17.33Cost189t Stat9.15P-value4.05 E -16Regression StatisticsMultiple R0.372R Square0.14Adjusted R Square0.133Standard Error17.93Observations1512. Write down the equation of your regression line.17:32-0.02costTrips =17.32-002 costTrips =017.32=0.02 co5+D.020002C=866(5=(1)/(2)2[7.32(866)= $75001513. Use the number of observations to calculate CS per person.CS =1500-49.661514. Find the average number of trips in the sample.Avg # of trips a11.415. Calculate consumer surplus per trip7500CS/AriP =11,41=656-95

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!