Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
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
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.)
please help me understand.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started