Hello, everyone! 
In Excel I 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 ???
What are the right cofficients?
Can someone show a regression analysis in Excel? I made a column for M.Sharp and M.Sony, but the result is incorrect.
The basic regression equation is: Price =-2484+101 Screen
The sample and sample in Excel are in attachment!
In Excel I 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 ???
What are the right cofficients?
Can someone show a regression analysis in Excel? I made a column for M.Sharp and M.Sony, but the result is incorrect.
The basic regression equation is: Price =-2484+101 Screen
The sample and sample in Excel are in attachment!