60.1K

Verified Solution

Link Copied!

please help me understand.

A video media consultant collected the following data on popular LED televisions soid through on-line retailers. Click here foc the Excel Data File a. Does there oppear to be a linear relationship between the screen size and the price? (Round your answer to 2 decimal places.) Click here for the Excel Data File a. Does there appear to be a linear relationship between the screen size and the price? (Round your answer to 2 decimal places.) b. Which variable is the "dependent" variable? Screen size Price c-1. Use statistical software to determine the regression equation. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.) c-2. Interpret the value of the slope in the regression equation. (Round your answer to 3 decimal places.) d. Include the two qualitative variables, "Sony" and "Sharp", as "dummy" variables in the multiple regression analysis. Note: if both "Sony" and "Sharp", are equal to zero, then the manufacturer is Samsung: if "Sony" =1 and "Sharp" =0, then the manufacturer is Sony: ; If "Sony" =0 and "Sharp" =1, then the manufacturer is Sharp. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.) e. Test each of the individual coefficients to see if they are significant. (Negative amounts should be indicated by a minus sign. Round your t-value to 2 decimal places and p-value to 4 decimal places.)

Answer & Explanation Solved by verified expert

See Answer