Hello, everyone! InExcelI tried to make a regression equation with several dummies. The task is:

Include the manufacturer in a multiple linear regression analysis using a "dummy" variable. Does it appear that some manufacturers can command a premium price? Hint: You will need to use a set of indicator variables.(Round your answers to 2 decimal places.Negative amounts should be indicated by a minus sign.)

Price =b0+b1Screen+b2Manufacturer Sharp +b3Manufacturer Sony ???Can someone show a regression analysis in Excel? I made a column for M.Sharp and M.Sony, but the result is incorrect.

What are the right cofficients?

The basic regression equation is:Price =-2484+101 Screen

The sample and sample in Excel are in attachment!