Question: Use this data which you can also access by using this link to the Excel sheet to answer all of the questions in this problem

 Use this data which you can also access by using this

Use this data which you can also access by using this link to the Excel sheet to answer all of the questions in this problem set. P Y Ps 1 2 3 4 5 6 7 8 9 7.00 0.48 11.38 14.53 10.26 14.91 9.40 10 11 12 Q 599.5 510.0 417.0 520.5 465.8 392.3 482.1 475.0 407.4 330.6 513.3 449.2 516.2 387.7 554.5 456.6 607.3 508.2 545.6 533.6 600.9 424.3 547.8 1000.00 207.60 267.35 208.65 73.80 91.96 103.45 111.38 399.25 74.34 300.43 451.78 190.69 256.42 273.27 532.67 431.56 215.26 459.04 104.58 88.55 25.88 399.75 50.00 92.18 26.60 98.10 6.36 95.95 88.20 42.30 46.62 59.02 25.26 48.04 27.32 13.12 49.89 15.42 63.42 12.42 98.55 73.59 64.21 57.86 75.40 10.72 11.24 10.29 14.36 12.70 0.95 8.94 1.23 12.48 6.31 4.65 9.39 4.46 5.08 2.68 2.55 13 14 15 16 17 18 19 20 21 22 23 Paul owns a food truck that specializes in northern french cuisine and he has noticed he faces weak competition due to the unique nature of his food. Paul was charging $7 per meal when he decided to run an experiment and charge different prices at different locations for one month In this excel sheet, you will find the information that was collected. Where Q represents the quantity of meals sold, P represents the price Paul decided to charge in that location, Y is the average weakly earnings of the typical household in the corresponding neighborhood, and Ps represents the average price of the (substitute) meals offered by the competing vendors in each location. 1. Use the data provided to estimate the demand equation that Paul's food truck is facing using the Excel regression tools of data anaylsis. Use P, Y, and Ps as the independent variables. Present your results in a screenshot that you upload numbered screenshot 1

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 Finance Questions!